Support of CSV/TXT flat files as data-sources for CR4E:
Crystal Reports Enterprise 4.1 SP06 release supports the new data-source support ie Support of CSV/TXT flat files as data source. The functionality remains the same as in SAP Information Design Tool.
Here I will be explaining how to consume flat files in CRE with screenshots and steps below.
1. CSV/TXT option is available in CR4E under connection by vendor section. Connection by vendor-> General-> Text Files-> BusinessObjects OpenConnectivity as shown in below screenshot.
Select the option and click “Next”.
2. The next screen will display list of options which are briefly explained below.
a. The connection dialog has two tabs ie “Login Parameters tab” and “Basic Text file settings”.
b. Login Parameters tab contains file input fields such as Location Type, Protocol, Filepath and schema fields.
c. Location Type: Local and Remote are supported.
d. Under Remote location type: SMB (Windows share), FTP and HTTP protocols are supported which are listed under protocol dropdown list.
e. The corresponding authentication fields are also displayed in the “Login Parameters” tab
f. Schema fields supported include auto, no detection, DDL (Data Definition Language) and SQLDDL.
g.“Basic Text file settings” tab contains file editing parameters such as qualifiers and separators.
3. Now let me take you through the flow of consuming csv file.
a. Specify the path of csv file in Filepath or Pattern field in the dialog as shown below and select next
b. The CSV file will get listed in Table section and double click on the table. The table appears on the selected tables section as below:
Select “Finish”. The rest of the flow will be same as acquiring other data sources.
4. While using HTTP and FTP protocols, select location type as ‘Remote’ and also select specific protocol you want to use. Later give the path of csv file and its corresponding credentials if exists. And rest of the acquisition will be same as above.
Using DDL or SQLDDL Files:
While using DDL and SQLDDL files, Select “DDL” in Schema Detection field and enter both file path and schema file path of the input file and click next. The rest of the flow is same as other data sources.
This is the brief introduction on how to use flat files CSV or Text files as input in CR4E. Hope it helps..