CBSubs Import Error

1 year 6 months ago - 1 year 6 months ago #309476 by ernienet
CBSubs Import Error was created by ernienet
I'm setting up an import to instantiate a starting membership level for all users and I'm getting an error.

First, I exported all users using CBJuice. I retained enough of the fields so that I would be able to create a spreadsheet where each userid has a planid, status, and date as configured in CBSubs.

When I import the CSV file, it's giving me an error:

Error
Failed to save Import subscriptions because: Importer - error: Line 1 does not match the format userid,planid,status,date, e.g. 63,1,A,2009-01-01 00:00:00, and is instead: userid,planid,status,date .

As you can see, ti quotes back to me the format I'm using, which is exactly what my import file contains. Here's a sampling of the first few recirds:

userid,planid,status,date
190,5,A,2018-12-3 00:00:01
219,4,X,2015-6-11 00:00:01
222,2,A,2018-3-22 00:00:01
223,2,X,2015-4-10 00:00:01
225,5,A,2018-12-3 00:00:01
226,5,A,2018-12-3 00:00:01
224,4,X,2015-7-10 00:00:01
227,5,A,2018-12-3 00:00:01
229,4,X,2017-11-3 00:00:01

Now, there's also a conflict in the heading names, where your error message shows:

userid,planid,status,date

but the instructions on the page shows:

userid,planid,statusSingleChar,SubscriptionDateISO

When I set the import file with those headings, I simply get the same error with the new headings:

Error
Failed to save Import subscriptions because: Importer - error: Line 1 does not match the format userid,planid,status,date, e.g. 63,1,A,2009-01-01 00:00:00, and is instead: userid,planid,statusSingleChar,SubscriptionDateISO .

So it seems that neither heading option works - is there something else wrong with this process?

I have the Import Behavior set to testing - is the error message the expected result from a test? Also note that these are real dates and statuses based on the client's current membership roster, and that all userid's are valid.

Thank you,
Ernie

Please Log in to join the conversation.

1 year 6 months ago #309485 by nant
Replied by nant on topic CBSubs Import Error
I think you need to pad 0.

2015-6-11 --> 2015-06-11
2018-12-3 --> 2018-12-03

Please Log in to join the conversation.

1 year 6 months ago #309487 by ernienet
Replied by ernienet on topic CBSubs Import Error
No, changing that didn't change the response - it's still the same error message:

Error
Failed to save Import subscriptions because: Importer - error: Line 1 does not match the format userid,planid,status,date, e.g. 63,1,A,2009-01-01 00:00:00, and is instead: userid,planid,status,date .

It's saying that Line 1 does not match the format, yet it repeats exactly what I have.

Any other ideas?

Thank you,
Ernie

Please Log in to join the conversation.

1 year 6 months ago #309489 by nant

Please Log in to join the conversation.

1 year 6 months ago #309491 by ernienet
Replied by ernienet on topic CBSubs Import Error
I'm getting the same exact error:

Error
Failed to save Import subscriptions because: Importer - error: Line 1 does not match the format userid,planid,status,date, e.g. 63,1,A,2009-01-01 00:00:00, and is instead: userid,planid,status,date .

If the message is accurate, the import process is not getting past the field names - the first line. If the error message is incorrect. If it's the data, shouldn't the error refer to line 2?

Here's the first few records as the .csv file is currently formatted:

userid,planid,status,date
190,5,A,2018-12-03
219,4,X,2015-06-11
222,2,A,2018-03-22
223,2,X,2015-04-10
225,5,A,2018-12-03
226,5,A,2018-12-03
224,4,X,2015-07-10

Thank you,
Ernie

Please Log in to join the conversation.

1 year 6 months ago #309493 by nant

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.430 seconds