DOCUMENTATION (CURRENT)

v8.x Documentation v6.x-v7.x Documentation

New Data Source screen (Microsoft Excel)

Configures a Microsoft Excel file as your data source.

How do you want to set up your entity? screen — Figure: How do you want to set up your entity? screen

Background and Setup

Prerequisites

A process-based app.
Your Microsoft Excel file must be formatted so AgilePoint NX can read it.
For more information, refer to Rules for Using Microsoft Excel Files with AgilePoint NX

Good to Know

Your Microsoft Excel file must be permanently stored in a supported repository. The following rules apply:
- The file name must not change for the Excel file.
- Once the data source is configured, the Excel file must not move from the configured location.
- The names for any folders or other dependent items, such as SharePoint document libraries, in the path to the Excel file must not change.

How to Start

Click App Builder.
On the App Builder Home screen, click All Apps.
On the All Apps screen, on an app, click Edit .
On the App Details screen, click Add New > Data Source.
On the Please select data source type screen, select Microsoft Excel.
Click Next.

Please select data source type screen

Specifies the location of your Microsoft Excel file that contains the data in table format.

Please select data source type screen — Figure: Please select data source type screen

Fields

Field Name	Definition
Box	Opens this Screen: Document Repository for Box Function of this Screen: Specifies the location of your Microsoft Excel file in Box.
Google Drive	Opens this Screen: Document Repository for Google Drive Function of this Screen: Specifies the location of your Microsoft Excel file in Google Drive.
OneDrive	Opens this Screen: Document Repository for OneDrive Function of this Screen: Specifies the location of your Microsoft Excel file in OneDrive.
OneDrive For Business	Opens this Screen: Document Repository for OneDrive for Business Function of this Screen: Specifies the location of your Microsoft Excel file in OneDrive for Business.
SharePoint	Opens this Screen: Document Repository for SharePoint Function of this Screen: Specifies the location of your Microsoft Excel file in SharePoint.
File System	Opens this Screen: Document Repository for File System Function of this Screen: Specifies the location of your Microsoft Excel file on the AgilePoint Server machine.

How do you want to set up your entity? > Configuration tab

Configures how to collect data from a Microsoft Excel file for your process-based app.

How do you want to set up your entity Configuration tab — Figure: How do you want to set up your entity? > Configuration tab

Good to Know

The word entity on this screen refers to a container within your data model. For Data Entities or Salesforce, this container is called an entity. For a database, entity refers to a database table. For SharePoint Integration, entity refers to a SharePoint list. For Microsoft Excel, entity refers to an Excel table.

Fields

Field Name	Definition
Data Source Name	Description: Specifies a name for your data source. Allowed Values: One line of text (a string). Not Accepted: Spaces Default Value: None Accepts Variables: No Example: Refer to: (External) Form Based Apps – SharePoint Data Source
Repository Type	Description: Shows the type of repository you selected in the Repository screen for your Microsoft Excel file. Allowed Values: Read only.
File Name	Description: Shows the name of the Microsoft Excel file you selected in your repository. Allowed Values: Read only.
Primary Entity Name	Description: Specifies the name of the Microsoft Excel table to use for your process. Note: The word entity on this screen refers to a container within your data model. For Data Entities or Salesforce, this container is called an entity. For a database, entity refers to a database table. For SharePoint Integration, entity refers to a SharePoint list. For Microsoft Excel, entity refers to an Excel table. Allowed Values: A Microsoft Excel table name from the list. Default Value: None. When you select the access token in the Repository Configuration screen for your repository, the Microsoft Excel tables associated with the Excel file in the repository show in the Primary Entity Name list. Accepts Variables: No

How do you want to set up your entity? > Fields tab

Specifies the Microsoft Excel columns to use in a process-based app.

How do you want to set up your entity Fields tab — Figure: How do you want to set up your entity? > Fields tab

Prerequisites

Complete the How do you want to set up your entity? > Configuration tab.

Fields

Field Name	Definition
Check box	Description: Specifies the Microsoft Excel columns to use in your process. Allowed Values: Selected - Your process uses the Excel column. Deselected - The Excel column does not show in your process. Default Value: Selected
Display Name	Description: Shows the Microsoft Excel column associated with an Excel table. Allowed Values: Read only.
Data Type	Description: Shows the data type for a Microsoft Excel column. Allowed Values: A data type from the list. Default Value: The data type of the associated Excel column.
Required	Description: Shows whether a value is required in the Microsoft Excel column. Allowed Values: Read only. Yes - The Excel column must have a value. No - The Excel column value is not required.
Unique	Description: Shows whether a duplicate value is permitted in the Microsoft Excel column. Allowed Values: Read only. Yes - This column is unique. Duplicate values are not permitted. No - Duplicate values are permitted.