This is the type of operation used to call the information prepared in Excel CSV format to the Grid Form control added to the form.
Show Content Csv operation at Property Panel
Properties
Description: A description of the action is written.
Heading: Specifies the name in the action list when added as a Form Action.
SQL Query: First, it saves the fields in the .csv file to the XPODA_CSV_TABLE table with the column names Col1, Col2 .. with the specified delimiter. The XPODA_CSV_TABLE table in the query field is connected to the table in which information is to be retrieved, and the data in the grid is transferred.
Bracket: The contents of the invoked CSV's delimiter format are defined.
Start Line: If there are titles in the CSV file, it is provided to read the records without considering these records by giving start line information.
Line Looking: The selection of whether or not to be navigated individually in the lines of the list to be transferred is made.
Run Condition: If the value in the query entered in this field is ‘0′, the corresponding action will not run.
Request Confirmation: Select whether to ask for confirmation before running the action. If Request Confirmation is activated, the Confirmation Message feature is turned on and the message that will be displayed when requesting confirmation is written.
Example Used
For instance; There are a button and a grid form controls in a form. The button has a Show Content Csv operation with When clicked event. SQL Query is written below. The columns in the query must be as much as the columns in Excel. Aliases are grid columns names. These columns are taken from #XPODA_CSV_TABLE. Bracket is a CSV data split.
Excel data is prepared for the Grid control without headings.
Excel screen
This excel program is saved as CSV.
When the button in the Client screen is clicked, the file menu is opened from the computer. The CSV excel is chosen.
Client view on screen
Then, the excel data fill to the Grid control.
Client view on screen