...
DataBridge already has great support for all major SuperOffice entities like ‘Company’ and ‘Appointment’ for example, DataBridge imports the data for these entities straight into the SuperOffice database to make the data available to your SuperOffice users.
Importing documents into SuperOffice raises a bigger challenge as a physical document/file is required besides the document entity data that details that goes into the database. Due to this complexity, this feature has some restrictions to consider, so please read the checklist below carefully.Please note: when When we talk about a physical document we mean the actual digital file like a Word or PDF document, a . A document entity represents document metadata, as shown in the SuperOffice document dialog. Both are required to represent a document inside SuperOffice.
| Info | ||||
|---|---|---|---|---|
| ||||
When using Microsoft 365 (SharePoint) as a storage location for SuperOffice instead of the standard SO_ARC folder, document import is not possible as DataBridge can not gain access via SuperOffice system-user to Microsoft 365. |
Checklist
Please consider the following requirements and restrictions that are currently effective for the SuperOffice document import feature. As we continue development on this feature this list could change over time.
- Currently only this profile setup is supported, FTP to SuperOffice:
- Currently, it is required to have an import file in a supported format on an FTP server that can be reached by DataBridge.
- This is a regular import file with data regarding one or more SuperOffice entities on each line.
- Each ‘line’ in this import file can have 1 accompanying physical document when document fields are configured.
- The physical documents need to be available on the same FTP connection as used for the main import file, subdirectories can be used, however.
- Physical documents are limited to a size of 10MB each, the same file types as SuperOffice are supported.
- Also, consider your available storage space when using SuperOffice Online as this differs per price plan.
- The speed of document import is mostly impacted by the FTP server and the SuperOffice connection.
- Currently, only 1 column of the main import file can be assigned for the path of the physical document, this can be a relative path, only the file name or any other identification value.
...
| title | How to find documents > 10Mb? |
|---|
On windows use the command "forfiles" with parameters. It will list all documents that are bigger than 10Mb, even on a mapped network drive, including a recursive search in directories.
If you want the output of this search go into a text file, just add >c:\users\<your username>\Big Files.txt (or any file location you have write access to.)
| Code Block | ||
|---|---|---|
| ||
forfiles /P D:\ /M *.* /S /D +"01/01/1980" /C "cmd /c if @fsize gtr 10485760 echo @path @fsize @fdate @ftime" |
...
Source
DataBridge supports the import of documents, including physical documents from:
- FTP and SFTP
- Microsoft OneDrive
- Microsoft SharePoint
Besides the physical document file(s), an import file is needed in which there is more information on the document, like the company to which the document will be linked. The source needs to provide both types of files.
In the example below, there is an import file that holds the details for 3 documents that will be imported. On the FTP location that is used in this example, you also see the 3 physical documents on the same FTP location as the import file.
| Info | ||
|---|---|---|
| ||
Note that each document can be a maximum of 10MB. Documents that exceed this amount are not processed. |
How to
Step 1 - Configure Profile
In the first step of the wizard, configure the access to the source. This is where you also configure what import file to use. How this is done, depends on the source platform. In the example below, FTP is used.
If you have a profile that imports data from FTP to SuperOffice the required configuration options become visible in the DataBridge wizard.
...