Importing Org Data 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.

Download Airbyte Local CLI, then from your terminal, create your Airbyte config file and run the CLI to import your org data into a desired graph in Faros (default graph in this example):

📘
Modify /path/to/my-teams.xlsx with the correct path to the file.

>> Create a config file 'test.json'
{
  "src": {
    "image": "farosai/airbyte-faros-feeds-source",
    "config": {
      "feed_cfg": {
        "feed_name": "org-import-feed",
        "faros_api_key": "<YOUR_FAROS_API_KEY>",
        "spreadsheet_source": {
          "sheet_source": "LocalSpreadsheet",
          "file": "/my-teams.xlsx"
        },
        "graph_name": "default",
        "resolve_location": true
      }
    }
  },
  "dst": {
    "image": "farosai/airbyte-faros-destination",
    "config": {
      "edition_configs": {
        "api_key": "<YOUR_FAROS_API_KEY>",
        "graph": "default"
      }
    }
  }
}

>> Save it  
  
./airbyte-local \
	--config-file test.json \
  --check-connection \
  --raw-messages

If you are still using the deprecated Airbyte Local CLI airbyte-local.sh, run the equivalent command:

./airbyte-local.sh \
  --src 'farosai/airbyte-faros-feeds-source' \
  --src-docker-options '-v /path/to/my-teams.xlsx:/my-teams.xlsx' \
  --src.feed_cfg.faros_api_url "https://prod.api.faros.ai" \
  --src.feed_cfg.feed_name "org-import-feed" \
  --src.feed_cfg.faros_api_key "<faros_api_key>" \
  --src.feed_cfg.spreadsheet_source.sheet_source "LocalSpreadsheet" \
  --src.feed_cfg.spreadsheet_source.file "/my-teams.xlsx" \
  --src.feed_cfg.graph_name "default" \
  --src.feed_cfg.graphql_api "v2" \
  --src.feed_cfg.resolve_location true \
  --dst 'farosai/airbyte-faros-destination' \
  --dst.edition_configs.edition "cloud" \
  --dst.edition_configs.api_url "https://prod.api.faros.ai" \
  --dst.edition_configs.api_key "<faros_api_key>" \
  --dst.edition_configs.graph "default" \
  --dst.edition_configs.graphql_api "v2" \
  --check-connection \
  --raw-messages

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 additionally specify source names matching your sources:

{
  "src": {
    "image": "farosai/airbyte-faros-feeds-source",
    "config": {
      "feed_cfg": {
        ...
        "tms_source": "Jira",
        "vcs_source": "GitHub",
        "ims_source": "PagerDuty",
        "cal_source": "GoogleCalendar",
        "ams_source": "Everhour"
      }
    }
  },
...

The equivalent config for the deprecated Airbyte Local CLI airbyte-local.sh:

./airbyte-local.sh \
	...
  --src.feed_cfg.tms_source "Jira" \
  --src.feed_cfg.vcs_source "GitHub" \
  --src.feed_cfg.ims_source "PagerDuty" \
  --src.feed_cfg.cal_source "GoogleCalendar" \
  --src.feed_cfg.ams_source "Everhour" \