Topic-icon Import K2 items specifics

  • CFDT SERVICES
  • CFDT SERVICES's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Apr 2017 12:02 #4183

Yes, it's good.
Thanks.

Please Log in or Create an account to join the conversation.

More
24 Apr 2017 11:14 #4181

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 or Create an account to join the conversation.

  • CFDT SERVICES
  • CFDT SERVICES's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Apr 2017 10:39 #4179

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 or Create an account to join the conversation.

  • CFDT SERVICES
  • CFDT SERVICES's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Apr 2017 10:32 #4178

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 or Create an account to join the conversation.

Cron Job Starts