Import K2 items specifics

More
8 years 4 months ago #4178 by CFDT SERVICES
Hello,

I try to import K2 Item with the id between 1236 to 1248.
But in the joomla backend, it makes me the import successfull, but there's none item imported.
Here the log :

#Date: 2017-04-24 10:30:22 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority clientip category message
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Profile title - k2 item import
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Table - #__k2_items
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Format - CSV
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1236'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1237'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1238'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1239'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1240'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1241'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1242'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1243'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1244'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1245'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1246'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1247'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1248'
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Imported Record count - 0

Please Log in to join the conversation.

More
8 years 4 months ago #4179 by CFDT SERVICES

CFDT SERVICES wrote: Hello,

I try to import K2 Item with the id between 1236 to 1248.
But in the joomla backend, it makes me the import successfull, but there's none item imported.
Here the log :

#Date: 2017-04-24 10:30:22 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority clientip category message
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Profile title - k2 item import
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Table - #__k2_items
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Import Format - CSV
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1236'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1237'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1238'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1239'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1240'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1241'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1242'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1243'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1244'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1245'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1246'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1247'
2017-04-24T10:30:22+00:00 ERROR 46.218.167.138 com_vdata Insert Failed,record already exists - `id`='1248'
2017-04-24T10:30:22+00:00 INFO 46.218.167.138 com_vdata Imported Record count - 0


How to tell vData to redial the id automatically ?
Thanks

Please Log in to join the conversation.

More
8 years 4 months ago #4181 by Daniel
Replied by Daniel on topic Import K2 items specifics
Hello,
You need to choose Skip option for ID column in Profile settings you are using to import the records.

Thanks
Daniel

Please Log in to join the conversation.

More
8 years 4 months ago #4183 by CFDT SERVICES
Yes, it's good.
Thanks.

Please Log in to join the conversation.

Cron Job Starts