Importing from a local spreadsheet
Same as with Importing Org Data with Google Sheets but from a local spreadsheet.xlsx
file.
Prepare my-teams.xlsx
spreadsheet same as described in Importing Org Data with Google Sheets.
Then from your terminal, run the following command to import it into a desired graph in Faros (default
graph in this example):
Modify
/path/to/my-teams.xlsx
with the correct path to the file.
docker run -v "/path/to/my-teams.xlsx:/my-teams.xlsx" \
farosai/org-import-feed:latest \
-u https://prod.api.faros.ai \
-k $FAROS_API_KEY \
-f /my-teams.xlsx \
--graph-name default \
--resolve-location
At anytime you can make changes in your local spreadsheet and re-import it. The process will overwrite the existing org structure in the specified graph.
Link Identities
In order to link employees to their user accounts as explained here, please specify source names matching your sources:
docker run -v "/path/to/my-teams.xlsx:/my-teams.xlsx" \
farosai/org-import-feed:latest \
-u https://prod.api.faros.ai \
-k $FAROS_API_KEY \
-f /my-teams.xlsx \
--graph-name default \
--resolve-location \
--ims-source PagerDuty \
--vcs-source GitHub \
--tms-source Jira \
--ams-source Everhour \
--cal-source GoogleCalendar
Updated 5 months ago