Help with MYSQL For Solution Import

Help with MYSQL For Solution Import

I'm trying to import our existing solutions (in another product) into service desk but I'm not sure how some of the ID's get created.

For example, I create a solution and it has an ID of 4201 in the Solution, Solution_Keyword, SolutionCreateInfo, SolutionInfo, SolutionRI, and SolutionsAttachment tables. How does it get the 4201? Could I just start at like 20,000 and be ok?

Now, the KeywordID, how is this ID generated in the Solution_Keyword table? In my case its 4801. Again, could I just start with 20,000 and be ok?

Now the ItemID in the SolutionRI table (I don't know for sure what this table is for), how is this # generated? its 12294 in my case. Again, could I just start with 20,000 and add 1 entry per solution?

And finally the attachmentID's, I added 2 files to this solution, they ended up with 2101 and 2101 in the database. How are these ID's generated?

If I could just figure out how these 4 ID #s are generated I could quickly and easily export our current solutions into the mysql database for servicedesk and post it for all to enjoy.

Help please??!?!? My only alternative is a vbscript that uses sendkeys to enter in the data into servicedesk via the web interface, and that is just a completely unacceptable solution.

Thanks,
Bad Syntax














                    New to ADSelfService Plus?