|
|
Component: CsvImport
|
|
The CSV import service extracts data from a Comma Separated Value (CSV) file to be used within a LiveCycle process. Many tools export CSV data. For example databases use this format to dump the contents of their tables, MS Excel spreadsheets can be exported/imported to/from the CSV format. Business processes, being across many knowledge based systems and being knowledge intensive in nature require a way to import CSV data into the process. This service provides the ability to import CSV into your process to an XML format. Sometimes the datasets being imported from are extremely large (i.e. in excess of 50 MB) in which case it is not feasible for the CSV data to be transformed into XML. In this case the service allows us to import data from the CSV and, line by line, update straight into a database table.
|
Operations
|
Icon
|
Name
|
About
|
Link |
|
|
Import a Csv File into SQL
|
This operation imports the contents of a CSV document and writes each line of it, as a row, into a selected database table. This is fully configurable.
Why use it
- In many situations the CSV file is too large to be stored into LiveCycle as a process variable. In such cases it becomes necessary to write the CSV file contents into a database line by line.
- This operation allows us to update such a table with new values for existing rows, or to create new rows as needed.
|
Properties |
|
|
Import a Csv File into XML
|
This operation imports a CSV file into an XML format. This is only feasible for smaller CSV files. For CSV files larger than 10 MB it is recommended to use the 'Import a Csv File into SQL' operation.
Why use it
- XML is a common data format in LiveCycle processes and so when data is stored in a document/file as CSV and the process we create needs to 'reason' about the contents of the CSV file, converting it into XML makes our life easier.
- In many cases, this operation allows you to use CSV file to populate a form or a dropdown list on your form dynamically.
|
Properties |
|
DOWNLOADS
DOCUMENTATION
|
|
Products
LiveCycle ES Components Installer
Business Process Techniques and Patterns