Hi!

This is my first bug report so please be kind to me :)

I have a Drupal site that runs power plant asset information and I use Views to print out different lists of those plants. Pretty basic stuff I guess.

No I have tried to make exports to a .csv file of all power plant information stored in the database and I use Views Data Export for that. The export works fine until I add more than 62 fields to be printed. 62 or less fields print out fine. Over 62 fields csv prints out blank, only the first line of field names is printed.

The guestion is not about how many rows I print out, the result is the same if I print 10 or 100 rows.

Is there some kind of limitation of how many fields the Views Data Export is able to print and if so, I is adjustable somehow?

Thank you!

Comments

PLT875’s picture

PLT875 CreditAttribution: PLT875 commented

I experience the same problem as you, so basically if a view has a lot of results that have to be spread across multiple pages then views data export will only export those that are on the first page.

Looking to see if there is a way of exporting all results from a view.

Publishing Future’s picture

Publishing Future CreditAttribution: Publishing Future commented
Issue summary: View changes

I have the same problem with a CSV export of 64 fields. If I delete any field, the export works fine, but with all fields the exported file only includes the header line. The problem is also there if I use version 6.x-2.x-dev.

KristineC’s picture

KristineC CreditAttribution: KristineC commented

That is a huge concern for me at the moment. Is this a problem in 7.x too??

iwant2fly’s picture

iwant2fly CreditAttribution: iwant2fly commented

Is this a one time need or an ongoing need? If it is a one time thing you can probably just use phpmyadmin and export it from the database directly. Also if you want to use views to create the SQL query that you then run in phpmyadmin go to /admin/structure/views/settings and click the Show the SQL query. You can also turn on a few other things there that can help you figure out where the view might be breaking.

amoebanath’s picture

amoebanath CreditAttribution: amoebanath at ComputerMinds commented
Status: Active » Closed (won't fix)

As Drupal 6 nears the end of its life and support period, the 6.x version of Views Data Export will not be supported either. To that end, this issue has been closed, and will not be resolved in the 6.x branch of Views Data Export.

If this issue is still relevant to 7.x branch of Views Data Export, then please re-open and move to a relevant 7.x version.