Category Export

[derek_h]

Is there a way to export the category/subcategory/details/issue list into a spreadsheet that I can distribute to my service desk team?   I've managed to export them all into a spreadsheet using the instructions from a different thread here but it is going to take a long time to format the data properly based on the format that it was initially exported into which is one giant list.   Thanks for any help.

[JohnG3]

Hi Derek,

Sometimes, I limit the columns of the Choice List table to just two columns - Dependent Value and Label.   I have found this helpful for Subcategory to show me the Dependent Value "Category" and the Label of the Subcategory. I usually also sort the Dependent Value from A to Z to group together the "Categories".

Hope that might help a little.

Cheers,

John

[sach1]

Hi Derek,

Exporting the data from 'sys_choice' table and then resolving the dependencies manually on a spreadsheet can take a lot of time.

One easy thing that you can do is:

1. Create a new table with the field names as per your Categorization

2. Create a script to query the sys_choice table. Start querying from the bottom most Categorization, for example "issue" in your case. Then find dependent value of the 'issue'. The value which you will get will be of "details"

3. Again run a query and find dependent value for "details"...In this way you can query for each level.Store the value in variable at each level.

4. At the end insert the value in the table you created in form of record.

Once the script is executed you will have a table with all the Categorizations sorted out systematically. Now you can export this table records in a spreadsheet.

Regards,

Sachin