Conversion from Excel into Aleph sequential
Tags: basic
, conversion
, loading_records
, aleph_sequential
, aleph
Last Updated: Oct 30, 2009 00:48
- Description
Libraries must sometimes load records that are not available to them in a bibliographic format standard (Marc21, Unimarc...): integration of the book database of an academic research center, list of new e-journals bought by the library... This can make the conversion procedure of the data to the Aleph sequential format quite hard. Sometimes the records are only available in Excel. There is a way to convert easily in a few steps an Excel file into Aleph sequential in order to load records with manage-18. The strength of that method is that no extra programming is needed! Moreover, a basic knowledge of Excel is enough to understand and use that method.
- Author: François Renaville
- Additional author(s): Paul Thirion
- Institution: Université de Liege
University of Lièges Libraries - Year: 2009
- License: BSD style
- Short description: Use, modification and distribution of the code are permitted provided the copyright notice, list of conditions and disclaimer appear in all related material.
- Link to terms: [Detailed license terms]
- Skill required for using this code:
Basic.
State
Stable
Programming language
None
Software requirements
MS Excel or OpenOffice Calc.
Download
The procedure is described in files "poster_igelu2009.pdf" and/or "poster_igelu2009.pptx", both to be downloaded from http://hdl.handle.net/2268/19944.
TO DO list
After the conversion, 'tab_fix', 'fix_doc_do_file_08' or other scripts have to be used to correct or complete the data.