There are several fields that are necessary for the assets to show up correctly, the 2 that I remember offhand are Class ID and Dataset ID. These are static, so just look at what value is in these fields on an asset record that does show up, and use those values in the import.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan Navarra Sent: August 7, 2006 12:02 To: [email protected] Subject: Bulk loading asset records (ARS 6.03 / SQL Server / Windows Client) We're trying to bulk load asset records into Remedy Asset Management. The records appear to load correctly, yielding a clean log file: AR System Import Tool Mon Aug 07 11:39:29 2006 **** Import of c:\documents and settings\user\desktop\assets.csv started. (ARNOTE 4001) **** Import completed successfully. 956 Records imported to form BMC:BMC_ComputerSystem. (ARNOTE 4000) We loaded them into the form called "BMC:BMC_ComputerSystem" becase the asset record type for these assets is "Computer System." Interestingly, when I try to enter these records manually on the Computer System form, they all load perfectly. I'm trying to run the bulk load with only the following fields: Asset ID+ Name* Category Type Item Supported Status Tag Number Serial Number Environment Specification Priority We tried this by turning off all the error checking on the import tool. After loading the file, our administrator checked Remedy, but none of the assets could be found by doing a search. So even though Remedy says the file loaded, we can't find them...any suggestions? Thanks! ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
