Thread: Custom Categories ID

Hello,

We are on the Data Migration Process and I have a question for you, we need to keep our old urls, so I found the url rewrite very helpful for us. Now our problem is that for our Categories pages we use a ID on our current urls so we need to keep the same IDs when we migrate over ASPDN, my question is how can I customize the CategoryID field, I already tried to remove the Identity option from the database and create a XML file with the CategoryID that we want to have, but didn't work.

Could I save the ID we need in other field and then make the url structure with this specific field and not the CategoryID, I also tried this with the CategoryGUID, but didn't work either.

There's any possibility of doing this. Do you have any other idea of how can be implemented. We really need to keep our urls so I'll appreciate our help.

Thanks again

You would need to disable the identity insert for the category table prior to impporting the data, like this:

Code:

SET IDENTITY_INSERT Category ON

And then re-enable it after importing, like this:

Code:

SET IDENTITY_INSERT Category OFF

However, I don't know whether this can be acheved using WSI, as we don't use it here.

Off the top of my head (ie without actually thinking about the detail!), another way to approach this with some programming would be to store your 'old' category IDs in the ExtensionData field.

Then, redirect all legacy category pages to showcategory.aspx and within showcategory.aspx.cs or ShowEntityPage.cs, do a lookup of the ExtensionData field to get the correct category to display.

Problem solved. Thank you guys!