[Isis-users] Importing winisis records into abcd

[De Smet Egbert]

Tg,

if you mean by cleaning :
- getting rid of logically deleted records : use mx to create a copy of the database, automatically the deleted ones will be left out
- getting rid of initial/trailing spaces etc. : use mxcp (in the ABCD-cgi-bin folder) with just the parameter 'clean'; this allows also to use gizmos (strings to be replaced by others in resp. v1 and v2 of a database for that purpose) and split occurrences.

Egbert de Smet
Universiteit Antwerpen
________________________________________
From: isis-users [isis-users-bounces at iccisis.org] on behalf of bhowa tg [bhowatg at gmail.com]
Sent: Tuesday, December 03, 2013 3:04 PM
To: ISIS Users List
Subject: [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