Embedded Files
๐๐ป Say goodbye to tedious manual updates!
๐๐ป Say goodbye to tedious manual updates!
We understand that errors or mistakes can occur when entering data, and correcting them individually can be time-consuming. To address this, we offer an update feature that allows you to update multiple data entries simultaneously with just a few clicks!
Prepare the Updated File
Prepare the Updated File
Watch the guided demo below to see how to add the new user with the appropriate role.
You can also follow the same steps using the written guide below.
Open the record where you will update the data.
Export a list of entries as your starting point to ensure each row includes a valid entry ID.
โ๏ธNote
ย The exported file does not include any Sub Record entries contained within the record.
From the exported file, you can delete any columns you donโt need or donโt want to update, such as `createdAt` and `updatedAt`. You can also fill in or edit the columns and cells for the data you want to update.
๐ Info
When you are importing or updating the file, you can still skip or remove any columns you donโt want to update in the Map Columns step.
๐ See also
You can use the importing format for reference.
Save the file.
Update the Data
Update the Data
Watch the guided demo below to see how to add the new user with the appropriate role.
You can also follow the same steps using the written guide below.
There are two ways to access the Import page.
Via System Settings
Click "Settings" and proceed to "System Settings".
Select Import Data option.
On the New Import tab, click on the Start Import button.
Here, you need to select the record you want to import or update.
Via the Record
Open the record where you will update the data.
Click on the three-dot horizontal button, then select Import Data.
From the Import page, select the Update Data option.
Upload the CSV file to update the existing entries.
๐ Info
Max file size 50 MB
Click Next.
In the Map Columns page, select or deselect the checkboxes to choose which fields you want to import into the record.
The grey colour indicates fields that will be skipped (unmapped).
The red colour indicates invalid fields that require mapping.
๐ Info
Whenever you hover over the column, you will see the data preview in the right side of the page.
Click Next to continue to the next step.
Review your data.
Click Import to System to finish the importing process.
You will get an error message if there are errors in the rows.
Click No, go back to resolve the errors.
Click Import, if you decided to skip the errors and continue to update. Rows with errors will be skipped and written to an error file so you can reimport them later.
After you import the file, you can view its process and error details. You can also go back to the record, and click the search bar to find and filter specific data you just updated.
Update the Sub-Record Data
Update the Sub-Record Data
Watch the guided demo below to see how to add the new user with the appropriate role.
You can also follow the same steps using the written guide below.
Click "Settings" and proceed to "System Settings".
Select Records menu.
Look up for the sub record in the standard or custom record section.
Export the entries of the record.
Open the downloaded CSV file. You can delete any columns you donโt need or donโt want to update, or edit the columns and cells for the data you want to update.
โ๏ธ Warning
Do not delete INDEX and PARENT_ENTRY columns.
Save and export the CSV file again.
Go back to the main record.
Click on the three-dot horizontal button, then select Import Data.
From the Import page, select the Update Data option.
Enable the Update Sub-records toggle.
Select the sub-record you want to update from the dropdown.
Upload the CSV file to update the existing sub-record.
๐ Info
Max file size 50 MB
Click Next.
Select or deselect the checkboxes to choose which fields you want to import into the record.
Click the Next button to proceed to the final preview import step.
Review your data. Click Import to System to finish the importing process.
You will get an error message if there are errors in the rows. You can go back to the previous step to resolve the errors, or skip the errors and continue to update.
After you import the file, you can view its process and error details. You can also go back to the record, and click the search bar to find and filter specific data you just updated.
Page updated
Report abuse