0|'2015-12-04 10:11:30.611'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04
10:11:30.611'|8|0||'No cluster'|'Non-existing cluster'
1|'2015-12-04 10:11:37.748'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04
10:11:37.748'|8|0||'after import'|'Cluster for all pre-existing instances'
The record 0 start from line 1.
-----Original Message-----
From: Bryan Pendleton [mailto:[email protected]]
ERROR XIE0R: Import error on line 1 of file D:\derby\data\wincluster:
The syntax of the string representation of a date/time value is incorrect.
What's on line one of that file?
Can you try modifying the file? Perhaps create a simple subset (the
first 10 lines or so), and experiment with it?
For example, try removing the single quote marks around the dates,
and see if that causes the dates to be processed successfully.
My import files are typically comma-separated; I assume that you
have set the delimiter to '|'?
thanks,
bryan