What’s the best / supported / safest way to do this?
- I have a backup of the entire database
- I have an export of this Assets catalog as it is now
Edit: I should mention: the main reason I’d like to do this is that on my initial creation of the catalog, I have the workstation hostname as just a field, and RT has assigned them an internal ID, in the order they were created. On import, the workstation name will be the ID field and therefore the list will look sensible, more or less in order, during searches - since the name will always need to be unique anyway.
I have a new master CSV that I would like to import into this catalog as the definitive list. I have, in the current catalog (“Desktop Workstations” in this case), created some new Custom Fields and applied them to this catalog, which will be populated by the new import. I have also re-arranged some of the existing fields, their data, format, etc.
I’d like to drop the existing entries, in their old format, and just import the whole thing from this master CSV which was created by dumping existing assets, adding the new fields to correspond to new custom fields, altering data where needed to match the new format, and then additional fresh entries were added to it.
Is there a supported mechanism to drop this catalog, other than doing it manually via SQL?