I’m currently in the midst of cleaning up our Models/Model categories. I am hoping to find a way to export our existing Model Categories to a spreadsheet, associate those categories with their models within the spreadsheet, and then link the overall Model Category/Models to their associated Issues/Resolution Actions which I have already created in separate spreadsheets. Currently I have over 600 enabled Models and over 120 enabled Model Categories (hence the need for cleanup). Does anyone have a tip on how to export this as a .csv so I don’t have to type out and organize 600 rows/columns?
Hi
^^ agree with
Export your assets along with the model category and model columns. Then, you can clean up the data from there.
Hello,
I’m in a somewhat similar situation as KSmith.I have mapped the assets models I will be bringing in my initial import. I would like to see (Export) all of the Enabled Models and Model Categories so that I can review and adjust them prior to my initial asset import. Any hints on exporting (models and model categories) these without having to first import the assets? Thanks!
Exporting the models and categories did help but it was a long list to clean up. Also, the categories aren’t exactly 1:1. Custom categories don’t show up exactly as they’re listed. But overall the export listed above worked for my purposes. Once it was in Sheets/Excel I just had to put a custom format to highlight/hide the duplicate assets that way I only had a single asset of each listed and then associated to it’s model category.
Wow
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.