README revision b55bdee3f12a9ac6ad2d4bfb1210578151016bb1
Sample 4 - CSV File
-------------------
Copyright (c) 2012 ForgeRock AS
This work is licensed under a Creative Commons Attribution-
NonCommercial-NoDerivs 3.0 Unported License. See
This sample demonstrates using a comma-separated value file as an external
resource. The synchronization mapping is defined only from the CSV file to
the OpenIDM internal repository, so changes flow only from the CSV to OpenIDM.
For documentation pertaining to this example see:
To try the sample, follow these steps.
1. Copy the sample configuration and data.
$ cd /path/to/openidm
$ cp -r samples/sample4/conf samples/sample4/data .
$ cat data/hr.csv
firstName, uid, "lastName","email", "employeeNumber", password
"Darth", "DDOE", "Doe", "doe@forgerock.org", "123456", "Z29vZA=="
"Darth", "VDART", "Vader", "vader@forgerock.org", "654321", "Z29vZA=="
2. Start OpenIDM.
$ ./startup.sh
3. Run reconciliation.
$ curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --request POST "http://localhost:8080/openidm/sync?_action=recon&mapping=systemHrAccounts_managedUser"
{"reconId":"84b55592-a2d5-438a-ba71-c5e9a7a93938"}
4. See the users from the CSV file show up in the OpenIDM repository.
$ curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --request GET "http://localhost:8080/openidm/managed/user/?_query-id=query-all-ids"
{
"query-time-ms": 0,
"result": [
{
"_id": "1f914f71-032e-48ad-a39c-dcd972deaae4",
"_rev": "0"
},
{
"_id": "67cb30a4-0ad7-48e4-95b1-39b351ee2353",
"_rev": "0"
}
],
"conversion-time-ms": 0
}
In your terminal the response appears all on one line.
5. Retrieve an individual user using the ID value from the response.
$ curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --request GET "http://localhost:8080/openidm/managed/user/67cb30a4-0ad7-48e4-95b1-39b351ee2353"
{
"userName": "Vader",
"givenName": "Darth",
"employeeNumber": "654321",
"_id": "67cb30a4-0ad7-48e4-95b1-39b351ee2353",
"_rev": "0",
"email": "vader@forgerock.org"
}