JSON Importer
The JSON importer can be used to bulk import data in JSON format
Last updated
The JSON importer can be used to bulk import data in JSON format
Last updated
The JSON importer can be used to bulk import data in JSON format.
A step by step tutorial on how to generate JSON Payloads can be found here.
The importer can be found under "Tools > JSON Importer".
The configuration for the JSON importer can be uploaded in a manifest file (.json
). The manifest contains payloads and other information which will preset the importer.
Please note that the server where the manifest.json
and the payloads are stored, needs to be accesible from the frontend
Option | Description |
---|---|
URL manifest.json | This is a URL to get the |
Source | Name of the source instance. Can be freely selected. This information is not migrated, it is only used for identification purposes (optional) |
Payloads base URI | Base URI for all the payloads in the list. It will be prepended to each payload. The default value will be the same base URL of the manifest. If the payloads are not stored in the same folder as the manifest (or on another server), this is needed to build absolute paths from the payload file names. This value needs to be the relative path to the payload folder |
Batch size | Quantity of objects pushed to the server per request |
File upload type |
|
Skip HEAD Request | Enable this, to skip the HEAD request that is performed by fylr before files are loaded. This is only effective, if remote put is selected |
Metadata mapping | Metadata mapping used for files (optional) |
Ignore file upload errors | When checked, all errors of file uploads will be ignored and the import process will continue. All errors will be available in the logs |
Ignore unique constraint errors | When checked, all UNIQUE constraint database errors from the server will be ignored |
File replace url | The location for each file URL will be replaced by the value configured here. If a file URL in the payload starts with |
Some of these fields can be pre-filled by values in the manifest.json
file:
Option | Key | Type | Description |
---|---|---|---|
Source |
| String | |
Payloads base URI |
| String | |
Batch size |
| Integer | min: |
File upload type |
| String |
|
Skip HEAD Request |
| Boolean | |
Ignore file upload errors |
| Boolean | |
File replace url |
| String | Valid URL |
Metadata mapping |
| Integer | ID of the metadata mapping |
This list show all available payloads. It is possible to see the content by clicking them.
Header | Description |
---|---|
Status | Current status of the payload. |
URL | The url of the payload |
Starting batch | Number of the starting batch. As default the first one is selected, so all batches are processed |
Batches | Quantity of batches (they will depend on the quantity of objects and the selected batch size) |
Objects | Quantity of objects |
Objecttype | Objecttype of the payload |
Actions | Opens the payload in a new tab |
Enabled | Checkbox to enable or skip the payload (Ctrl+Click to select/unselect all in the selected page, or click in the button below to select/unselect in all pages) |
Function | Description |
---|---|
Load | (Re)Load the manifest file from the URL |
Download logs in CSV format. | Download the logs in CSV format |
Clear the logs | Clear the logs of the last run |
See the last report generated. | See the report of the last run |
Prepare | By clicking some validations are performed before the actual import can be started |
Start | It starts the import of all the enabled payloads |
Since the frontend loads the JSON files as a client, it is possible that the browser you are using will block the request to the other server.
Mixed Content Blocking is implemented in many browsers and is a security feature:
Google Chrome: "No More Mixed Messages About HTTPS"
Mozilla Firefox: "Mixed content blocking in Firefox"
Microsoft Edge: "Learn how Microsoft Edge handles mixed content downloads"
this might also be implemented in other browsers in some way
If the manifest and the payload files can not be loaded, check the developer tab of your browser and look for an error message that looks like any of these (there my be variations):
or
If this is the case, your browser blocks the request. Depending on the browser, there are ways to work around this, and allow loading the files anyways.
Caution: Mixed Content Blocking is a security feature. Only disable it if you trust the other server. This might be a security risk!
For different browsers, there are plugins available which allow to disable Mixed Content Blocking, for example:
Google Chrome: "Allow CORS: Access-Control-Allow-Origin"
Mozilla Firefox: "CORS Everywhere"
With many of the available plugins it is possible to toggle Mixed Content Blocking. Please check the availability of plugins for your browser.