ETL For PAS800 Data Log Export CSV File

[JamesChen]

Hello All

When I test ETL with the PAS800 data log export CSV file.

It's not working

Because the export CSV format different to data publication via SFTP

[Charles_Murison]

Hello @JamesChen ,

Have you applied the hotfix for ETL from https://www.se.com/in/en/faqs/FAQ000259575/ ? If so and did not work, did you try the workaround?

Regards,

Charles

[UdhayakumarAK]

Hello @JamesChen 

Hope Charles message helped you out. If you are using PAS (panel server) with older Firmware i.e lesser than 1.6.0 the default ETL - EGX extract task should work. In case if you are using latest Firmware version or higher than 1.5.1 then you should use the ETL with hotfix version as mentioned in the FAQ link. Suggestion is to use to the latest Firmware version of panel server and the ETL with hotfix. 

[JamesChen]

Does anyone knows how to use ETL import the PAS800's CSV file to PME?

p.s. the CSV file export from PAS800's WEB page ,  not use SFTP publish.

Thanks

[JamesChen]

Hi  @Charles_Murison 

This way only apply for PAS800 publish csv file via SFTP.

Not for downloading directly from PAS800 Web page.

Thanks

[JamesChen]

Hi  @UdhayakumarAK 

ETL only apply for PAS800 publish csv file via SFTP.

Not for downloading directly from PAS800 Web page.

Thanks

[UdhayakumarAK · Accepted solution]

Hi @JamesChen 

Local export csv file format is meant for local analysis purpose (like excel report/data validation/.. ). SFTP export csv file format is more for data sharing for another systems/SCADA. PAS800 local export csv file format is slightly different than the SFTP export csv format. So, there is a predefined ETL extract job for SFTP csv files which does it for PME data upload and other Schneider applications but in case if you want to use local export file still it is possible. This needs an ETL expert advice it depends on your requirement.

FYI, i think there is no support for new requirement on ETL. This will be a requirement, maybe you can elaborate your requirement and purpose, will check and comment on that.

[JamesChen]

@UdhayakumarAK 

We install the PAS800 for power meter recod in different sites without Internet access.

Monthly we manualy download the energy data from PAS800.

And all so the data needs to be imported into PME for energy Management.

Maybe can add a new function button to PAS800 "Download CSV for ETL"

Thanks for your support

[Charles_Murison]

Hello @JamesChen ,

I do not know the PAS devices well so I cannot speak to exactly how the downloaded data is formatted. If you have this data and doing manual steps already, perhaps there could be 1 additional step to format the data in a way that the existing ETL extract tasks can process the file. I believe there are a few different CSV formats ETL tool supports.

Regards,

Charles

[JamesChen]

Hi @Charles_Murison 

How to format the data in oder to importing to PME by ETL.

I hope Schneider teams can provide steps via docs or videos.

Thanks