I have more than 370 web form submissions. So i need it to download as either csv or excel format.
After giving delimited text with comma separation in download option, the file downloaded successfully.
But the issue is, it shows empty columns & rows. There is no more data in that. The downloaded file size is only 3 kb.

When i search this issue through drupal.org i found some solutions and i tried that, but didn't solved. Even i make temp directory writable and readfile function also enabled.

Am using drupal version 7.36 and webform version 4.8 , webform rules version 1.6

Any help would be appreciate .

Comments

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented
Category: Bug report » Support request
Priority: Major » Normal

You haven't provided any information that anyone can use to help. What happens when you limit the download to just the first submission? The first 10? Limit the components? You'll need to do a lot more debugging yourself. I know of no issues with delimited file downloading. There is an issue -- than no one has been willing or able to characterize -- where some data can't be exported in Excel format, but you are using csv.

You say it "shows empty rows and columns", but a csv file doesn't have either. It has lines of text, separated by commas. Open it in a text editor to see what's in it.

selva.innoppl’s picture

selva.innoppl CreditAttribution: selva.innoppl commented

Of course the delimited text is separate by commas.But i saw it in libraca office excel sheet so that only i mentioned in columns and rows.
I limit the range to 10. Still having no records.
But only when i limit to 2 ,Its shows the record. So whats the issue.

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented

You are the only one with this installation that isn't working. I would use delimited text for testing so as to eliminate issues with Excel or another spreadsheet app. Just look at the files with a text editor.

Perhaps it's a component. Or something in your server setup. While testing, bear in mind that 1000's, probably 10,000's of sites are downloading data without an issue. So what is different about your site? Perhaps you have another module which is conflicting. Disable all other modules other than webform and its dependencies.

Try downloading only one simple component. How does that change things?

If you can't resolve this by yourself, you'll need to hire a developer to figure out what's happening.

selva.innoppl’s picture

selva.innoppl CreditAttribution: selva.innoppl commented

Am a drupal developer only.
Not am saying that the installation is not working. Its working good.
I can also download the webform results in csv. At first time once cleared my cache all my 373 submissions are successfully downloaded . But again i try to download it shows empty data. I dont know what issue is that?

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented
Status: Active » Fixed

No clue. You'll have to debug your installation to see what is happening. If clearing the cache temporarily fixes the problem, you probably have some issue with your cache setup.

Since you are a developer, I suggest you set through the code that outputs the data to see what's going wrong.

selva.innoppl’s picture

selva.innoppl CreditAttribution: selva.innoppl commented
Status: Fixed » Active

Please check with the following link :
https://www.drupal.org/node/890376

Am also having the same issue. But am using drupal version 7.36 and webform version 4.8.

I tried with above link's solution. But didn't solved my issue. Still webform results downloaded as emty csv file.
Any help would be appreciate .

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented
Status: Active » Fixed

@selva.innoppl -- I doubt anyone can help you except yourself. You or your paid developer will have to figure out what is different (and maybe wrong) with your installation, it's configuration, or modules that is causing this. For the vast majority of users, including me, the files download fine.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

john.oltman’s picture

john.oltman CreditAttribution: john.oltman commented

The File System admin page within Configuration has a field containing the path to a temporary files folder. You can experiment with changing that path to see if it helps. Of course, if you change it, make sure the new folder locations exists and is writable by "public". We moved the location on our site to solve this problem. Went from empty 90% of the time to correct 100% of the time.

surya.sairaam’s picture

surya.sairaam CreditAttribution: surya.sairaam as a volunteer commented

Hi, Just make sure that your hosting is not full eg: 100mb hosting and you have already 99mb. On this time you will have the same type of problem.

clemorphy’s picture

clemorphy CreditAttribution: clemorphy commented

I can confirm what john says in comment #9.
All my downloads (csv or xls) were empty files, until I moved the tmp folder from /tmp to /var/www/myfolder/tmp.
And then it was all good.

drall’s picture

drall CreditAttribution: drall as a volunteer commented

Here, my webform downloads (of the complete submissions table) were empty -- 0 kb. surya.sairaam's comment #10, "Just make sure that your hosting is not full" was the problem. Emptying/truncating unneeded MySQL database entries was the solution.