First, what are those queries for, there not ones created by Connections or the CSV Import???
re: Since my WordPress is in French, the automapping didn’t recognise my first CSV, the one where I was using the native english column names (Work Adress, instead of Travail Adress)…
re: Is there an easier way to rename the columns so they match the auto-mapping name you have?
If you used the columns names as shown in the
CSV File Setup, they’ll automap just fine. I switch my dev WordPress to French and used the column headers suggested in the
CSV File Setup section and they automapped as they should.
re: I figured it needed BOTH first AND last name to keep it set as individual, otherwise it would default out to organization…
Yes, this is explained in the instructions in the section
CSV File Setup. Here’s what it says:
The import process will automatically attempt to identify the entry type. It does this by checking to see if the CSV text file has first and last name or organization name fields and that they were mapped to the matching Connections fields. For example, if a row in the CSV text file has a first and a last name that row would import as an Individual. Or if a row has only an organization name that row would be imported as an Organization. If the row contains both a first / last name and an organization name the entry would be imported as an Individual. You can explicitly specify the entry type of each row to be imported as by adding an Entry Type column to the CSV text file and setting each row as either individual or organization. In Step 2 you would map the CSV Entry Type column to the Entry Type field.
I downloaded the CSV file you attach and it didn’t have headers at all so I was not able to test it to see if I could duplicate the issue. Can I have a copy of the full CSV file? I’d like to see if I can duplicate the issues you have explained.