Steps to Import Data from a Spreadsheet
- Lakshminarayanan1 S CTOO (Unlicensed)
- Ravikumar Babu CTOO (Unlicensed)
After you log into Sigma Studio, perform the following steps to import data from a spreadsheet:
On the home page of Sigma Studio, click Excel Import on the top pane.
%20-%203.png?version=1&modificationDate=1637495776841&cacheVersion=1&api=v2&width=900&height=409)
On the Import File to DB screen, select the Browser Files option and proceed to import the spreadsheet of your choice.
The supported spreadsheet formats are: XLS, CSV and XLSX.
.png?version=1&modificationDate=1634763358320&cacheVersion=1&api=v2&width=900&height=407)
The imported spreadsheet data appears..png?version=1&modificationDate=1634763358091&cacheVersion=1&api=v2&width=900&height=407)
To generate an app or a view for the imported spreadsheet, click the Generate View option.
On clicking the Generate View option, the Select Workspace drop-down list appears automatically and you can choose an existing workspace of your choice. If you do not select a workspace, then by default, the imported spreadsheet will automatically get mapped to the Welcome workspace. If you do not make use of the Generate View option, then the imported spreadsheet will get saved in the form of a connection and a data source.
%20-%202.png?version=1&modificationDate=1634763357611&cacheVersion=1&api=v2&width=900&height=407)
Before you enable the Generate CRUD sequence, ensure that you select the primary key of your choice from the Primary Key drop-down list.
You can even select multiple primary keys for the imported spreadsheet.
.png?version=1&modificationDate=1634763357381&cacheVersion=1&api=v2&width=900&height=411)
- Select the Generate CRUD option to enable the CRUD sequential flow for the imported spreadsheet.
.png?version=1&modificationDate=1634763357152&cacheVersion=1&api=v2&width=900&height=409)
- To preview the imported spreadsheet, enable the Preview Mode toggle option.
%20-%202.png?version=1&modificationDate=1634763356679&cacheVersion=1&api=v2&width=900&height=413)
To publish the imported spreadsheet, click Publish.
When you try to exit the Import File to DB screen before publishing the imported excel sheet, a warning pop-up message appears as shown in the following screen shot:
%20-%202.png?version=1&modificationDate=1648581821154&cacheVersion=1&api=v2&width=296&height=197)
- Click Cancel, if you do not want to exit the Import File to DB screen.
- Click Ok, if you want to exit the Import File to DB screen.
.png?version=1&modificationDate=1634763356445&cacheVersion=1&api=v2&width=900&height=413)
A confirmation message, indicating a successful data import of the spreadsheet, appears..png?version=1&modificationDate=1634763356210&cacheVersion=1&api=v2&width=387&height=253)
- Click Ok.
Copyright © Intellect Design Arena Limited.
All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.