EGX300 Data retrieval cannot push FTP

[arjanbijker]

Hi,

is there a way to pull the historical data from a remote connected EGX300,  everyday, or every hour?  Preferably only pull the 'new' information, and not the complete logs.

Because of firewall restrictions, I cannot get the data to be 'pushed' from the EGX300 to an FTP server (port 21 is blocked). [ which is the standard method for connecting remote points ].

It works if you use a FTP client and connect to the EGX300 from your server.  However, using this method, you will have to transfer the complete CSV files from EGXIP:21/data/logging/*.csv

My limitation is that this is over GPRS network, so effectively, if you pull the complete historical logs everydag, the bandwidth usage will be massive.

Is there a way to get only the newest logs transferred, using the "pull" method?

Regards,

[Adrian_Dicea · Accepted solution]

Hi Arjan,

I came across your post while searching Jive for a different topic.

I'm late with this reply, but I had an idea, I tested and it works given your conditions.

EGX300 can work as FTP Client when exporting Device Log files to a remote FTP Server and also can work as an FTP Server when a remote FTP Client connects to get/put files in the EGX300.

You would want the newest data only.

For that I setup EGX300's Device Log Export to have "Incremental" FTP Transport and to export the data to itself.

Now, there are some issues which I had to overcome:

- it worked with Directory set as empty, this means it puts the CSV files in the device root; I have tried with different other existing folder names and some are protected from writing from external FTP Clients, some are not (/www/maintenance for example works).

- you cannot create neither directory, not subdirectory in the EGX300, to be better organized

- you will need to move files with your FTP Client (RETR and DELE - FTP commands) not to fill up the EGX300 with too many files.

Regards,

Adrian

[sesa205726_brid]

Hi Adrian,

about the point:

"it worked with Directory set as empty, this means it puts the CSV files in the device root; I have tried with different other existing folder names and it didn't work"

I set a directory and EGX300 works properly.

I sent a procedure written for a customer, this is written in italian, but I think the pictures can help you to understand.

BR

https://schneider-electric.box.com/s/sl1nvf6whx1nh24v3lzt

[arjanbijker]

Cool

Excellent work!

Sent from my iPad

[Adrian_Dicea]

Ciao Salvatore,

The document in Italian that you are referring to is good when setting EGX300 to export Device Logs to an External FTP Server.

In my "solution": I am using EGX300 as FTP Server, not a regular PC with FTP Server installed.

EGX300 pushing Incremental Device Logs, through FTP, to itself.

File and Directory Permissions are handled in different way (they are forced) inside the EGX300 FTP Server.

You cannot create a new directory inside EGX300 using an FTP Client. You will need a new Disk Update for that.

You cannot write files anywhere you want inside EGX300 using an FTP Client. Only some places are unprotected.

Cordiali Saluti,

Adrian

[sesa205726_brid]

Hi Andrian,

thank you for the explanation.

BR