The import system will help you migrate any existing records to Fusioo.
If you have a Comma Separated Value (CSV) file, you might want to check how to convert it to an Excel file here.
Navigate to the Import page and select the App where you want to import your records. An Excel file template will be available to download.
You need to enter the records you wish to import. Make sure you are entering the correct information for each Field.
Once you’re done, save your Excel file and upload it to Fusioo (in the import file drop zone).
If the Excel column headers match the App Field names, then Fusioo will automatically build the mappings. Double check the Field mappings and click Next to start the import.
Import the records into Fusioo.
You can avoid importing duplicate records in your App by updating existing records. You can do this by choosing a "match by" Field. Values are matched case sensitively.
For example, when matching by the Title Field, if a record exists with that exact Title, Fusioo will update that record. If it doesn't already exist, it will create a new record.
If a row in your import file matches multiple records in Fusioo, all of the matched records will be updated.
If you choose the Create records anyway option, existing matched records will not be updated and duplicates will be created instead.
The accepted values for a Tick Box Field include any of the following:
The format accepted depends on the Field's Date Type
Accepts web URLs that are prefixed with any of the following application protocols:
Accepts any of the custom list items for the specific App Field. To find the supported list items go to the Fields Page of the App in context.
If the Select Field accepts multiple list items, you could separate the list items by using the pipe character ("|").E.g: "Completed|Approved"
If the Link to User in context allows entries with multiple users, you could separate users by using the pipe character ("|").E.g: "John Doe|Jane Doe"
If the Link to Role in context allows entries with multiple roles, you could separate roles by using the pipe character ("|").E.g: "Software Developer|Marketing Manager"
When referencing records found within other Apps, you can only reference values of existing records. If you need to connect the inserted deliverables (as shown in the example) to their respected projects, just insert the Name of the project under the Project column. You could match a project using different Fields, just select the Fields from the available "Match by:" drop down (as shown below).
If we find multiple project matches with the same Name, we will automatically connect the deliverable to the matched projects.
You can use the pipe character ("|") to separate the records you wish to connect the record to.E.g: "Project A|Project B"
You cannot import values for Formula Fields. Values will be automatically computed for each record.