Docker Fsync How To Get Fulcrum

Combining the custom fulcrumviews schema above with the FULCRUMPGARGS setting will create nice user-friendly views for working with your records, photos, and changeset history.

With our export tool, its simple to pull out extracts in formats like CSV, shapefile, SQLite, and even PostGIS or GeoPackage.

What this doesnt allow, though, is an automatable way to keep a local version of data on your own server.

A while back we built and released a tool called Fulcrum Desktop, with the goal of alleviating this problem.

Its an open source command line utility that harnesses our API to synchronize content from your Fulcrum account into a local database.

It supports PostgreSQL (with PostGIS), Microsoft SQL Server, and even GeoPackage.

Other than the primary advantage of providing a way to clone your data to your own system, one of the cool things you can do with Desktop is easily make your data available to your GIS users in a tool like QGIS.

It also has a plugin architecture to support other cool things like: Media management syncing photos, videos, audio, signatures S3 storing media files in your own Amazon S3 bucket Reports Generating PDF reports If you have the Fulcrum Developer Pack with your account, you have access to all of the APIs, so you need that to get Desktop set up (though it is available on the free trial tier).

The quickest way to get up and running with Fulcrum Desktop is to check out the releases page on GitHub and download the latest version for your platform of choice (Windows, macOS, or Linux).

With a simple drag-and-drop you can have the command line tool installed and ready for use.

But here I wanted to cover another utility weve built called fulcrum-sync, which makes it easy to set up Desktop using Docker.

This is great for version management, syncing data for multiple organizations, and overall simplifying dependencies and local library management.

With Docker containerizing the installation, you dont have to worry about conflicting libraries or fiddle with your local setup.

All of the FD installation is segmented to its own container.

This utility also makes it easier to install and manage FD plugins.

Docker Fsync How To Get Fulcrum

The goal of this short tutorial is to show how to get Fulcrum syncing to a PostgreSQL database, connected in QGIS, and to add a data layer to a QGIS project.

Getting Set Up First things first, youll need a couple of things: Docker Desktop youll need this installed and running for your platform to support and run containers.

Fulcrum API key from the Settings in your Fulcrum account, API tab.

GitHub Desktop or standard git, Desktop just makes it easier to clone and set up Next youll want to clone the fulcrum-sync repository, then open a command line prompt to that directory.

Syncing an Account First youll want to set up a local Postgres database to which youll sync your Fulcrum data.

When run the first time, youll see Docker downloading all of the dependency containers, then creating your database (with PostGIS extensions), and syncing the data for the account.

After a few minutes (depending on the amount of data in your Fulcrum account), youll have a database called fulcrumdata in Postgres that contains all of the apps and records from your account.

Youll also have a data directory in that repository with a SQLite version of all your Fulcrum data.

Fulcrum Desktop creates many tables by default to represent various pieces of data.

Docker For Mac Fsync