Data Conversion

Only convert essential data. Only convert objects that are essential to running the business.

Pay careful attention to measurement data. Measurement data is very, very large and may take weeks to convert. Consider this: if it takes one hour to load measurements every day, how long will it take to load 5 years of measurements? Although conversion jobs are faster than regular data loading, measurement conversion still takes time. Here are a few measurement best practices:

• Projects are encouraged to only convert the minimum amount of measurement data required.

• If historical measurements are required, try to limit the amount of data converted. The best practice is to convert 13 months of consumption to support VEE.

• Only convert channels absolutely required, usually billing channels, and don’t convert other interval data if not needed.

• Measurement data values should be converted directly into the Measurement table and not use the IMD and VEE processes.

• Do not convert Initial Measurement (IMDs). Completed IMDs are not needed for any Meter Data Management processes.

• Remember that billing quantities will likely also be stored in the customer information system, so confirm that the measurement data is required before conversion.