Import error with a file I've used multiple times...

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

I'm having an issue with an import. I use the same export from my CRM every week, saved as a .CSV. But some reason, this week, I am getting a strange error. 

Error message
Expected weeks-term entry "General" for member "Tca C.C""" on row 1 to be a numeric!

The field it's referencing, weeks-term, IS a numeric field. And I am marking the first column as a "skip" as it includes headers. 

Please help!
Photo of The Cleaning Authority

The Cleaning Authority

  • 4 Posts
  • 0 Reply Likes
  • frustrated

Posted 3 years ago

  • 0
  • 1
Photo of Anthony Miranda

Anthony Miranda, Customer Support Specialist

  • 135 Posts
  • 16 Reply Likes
Hi there! Sorry to hear about the import troubles, but I'm glad you reached out so we can get this taken care of.

The first thing I want to confirm is that the entire column that is going to be imported into the weeks-term field is comprised of numbers. Numeric fields will allow accept numeric values and unsupported characters within that column could be causing the error.

If you aren't seeing any non-numeric characters in that column, go ahead and upload the spreadsheet into your documents library. This will let me take a look at the file and see if I can spot anything that would be giving us a hard time. You can find the documents library on the campaigns page.

I'll keep an eye open for your reply!