Import Data

Importing existing data in Excel format, into an application is important for several reasons, as it facilitates better data management, analysis, and integration with existing workflows. By allowing data in Excel format to be imported, Codeless ONE can provide users with a robust, flexible, and efficient way to manage and utilize their data.

The most important thing while importing the data is that values of the columns in the excel file should be in the same format as of the relevant properties of the target object.

The process of importing data is elaborated in the following steps:

Click the App Settings icon and select the Application Settings option.

Click the Import Data option in the App Settings panel.

Click the From Excel Sheet button/tile.

Provide the source file.

Select the Header Row and click the Next Step button. The Header row tells Codeless ONE that this is the row in the sheet that stores the column names.

Select the First Data Row and click the Next Step button. This tells where the actual data starts in the excel file.

Select the Target Object and click the Next Step button. The data from the excel file would be transferred to this table in Codeless ONE.

Enable relevant Match Existing Records checkboxes (if required), and then click the Next Step button.

What does the Match Existing Record checkbox do?

This checkbox is usually enabled if there is already existing data in the target table. When the checkbox is selected, the data being imported is compared with the existing data. If there is a match then the existing data is updated with the new values from the excel file being imported, otherwise new records are created from the data being imported. If multiple checkboxes are selected, a match will occur only if all the values from the enabled columns in the existing data align with the corresponding values in the dataset being imported.

Click the Yes, Import button.