In instances where automated (either direct or via modem) communication channels between the SPM server and the remote device isn't available, ION Setup can be used on a laptop by field personnel to retreive logged data to be imported into the SPM database.
Using customized ION Setup Assistants, users can easily collect the data and send the files to the SPM server which is configured to import the XML data files into the SQL database.
Contact the Schneider Services group for exact details on configuration of the ETL service and myself for the specialized ION Setup assistants.
Here is the procedure on how to incorporate SPM data collection into an existing Setup Assistant:
AssistantText=Welcome to the Setup Assistant! The following dialogs guide you through device setup. Select from the left which setup you wish to perform or press the Next button to cycle through all of the different setups.
Tab1Text=Allows you to collect recorder information to transfer to an ION Enterprise system.
Tab1Log2=All Data Recorders,1,0x84
You should speak to Tom Stevenson (email@example.com) about the ETL for the SPM. He'll can point you to an available developer that can help you.
Hi Jairo - Kyle LeBlanc will connect with you for more detail.
Hi Jairo - I'll get in touch with you shortly. I'll start off with a few questions to make sure I understand your request.
So I'm assuming this is an ETL routine, and also only applies to tabular data, and not PQ waveform data?
The actual waveform captures can be stored using a base64 encoded XML format into the file which ETL can import data (similar to how MeterM@il data can be imported into the SPM database).
The Custom setup assistant provides options which allow the user to upload Events, Waveforms and Data Recorder logs into an ION Enterprise XML format (which requires ETL to be setup on the SPM side to import the file in).
Okay. So are you making this available to the advanced solutions integrators?
I've posted in the original post instructions on how to incorporate the ability to generate XML files for SPM data collection. You'll still need to configure ETL to setup SPM to allow the importing of the data files into the database.
Kyle/Tom, can you post the ETL configuration required to import this into SPM? Thanks.
Are these documents available? I need to shift data from one DB to another (PME to PME)
I've had a look through this and also trying different options with the ETL tool. I can only export my PME data into an HTML file (can't seem to get it in csv) and see how to load an HTML file into my new database. I've tried manually altering the html file into csv but ETL doesn't seem to like this.
Hi Alister - I will get in touch with you shortly and go through the PME to PME scenario. You can go from one PME to another directly. I'll help you with CSV too, if that's still needed.
when done i will test the option for the ion 8000 family.
this is most used by the brazillian utilities.
there is a way to custom the xml schema generated by the ION SETUP?
The latest ION Setup on Box already has the Data Collection feature available for the ION8650 models but the other models (8300/8400/8500/8600/8800) will still need the custom assistant changes. There is no way to customize the XML schema as it is designed to import the information in via ETL which expects the schema in the expected format. You should be able to copy the changes from the 8650 setup assistant to the others however.
we will try it. good job Robert.