Is it possible to put several CSV files at once for the feeder
Article ID: 130791
Updated On:
Products
CA Privileged Access Manager - Server Control (PAMSC)
CA Privileged Identity Management Endpoint (PIM)
Issue/Introduction
Is it possible to put several CSV files at once for the feeder?
In which order are they processed?
Is there built in logic to process them in a semantically correct order?
Environment
Release:
Component: SEOSWG
Component: SEOSWG
Resolution
As per
https://docops.ca.com/ca-privileged-identity-manager/14-0/en/administrating/enterprise-administration/how-to-import-sam-endpoints-and-shared-accounts
the Endpoints need to be defined first.
For the test I used the Endpoints_Disconnected.csv & PrivilegedAccounts_Disconnected_endpointType.csv files which are found in
../CA/AccessControlServer/IAM_Suite/Access Control/tools/samples/feeder
Put them in the alphabetic order, i.e. Accounts first (which I expected would cause issues since as per above statement the Endpoints need to be defined first)
Also the Accounts file's time stamp would be older than the Endpoints one - to verify if the files are processed FIFO.
I also tried it in the reverse order with the file stamp, ie. Endpoints is older Accounts is newer.
Either way, importing both files at once correctly created the Endpoint and Account in ENTM.
(If only the Accounts.csv was put alone as expected an error was issued that the Endpoint did not exist)
Also, as to see from the time stamps and the file name of the files in the 'processed' folder the Endpoints.csv was processed first the Accounts.csv.
[[email protected] feeder]# ll -trR *
processed:
total 0
failedToSubmit:
total 0
waitingToBeProcessed:
total 8
-rw-r--r-- 1 root root 241 Apr 9 15:58 Accounts.csv
-rw-r--r-- 1 root root 308 Apr 9 15:59 Endpoints.csv
[[email protected] feeder]# ll -trR *
failedToSubmit:
total 0
waitingToBeProcessed:
total 0
processed:
total 8
-rw-r--r-- 1 root root 241 Apr 9 15:58 Accounts_20190409_1559_47062.csv
-rw-r--r-- 1 root root 308 Apr 9 15:59 Endpoints_20190409_1559_46967.csv
Bottom line, it is possible to put several CSVs to define Endpoints and Accounts at once.
https://docops.ca.com/ca-privileged-identity-manager/14-0/en/administrating/enterprise-administration/how-to-import-sam-endpoints-and-shared-accounts
the Endpoints need to be defined first.
For the test I used the Endpoints_Disconnected.csv & PrivilegedAccounts_Disconnected_endpointType.csv files which are found in
../CA/AccessControlServer/IAM_Suite/Access Control/tools/samples/feeder
Put them in the alphabetic order, i.e. Accounts first (which I expected would cause issues since as per above statement the Endpoints need to be defined first)
Also the Accounts file's time stamp would be older than the Endpoints one - to verify if the files are processed FIFO.
I also tried it in the reverse order with the file stamp, ie. Endpoints is older Accounts is newer.
Either way, importing both files at once correctly created the Endpoint and Account in ENTM.
(If only the Accounts.csv was put alone as expected an error was issued that the Endpoint did not exist)
Also, as to see from the time stamps and the file name of the files in the 'processed' folder the Endpoints.csv was processed first the Accounts.csv.
[[email protected] feeder]# ll -trR *
processed:
total 0
failedToSubmit:
total 0
waitingToBeProcessed:
total 8
-rw-r--r-- 1 root root 241 Apr 9 15:58 Accounts.csv
-rw-r--r-- 1 root root 308 Apr 9 15:59 Endpoints.csv
[[email protected] feeder]# ll -trR *
failedToSubmit:
total 0
waitingToBeProcessed:
total 0
processed:
total 8
-rw-r--r-- 1 root root 241 Apr 9 15:58 Accounts_20190409_1559_47062.csv
-rw-r--r-- 1 root root 308 Apr 9 15:59 Endpoints_20190409_1559_46967.csv
Bottom line, it is possible to put several CSVs to define Endpoints and Accounts at once.
Feedback
Yes
No
Powered by
