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