Thanks Everyone,
John had the right answer.
Not sure where we went wrong originally, but for the record, this is the way it works.
INSTRUCTIONS TO IMPORT MULTIPLE MDR LINES AGAINST A SINGLE CI
1. The MDRs and the Classes must exist prior to load.
If not, then create them either manually or by load.
EXAMPLE.
- - -
New MDRs:
Button Name: NY
MDR Name: NY
MDR Class: baseball
Button Name: NJ
MDR Name: NJ
MDR Class: hockry
Button Name: NHP
MDR Name: NHP
MDR Class: football
New Classes:
Class: baseball1
Family: Computer
Class: hockry1
Family: Computer
Class: football1
Family: Computer
- - -
2. Save the data in the MS Excel spreadsheet.
Here is a sample CSV file that may be opened in MS Excel and saved as in Excel format.
Example: MDR_Test.xlsx
- - -
objecttype,name,mdr_name,mdr_class,federated_asset_id,class
ci,LFT5116061860491,NY,baseball,AB30,baseball1
ci,LFT5116061860491,NJ,hockry,AB31,hockry1
ci,LFT5116061860491,NHP,football,AB32,football1
- - -
3. Load with this command:
grloader -u Administrator -p <PASSWORD> -s http://localhost:8080 -i MDR_Test.xlsx -a -n -E
The results are:
- - -
14:43:10.985 CI and Relationship Loader for CA Service Desk Manager R12.9.000
\
Results:
Read Skipped Inserts Updates Errors Warnings
CI 3 0 1 2 0 0
Relation 0 0 0 0 0 0
GRLoader completed.
14:43:49.336 GRLoader ended
- - -
4. Check the CI.
If you use "Edit" you will find the added MDRs against the new CI.
If you check Versioning, Show Log, you'll find the details added.
- - -
Date Log Attribute New Value Old Value Changed By MDR
07/07/2017 02:43 pm Field Updated Class football1 hockry1 Administrator NHP
07/07/2017 02:43 pm Field Updated Class hockry1 baseball1 Administrator NJ
07/07/2017 02:43 pm Field Updated Exclude Ambiguity NO Administrator NY
07/07/2017 02:43 pm Field Updated CI? YES Administrator NY
07/07/2017 02:43 pm Field Updated Asset? NO Administrator NY
07/07/2017 02:43 pm Field Updated Name LFT5116061860491 Administrator NY
07/07/2017 02:43 pm Field Updated Class baseball1 Administrator NY
07/07/2017 02:43 pm Field Updated Family Computer Administrator NY
07/07/2017 02:43 pm Field Updated Creation date 07/07/2017 02:43 pm Administrator NY
- - -
You should run through a simplified example as above on a test system before going to a more complex example.
Thanks, Kyle_R.