You can import data from Excel files to load data to your application server entities. This is quite useful when you are developing and testing your application.
If you're using Google Sheets, download your document as an .xlsx file (File > Download > Microsoft Excel), and then bootstrap the data.
This way, you can quickly have your data up and running in the application while developing it.
To bootstrap data from an Excel file to an existing entity:
- Open the Excel file, check column headers to have the name of an entity attribute. Close the file or the bootstrap cannot read it.
- In Service Studio, go to the Data layer, right-click on the entity and, in the Advanced menu, choose 'Create Action to Bootstrap data from an Excel.
- Select the Excel file, check the mappings, and proceed.
- Publish to bootstrap the data.
Service Studio will automatically create:
- An action with the bootstrap logic named "Boostrap<entityname>" in the Logic tab, Server Actions folder.
- A structure with the content of the Excel file named "Excel_<filename>" in the Data tab, Structures folder.
- A resource with the Excel file in the Data tab, Resources folder.
- A timer to execute the action at publish time named "Bootstrap<entityname>" in the Processes tab, Timers folder.
When you publish the module, it executes the action to bootstrap the data. If the entity already has data, the action with the bootstrap logic is not executed.
In GoOutWeb, an application for finding and reviewing places, we want to bootstrap places we have in an Excel file. The Excel file is
Places.xlsx and contains values for the mandatory attributes Name and Address, and PhoneNumber for the places we are adding.
To bootstrap data from the Excel file to the Place entity:
Open the Excel file and ensure that column headers names match the names of the Place entity attributes for which you are importing data. Close the Excel file.
In Service Studio, go to the Data layer, right-click on the Place entity, and in the Advanced menu choose Create Action to Bootstrap Data from an Excel....
Places.xlsxfile, check the mappings and proceed.
Publish to bootstrap the data.
Make sure you're following these guidelines to import data from Excel without errors:
- Each Excel sheet must have the name of the Entity.
- Each column header must have the name of the Entity attribute.
If your spreadsheet has blank cells and you're getting import errors, check this Development FAQ on how to proceed.