CSV Import | Worked, but didn't...

SOLVE
New Contributor

Hi all,

 

I've created x8 CSV files of 100k lines of data, and another at 85,000 lines.

 

Fields were matched OK and paired to the correct corresponding Company Data Field and all imports appeared to have been accepted by Salesforce GUI.

 

Having said that, on the upload manager screen, I can see my data files have been acccepted however the Added Column shows zero lines of data added, and the errors column shows no errors.

 

The CSV files are OK, as I have just downloaded them from the Hubspot Upload page.

 

I understand there is a 1,000,000 record limit per user, but even so, I am well below the limit.

 

Please help.  I need to get the data imported and as a IT techy, I am banging my head off a wall.

 

1 Accepted solution

Accepted Solutions
Community Thought Leader


2000px-Ok_sign_font_awesomeDid my post help answer your query?

Help the Community by marking it as SOLVED

 

Q: CSV Import | Worked, but didn't...

Short A: Clean those .CSV files?

 

Longer Amicrosoft-excel-dirty-data-400x600.png#1 Reason For Import Failures

We've seen numerous issues with 'dirty' .csv files being imported into HubSpot. 'Dirty' can mean lots of things, but specia1 characters are typically the culprits.

 

Unfortunately, some file issues don't generate errors. They just don't import anything.

 

Also, make sure your .csv meets all criteria specified on this page - https://knowledge.hubspot.com/articles/kcs_article/contacts/why-is-my-contact-import-failing-or-retu...

 

Test Solution Steps:

-1- Chop your 1st .csv down to maybe 10 records and test that import. No problem, continue.

-2- Increase the size of that same .csv to 1000 records and test that import. No problem, continue.

-3- Continue increasing the size of the .csv by a factor of 10 until you encounter the import problem.

 

Willing to wager that the files are somehow 'dirty'. Also check UTF8 encoding (see KB article referenced above).

 

Hope that helps.

 

Your Remote HubSpot Partner

Hope that helps.

 

Best,
Frank

 

MFrankJohnson-dot-com-HubSpot-Community-banner-gif-v20190817

Reply
0 Upvotes
4 Replies 4
Regular Contributor

Have you called tech support? They are pretty awesome.

 

Honestly I don't think there is anything we can do here without looking into the guts more.

Highlighted
Regular Contributor

Hello! As an alternative to manual data import, you can take a look at Data2CRM service, their techs or automated solution may be useful (however it's paid, but in this case you can delegate all the works). BTW - the free demo import is also available.

 

Hope, my answer will be usefull. Thanks, with respect!

Reply
0 Upvotes
Community Thought Leader


2000px-Ok_sign_font_awesomeDid my post help answer your query?

Help the Community by marking it as SOLVED

 

Q: CSV Import | Worked, but didn't...

Short A: Clean those .CSV files?

 

Longer Amicrosoft-excel-dirty-data-400x600.png#1 Reason For Import Failures

We've seen numerous issues with 'dirty' .csv files being imported into HubSpot. 'Dirty' can mean lots of things, but specia1 characters are typically the culprits.

 

Unfortunately, some file issues don't generate errors. They just don't import anything.

 

Also, make sure your .csv meets all criteria specified on this page - https://knowledge.hubspot.com/articles/kcs_article/contacts/why-is-my-contact-import-failing-or-retu...

 

Test Solution Steps:

-1- Chop your 1st .csv down to maybe 10 records and test that import. No problem, continue.

-2- Increase the size of that same .csv to 1000 records and test that import. No problem, continue.

-3- Continue increasing the size of the .csv by a factor of 10 until you encounter the import problem.

 

Willing to wager that the files are somehow 'dirty'. Also check UTF8 encoding (see KB article referenced above).

 

Hope that helps.

 

Your Remote HubSpot Partner

Hope that helps.

 

Best,
Frank

 

MFrankJohnson-dot-com-HubSpot-Community-banner-gif-v20190817

Reply
0 Upvotes
New Contributor

Hi,

 

Thank you for your reply, the CSV is clean in that there are no '**bleep** characters...' other than the one trying to upload it.

 

Will trim the file sizes down.  Each one is 100k lines of data.

 

It might be a while before I post again. ;-)

 

Thanks again, appreciated.