Carl Reeder
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forums
Enhancement Requests
Posts posted by Carl Reeder
-
-
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?
-
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 CachedProcessing 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 ---- -
Thank you - have checked and both are all lowercase.
-
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> -
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.
Can the manual import csv facility have the ability to identify existing assets and update these rather than create duplicate?
in Service Manager
Posted
I have admin rights to the system but can't see the Entity Explorer. Do I need some other rights as well?