Please replace the ??? with your data!
- URL to the FORM: http://www.automotiveit.eu/automotiveday2010
- The browser used: FF 3.5.7
- cforms version: 10.5.2
- Your Wordpress version: 2.9.1
when I open exprted CSV files in Excel or Open Office some of the entries are messed up. The do not appear under their correct heading (column) but somewhere in the table you would never expect them.
Have a look at http://www.der-prinz.com/test.csv
March 6, 2005
Frau XY is exactly what I mean. There are some others in the complete record set as well.
I trimed or shortened the records because i didn´t wanted to post so many adress records to the public ;-)
I can send you the complete file via email if you like (to which adress?)
March 6, 2005
no need to.
can you find out what triggers this, in other words what do theses unusually formatted records have in common, or the ones just before or after?
OK, will try to find a pattern and get back asap
since I have the same problem with exporting in CSV (apparently it has something to do with textareas that mess lines), could anyone tell me if this problem has been solved and how ?
I'm using latest version of cforms II and it works very well, but while the textarea contents are perfectly saved and displayed within cforms admin panel, that's not the case while exporting in CSV, where most of the lines are anyway good.
Thanks in advance,
February 10, 2009
Haven't heard of this before.
Does it always happen with text area fields?
How can I reproduce this error?
I have found the pattern: Some entries have the same ID. The pattern with this bug is that the form data is filled in around the same moment. So when some people fill in a form while someone else is busy, it's saved at the same ID. That way it's exported in Excel at the same line. I have some examples where there are more than 5 form fields stored at the same line.
March 6, 2005
When looking in phpadmin at the database, in the _cformsdata table I can find several data entries under the same sub_id.
Example (data anonimized):
The people who entered this data (Henk and LYDIA) some way got the same sub_id, while the f_id is unique. The CSV is only messed up where the sub_id field is a shared factor.
When looking for Henk in the _cformsubmissions table I can find this:
I can't find LYDIA by searching for id 3783 in that _cformsubmission table. She isn't exported in the csv file neither. When looking on the tracking page table itself, I can find her by her mail adres:
Competition Kana NL
I can't find her on the # within the tracking page, then the table only shows Henk his entry.
You see, somehow the system must have saved different data on the same id…
Most Users Ever Online: 959
Currently Browsing this Page:
Guest Posters: 3739
Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass
Moderators: Paul (421), cnymike (8), sonika (95)
Administrators: Oliver (6400), Nicky (3)