Question & Answer
Question
CSV file format for usage data
Answer
CSV file format for usage data
Water usage data needs to be imported into IBM? Work Optimization for Water Utilities for analysis.The data needs to be formatted as a comma-separated value file andimported into IBM Work Optimization for Water Utilities withthe wusage.sh script.
ACCOUNTNUNDTENCODER
Account_numberTimestampUsage_value
- Account_number is a customer account numberup to 20 characters in length. The account number must be an accountnumber defined in the customer account information customer productiondata CSV file (customer.csv).
- Timestamp is the time the usage data was readin the format:
Year-Month-Day Hour:Minute:Second:Millisecond
Where:- Year is a four-digit year value.
- Month is a two-digit month value.
- Day is a two-digit day value.
- Hour is a two-digit hour value in 24-hour format.
- Minute is a two-digit minute value.
- Second is a two-digit second value.
- Millisecond is a four-digit millisecond value
The Year Monthand Day must always be specified. If time is alsospecified Hour Minute Secondand Millisecond must be specified.
- Usage_value is text up to 10 characters inlength representing the amount of usage measured by an encoder. Thevalue can include leading zeros. Non-numeric characters will be discarded.
If a value contains non-alphanumeric charactersfor example spaces or symbols the value must be enclosed in quotationmarks. Otherwise surrounding values with quotation marks is optional.Values cannot include double or single quotation marks. All valuesmust be separated by commas.
Allvalues are required for usage analysis.
ACCOUNTNUNDTENCODER"C12345"2011-09-01 14:23:15:123400563"C456782011-09-02 09:01:15:03:000100789"B3987522011-09-15 23:23:01:078610578
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10758623