Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Bulk Modifications to the Cat Tools DB

My organization is in the process of upgrading all of our remote routers - we swap out approximately 20 a week. This swap out includes a hardware refresh as well as a subnet change - so nothing is really the same. I have written a powershell script to compare 2 files (existing cat tools export-device.txt and spreadsheet we are tracking new installs), and it generates an export-device.txt file to import into cat tools. However, when I do this I lose all of my activities. So far I have had to start an entirely new db with my import. I am thinking there has to be a better way.

Any one else have any experience with this?

Thanks,

Find more posts tagged with

Accepted answers

All comments

charliemonster

I agree. A bulk import of several hundred devices only supports the Group, Name, Host Address, Type, and Model fields. This is not acceptable as all fields for a device should be editable in a bulk import. It is not at all feasible to manually modify hundreds of nodes.

Thanks,

Charles Warren III

bkyle

Please submit a feature request here:

Kiwi Syslog Feature Requests

charliemonster

Found a way to do this. Import or create all nodes you are managing with Kiwi CatTools into the application then export the entire database to a tab delimited file you can then import into Excel while also backing up the database. Make any changes you need to make to the data in Excel without changing the formatting or file format. Close and save the file when complete. Import the file back into Kiwi allowing the application to update the existing devices. All changes should now be reflected in the Kiwi CatTools database.

Hope this helps,

Charles Warren III