• All Files

Excel File Folder

this link.

 

Microsoft Excel is a spreadsheet developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to keep and process the spreadsheet content.

The Excel File Folder connector by IConduct allows you to seamlessly integrate Excel with other business applications to transfer data onto/from a set of Excel files in the folder. The connection is organized via OLE DB provider. The Excel File Folder connector works with .xls, .xlsx and .csv files.

 

To configure the Excel File Folder connector, follow the instructions below:

 

  1. In the Main Menu, select Connections and press Create connection.

Accessing connections

  1. On the Connector Selection Page select the Excel File Folder item from the Data Files section.

Connector Selection Page

  1. In the Excel files folder Provider work area, fill in the following fields and press Create.

Connection Details Area

Fields Description

Connection*

A new connection name. Enter a connection alias here.

Is Active

Toggles connector’s activity at interface execution. Enable the checkbox to activate the connection for execution.

Cloud Agent*

The LAN you are working with. Select your corporate agent in the local network where file folder is located.

Implementation Type*

Defines the implementation type. Select from the drop-down list:

  • Default. IConduct scheduler works on the cloud agent set in the Cloud Agent field.
  • Java. IConduct scheduler works by sending requests to a Java agent.

Is Source

This connection entity is available as a data source for Import (writing to Schema). Enable the checkbox to ensure data import.

Is Target

This connection entity is available as a data target that receives data from schema to current data container. Enable the checkbox to ensure data export.

Timeout

The length of time (in milliseconds) the IConduct platform waits for a response from the connection provider before returning a timeout error. Set the time value to stop the system from connection attempts.

Query

The box is intended for entering a query. You can test the defined query by clicking Test Query once the connection is saved.

It’s recommended to test the query after the connection testing.

DateTime Format

Not used in this connector.

Connection String*

A string that specifies information about a data source and the means of connecting to it. Specify the name and file type in the Connection String field. Refer to this page for more information about connection strings.

Example:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties="Excel 12.0 Xml;HDR=YES";

Note: Data Source is the folder path.

File Pattern*

The file mask to filter required files in the folder. Enter the file name pattern for the files you are going to work with.

Example:T*.xlsx, where all Excel files that start with ‘T’ are processed.

Source Folder*

Defines the file(s) directory that the IConduct cloud agent has access to process files from. Enter a valid path to a local network files folder.

Example:d:\source

Sample File Name

A sample file to test the query at import step. Define the Excel file name here.

 

* - mandatory fields

 

Once the connection is saved, you can test if it is successful. Press the Test Connection button. If the created connection works, you will receive a success message. 

Testing the Connection