Import from CSV with custom id

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
earthdog
Posts: 5
Joined: 19 Nov 2019, 13:39

Import from CSV with custom id

Post by earthdog »

I am usign the plugin for custom CSV im[port from here: https://github.com/mantisbt-plugins/csv-import

It seems to work but i cant find a way to import my bugs with specific id instead of autoincrement. I tried changing the auto increment on the table but it seems the script will not insert the id column. Has anybody done this another way?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Import from CSV with custom id

Post by cas »

wel, here is a workaround.
Check if the bug-id's you want to use, are not already used
Remove autoincrement from that table in full ( ensure no users are active in the system)
Once done enable autoincrement on the ID-field and ensure it has a safe value (+1on the highest value)
earthdog
Posts: 5
Joined: 19 Nov 2019, 13:39

Re: Import from CSV with custom id

Post by earthdog »

cas wrote: 25 Nov 2019, 13:34 wel, here is a workaround.
Check if the bug-id's you want to use, are not already used
Remove autoincrement from that table in full ( ensure no users are active in the system)
Once done enable autoincrement on the ID-field and ensure it has a safe value (+1on the highest value)
Thats what i did and it worked perfectly. Thanks.
Post Reply