I first import accounts and it is done successfully.
When i try to import contacts it will import if imported without any relationships but once i choose account name to link data of both modules, it stops and showing many warnings that some fields in account is undefined.
Fields exist and filled with data. But in account that is why i canāt map it from contacts import wizard.
Hi @sarahmdht, which is your SuiteCRM version?
Could you please past here the warning messages youāre receiving?
Starting with Accounts is a good approach if you already set up your Users; usually the import order is:
ok, which is your PHP version?
Are you on SuiteCRM 7 or 8?
Hello Sara,
Iāve had sometimes sth. similar and in one project it took a lot of debugging to figure out the issue.
alt_address_street_2 and primary_address_street_3:
Do you have these columns in your CSV file?
Do you have them mapped in the import wizard?
Are any of them required fields in your CRM?
event_invite_id:
Youāve got a related event to the contact there?
Thatās correct and you can see this event field inside the contact when you create a contact manually?
In general:
Can you create one contact manually, export it, update one field and re-import again?
How many records do you have in your file?
Can you break the file down in multiple smaller CSV files?
Do you have a , or ; separated list?
Do the value fields contain , or ;?
Are there line breaks in the values / multi line fields with values in your CSV?
Are there hidden / special character in your CSV?
Is the CSV UTF-8 encoded?
If you open your CSV file in Notepad++ or similar, does it all look good and smooth?
Can you reduce the columns of your import (if there are empty columns, remove them from your CSV)?
Itās probably not the problem, but:
Data migrations can be incredibly complex for being a simple import.
Try to approach the whole topic with smaller chunks first (a few lines, bare minimum of columns).
I have 5700 record to import, i cleaned the file it was in a total mess, now I reached the state that if I work 100 by 100 and set these warning fields to default value N/A they are done, if i try the >5000 records with the same approach warnings appear
Itās a good sign that some smaller batches are importing fine.
I assume there are some issues with the CSV somewhere.
Try to split it in bigger batches - try 500 lines and then import batch by batch, see how far you can get.
If you hit the ātroublesomeā batch / file, split this up further and see where you find the issue.
An Update: It looks like memory or cache issue, I divided the data into 100 record each, then the data enters normally but starting from the 6th file it shows these warnings, after leaving the system for 5 minutes it starts to accept records again.
Awesome! So, are you able to import all accounts?
