[OPEN-ILS-DEV] import_demo question

[Nella Lall]

Thanks for the answer Dan.

That is good news.  I have finally got the xml file to work properly in 
step 6.  (I had to strip out some nasty 880 tags in our old records 
before everything worked.)  Now, I moved through step 6 and 7 perfectly 
and then bombed out on step 8.

evergreen-admin at eg-server:~/import_demo$ psql -U evergreen -f 
insert_holdings.sql evergreen 2> insert_holdings.errapr29
Password for user evergreen:
BEGIN
ROLLBACK

evergreen-admin at eg-server:~/import_demo$ more insert_holdings.errapr29
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.  Out of range?  Too old??  I'm beginning 
to feel too old myself but really, 1993 was not that long ago. :-)

Thanks,
Nella


Dan Scott wrote:
> 2008/4/28 Nella Lall <ndlall at ucalgary.ca>:
>   
>> Dan and anyone else who might know,
>>
>>  I was doing the import_demo you have posted and got through steps 5 without
>> error.  I was using my own sample of 1000 MARC21XML/UTF-8 (or so I thought)
>> records instead of your provided sample of 500 records.  When I got to step
>> 6 I received this error:
>>
>>  :61: parser error : Input is not proper UTF-8, indicate encoding !
>>  Bytes: 0xE6 0x69 0x3C 0x2F
>>  .....
>>
>>
>>  Anyway, I realized that somewhere in my attempt to go from our Unicorn
>> Marc21/Marc8 format records to the required MARC21XML/UTF8 records (via
>> MarcEdit), things did not go 100% correctly.
>>
>>  So, my question is:
>>
>>  -can I begin the import_demo steps back at step one with your provided 500
>> record sample (or any other record sample for that matter) without having to
>> do any cleanup of tables for the failed/partial load of my 1000 records?
>>     
>
> Hi Nella:
>
> Sorry for the delay in responding, but I have some good news... Step 6
> is running parse_holdings.pl, which just generates a SQL file of
> INSERT statements (insert_holdings.sql). You don't actually run that
> file until step 8, so you can fix up your MARC records and run step 6
> as many times as you like without having to clean up any tables.
>
>