CBSubs Import Error

11 months 1 week ago - 11 months 2 days ago #309476 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
11 months 4 days ago #309485 by nant
I think you need to pad 0.

2015-6-11 --> 2015-06-11
2018-12-3 --> 2018-12-03
11 months 4 days ago #309487 by ernienet
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
11 months 3 days ago #309491 by ernienet
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
11 months 3 days ago #309493 by nant
Moderators: beatnantkrileon
Time to create page: 0.410 seconds