Hi Ah Win, On Tue 29 May, 2018, 9:47 PM Ah Win, <ahwin2006@gmail.com> wrote: We are using one very simple software using MS Access for our school
libraries in Myanmar and now we would like to use Koha integrated system. We would like to import our bibliographic data into Koha and now we are testing.
Being an MS Access based system it will be easy to export it out as a spreadsheet. However that's where usually the fun begins :-) the first thing to identify is whether all your data is in Latin script (i.e. english) OR if your data also includes data in Burmese script. And if any data in Burmese script - is it Unicode (UTF-8) or does it involve any ASCII font replacement hacks for rendering it. Next is to clean up the data, perform de-duplication of the items (holdings data) and link them to unique bibliographic records. Now if your old aoftware had uawd any internal unique key for linking the tables, you can use this key as your de-duplication key OR if all your records have ISBN that is also a good dedup key to use. And while you do all that, you will be required to map your data into proper marc21 fields as most legacy software are unlikely to be marc compliant. This is a *crucial* step, where your librarian skills along with IT skills will get tested the maximum. Once you have de-duplicated the data, you have to add to the holdings information like item-level-type, branch codes and also biblio level itemtype to the biblio records. Your next stop will be the MarcEdit software where you will need to generate the unique biblio records marc file as well as the holdings marc file. And finally if everything goes ok you will have to merge them to get a new marc file. This is the file that you will import into Koha. Word of advice if your final marc file is over 1000 Bibliographic records, it will be helpful if you use MarcEdit to split it up into multiple files of 1000 records each. Koha will have an easy time ingesting a 1000 records file at a time, rather than one with say 25,000 records. That's basically the story of any legacy migration from a non-MARC21 dataset. Cheers Indranil.
Thank you again for your suggestion.
Best regards, Ah Win
Ah Win
Vice-President (1) Myanmar Library Association
On 29 May 2018 at 11:07, Father Vlasie <fv@spots.school> wrote:
Dear Ah Win,
The SQL examples from this page: https://wiki.koha-community.org/wiki/SQL_Reports_Library
Can be copied and pasted into the custom SQL reports in Home › Reports (your-koha-install/cgi-bin/koha/reports/reports-home.pl)
1) Copy the SQL from the sample
2) On the Reports page choose + Create from SQL
3) Enter a name for the report
4) Paste in the sample in the SQL box and click Save.
5) Click Saved Reports in the left hand column
6) Click Run on the report you would like.
Let us know if it works.
Father Vlasie
St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. <https://maps.google.com/?q=510+Collier+Way,+Etna,+CA+96027,+U.S.A.&entry=gmail&source=g>
Website: www.spots.school
On 28 May 2018, at 20:29, Ah Win <ahwin2006@gmail.com> wrote:
Dear Indranil,
I am new to the list and librarian from Myanmar.
Please help me the way if we are not handy with SQL. For both import and export, please.
Many thanks. Ah Win
On 27 May 2018 at 03:37, Indranil Das Gupta <indradg@gmail.com> wrote:
On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv@spots.school> wrote:
Hello everyone,
Is there an easy way to export a list of all items in a Koha database?
If you are handy with SQL, take a look at https://wiki.koha-community.org/wiki/SQL_Reports_Library
Particularly at the section Bibliographic / Catalogue reports.
TIA FV _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha