CSV Driver Connection Limit


#1

I would like to know if you can help me regarding what are the 5 connections limit that you have in your CSV driver.
The real application that I need is to export histories in a CSV format to a FTP remote server.
For example, I have in one project let say 20 energy meters and I want to export the values of the energy of each one to that remote FTP.
How many connections are this?
This limit is only in the AX version or also in the N4?”


#2

Hey mlubas,

Here is a link to a detailed response that will answer this question.

Removed Link


#3

I do not have access to that topic…


#4

Here is the contents of that post. Cleaned up a bit so it only contains information you are interested in.

The way to think of a connection in the context of the csv driver is to think about the data flow.

So when you think about imports and exports:

An import is best thought of as a single point of access that contains some csv data you need into Niagara.
An export is any group of histories that exist within Niagara that you need to get out of Niagara.
Example 1: You have 500 histories in your station and need them to export out of the station. This requires a single export object which counts as 1 connection against the licensing. One export object will then give you the ability to now export all of these 500 histories to any of the supported export locations (email, file, ftp, url, etc.).

Example 2: You have a csv file sitting on an ftp server somewhere and need that data in Niagara. This requires 1 CsvFtpImport object which counts as 1 connection against the licensing.

Example 3: Let’s consider both examples above and now say we need to import data from an ftp and also export historical data out of ftp. Perhaps you needed to combine some third party csv import within niagara with existing integration data to do some calculations and then export the results out to another system for final evaluation. In this instance, you would have one import and one export object which would count as 2 connections against the licensing.


#5

What is the specific device licensing that is required to add an import and/or export to a station? i have gotten mixed information from people and hope to have this cleared up here. I have the CSV driver installed on the supervisory station and i am trying to export .csv history files for commissioning.

Are the connections IP connections (PN: FX-SLDL010-0 for 10 connections) or is it a different type of connection charged against the license? if so what would the part number be? Is there a limit to how much you can export with s single connection?

Thanks for the help.


#6

The number of imports and exports you need is what determines the number of connections.

For example, If you have 10 imports and 10 exports you need 20 connections.

Edit: Also here is a video on how to license our drivers: https://youtu.be/rDHyof-NIi8