[OPEN-ILS-DEV] problem regarding bulk imporing

[vijay kumar]

Dear All,
For testing, I have imported import_demo import_marc.xml records.

I have converted a set of marc21 records into marcxml through MarcEdit software.
But I am getting error during bulk import of records.
I am not able to understand the value of    035 field as  you have
mentioned in import_demo file. I assign random value for that.
So what should I assign for  035 marc field?
Is there any alternative tools for converting marc21 file to marcxml
because whatever I have converted there is minor difference with your
sample_marc.xml file like there is repetition of " marc: "

I attached my marcxml and xls file for have a look..
Running of last two command showing  error....

Thank you for in advance,
vijay kumar

(((((((((((((These are my error screenshot))))))))))))))))))

evergreen at test-evergreen:/home/test/Desktop/import_demo$ psql -U
evergreen -f insert_holdings.sql evergreen
psql:insert_holdings.sql:1: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:2: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:3: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:4: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:5: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:6: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:7: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:8: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:9: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:10: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:11: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:12: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:13: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:14: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:15: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:16: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:17: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:18: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:19: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:20: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:21: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:22: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:23: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:24: ERROR:  invalid input syntax for integer: ""
psql:insert_holdings.sql:25: ERROR:  invalid input syntax for integer: ""

evergreen at test-evergreen:/home/test/Desktop/import_demo$ psql -U
evergreen -f generate_copies.sql evergreen
INSERT 0 27
psql:generate_copies.sql:12: ERROR:  duplicate key violates unique
constraint "asset_call_number_label_once_per_lib"
psql:generate_copies.sql:47: ERROR:  duplicate key violates unique
constraint "copy_barcode_key"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sample_marc.xml
Type: text/xml
Size: 90126 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20081029/ce131834/attachment.xml 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: evergreen.xls
Type: application/vnd.ms-excel
Size: 123392 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20081029/ce131834/attachment-0001.xls