Help Portal categories want to replace with other categories

[vidyajadhav]

Hi All,

I want to replace the all categories which are showing in the left pane with other categories. 

I changed the table name from server script for Clone widget of sc categories as per below but it did not worked

[vidyajadhav]

@Juhi Poddar  Is that possible to copy these records to sc_category from new table? I was thinking this but not done to avoid any mess.

[vidyajadhav]

I tried with adding records in sc_category but its not displaying the categories which i want to show. Any alternate option to achieve this requirement?

[Community Alums]

Hi @vidyajadhav ,

Categories will not show up on the portal list if they don't have any catalog item. Make sure at least one catalog item is related to the category.

[vidyajadhav]

@Community Alums thank you for your response here. Yes i added catalog item and i was able to test one category to show up in left pane. Thank you for your support here.

[Juhi Poddar]

Hello @vidyajadhav 

• If both tables are identical, then a simple export and import is the easiest and most straightforward approach.

  You can try the following steps:

  1. Export the data from the original table in Excel format.

  2. Import that Excel file as a new data source and load it into a staging table.

  3. Create a Transform Map to map the staging table to your target table.

  4. Run the transform to load the data into the new table.

There are several ways to migrate data between tables in ServiceNow. Here are some useful resources:

• Migrate records from one table to another and still retaining sys field values after migration
• exporting-data

• Exporting and importing data via XML

Note: Always start by testing the process with just one record to ensure everything works as expected before doing a full migration.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You

Juhi Poddar