I tried to use this module, but it didn't work out. Sorry I don't have time to do a detailed investigation and raise proper issues reporting exact repro scenario, but hopefully this might help as an idea of areas for investigation and testing (roughly most important issues first):

  • With larger datasets, the CSV results contain some rows 2 or 3 times and others missing.
  • The handling of HTML is not ideal. On a view of users, if I turn on "Strip HTML tags" then the roles (which are HTML ul) disappear entirely. However with Views Data Export the roles are present in the CSV even when HTML is stripped.
  • The "CSV" file actually seems to be separated by semi-colon not comma.
  • Views Data Export has more options.
  • Warning after install that module had moved in filesystem?

Just a thought, but is this module reinventing lots of complex code that is already present and working in Views Data Export? Maybe it would be more useful to contribute to that module (with 87000 reported installs) where there is a patch in progress #1436726: Add integrations with Views Bulk Operations (sample VBO action to expose selected records to CSV export included herein) that needs a little work. I feel it might be better for the community to focus efforts on the existing module rather create a new one.

Comments

AdamPS created an issue. See original summary.

Graber’s picture

Graber CreditAttribution: Graber as a volunteer commented
Status: Active » Postponed (maintainer needs more info)

I need more information on how can I reproduce the beforementioned issues, this module is installed on a huge environment and no errors were reported so far.

As to contributing to views_data_import, I think it's better the way it is, it's not good when you have 10 UI options and a heap of code loaded by the interpreter when all you need is one functionality. Not good for performance and site admin convenience as well. The purpose of this module is to give a simple VBO functionality as many other VBO - related modules do.

Thanks,

Graber

AdamPS’s picture

AdamPS CreditAttribution: AdamPS commented

Thanks for the response. Sorry I no longer have the module installed as I am using another option. The larger dataset was around 400 user accounts. I didn't investigate closely, I may have made a mistake.

However hopefully the 2nd, 3rd and 4th bullets should be fairly clear with the information already in the issue. I'm just letting you know my experience. You can of course decide to close "can't repro" or "won't fix".

Graber’s picture

Graber CreditAttribution: Graber as a volunteer commented

Thanks!

#1 was alarming so I investigated and also found a few duplicates, but.. the exported view had the duplicates as well so it wasn't caused by the module itself.

Check your view, probably you query for multi-value fields and need a DISTINCT clause.

AdamPS’s picture

AdamPS CreditAttribution: AdamPS commented

Thanks for checking!

singh.chandrakant’s picture

singh.chandrakant CreditAttribution: singh.chandrakant commented

I am getting complete HTML in exported sheet. How to fix this?

Graber’s picture

Graber CreditAttribution: Graber as a volunteer commented

singh.chandrakant: View edit form -> fields -> VBO export -> scroll to the vbo export action -> check "strip tags" checkbox.

thebigmacmurray’s picture

thebigmacmurray CreditAttribution: thebigmacmurray commented

> With larger datasets, the CSV results contain some rows 2 or 3 times and others missing.

I have this problem when performing an export with pagination and a "Select All". For example if I have pagination set to 50 items per page and 10 pages and I try to select all rows to export it will give me the first 50 rows repeated 10x.

I do have a lot of relationship and aggregated data with this view but the view itself performs correctly, just the export that has a problem. And if you turn off pagination and show all items on a page it also works correctly.

Thanks.

timb’s picture

timb CreditAttribution: timb commented

I saw the Drupal 8 version of this module got an option page with the ability to set the Seperator. Any plans to do this for the 7 version?