Jump to content

Carl Reeder

Hornbill Users
  • Posts

    6
  • Joined

  • Last visited

Everything posted by Carl Reeder

  1. Some success thank you have managed to update one field in a record. Where can I find the table structure to see how the tables relate to each other? So we have Asset Tag under financial information - but how can I check that this relates to h_asset_tag in the tables and not a reused field?
  2. It appears to run now (Maybe had to wait for permissions to filter) - however fails to update any records. Have you got any examples of a simple json file and csv file? I don't think I have the AssetGenericFieldMapping and/or AssetTypeFieldMapping set quite right. Not sure I understand the difference and how they work. Current binary is the latest version: 3.3.0 ---- XMLMC Database Asset Import Utility v3.3.0 ---- [DEBUG] Flag - Config File conf_ReloadName_csv.json [DEBUG] Flag - Dry Run false [DEBUG] Flag - Concurrent 1 Caching Application Records from Hornbill... Running CSV query for BASE assets. Please wait... 1 of 1 returned assets successfully retrieved ready for processing. Caching BASE Asset Records from Hornbill... 4471 / 4471 [=============================================================================================] 100.00% 0s Hornbill BASE Asset Records Cached Processing 1 of BASE Type Assets... 1 / 1 [===================================================================================================] 100.00% 0s BASE Asset Type Processing Complete! -=-=-= Summary =-=-=- Created: 0 Create Skipped: 0 Create Failed: 0 Updated: 0 Update Skipped: 0 Update Failed: 0 Update Extended Record Skipped: 0 Update Extended Record Failed: 0 Assets Software Inventory Skipped: 0 Software Records Created: 0 Software Records Create Failed: 0 Software Records Removed: 0 Software Records Removal Failed: 0 Asset Supplier Associations Success: 0 Asset Supplier Associations Failed: 0 Asset Supplier Associations Skipped: 0 Asset Supplier Contract Associations Success: 0 Asset Supplier Contract Associations Failed: 0 Asset Supplier Contract Associations Skipped: 0 Time Taken: 3s ---- XMLMC Database Asset Import Complete ----
  3. Have now set APIKey and InstanceID correctly but am still getting the following message: PS C:\asset_import> ./goDBAssetImport -dryrun=true -file=.\conf_ReloadName_csv.json [ERROR] Error Decoding Configuration File: read C:\asset_import/: The handle is invalid. [ERROR] Unable to retrieve endpoint information for the supplied InstanceID: PS C:\asset_import>
  4. New to the Asset import tool. However I am struggling to see, from the templates, how data is imported from a csv file. Do you have any examples that I could look at. I don't understand the difference (and/or what fields I need) for AssetGenericFieldMapping and AssetTypeFieldMapping - I am trying to rename the Name of the asset using the two attached files. ReloadName.csv conf_ReloadName_csv.json
×
×
  • Create New...