Hi Ian, You are so responsive...it's great!! And yes, I am new. We just finished the upgrade from Unicorn to Symphony (it seems as though we have wasted a lot of money and time but we are getting on track trying to implement Koha (we figure about 1 year). We have two servers with Koha (Lenny with Koha 3.0) one is virtual and one is just a desktop server for testing. We are using the MySQL Migration Toolkit ( https://www.regnow.com/softsell/nph-softsell.cgi?item=5160-30 ). I create a *.dmp file when doing an export from our Unicorn production to test server and have imported the dump file from our Symphony test server to the Koha MySQL using the migration tool. So...we imported the Oracle-Sirsi data into the Koha-MySQL but, now...how do we set it up? I don't get how to create the Koha db and what formats to apply. We did not the test db on the virtual Koha...do you recommend doing it? How about the tools that you are describing? Do you have any information on how to do this from SD to Koha given our setup? Man, any onformation you can give I would greatly apprecaite. We are wanting to be rid of SD within the year.. To get the bibliographic, item and user/borrower data you will be far better off using the SirsiDynix (is it Unicorn/Symphony?) tools to get the data out. If you have command-line access to your old system this will include using selcatalog, catalogdump and seluser with dumpflatuser. Then they will need a bit of manipulation to get into the format expected by Koha for importing bibliographic, item and borrower data. If you plan to take lots of datasets across then extracting from Oracle and into Mysql sounds like a good bet. I won't go into the detail of those commands here but do come back if you have any specific questions. Good luck. Ian Todd L. Goatley DCAS Washoe County Library - Spanish Springs 7100A Pyramid Lake Highway Sparks, NV 89436 Email: tgoatley@washoecounty.us W: 775-424-1843 C: 775-771-3489
HI Ian, I have found in Librarything.com how to use the selcatalog: --To get the data in tab-delimited format, run the following command from the UNIX command line. selcatalog -iC -oe -e020,245,100 > ISBN_extract.out -e020,245,100 selects the fields which are extracted to file; 020 = ISBN, 245 = Title, 100 = author Still having a an issue finding the other bits you spoke of (catalogdump and seluser with dumpflatuser) I am not finding anything on this. Can you please assist? Links to sites? Anything? Regard, Todd Goatley tgoatley wrote:
Hi Ian, You are so responsive...it's great!! And yes, I am new. We just finished the upgrade from Unicorn to Symphony (it seems as though we have wasted a lot of money and time but we are getting on track trying to implement Koha (we figure about 1 year). We have two servers with Koha (Lenny with Koha 3.0) one is virtual and one is just a desktop server for testing. We are using the MySQL Migration Toolkit ( https://www.regnow.com/softsell/nph-softsell.cgi?item=5160-30 ). I create a *.dmp file when doing an export from our Unicorn production to test server and have imported the dump file from our Symphony test server to the Koha MySQL using the migration tool. So...we imported the Oracle-Sirsi data into the Koha-MySQL but, now...how do we set it up? I don't get how to create the Koha db and what formats to apply. We did not the test db on the virtual Koha...do you recommend doing it? How about the tools that you are describing? Do you have any information on how to do this from SD to Koha given our setup? Man, any onformation you can give I would greatly apprecaite. We are wanting to be rid of SD within the year..
To get the bibliographic, item and user/borrower data you will be far better off using the SirsiDynix (is it Unicorn/Symphony?) tools to get the data out. If you have command-line access to your old system this will include using selcatalog, catalogdump and seluser with dumpflatuser. Then they will need a bit of manipulation to get into the format expected by Koha for importing bibliographic, item and borrower data.
If you plan to take lots of datasets across then extracting from Oracle and into Mysql sounds like a good bet.
I won't go into the detail of those commands here but do come back if you have any specific questions.
Good luck.
Ian
Todd L. Goatley DCAS Washoe County Library - Spanish Springs 7100A Pyramid Lake Highway Sparks, NV 89436 Email: tgoatley@washoecounty.us W: 775-424-1843 C: 775-771-3489 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Regarding-the-Oracle-MySQl-data-import.-Thanks.-HELP%2... Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hi Todd, On reflection I think you need to see if you can get someone to help with your migration from Unicorn/Symphony. The database toolkit you mention below might be OK for migrating your own private database from Oracle to Mysql but the Unicorn database tables and fields are completely different from the Koha ones. So I don't think there is much point in trying to migrate that way. The selcatalog options you found below are just specific options to get particular MARC fields for a particular record. I think you need to sit down with someone who understands getting data out of Unicorn and who understands getting data into Koha. Good candidates might be on the "pay for support" pages or perhaps one of the upcoming Koha enthusiasts that is more likely to also have recent advanced Unicorn experience such as Jane Wagner (who recently posted). I am happy to continue this discussion off-list but I think getting help from someone close to your timezone would be your best bet. Good luck for now. Ian. ----- Original Message ----- From: "tgoatley" <TGoatley@washoecounty.us> To: <koha@lists.katipo.co.nz> Sent: Tuesday, March 03, 2009 12:01 AM Subject: Re: [Koha] Re garding the Oracle/MySQl data import. Thanks. HELP!!
HI Ian, I have found in Librarything.com how to use the selcatalog:
--To get the data in tab-delimited format, run the following command from the UNIX command line. selcatalog -iC -oe -e020,245,100 > ISBN_extract.out -e020,245,100 selects the fields which are extracted to file; 020 = ISBN, 245 = Title, 100 = author
Still having a an issue finding the other bits you spoke of (catalogdump and seluser with dumpflatuser) I am not finding anything on this. Can you please assist? Links to sites? Anything?
Regard, Todd Goatley
tgoatley wrote:
Hi Ian, You are so responsive...it's great!! And yes, I am new. We just finished the upgrade from Unicorn to Symphony (it seems as though we have wasted a lot of money and time but we are getting on track trying to implement Koha (we figure about 1 year). We have two servers with Koha (Lenny with Koha 3.0) one is virtual and one is just a desktop server for testing. We are using the MySQL Migration Toolkit ( https://www.regnow.com/softsell/nph-softsell.cgi?item=5160-30 ). I create a *.dmp file when doing an export from our Unicorn production to test server and have imported the dump file from our Symphony test server to the Koha MySQL using the migration tool. So...we imported the Oracle-Sirsi data into the Koha-MySQL but, now...how do we set it up? I don't get how to create the Koha db and what formats to apply. We did not the test db on the virtual Koha...do you recommend doing it? How about the tools that you are describing? Do you have any information on how to do this from SD to Koha given our setup? Man, any onformation you can give I would greatly apprecaite. We are wanting to be rid of SD within the year..
To get the bibliographic, item and user/borrower data you will be far better off using the SirsiDynix (is it Unicorn/Symphony?) tools to get the data out. If you have command-line access to your old system this will include using selcatalog, catalogdump and seluser with dumpflatuser. Then they will need a bit of manipulation to get into the format expected by Koha for importing bibliographic, item and borrower data.
If you plan to take lots of datasets across then extracting from Oracle and into Mysql sounds like a good bet.
I won't go into the detail of those commands here but do come back if you have any specific questions.
Good luck.
Ian
Todd L. Goatley DCAS Washoe County Library - Spanish Springs 7100A Pyramid Lake Highway Sparks, NV 89436 Email: tgoatley@washoecounty.us W: 775-424-1843 C: 775-771-3489 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Regarding-the-Oracle-MySQl-data-import.-Thanks.-HELP%2... Sent from the Koha - Discuss mailing list archive at Nabble.com.
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-------------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.11.6/1981 - Release Date: 03/03/09 07:25:00
participants (3)
-
Goatley, Todd -
Ian Bays -
tgoatley