===== Import configuration via CSV ===== **Description:** * 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**