[Koha] Re garding the Oracle/MySQl data import. Thanks. HELP!!

[tgoatley]

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 at washoecounty.us
> W: 775-424-1843
> C: 775-771-3489
> _______________________________________________
> Koha mailing list
> Koha at 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%21%21-tp22214734p22299834.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.