The renewal maintenance has officially ended for Progress iMacros effective November 30, 2023.
This Wiki site will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely, The Progress Team
Difference between revisions of "!DATASOURCE"
(→See Also: added reference to !DATASOURCE_LINE) |
|||
Line 28: | Line 28: | ||
[[!DATASOURCE_DELIMITER]], Do not confuse with [[!FOLDER_DATASOURCE]] | [[!DATASOURCE_DELIMITER]], Do not confuse with [[!FOLDER_DATASOURCE]] | ||
+ | |||
+ | [[!DATASOURCE_LINE]] for selecting a specific record |
Revision as of 07:30, 7 March 2014
Specifies the name and location of an input file for merging data with macro. If no folder is supplied the file is assumed to lie in the standard data input directory of your iMacros installation, e.g. %USERPROFILE%\Documents\iMacros\Datasources\.
Currently iMacros can read data sources files only in CSV format.
Value
Valid name and location of the input file.
Set By
[ ] Internal
[X] SET
Internal means that the iMacros program itself sets the value of the variable during program run. SET means that the user can set this value via the SET command inside a macro.
Examples
SET !DATASOURCE C:\mysource.txt
Sample macros: Demo-Datasource, Demo-Loop-Csv-2-Web
Notes
- iMacros for IE and the iMacros browser can use either a comma as a CSV separator, or the list separator as set in the Windows Regional Settings. To set the separator for both reading and writing (as in SAVEAS TYPE=EXTRACT) CSV files, use the check box in the iMacros Options dialog.
- iMacros for Firefox uses the a comma as the default delimiter. To specify a different separator, use !DATASOURCE_DELIMITER.
See Also
!DATASOURCE_DELIMITER, Do not confuse with !FOLDER_DATASOURCE
!DATASOURCE_LINE for selecting a specific record