- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Upload file Question results: Corrupted entries, cause reset and no download
- w3rdna
- Topic Author
- Offline
- New Member
Less
More
12 years 1 month ago - 12 years 1 month ago #78214
by w3rdna
Upload file Question results: Corrupted entries, cause reset and no download was created by w3rdna
I have been trying to use the multiple selection download and kept having it fail in a certain block of files. I tracked it down to a single entry that when included or done by itself caused the window to "reset" back to the 0th record with 50 spacing and not download. I can probably get the individual to get me the file but that may not always be the case so:
UPDATE: the file for the entry is missing thus the barfing on download. Record show submission as completed with file upload.
1) Any idea what may have corrupted the file upload. Is there a diagnostic to check.
2) Is there a "good" way to directly access the files from the server to recover it. You can find the files in the upload dir under the survey but the file names have no correspondence or association with the records. Any way to decipher the names. (I subsequently realized I could use date but that is cumbersome.) Could the names be placed in the record or just use the index number in someway in the file naming? What advantages is there for names like fu_vcqr27vzfgjqn4n?
3) It was a pain to figure out what was going on with the corrupted entry. I thought it might be file size, browser, star moon alignment, etc. Is there a method to report the failure in the zip file but carry on with the download.
4) It would be nice to dump all the files with one click. It would even be okay if it was done sequentially to their own zip as opposed to a monolithic zip.
UPDATE: the file for the entry is missing thus the barfing on download. Record show submission as completed with file upload.
1) Any idea what may have corrupted the file upload. Is there a diagnostic to check.
2) Is there a "good" way to directly access the files from the server to recover it. You can find the files in the upload dir under the survey but the file names have no correspondence or association with the records. Any way to decipher the names. (I subsequently realized I could use date but that is cumbersome.) Could the names be placed in the record or just use the index number in someway in the file naming? What advantages is there for names like fu_vcqr27vzfgjqn4n?
3) It was a pain to figure out what was going on with the corrupted entry. I thought it might be file size, browser, star moon alignment, etc. Is there a method to report the failure in the zip file but carry on with the download.
4) It would be nice to dump all the files with one click. It would even be okay if it was done sequentially to their own zip as opposed to a monolithic zip.
Last edit: 12 years 1 month ago by w3rdna.
The topic has been locked.
- w3rdna
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
12 years 1 month ago - 12 years 1 month ago #78220
by w3rdna
Replied by w3rdna on topic Upload file Question results: Corrupted entries, cause reset and no download
I just noticed that the attached file field carries more information when exported to excel or csv. It has the original file name and the name used to store it on the server along with other information in the string. That is very helpful, thank you. I was not expecting it to be different than what is displayed through the limesurvey interface.
Last edit: 12 years 1 month ago by w3rdna.
The topic has been locked.
- duvemyster
- Offline
- Senior Member
Less
More
- Posts: 60
- Thank you received: 6
10 years 3 months ago #103317
by duvemyster
Replied by duvemyster on topic Upload file Question results: Corrupted entries, cause reset and no download
Thank you for your entries above, as they pointed me in the right direction.
It happened to be the entry for the largest one of the files I was looking at that was corrupt, and at first I mistakenly assumed that filesize was the culprit.
In this case the database record had the filename recorded as "??tmp_yadayadayada_ext". I was able to deduce from the filesize what the filename in that entry should be, and confirmed through search that it didn't exist in another record. And then after making the manual change in the database to the correct filename, all was then working smoothly. Yes, it was the correct file.
It happened to be the entry for the largest one of the files I was looking at that was corrupt, and at first I mistakenly assumed that filesize was the culprit.
In this case the database record had the filename recorded as "??tmp_yadayadayada_ext". I was able to deduce from the filesize what the filename in that entry should be, and confirmed through search that it didn't exist in another record. And then after making the manual change in the database to the correct filename, all was then working smoothly. Yes, it was the correct file.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13684
- Thank you received: 2497
10 years 3 months ago #103366
by DenisChenu
1st : is user choose the same file name, we have to rename the file
2nd : If we leave file name clean (and extensions), then all web can access easily to the file ....
It's not perfect, we need a better way (easy way to put this file in a directory not on the web), but take time to fix.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Upload file Question results: Corrupted entries, cause reset and no download
Add some security ....What advantages is there for names like fu_vcqr27vzfgjqn4n?
1st : is user choose the same file name, we have to rename the file
2nd : If we leave file name clean (and extensions), then all web can access easily to the file ....
It's not perfect, we need a better way (easy way to put this file in a directory not on the web), but take time to fix.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- duvemyster
- Offline
- Senior Member
Less
More
- Posts: 60
- Thank you received: 6
10 years 3 months ago #103499
by duvemyster
Replied by duvemyster on topic Upload file Question results: Corrupted entries, cause reset and no download
Well thought through and well done on the use of filenames like fu_vcqr27vzfqjqn4n!
The case I ran into above was a database record that contained a different filename from the final name. The filename in the database contained "tmp" and it would seem logical that a temporary name may be utilized during the upload process.
I've run into this a couple of times but haven't replicated it. Perhaps two users were sharing the same persistent token link at the same time and one a second user's entry interrupted the first user's transaction? I know limesurvey isn't designed to accommodate that type of use, though that type of survey respondent behavior might be one plausible explanations.
The case I ran into above was a database record that contained a different filename from the final name. The filename in the database contained "tmp" and it would seem logical that a temporary name may be utilized during the upload process.
I've run into this a couple of times but haven't replicated it. Perhaps two users were sharing the same persistent token link at the same time and one a second user's entry interrupted the first user's transaction? I know limesurvey isn't designed to accommodate that type of use, though that type of survey respondent behavior might be one plausible explanations.
The topic has been locked.
- ahmadaub
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
9 years 7 months ago #112808
by ahmadaub
Replied by ahmadaub on topic Upload file Question results: Corrupted entries, cause reset and no download
I'm having the same problem with V.2, any insight on how to fix it?
regards,
regards,
The topic has been locked.