Hi All,
I am trying to import leads from CSV format but its showing multiple errors in the console,
2020-07-31 13:56:41.059 DEBUG 159 — [nio-8080-exec-5] c.a.meta.schema.actions.ActionGroup : action: save
2020-07-31 13:56:41.059 DEBUG 159 — [nio-8080-exec-5] c.a.meta.schema.actions.ActionGroup : wait for ‘save’, pending actions: action-import-configuration-method-run,save
2020-07-31 13:56:41.405 DEBUG 159 — [io-8080-exec-10] c.a.meta.schema.actions.ActionGroup : action: action-import-configuration-method-run
2020-07-31 13:56:41.408 DEBUG 159 — [io-8080-exec-10] c.a.a.b.s.imports.importer.Importer : Initialisation de l’import pour la configuration import-lead-config
2020-07-31 13:56:41.455 INFO 159 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter : Importing com.axelor.apps.crm.db.Lead from Lead.csv
2020-07-31 13:56:41.455 DEBUG 159 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter : Header [importId,titleSelect,enterpriseName,name,firstName,officeName,jobTitle,mobilePhone,fixedPhone,department,fax,website,primaryAddress,primaryPostalCode,primaryCity,primaryCountry.alpha3Code,email,description,contactDate,statusSelect,source.importId,statusDescription,sourceDescription,campaign.id,referredBy,isDoNotCall,partner.importId,userImportId,team.id]
2020-07-31 13:56:41.459 WARN 159 — [io-8080-exec-10] com.axelor.data.csv.CSVBinder : Bind null value to user with context: [{importId,titleSelect,enterpriseName,name,firstName,officeName,jobTitle,mobilePhone,fixedPhone,department,fax,website,primaryAddress,primaryPostalCode,primaryCity,primaryCountry.alpha3Code,email,description,contactDate,statusSelect,source.importId,statusDescription,sourceDescription,campaign.id,referredBy,isDoNotCall,partner.importId,userImportId,team.id=10,Amphisoft,RAGUL,Ragul,officeName,9094566263,test@gmail.com,1, path=/var/lib/tomcat/temp/1596201928547-0/Lead-20200731}]
2020-07-31 13:56:41.461 WARN 159 — [io-8080-exec-10] com.axelor.data.csv.CSVBinder : Bind null value to createdBy with context: [{importId,titleSelect,enterpriseName,name,firstName,officeName,jobTitle,mobilePhone,fixedPhone,department,fax,website,primaryAddress,primaryPostalCode,primaryCity,primaryCountry.alpha3Code,email,description,contactDate,statusSelect,source.importId,statusDescription,sourceDescription,campaign.id,referredBy,isDoNotCall,partner.importId,userImportId,team.id=10,Amphisoft,RAGUL,Ragul,officeName,9094566263,test@gmail.com,1, path=/var/lib/tomcat/temp/1596201928547-0/Lead-20200731}]
EEE: java.lang.reflect.InvocationTargetException
2020-07-31 13:56:41.462 ERROR 159 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter : Error while importing Lead.csv.
2020-07-31 13:56:41.462 ERROR 159 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter : Unable to import record: [10,Amphisoft,RAGUL,Ragul,officeName,9094566263,test@gmail.com,1,]
I have import only one contact and below is the CSV file content,
importId,titleSelect,enterpriseName,name,firstName,officeName,jobTitle,mobilePhone,fixedPhone,department,fax,website,primaryAddress,primaryPostalCode,primaryCity,primaryCountry.alpha3Code,email,description,contactDate,statusSelect,source.importId,statusDescription,sourceDescription,campaign.id,referredBy,isDoNotCall,partner.importId,userImportId,team.id
10,,Amphisoft,RAGUL,Ragul,officeName,,9094566263,,,,,,,,,test@gmail.com,1,
Please let me know the issue and how to resolve this?
Thanks
Pradeep D