cforms II User Forum

Registration is currently disabled.
Guest

FAQs

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
CSV Export messed up
February 8, 2010
10:35 am
Guest

Please replace the ??? with your data!


Hi Oliver,

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

Any idea?

February 8, 2010
7:54 pm
Oliver
Munich, Germany
Admin
Forum Posts: 6400
Member Since:
March 6, 2005
Offline

i opened the sample file and only one record "Frau…" appears to be out of sync.

I've never seen this before…did you trim the records? I'm asking because usually the form's name is supposed to only appear once for a set of records.

February 9, 2010
7:40 am
Guest

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?)

February 10, 2010
7:13 am
Oliver
Munich, Germany
Admin
Forum Posts: 6400
Member Since:
March 6, 2005
Offline

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?

e.g. missing fields, first record of the day, submitted with Javascript turned off, certain field data….

February 10, 2010
8:25 am
Guest

OK, will try to find a pattern and get back asap

March 30, 2011
1:14 pm
kjj
Guest

Hi,

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,

 

Karl

April 5, 2011
7:53 am
Paul
Amsterdam, NL
Moderator
Forum Posts: 421
Member Since:
February 10, 2009
Offline

Hi!

Haven't heard of this before.

 

Does it always happen with text area fields?

How can I reproduce this error?

 

Paul.

* Paul Silter
August 21, 2012
8:09 pm
Pieter
Guest

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.

August 22, 2012
6:40 am
Oliver
Munich, Germany
Admin
Forum Posts: 6400
Member Since:
March 6, 2005
Offline

That's odd though, b/c the record (and hence file-) ID gets created and assigned right in that milli second the data is stored in the DB. I'll double check the code again, but fail to see how this can occur even under heavy submission circumstances…

October 18, 2012
1:34 pm
Pieter
Guest

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):

f_id sub_id field_name field_val
30486 3783 Voornaam Henk
30494 3783 Voornaam LYDIA

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:

id form_id   sub_date email ip
3783 25 2012-10-18 08:47:13 henkXXXX@telenet.be 94.XXX.XXX.21

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:

#
Form Name
e-mail Address
Date
IP
3784
Competition Kana NL
2012-10-18 08:49:20
178.XX.XX.21

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…sf-cry

Forum Timezone: Europe/Berlin

Most Users Ever Online: 959

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

tracedef: 43

mores: 21

Gyrus: 20

frozenwaste: 18

asuffredini: 15

photoworks: 14

Member Stats:

Guest Posters: 3708

Members: 1463

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 5307

Posts: 18665

Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass

Moderators: Paul (421), cnymike (8), sonika (95)

Administrators: Oliver (6400), Nicky (3)