[OPEN-ILS-DEV] import_demo question

[Nella Lall]

Bill,

Perfect, that did the trick!  At long last I have 1000 of our own marc 
records and their copies in a sample evergreen system. 

Nella

Bill Ott wrote:
>> psql:insert_holdings.sql:1: ERROR:  date/time field value out of 
>> range: "12/13/1993"
>> HINT:  Perhaps you need a different "datestyle" setting.
>> psql:insert_holdings.sql:2: ERROR:  current transaction is aborted, 
>> commands ignored until end of transaction block
>> psql:insert_holdings.sql:3: ERROR:  current transaction is aborted, 
>> commands ignored until end of transaction block
>> ......
>>
>> So, can you help me figure out how to fix this problem it is having 
>> with my create date of 12/13/1993. 
>
> The short answer is, it's expecting an ISO 8601 date.  i.e.  yyyy-mm-dd
>
> If you feel adventuresome, the following *should* reformat all dates 
> in the file.  Just in case, it will also create a backup of your 
> original.   perl -i.orig -p -e 
> 's/(\d+)(\/)(\d+)(\/)(\d{4})/$5-$1-$3/g' <filename>
>
>
>