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?
Import from CSV with custom id
Moderators: Developer, Contributor
Re: Import from CSV with custom id
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)
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
Thats what i did and it worked perfectly. Thanks.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)