Files
Files can also be imported via the CSV importer. If the files are already accessible via the web, you can simply use this URL in the CSV file.
If the files are located locally on your computer, they must first be made available via a web server, since web browsers do not support direct access to files on your computer.
Alternatively you can upload the files using upload collections. Either upload all files first and then update the records using the CSV importer or import the data using the CSV importer first and then add the files using an upload collection.
Preparation
In order to import files that are located in the local file system using the CSV importer, it is necessary to make them available on a local server. For example, see this list of web servers: https://slashdot.org/software/p/Tiny-Web-Server/alternatives.
In your CSV file you then enter the URL, e.g. http://127.0.0.1:887/my-image.png.
Example Files
| ID | TITLE | CREATE DATE | FILE |
|---|---|---|---|
1 | Rome | 2020-01-01 | |
2 | Laptop | 2007-02-01 | http://127.0.0.1:887/my-image.png |
If your data model allows multiple files to be uploaded per record, then enter all URLs into one cell separated by a break:
| ID | TITLE | CREATE DATE | FILES |
|---|---|---|---|
1 | Trevi Fountain | 2020-02-17 | http://127.0.0.1:8887/Trevi-001.JPG http://127.0.0.1:8887/Trevi-002.JPG |
If in your FYLR the object and image information are managed in separate object types (e.g. "collection objects" and "images"), please import both information separately. Create a CSV file with all information about the objects incl. unique identifier and import it. In the second CSV file, enter all information about the images including the URL to the file and the unique identifier for the associated object and import it.
Import Procedure
first open the CSV importer
upload your CSV file
select "1st Row" for "CSV Field Names"
select the target object type, pool and the corresponding mask
switch to the tab "Import Mapping" and select the corresponding target field for the column containing the URLs
for "Type" select "url" to import new files
switch back to the tab "Import Settings" and select the "Update Field" if there are already records in the list that should be updated if necessary
click on "Prepare" and you will get an overview how many rows will be imported or updated
then the import / update can be started
Last updated