Page 1 of 1

Import from CSV with custom id

Posted: 19 Nov 2019, 20:07
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?

Re: Import from CSV with custom id

Posted: 25 Nov 2019, 13:34
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)

Re: Import from CSV with custom id

Posted: 26 Nov 2019, 18:23
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.