AbanteCart Community

Shopping Cart Operations => Support => Topic started by: denagpam on October 16, 2012, 01:52:53 AM

Title: No data imported after importing.
Post by: denagpam on October 16, 2012, 01:52:53 AM
Yes, You know I can not believe that importing daa in AbanteCart cart is not simple as I imagine. Can you tell me how to import data correctly?

I don't know the exact value of each column in the .csv data. There are

Can you tell me whether the data I attach is correct or not? I have repeated the values so that the values of

Hope for your answer.

Thanks.
Title: Re: No data imported after importing.
Post by: andrew.mikhailyk on October 16, 2012, 11:39:53 AM
Hello.

How do you get data for import?

I've noticed that you provide category_id in your data but don't provide "action" parameter.
By default this means that you will perform UPDATE query.
Maybe problem is that you are trying to update rows in database that are not exist.
If you need to add something into database with import you have to add column "action" with value "insert" in each row.
Or you can simply remove category_id from imported data. In that case script will autoincrement IDs in table.
Title: Re: No data imported after importing.
Post by: denagpam on October 16, 2012, 08:21:14 PM
Quote from: andrew.mikhailyk on October 16, 2012, 11:39:53 AM
Hello.

How do you get data for import?

I've noticed that you provide category_id in your data but don't provide "action" parameter.
By default this means that you will perform UPDATE query.
Maybe problem is that you are trying to update rows in database that are not exist.
If you need to add something into database with import you have to add column "action" with value "insert" in each row.
Or you can simply remove category_id from imported data. In that case script will autoincrement IDs in table.

Yes I get the data after exporting it and fortunately, I have imported those data in correct manner.

Cheers.