Bulk Import Wizard for Leads Issue - source file corrupt message

Hi,

I am trying to import Lead records using a CSV file containing around 3,000 
records.

I have tested with around 20 records (taken from the larger file) and it 
imports fine but when I select the the 3,000 record file for import the 
wizard gives an error message somthing like (sorry don't have exact wording) 
'Source Import file is corrupt'.

Are there any known issues with CSV files such as the following :

1) Special characters such as an asterix not handled 
2) Email and Website type fields must all be correctly formatted?
3) File is too large

Thanks for your help in advance



0
Utf
1/27/2007 3:01:01 PM
crm 35858 articles. 1 followers. Follow

6 Replies
912 Views

Similar Articles

[PageSpeed] 47

Hi Agile,

I have tried to import 10000 records and I have not had any issues. 
Could you try to split it up into small group and try it again. Don't 
use the original CSV file, try to create a new file to see if it works 
for you.

Hope this helps!

Darren Liu
Crowe Chizek and Company
http://www.crowecrm.com

On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com> 
wrote:
> Hi,
>
> I am trying to import Lead records using a CSV file containing around 3,000
> records.
>
> I have tested with around 20 records (taken from the larger file) and it
> imports fine but when I select the the 3,000 record file for import the
> wizard gives an error message somthing like (sorry don't have exact wording)
> 'Source Import file is corrupt'.
>
> Are there any known issues with CSV files such as the following :
>
> 1) Special characters such as an asterix not handled
> 2) Email and Website type fields must all be correctly formatted?
> 3) File is too large
>
> Thanks for your help in advance

0
Darren
1/27/2007 3:07:44 PM
Yes invevitably that's what I'll have to do but hasn't anyone else come 
across this message?

"Darren Liu" wrote:

> Hi Agile,
> 
> I have tried to import 10000 records and I have not had any issues. 
> Could you try to split it up into small group and try it again. Don't 
> use the original CSV file, try to create a new file to see if it works 
> for you.
> 
> Hope this helps!
> 
> Darren Liu
> Crowe Chizek and Company
> http://www.crowecrm.com
> 
> On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com> 
> wrote:
> > Hi,
> >
> > I am trying to import Lead records using a CSV file containing around 3,000
> > records.
> >
> > I have tested with around 20 records (taken from the larger file) and it
> > imports fine but when I select the the 3,000 record file for import the
> > wizard gives an error message somthing like (sorry don't have exact wording)
> > 'Source Import file is corrupt'.
> >
> > Are there any known issues with CSV files such as the following :
> >
> > 1) Special characters such as an asterix not handled
> > 2) Email and Website type fields must all be correctly formatted?
> > 3) File is too large
> >
> > Thanks for your help in advance
> 
> 
0
Utf
1/28/2007 12:55:00 PM
It must be some error in your data. For example field is too long for name.
You also can change the import log message from the Activties->types as bulk 
import.

"Agile CRM" wrote:

> 
> Yes invevitably that's what I'll have to do but hasn't anyone else come 
> across this message?
> 
> "Darren Liu" wrote:
> 
> > Hi Agile,
> > 
> > I have tried to import 10000 records and I have not had any issues. 
> > Could you try to split it up into small group and try it again. Don't 
> > use the original CSV file, try to create a new file to see if it works 
> > for you.
> > 
> > Hope this helps!
> > 
> > Darren Liu
> > Crowe Chizek and Company
> > http://www.crowecrm.com
> > 
> > On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com> 
> > wrote:
> > > Hi,
> > >
> > > I am trying to import Lead records using a CSV file containing around 3,000
> > > records.
> > >
> > > I have tested with around 20 records (taken from the larger file) and it
> > > imports fine but when I select the the 3,000 record file for import the
> > > wizard gives an error message somthing like (sorry don't have exact wording)
> > > 'Source Import file is corrupt'.
> > >
> > > Are there any known issues with CSV files such as the following :
> > >
> > > 1) Special characters such as an asterix not handled
> > > 2) Email and Website type fields must all be correctly formatted?
> > > 3) File is too large
> > >
> > > Thanks for your help in advance
> > 
> > 
0
Utf
1/29/2007 5:14:00 AM
open the csv file in notepad and then click file saveas and then choose 
unicode in the encoding list and try to import again

==============================
John O'Donnell
Microsoft CRM MVP
http://www.crowecrm.com


"Andrew" <Andrew@discussions.microsoft.com> wrote in message 
news:F4D663B0-0943-4ADF-BD40-1AC91070A71D@microsoft.com...
> It must be some error in your data. For example field is too long for 
> name.
> You also can change the import log message from the Activties->types as 
> bulk
> import.
>
> "Agile CRM" wrote:
>
>>
>> Yes invevitably that's what I'll have to do but hasn't anyone else come
>> across this message?
>>
>> "Darren Liu" wrote:
>>
>> > Hi Agile,
>> >
>> > I have tried to import 10000 records and I have not had any issues.
>> > Could you try to split it up into small group and try it again. Don't
>> > use the original CSV file, try to create a new file to see if it works
>> > for you.
>> >
>> > Hope this helps!
>> >
>> > Darren Liu
>> > Crowe Chizek and Company
>> > http://www.crowecrm.com
>> >
>> > On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com>
>> > wrote:
>> > > Hi,
>> > >
>> > > I am trying to import Lead records using a CSV file containing around 
>> > > 3,000
>> > > records.
>> > >
>> > > I have tested with around 20 records (taken from the larger file) and 
>> > > it
>> > > imports fine but when I select the the 3,000 record file for import 
>> > > the
>> > > wizard gives an error message somthing like (sorry don't have exact 
>> > > wording)
>> > > 'Source Import file is corrupt'.
>> > >
>> > > Are there any known issues with CSV files such as the following :
>> > >
>> > > 1) Special characters such as an asterix not handled
>> > > 2) Email and Website type fields must all be correctly formatted?
>> > > 3) File is too large
>> > >
>> > > Thanks for your help in advance
>> >
>> > 


0
John
1/29/2007 5:19:02 AM
Hi,
If none of the other posts have solved your issue, try this.

go to the registry,
My computer\HKEY_local_Machine\Software\microsoft\mscrm
and then open the key 'maxuploadfilesize', increase its size value (just add 
a couple of more 0's at the end)
and then try to import your file.



"John O'Donnell" wrote:

> open the csv file in notepad and then click file saveas and then choose 
> unicode in the encoding list and try to import again
> 
> ==============================
> John O'Donnell
> Microsoft CRM MVP
> http://www.crowecrm.com
> 
> 
> "Andrew" <Andrew@discussions.microsoft.com> wrote in message 
> news:F4D663B0-0943-4ADF-BD40-1AC91070A71D@microsoft.com...
> > It must be some error in your data. For example field is too long for 
> > name.
> > You also can change the import log message from the Activties->types as 
> > bulk
> > import.
> >
> > "Agile CRM" wrote:
> >
> >>
> >> Yes invevitably that's what I'll have to do but hasn't anyone else come
> >> across this message?
> >>
> >> "Darren Liu" wrote:
> >>
> >> > Hi Agile,
> >> >
> >> > I have tried to import 10000 records and I have not had any issues.
> >> > Could you try to split it up into small group and try it again. Don't
> >> > use the original CSV file, try to create a new file to see if it works
> >> > for you.
> >> >
> >> > Hope this helps!
> >> >
> >> > Darren Liu
> >> > Crowe Chizek and Company
> >> > http://www.crowecrm.com
> >> >
> >> > On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com>
> >> > wrote:
> >> > > Hi,
> >> > >
> >> > > I am trying to import Lead records using a CSV file containing around 
> >> > > 3,000
> >> > > records.
> >> > >
> >> > > I have tested with around 20 records (taken from the larger file) and 
> >> > > it
> >> > > imports fine but when I select the the 3,000 record file for import 
> >> > > the
> >> > > wizard gives an error message somthing like (sorry don't have exact 
> >> > > wording)
> >> > > 'Source Import file is corrupt'.
> >> > >
> >> > > Are there any known issues with CSV files such as the following :
> >> > >
> >> > > 1) Special characters such as an asterix not handled
> >> > > 2) Email and Website type fields must all be correctly formatted?
> >> > > 3) File is too large
> >> > >
> >> > > Thanks for your help in advance
> >> >
> >> > 
> 
> 
> 
0
Utf
1/29/2007 9:30:00 PM
Sorry for not closing off this thread sooner - after modifying the data 
(possibly wrongly formated email fields) it worked OK.

"~Jij" wrote:

> Hi,
> If none of the other posts have solved your issue, try this.
> 
> go to the registry,
> My computer\HKEY_local_Machine\Software\microsoft\mscrm
> and then open the key 'maxuploadfilesize', increase its size value (just add 
> a couple of more 0's at the end)
> and then try to import your file.
> 
> 
> 
> "John O'Donnell" wrote:
> 
> > open the csv file in notepad and then click file saveas and then choose 
> > unicode in the encoding list and try to import again
> > 
> > ==============================
> > John O'Donnell
> > Microsoft CRM MVP
> > http://www.crowecrm.com
> > 
> > 
> > "Andrew" <Andrew@discussions.microsoft.com> wrote in message 
> > news:F4D663B0-0943-4ADF-BD40-1AC91070A71D@microsoft.com...
> > > It must be some error in your data. For example field is too long for 
> > > name.
> > > You also can change the import log message from the Activties->types as 
> > > bulk
> > > import.
> > >
> > > "Agile CRM" wrote:
> > >
> > >>
> > >> Yes invevitably that's what I'll have to do but hasn't anyone else come
> > >> across this message?
> > >>
> > >> "Darren Liu" wrote:
> > >>
> > >> > Hi Agile,
> > >> >
> > >> > I have tried to import 10000 records and I have not had any issues.
> > >> > Could you try to split it up into small group and try it again. Don't
> > >> > use the original CSV file, try to create a new file to see if it works
> > >> > for you.
> > >> >
> > >> > Hope this helps!
> > >> >
> > >> > Darren Liu
> > >> > Crowe Chizek and Company
> > >> > http://www.crowecrm.com
> > >> >
> > >> > On Jan 27, 9:01 am, Agile CRM <Agile...@discussions.microsoft.com>
> > >> > wrote:
> > >> > > Hi,
> > >> > >
> > >> > > I am trying to import Lead records using a CSV file containing around 
> > >> > > 3,000
> > >> > > records.
> > >> > >
> > >> > > I have tested with around 20 records (taken from the larger file) and 
> > >> > > it
> > >> > > imports fine but when I select the the 3,000 record file for import 
> > >> > > the
> > >> > > wizard gives an error message somthing like (sorry don't have exact 
> > >> > > wording)
> > >> > > 'Source Import file is corrupt'.
> > >> > >
> > >> > > Are there any known issues with CSV files such as the following :
> > >> > >
> > >> > > 1) Special characters such as an asterix not handled
> > >> > > 2) Email and Website type fields must all be correctly formatted?
> > >> > > 3) File is too large
> > >> > >
> > >> > > Thanks for your help in advance
> > >> >
> > >> > 
> > 
> > 
> > 
0
Utf
2/16/2007 11:58:05 PM
Reply:

Similar Artilces:

#Delete Mark in Bound Memo filed
I have form that has bound memo field, sometime, no sure how it happen, the memo filed is filled with #Delete. My application is a stand alone program. Kindly advise what can cause this and how to avoid it from happening. -- TS Lim When was the last time you performed a compact and repair? Is you db split? Does each user have their own copy of the front-end? Please checkout http://www.granite.ab.ca/access/corruptmdbs.htm http://www.granite.ab.ca/access/corruption/symptoms.htm http://office.microsoft.com/en-ca/access/HA011865661033.aspx - No very helpful but directly from MS ...

Caption Issue #2
The newsletter has a colored gradient with columns. The caption in the column has a white background. How can one include the gradient in the caption to match the overall scheme? >-----Original Message----- >The newsletter has a colored gradient with columns. The >caption in the column has a white background. How can one >include the gradient in the caption to match the overall >scheme? >. > Hi - If you set the fill to "no fill" would that give you the effect you are looking for (the background will show through.) OR fill> fill effects and ...

CSV File Problem
Can any one explain why the following problem occurs please? A colleague has a small list of data which is a csv file exported from SQL. Column One is a serial number from 1 to 29. Column 2 is a number of transactions which have occurred.(it should look like example A below in Excel) 1 475 1,475 2 1732 21,732 3 1670 31,670 4 2176 42,176 5 608 5,608 6 1579 61,579 7 43101 743,101 8 54512 854,512 9 51258 951,258 10 61050 1,061,050 A B If I double click on the csv file, it opens in Excel but c...

Leading and trailing spaces trimmed with SQL XML
Hi, I am inserting data into a table using xml bulk insert. One of the field is of string type and contains data with leading and trailing spaces. But on insert the spaces automatically trimmed off. Can you please tell me how to avoid this trimming of spaces, as i have to insert data using xml. EXEC sp_xml_preparedocument @hDoc OUTPUT, @InsertLines INSERT INTO tblLine WITH (TABLOCKX) ([Text]) SELECT [Text] FROM OPENXML (@hDoc, '/Lines/Line', 1) WITH ([Text] nvarchar(max)) EXEC sp_xml_removedocument @hDoc Thank you Frank bad_clone (bad_clone@hotmail.com) writes: ...

CFile (delete file)
How can I delete all files that end with ".temp" in some folder? CFile::Remove remove unlink -- cheers, Alok Gupta Blogs: http://wdevs.com/thatsalok "Petar Popara" <my.fake@mail.net> wrote in message news:Op6#URKfFHA.2644@TK2MSFTNGP09.phx.gbl... > > How can I delete all files that end with ".temp" in some folder? > > SHFileOperation() will and it supports wildcards! DeleteFile() will operate on one file at a time. "Petar Popara" <my.fake@mail.net> wrote in message news:Op6%23URKfFHA.2644@TK2MSFTNGP09.phx.gbl... > >...

Opening an *.MSG file with it's respective attachment.
Hello, The file *.MSG is a message file. This can be viewed by any editor, like Notepad. However, when there's an attachment to it, we see garbage. Is there a way to open the attachments present inside the *.MSG files ? Thank you Yes, by opening it with Outlook. -- Roady [MVP] www.sparnaaij.net Microsoft Office and Microsoft Office related News Also Outlook FAQ, How To's, Downloads and more... Tips of the month: -Create your own fully customized Toolbar -Creating a Classic View in Outlook 2003 Subscribe to the newsletter to receive news and tips & tricks in your mailbox!...

Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP and MS Money 2005. I am now unable to open my previously converted 2005 file or restore any backup version. I consistently get the following error message: "Money cannot locate filename or cannot open it, possibly because it is a read-only file, you do not have permission to change it, or your disk drive is write- protected. If you have chosen the correct file and it cannot be accessed, you will need to click OK and then Restore your most recent backup file." Any help or thoughts would be greatly ap...

import a 123 file
My excel version cannot open a Lotus 123 file. Is there an import feature to move the data from Lotus 123 to Excel? Thanks No, you need to convert the file either from Lotus 123 or get commercial converter -- Regards, Peo Sjoblom "Frank" <Frank@discussions.microsoft.com> wrote in message news:59B55F98-4C79-4917-928B-F1B309660730@microsoft.com... > My excel version cannot open a Lotus 123 file. Is there an import feature > to > move the data from Lotus 123 to Excel? > Thanks > > ...

Where is the cache files folder located for windows media player?
Does windows media player have a cache files folder? Where is the cache files folder located for windows media player? Or how do I find the cache files folder for windows media player? Thank You for your Help. Bob Background info: I have a desktop AMD 4400+ 64X2 4GB memory 320GB HD(way bigger than I need) Acer computer (AM3100-U3201A) I purchased new February 2008 running 32-bit MS Vista Home Premium SP2 box. I use MS auto updates. I think it has onboard shared memory for video and sound. My ISP is Comcast 12mbps with Motorola SURFboard SB5101 Cable Modem direct to...

How Do I Import Stock Quotes to Money2004 Standard?
Does anyone know how to import stock quotes into Money. Some of the ones I am interested in are not supported by MSN for online update. I know I can enter the data manually but I want to be able to update prices for multiple stocks on a regular basis. I have tried ceating a .ofx file for importing and Money reports "Import Completed" with no errors but the price I specified does not appear in the price history. The extract from the .ofx file relating to price I was trying to import is as follows: <SECLISTMSGSRSV1> <SECLIST> <STOCKINFO> <SECINFO> <S...

Messages Cut off
A recipient receives forwarded mail messages that are cut off in random locations throughout the email. Outlook 2000 with latest SP. Any ideas? ...

Public Folder link to Excel File
Hi - I have a user that claims that he had a shortcut to a spreadsheet "in his public folders" at his old job. Obviously, he's an end user that may or may not know what he's talking about.... I'm trying to figure out the best way to accomodate him. He basically wants an Excel file stored on a shared folder to be available to all user as either a shortcut, or a link in the public folders (can't post to a folder as he will be updating the sheet regularly). When a user clicks on the shortcut/link, it would just launch Excel and display the file. Anybody have any ideas...

Interface not registered message
when i try to send a e-mail message through outlook, i get the message interface not registered ? and then can't even save message. can anyone tell me why ? ...

Outlook Hangs Reading Messages
I am running Windows XP Pro & Outlook 2003 via POP3 & Symantec AV I had to reinstall everything on my pc and now find when I double click an email outlook hangs for roughly a minute and then it finally opens, I have tried a data compact, reinstalling outlook and creating a new pst then importing but it still happens Does anyone have any ideas? It's driving me mad Thanks Daz Try deleting and recreating the profile as one of your steps in troubleshooting: http://www.howto-outlook.com/Faq/newprofile.htm -- K. Orland Thoughts lead on to purposes; purposes go forth in action; ...

Corrupt "Deleted Items" folder
I am unable to empty the "Deleted Items" folder. The error that comes up tells me that the "Outlook.pst" file has errors in it and to use the "Repair Inbox Tool". I've tried using the repair function under the "help" menu...to no avail. I have also tried opening the "Outlook.pst" file in MS Word, but the file is 129 megabytes! It crashes MS Word when I try to open it. Any ideas? Look for scanpst.exe on your local drive and run it against your outlook.pst file >-----Original Message----- >I am unable to empty the "Del...

Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter which is using Publisher 97 The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200 Thank Richard this is caused by Publisher 97 not been printer independent. Even if you went back to Publisher 2000, unless you have the identical font versions and printer driver you would have issues with formatting. It sounds like the person sending you the file has a garbage HP inkjet printer. Get them to install the HP5P laser p...

Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and replace) My database pulls in the excel file names from a directory, with it's subfolders and contents as well. Every file begins with "Kay Form". Kay no longer works in our department, and I'd like to run a loop that replaces "Kay Form" with "Featured Track". I don't know how to do a partial replace though. Thank you in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201001/1 Checkout the Replace function. I...

Isinteg Warning Message Question
I ran isinteg -pri -test alltests. I came up with 506 warnings. There are basically 4 types of warnings. They are below. Are these something I need to worry about? What should I do? thanks stewart sschwartz@nal.usda.gov ================================== Warning: MsgFolder 165 (Fid=0001-0000000D1864, Mid=0001- 0000000D559D, Inid=0001-000000F33436): PR_READ_RECEIPT_REQUESTED(0029000B) prop in Messages table and MsgFolder table do not match. Warning: MsgFolder 4 (Fid=0001-0000086DC911, Mid=0001- 00000436F972, Inid=0001-000004A583F1): Error JET_errRecordNotFound seeking to INID for this ...

Wrong message with cascading deletes
A2003: Table Person linked 1 X M to table Activity. The relationship has its Referential Integrity checkbox and the Cascade Delete checkbox both checked. When I delete a person all related Activity records are deleted which is to be expected. According to http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should get the following message in this case: "Relationships that specify cascading deletes are about to cause 1 record(s) in this table and in related tables to be deleted. Are you sure you want to delete these records?" In stead I get: &quo...

Duplicate Messages
I have just upgraded from Office 2000 to Office XP. Ever since, i have been receiving duplicate email messages. Every time i do a send/receive, about 80% of my emails arrive twice (exactly the same ID, time, date etc.) I have got some rules running but these are necessary. Any ideas anyone. Thanks ...

printing imported gif files in Excel
When printing gif file with transparent background on the grey(25%) background of Excel non-transparent part of the picture has white border around it. Is there any way to prevent it? Thank you in advance... Tim ...

unknown .edb file
I have error messages in the log files that references a corrupt database named C:\Program Files\exchsrvr\Exchangeserver_Outlook.edb. "Outlook" is the name of the server. The problem is that this database is not listed in any of the Mail Stores or Public stores. I want to run the repair utilities on it, but since I'm not sure what it is used for, I don't know how I can restore it if the repair goes bad. Does anyone know what this is used for or how I can determine that myself? BTW, the database always has a current time stamp, so I assume that it is used by something....

Copying dbx files from a CDR back into Outlook
My computer was recently hijakced and I had to reinstall everything. I did however save all of my folders in Outlook onto a CD Rom and I do not know how to transfer them back so I can use them. Also I had an animated version of outlook where you could choose loads of diffent stationery and I cannot seem to find that upgrade anaywhere. Can you help me? Tee <tsahai33@hotmail.com> wrote: > My computer was recently hijakced and I had to reinstall > everything. I did however save all of my folders in > Outlook onto a CD Rom and I do not know how to transfer > them back so...

VCard issue #2
This is a weird problem, but when I send a vcard to someone, it shows up in my sent items as a vcf file, and has a vcard icon on it, but when the recipient gets the VCard, it shows up as msg file, with an envelope icon as the attachment. When I open it, nothing is there - it's empty. I can't find anything regarding this problem on google or MS's website. Anybody have any ideas? Is it a problem with Outlook? Do I need to do a detect and repair, a reinstallation? Thanks for your help! Does the same happen when you send a message to yourself? Is he/she able to see it w...

Forwarded messages are not being sent
One of our users is trying to setup his account to forward all messages to his yahoo account. We setup a rule that says keep a copy in his inbox and forward a copy to his yahoo account. The yahoo copy never gets out and message tracking says it is submitted to the categorizer but never gets any farther. What do we need to do? By default rule-based forwards to external recipients are disabled. To change this, go to Exchange System Manager, Global Settings, Internet Message Formats.. There, you can either enable this for all domains (*), or be specific and create a separate policy f...