Events Made Easy › Forums › How do I … › cvs import persons
- This topic has 5 replies, 2 voices, and was last updated 3 years ago by Franky.
-
AuthorPosts
-
Thu 11 Nov 2021 at 15:31 #63430AnonymousInactive
Hi Franky,
The cvs export works perfect. But when I want to import a cvs I got the following problems:
The headings of the exported cvs are in my language (in my case Dutch), when I use the same headings nothing happens. Only when I change it to the headings I found in the mysql database, it works. Could it be possible that it recognise the same headings as the export?
The same with massmail en gdpr: In the exported cvs, the answers are in words (yes, no / ja, nee). The imported cvs doesn’t recognise that, it has to be 1 or 0. Is is confusing. And if you use a existing list and add things, I need to change those collums. Could it be possible that it recognise the Ja, Nee for gdpr and massmail? Or it just stays 1 or 0 everywhere.
And my own fields are exported in cvs, but If I import persons with information in my own fields (with the same headings) there are no changes. Could it be possible to use the names of my own fields as headings to import cvs?
Warm greetings
StijnThu 11 Nov 2021 at 16:00 #63432AnonymousInactiveAnd another thing with the cvs import:
If I want to import persons without firstname and/or lastname, I can’t. And If I put ‘Geen familienaam’, the same as shown with export, it adds ‘Geen familienaam’ it becomes the real lastname, not just the text that it doesn’t exist. And with the export of an empty firstname, the cvs field is empty. But importing is not possible empty. Could it also be possible to import empty firstname or lastname fields.Thanks
StijnThu 11 Nov 2021 at 16:34 #63433FrankyKeymasterFor import titles and values are defined in the doc and need to be just that. It is just way too hard to try and detect the language and translate the language in the normal string (there’s no such function in wordpress).
Importing custom fields is also documented, the column title needs to be “answer_” followed by the title of the custom field (or the id, because if the title contains spaces that can fail).
Concerning empty lastname/firstname: you can import empty names: just define the column (“lastname” or “firstname”) and put as value “” (depending on the enclosure you use). That should work just fine.Thu 11 Nov 2021 at 17:23 #63435AnonymousInactiveThanks for the answer.
Sorry that I didn’t look into the documentation, I forgot to look there.
That is clear for me.To make it easy to import an changed exported document. Would it be possible to export a cvs the same way as you import it?
And thanks a lot.
Thu 11 Nov 2021 at 17:49 #63436AnonymousInactiveIf I add “” to firstname and lastname, the quotes are now the firstname and lastname, it is not empty. How do I arrange that?
Thu 11 Nov 2021 at 18:27 #63437FrankyKeymasterThat means your CSV contains double quotes (with the second ones escaped). Check your generated CSV …
-
AuthorPosts
- The forum ‘How do I …’ is closed to new topics and replies.