This issue is related to #1258390: Add support for batched exports of Search API views, but since the problem also exists in the latest stable version and because the patch posted there also works for beta6, I thought I'd post it here as well.

CommentFileSizeAuthor
#4 views_data_export-solr_export-2080297-4.patch5.77 KBSneakyvv
#3 views_data_export-solr_export-2080297-3.patch5.28 KBSneakyvv
#1 views_data_export-solr_export-2080297-1.patch5.62 KBSneakyvv

Comments

Sneakyvv’s picture

Sneakyvv commented
Status: Active » Needs review
StatusFileSize
new views_data_export-solr_export-2080297-1.patch5.62 KB

patch attached

Status: Needs review » Needs work

The last submitted patch, views_data_export-solr_export-2080297-1.patch, failed testing.

Sneakyvv’s picture

Sneakyvv commented
Status: Needs work » Needs review
StatusFileSize
new views_data_export-solr_export-2080297-3.patch5.28 KB

patch corrected to use path relative from module root

Sneakyvv’s picture

Sneakyvv commented
Version: 7.x-3.0-beta6 » 7.x-3.0-beta7
Issue summary: View changes
StatusFileSize
new views_data_export-solr_export-2080297-4.patch5.77 KB

The problem still occurs in beta-7 but the patch didn't apply anymore. So, updated patch attached.

Sneakyvv’s picture

Sneakyvv commented
yannis_p’s picture

yannis_p commented

I applied the patch in beta-8 but I have problems in extracting results as CSV. The extract finishes but leaves blank rows and gives me the following error in the log:

User notice: <pre>&#039;Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column \&#039;data\&#039; at row 3&#039;</pre> in trigger_error() (line 7530 of \path_to_drupal\includes\common.inc).

I am already truncating a specific very long field to 200 characters from the View settings

yannis_p’s picture

yannis_p commented
Issue summary: View changes

Forget about my previous comment however I 'm still having issues when I try to export a view with many fields and Solr backend. Even if I set the batch to 2 it seems to be running out of memory see. Seems to be relevant to #2042231: Memory limit exceeds while exporting views result XML.

Jverg’s picture

Jverg commented

Same issue here. Is there someone who solve that issue in some way?

steven jones’s picture

steven jones commented
Status: Needs review » Closed (won't fix)

Sorry for the lack of attention to your issue, please accept my apologies.

Drupal 7 is going to be end-of-life'd by the community in approximately 1 month.

As such, I am closing all non-critical looking, non-PHP compatibility issues for Views Data Export to tidy up the issue queues and reduce the noise. You can read about this on #3492246: Close down Drupal 7 issues.

If you feel like this issue has been closed by mistake, please do comment about re-opening it.
If you feel like the ticket is still relevant for the 8.x-1.x version of the module, then please search for a duplicate issue first, and if there really isn't one (and you've looked properly) then change the version on the ticket and re-open.

Thanks to everyone involved in this issue: for reporting it, and moving it along, it is truly appreciated.
The Drupal community wouldn't be what it is today without your involvement and effort, so I'm sorry that we couldn't get this issue resolved. Hopefully we'll work together in a future issue though, and get that one resolved :)