Firebird Data Extractor

Download

Setup

  • Download appropo-win to your main server which runs the central database.
  • Extract zip
  • Edit config file appsettings.json and change Database Path and possibly User and Password
  • Next open Windows menu
  • Search and open “Task Scheduler”
  • Create a Task
  • Name it something like “Appropo Exporter”
  • Select Triggers tab
  • Select Daily
  • Set start time as 1 am
  • Tick repeat task every hour
  • Click Ok
  • Actions tab
  • Select New
  • Browse and select the appropo-win.exe
  • Also set “Start in” directory to the same location as the config appsettings.json
  • Then Ok
  • Select “Run whether user is logged on or not”
  • Then Ok (You’ll need to enter your password)
  • You can now “Run” the task to check if it’s working

Troubleshooting

  • View log.txt in the folder containing appropo-win.exe
  • View error.txt in the folder containing appropo-win.exe

Example config

{
  "Test": false,
  "Database": {
    "Host": "localhost",
    "Port": 3050,
    "Path": "/var/lib/firebird/2.5/data/otdata.fdb",
    "User": "SYSDBA",
    "Password": "masterkey"
  },
  "Targets": [
    {
      "Name": "Appropo",
      "URL": "http://example.appropo.dev/api/wizbang/import/all",
      "Headers": {
        "Authorization": "Token token=[token-here]"
      },
      "Tables": [
        {
          "Name": "INVOICE",
          "Primary": "INVOICEID",
          "ForeignKey": "INVOICEID",
          "Columns": "*",
          "CreatedAt": "WHENINVOICED",
          "UpdatedAt": "WHENUPD",
          "Nested": [
            {
              "Name": "INVLINE",
              "Primary": "INVOICELINEID",
              "Columns": "*",
              "Key": "INVOICEID",
              "ForeignKey": "INVOICEID",
              "Nested": [
                {
                  "Name": "ORDLN",
                  "Primary": "ORDERLINEID",
                  "Columns": "*",
                  "ForeignKey": "ORDERLINEID",
                  "Nested": [
                    {
                      "Name": "OLMOD",
                      "Primary": "ORDERLINEMODIFIERID",
                      "Columns": "*",
                      "ForeignKey": "ORDERLINEID"
                    }
                  ]
                }
              ]
            }
          ]
        },
        {
          "Name": "CASHUP",
          "Primary": "CASHUPID",
          "Columns": "*",
          "CreatedAt": "WHENCASHEDUP",
          "UpdatedAt": "WHENUPD",
          "Nested": [
            {
              "Name": "CUTLTYP",
              "Primary": "CASHUPID",
              "Columns": "*",
              "Key": "CASHUPID",
              "ForeignKey": "CASHUPID"
            }
          ]
        }
      ]
    }
  ]
}

Ready to get started? Get in touch.

Contact