[Isis-users] Importing winisis records into abcd

[Piet De Keyser]

Dear colleague,

It is best to prepare the database offline, using MX. MX will help you to get rid of the locks too:

The command for that is: retag databasename unlock

("databasename" should of course be replaced with the name of you database)

After that you can defragment and clean the data, using this command

mxcp databasename create newdatabasename clean

Mind you: clean will also deleted preliminary spacing etc.; in case of a MARC structure with indicators it should not be used.

You can also export and import the data in order to fysically delete all deleted records
mx databasename create=newdatabasename -all now

After that you rename the newly created database to the name you want and you reindex:

mx databasename fullinv now -all

After all this you can fysically copy the database onto you ABCD database folder.

Piet de Keyser
Belgium


________________________________
Van: isis-users [isis-users-bounces at iccisis.org] namens bhowa tg [bhowatg at gmail.com]
Verzonden: dinsdag 3 december 2013 15:04
Aan: ISIS Users List
Onderwerp: [Isis-users] Importing winisis records into abcd

Dear Colleagues'

i have a winisis database with a maximum 14200 records.i managed to recreate it in abcd (using create from winisis) with no problems including reconfiguring the fdt, fst. pft etc...

the problem i am encountering is DATA MIGRATION using the export/import function. exporting the whole database or in batches from winisis there is no problem, importing in abcd it gives an error after  3559 records.

to try to resolve this i did the following (winisis database);
1. unlock database
2. unlock records
no errors encountered.

i also noticed that when exporting first 3000 records am getting 2995 records, meaning that the other 5 are logical deleted.

how can i clean my 14 000+ winisis database before importing the MFNs or there is another option.

good day

tg


--

bhowa tg
Infoprenuer, abcdZim.org
bhowatg at gmail.com<mailto:bhowatg at gmail.com>  skypeID:  bhowatg
blog: http://bhowatg.blogspot.com
http://facebook.com/groups/abcdzim/; http://twitter.com/bhowatg
www.abcdZim.co.cc<http://www.abcdZim.co.cc>


"there are two equally dangerous extremes-
to shut reason out and to let nothing else in"
                                     Pascal, 1670


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20131203/36b77c58/attachment.html>