import people by csv

[Anonymous]

I tried to import people with CSV but it always shows:
Import finished: 0 inserts, 0 updates, 0 errors
Even use the example in documentation got the same result.

I modified the eme_import_csv_people function to figure out the problem, and got the result:
Not all required fields present. Import finished: 0 inserts, 0 updates, 0 errors
and then I rendered my $headers got: lastname,firstname,email,answer_uid

Looks like it stuck in checking the required columns, even though they are surely exist?

[Franky]

Could you post an example CSV here? I’ll try it myself then. Also: try with enclosed double quotes, that should work better (I changed the doc for that)

[Anonymous]

quotes or not didn’t change anything…

The CSV I tried was:
“lastname”,”firstname”,”email”,”answer_UID”
“李”,”四”,”dzyj529@gmail.com”,”A002″

Also I tried the example in the document:
“lastname”,”firstname”,”email”,”zip”
“Van Liedekerke”,”Franky”,”liedekef@telenet.be”,”2820″
“Van Liedekerke2″,”Franky”,”liedekef@telenet.be”,”2820″

gave me the same result:
Not all required fields present. Import finished: 0 inserts, 0 updates, 0 errors

[Franky]

Just tried it here with exactly this:

"lastname","firstname","email","zip"
"Van Liedekerke2","Franky","iedekef@telenet.be","2820"

Works just fine … make sure the quotes are regular double quotes (see https://practicaltypography.com/straight-and-curly-quotes.html)

[Anonymous]

I found the problem…
because the chinese couldn’t be imported successfully, I changed the encoding to utf8
and utf8 was decoded wrong so some fields were missed.

[Author]

Posts