Importing Contacts with Multiline Membership Notes Data

[Homerlex7]

I have a csv file that has a "column" that contains many lines of text destined for the Contact's "Membership Notes" property.  (yes the data in that column is surrounded by quotes)

I am importing 30 contacts but when I go to import the page tells me I am trying to import more than 1000.  If I remove the newlines from the notes it works properly.

The question is, how do I do an import that can populate "Membership Notes" with actual multi line text?

[franksteiner79]

Hi

Can you include a screenshot of the 1000 contact message and also of the
file structure you are importing?

Thanks
Frank

[Homerlex7]

Below is screenshot of the limit message.

Seems that the problem is in how Hubspot is counting the number of contacts.  I also included a screenshot showing me importing 1 contact and you can see it says scanning 74 rows.  If I import just that one contact it works properly.  If I import 20 (which will be over 1000 rows) I get the limit message. 

Seems like a bug in Hubspot importing.

Our production account will allow over 50K contacts but I will need to import 40K.  Breaking the imports into small chucks would be very tedious.

[Homerlex7]

Also just found that the production account doesn't have the same restriction.  Its limiting by the number of rows in the csv file (which is better).   Still seems like a bug in the import in my test account.

[GIlievski]

Hey @Homerlex7 

I tested this with a CSV and it seems the "new line" works when you hit command+return for each line in your doc. The <br> tag is not working as it does not render as HTML.

 Here is the sheet:

And how it came up in HS:

Hope that helps.

[Homerlex7]

Thanks for the reply.  The problem seems to be how the import routine calculates the number of contacts in the file when there are new lines.  (see my comment above)