DATA Migration

Precautions during Bulk Data Import (Data Migration)

Value in Every Marc Code must give during bulk import (i.e., auto values for 952 call #must be given in MARC file, because during bulk import, koha auto fields do not import data automatically. But during manual data entry, auto fields automatically fetch the data. )

SAVE AS excel sheet (urdu data) in UNICODE TEXT.TXT extension , it will help to secure the urdu font/words from breaking… Sometime urdu data in excel fail to work through Unicode , (in such condition don’t save excel file in Unicode) and just save in excel format…

ڈیٹا والی ایکسل کی شیٹ کو سیو ایز کر کے یونی کوڈ ٹیکسٹ میں محفوظ کریں ایسے کرنے سے اردو کے الفاظ ڈوٹتے نہیں۔

Sub fields of Same Marc Record should be MERGE in EditMARC Software before migration.

Click on UTF8 in MarcEdit (For Urdu Bibliography Material to Import in KOHA)

After migration if some data missing in any record i.e., “barcode in item” then search barcode, after result displace, click on barcode, and then click on Edit item below the barcode number (not at EDIT button and edit item)

اردو کے کٹر نمبر کے درمیان فاصلے ختم کر کے ڈیٹا ایمپورٹ کرنا پڑے گا۔ اس کے لئے کنٹرول ایچ اور پھر سپیس کو لکھیں۔۔ اور سب کو تبدیل کر دیں۔

How deal with multiple copies during import / migration - If any record have more than one copy, then create new column(s) in excel sheet (as many column as many copies want to enter) for new copy (accession) and enter data of copy (type, section, access) in same row (to which we want to create copy). But Give a different Header name (MARC Tag) for copy (column) i.e., 953 or 954 or 955 (instead of 952) otherwise MARCEdit Software will not accept 952 for copies. MARCEdit accept only one different tags. After working in MARCEdit (then change/replace all columns name of COPIES into 952 again) then import into KOHA.

Import in WHICH FRAMEWORK also very import

Date Format (must be change before import data. It should be dd-mm-yyyy) (Date format can be changed through System preferences / I18N/L10N preferences) --- TimeFormat should also be correct in this.      

MARC tags are in sensitive case, must be careful when assigning mark (should be in small alphabets i.e., 260$b (correct) but 260$B (wrong)

 

EXCEL FILE (Data move from MLIMS to KOHA)

MFN column not required

Assign MARC code to all fields

Create New Column for Barcode (Accession+Section+67)

Separate file for English & Urdu (based on Language)

Separate file for Single accessions (to create Barcode)

Separate separate files for double, triple and more accession

Author Mark (remove Spaces) (for proper printing of spine)

New Column for Call # (Location + Classification # + Cutter + Accession)

300$a (combination of 300a, 300b & 300c) Physical Description (it combine because at many places data is not in its proper cells)

Separate file for Blank Accessions

Remove ; (but not from accession, section, location, type, classification, author mar, title, author)

Remove NULL and NA (but not from accession, section, location, type, classification, author mar, title, author)

Misc Deletion 01 + 03

227 Data deleted (Gift) because all gift books shifted into other sections… But duplicate still available in Gift.

Steps to convert Excel through MarcEdit

Data in Excel Sheet (must be scanned very carefully before any further step, and gather columns arranged according to same tag).

·         کالم کے ڈیٹا کو اکٹھا کرنے کے لئے مندرجہ ذیل فارمولے استعمال کیے جا سکتے ہیں۔

=A2&B2&C2&D2 ... etc.

=CONCAT(A2,B2,C2,D2) ... etc.

=A2&" "&B2

ایکسل شیٹ میں ڈیٹا کو اچھی طرح سکین اور چیک کر لیں اور ایک قسم کے ٹیگ کو اکٹھا کر لیں

Open MarcEdit Software

Click at EXPORT TAB DELIMITED TEXT

SOURCE FILE (field) excel file location (click on all files)

OUTPUT FILE (field) give name and location where we want to save the MRK File.

Click at UFT-8 Encoded (It’s for Urdu) and then click at Edit LDR/008 and Click LDR (Specify Material) and then click dtropdown of 008 type t at start and give space space space space (4spaces) OK.

t (t mean publication & copyright date)

IMPORT FILE

Tag MAPPING process/ AUTO GENERATE (for auto mapping)

IGNORE header row

FINISH (mrk file ready)

OPEN MRK FILE in MarcEdit software

Click File / Compile file into MARC

MRC file is ready for upload…

 

 

After import/uploading data/file run this command

Rebuild Zebra Index (http://kohageek.blogspot.com/2016/12/import-marc-records-into-koha.html)

sudo su

koha-rebuild-zebra -v -f library

 

If Manage staged MARC records stuck (error - stop) on 0 (zero) then run

sudo apt update

sudo apt upgrade                       اس کو نہیں چلانا

جب ڈیٹا اپ لاڈ کر رہے ہوں۔ تب ساتھ اوپر والی کمانڈ چلادیں تو ڈیٹا شفٹ رکتا نہیں۔ اور پہلے ریکارڈ فائل ایم آر سی کا جو نام ہو۔۔ ۔اگلی دفعہ مزید ڈیٹا اپ لاٹ کرتے وقت فائل کا نام تبدیل کردینے سے بھی ریکارڈ جلد اپ لاٹ ہو جاتا ہے۔  اور اگرامپیورٹ ڈیٹا نہ ہورہا ہو تو مارک فائل میں کوئی مسلہ ہوتا ہے۔۔۔ لائبریری والا 952 کا کالم ضرور چیک کیا جائے۔ اگر پرمانینٹ لائبریری اور موجودہ لائبریری کا نام غلط لکھ دیا جائے تو بھی مارک فائل اپ لاٹ رک جاتی ہے۔