Has anyone created a tool to combine all EGX300 data...?

[JamesJeanette]

Happy Friday everyone!

I have a request from a Country representative who is looking for some help.  Maybe someone in this community already has the answer.

Background...

The EGX300 exports data for each device logged in a separate .csv file (for each device).  Make sense?  Example...If you are logging data for 3 meters, and exporting that data from the EGX300...you will see 3 separate .csv files exported...one for each meter.

The request....

Does anyone have experience, or maybe already a tool (in Excel?), that will take these 3 .csv files and combine them into one log file...with the push of a button?  This could also be used for the Com'X 200; however an additional step is required as the .csv files are published in a compressed .zip format.

Thanks!

James

,

[sesa82384_bridg]

Please send me the full specification. I may be able to help.

For instance, generate an Energy Operation XML file with all hierarchy and data.

Anyway, a clear, simple yet precise spec would be good.

Carlos

[ganesh_azzo_com]

Hi Carlos, I would be interested to have look on the solution . Please do pass on to me also. This will help our customers

[Juan_Arias]

Hi James,

The team in Belgium has a really interesting reporting application based in the EGX300 that I think it could do what you are looking for...

Cheers,

Juan

[sesa82384_bridg]

Hi all.

I'm wating for the minimum specification.

One comment is: We can't merge two EGX CSV files and generate an output with the same format because the measurement columns may not match for every meter.

So I'd like to know where these files will be used. If is to be sent to Energy Operation I do have an immediate solution.

Cheers

CT

[JamesJeanette]

Hi

Can you help provide some more information regarding this request?

James