Import configuration via CSV

This API allows to import a configuration for groups, systems, users and connectors via a CSV file

Services

Collect flat metrics
Description	Consumes a CSV file with configutation data
Method	POST
URL	/snapshots/importcsv
Authorizations	Admin user

Service usage

You need to post data to the service.

You can use curl with the below command

CSV configuration is written in config.csv file in this example

curl -H "Content-Type: application/csv" --data-binary @config.csv -u '[ADMIN USER]:[PASSWORD]' http://[HOST]:[PORT]/snapshots/importcsv

CSV format

GROUP;Organization short name;group name;group short name
USER;group short name;user title; username;user password
SYSTEM_NETWEAVER;group shortname;system shortname;SID;title;role [optional];environement [optional];description
SYSTEM_HANA;group shortname;system shortname;SID;title;System number;multi-tenant (true/false);role;environement;description
CONNECTOR_ABAP;system shortname;host;client;logon group;MS port number; user title
CONNECTOR_J2EE;system shortname;title;host;system number;MS port number; user title
CONNECTOR_HANA;system shortname;title;host;port [optional];tenant;user title
CONNECTOR_SYBASE;system shortname;title;host;DB port number;user title;properties
CONNECTOR_MSSQL;system shortname;title;host;DB port number;user title;properties

Example

GROUP;ORG01;GROUP 1;GRP01
GROUP;ORG01;GROUP 2;GRP02
USER;GRP01;USER S4H;PROMONITOR;asdff4!
USER;GRP02;USER QAL;qaluser;qwer789
USER;GRP02;USER SYB;sybuser;qwertoto789
USER;GRP02;USER MS;msuser;tqwer789
SYSTEM_NETWEAVER;GRP01;S4H000;S4H;Prod system;PRODUCTION;ECC;system PROD
SYSTEM_NETWEAVER;GRP02;QAL;QAL;QA system;QUALITY;BW;system QA
SYSTEM_HANA;GRP02;HAQ;HAQ;QA system;00;true;PRODUCTION;PI;My PI system
CONNECTOR_ABAP;S4H000;mys4hana.agentil.local;100;SPACE;3600;USER S4H
CONNECTOR_J2EE;QAL;mys4hana.agentil.local;00;;USER QAL
CONNECTOR_SYBASE;QAL;QAL sybase;aglgesyb.agentil.local;9900;USER SYB;
CONNECTOR_MSSQL;QAL;QAL MS;aglgems.agentil.local;6600;USER MS;toto=false
CONNECTOR_HANA;HAQ;HAQ tenant1;aglgehaq.agentil.local;;TENANT1;USER HAQ
CONNECTOR_HANA;HAQ;HAQ tenant2;aglgehaq2.agentil.local;23558;TENANT2;USER HAQ

Note:

Items must be declared in the following order:

GROUPS

USERS

SYSTEMS

CONNECTORS

Users in connector must be referenced by user title