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:

http://openidm.forgerock.org/doc/install-guide/index.html#more-sample4

To try the sample, follow these steps.

1. Data for this sample is in the CSV file, samples/sample4/data/hr.csv.

$ cd /path/to/openidm

$ cat samples/sample4/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 with the configuration for sample 4.

$ ./startup.sh -p samples/sample4

3. Run reconciliation.

$ curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --request POST "http://localhost:8080/openidm/recon?_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/?_queryId=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"

}