Not all data being imported

SOLVE
Highlighted
Occasional Contributor

Hi

 

I did an initial import, have sorted out some of the fields. Then I exported from Hubspot which gave me the ContactID and then updated more of the fields as it was easier to do them in bulk on a spreadsheet.

 

I then re-imported the CSV back, but there are some fields in some records that just haven't updated. So I did a smaller file with just two of the fields that have data missing and re-imported that. But there's still data missing. 

 

Here are a couple of screenshots. The first is my CSV file which has something in every field - there's only 151 so not a huge amount. The second is a screenshot of the data in Hubspot and there are blanks. 

 

I've gone through every record on Excel and ensured that it's spelt right, and all the properties match in Hubspot. 

 

It does appear to be those with more than one value but I thought separating with a comma was the way to do this. 

 

Anyone any ideas please? 

 

Many thanks

 

Ally

 

Screenshot 2019-12-12 at 17.57.13.pngScreenshot 2019-12-12 at 17.57.26.png

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Resident Expert

@AllyRRS Hi Ally,

 

Can you send a screenshot of the property that has the missing info?

 

Go to the gear and click on setting, then go to properties and find the one.

 

Love your perseverance!

3 Replies 3
Highlighted
Resident Expert

@AllyRRS Hi Ally,

 

Can you send a screenshot of the property that has the missing info?

 

Go to the gear and click on setting, then go to properties and find the one.

 

Love your perseverance!

Highlighted
Occasional Contributor

Lol thank you! I keep trying. 

 

Thanks so much for coming back so quickly. Actually, I have found that if I clicked on the "view import" button it refreshed it where refreshing the Contacts page on its own didn't. So it all seems okay now! Bit confusing as I thought that once it was imported, it would be updated, but it seems you have to go via that "View Import" link!

 

Smiley Happy 

Reply
0 Upvotes
Highlighted
Community Superstar

Commas are used as separators in the 'Subject of Interest' column for some of your cells. If the correspoding field type is Multiple Checkboxes it will call a semicolon separator instead. Please confirm that the following IDs have re-imported with correct data.


1301
3501
3651
2852
201
1901

 

Note: HubSpot is a constantly evolving platform. Please check the date of each post and view all solutions in that context -- see Marketing Hub Enterprise 2020.

 

Hope that helps.

 

Be well,
Frank


Support • Web • Apps • Training

HubSpot's Hiring World-Wide!