Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
MS CRM 3.0-Bulk Import

Answered MS CRM 3.0-Bulk Import

  • 2008. február 21. 7:53
     
     
    Bejelentkezés a szavazáshoz
    0

    Hi,

     

    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:30
    Moderátor
     
     
    Bejelentkezés a szavazáshoz
    0
    The 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:37
    Moderátor
     
     
    Bejelentkezés a szavazáshoz
    0

    check your csv file , might be in some row, there is coma (,) mentioned , so it increase header records.

     

    Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

     

     

     
  • 2008. február 21. 10:42
     
     
    Bejelentkezés a szavazáshoz
    0

     

    or mabey you saved wrong data , like you saved a string type and you want to exported on integer attripute
     
  • 2008. február 21. 11:11
     
     
    Bejelentkezés a szavazáshoz
    0

    hi,

     

    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
     
     
    Bejelentkezés a szavazáshoz
    0

    Hi Imran,

     

    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
     
     Válasz
    Bejelentkezés a szavazáshoz
    0

    Hi all,

     

    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.

     

    Thanks !