2008. február 21. 7:53
I am facing problem in the Bulk Import. When i try to import a .csv or .txt file to the CRM application,it imports only the first 15 records.
The same happens when i try to import Leads/Accounts/Contacts.It shows the rest of the records as failures with reason 'Number of columns does not match with the header rows'
Please help me out in this.
Az összes válasz
2008. február 21. 8:30ModerátorThe most likely problem is that one or more records have either a comma (or whatever delimiter you use) in them, or they do not have the full number of fields
2008. február 21. 10:37Moderátor
check your csv file , might be in some row, there is coma (,) mentioned , so it increase header records.
2008. február 21. 10:42
2008. február 21. 11:11
i dont understand where the comma will come.
I first converted the file into .csv file and in that comma wont come anywhere.
2008. március 5. 5:01
Yesterday i could import more than 1000 records without any issues.I checked the records.But today when i tried to import the same data again,it is again importing just 15 records.I cant understand why the application is showing this kind of inconsistency.Please suggest a solution for this.
2008. március 5. 7:07
i found the solution in one of the blogs
When you save an file in Excel 2003 as csv, it does the saving correct for the first records. Then after about 15 rows it starts to leave away the last splitter signs if the columns are empty! That does indeed end up in the error as shown above. The solution is to move one of the columns which does have data for all records in there, to the last column. Then again export the file to csv and do the import. You should now be able to import the records as expected.