General Site Issues : Data import

[Phoenix]

Ticket ID: DTM77

Priority: High

Unable to import the intra day data from 1/1/2011.

[Khokan]

Sir,
The data format has changed as a result of which we r getting errors in import. Can any1 suggest away around this problem. Thanks

[Prashanth]

Sir,
The data format has changed as a result of which we r getting errors in import. Can any1 suggest away around this problem. Thanks

Hello,

There are 2 changes

1. First line now contains the header instead of old file where no header existed.

2. Date format has changed from mm/dd/yyyy to yyyy-mm-dd

The above changes should have been communicated to members in advance. Apologies for the same.

Prashanth

[Khokan]

Thanks for the info. Can any1 suggest how to change the format in AB, so that we can import data.

[Prashanth]

Thanks for the info. Can any1 suggest how to change the format in AB, so that we can import data.

Attached is the format file. Open in Notepad and copy / paste it to your IEOD file.

[Khokan]

Many thanks, worked like a charm..