[Evergreen-catalogers] Importing Bib Records/Authorities through MARC Batch Import/Export: File type question (.db, .dat?)

[Mark Cooper]

Hi Alex,

Did you happen to read Galen's reply? The basic idea is to not use the Connexion save file directly with Evergreen. Instead you want to 'export' records from Connexion.

It's been a while since I last used Connexion but here's what I recall:

1. There are local save files you can setup -- these are the .db files you are referring to. They store groups of records in the db format Galen mentioned on your computer for easy access. These are really for use just with Connexion.

2. Either directly while searching, or when using a local save file, from within Connexion there is an option to 'Export' records (F5 shortcut ???). What happens on export is configurable (under options somewhere), but what you want to do is setup the exports to go to a file. Then when you export it will ask to overwrite the file or append to it, with the record(s) you've selected. This export file (which will contain nothing but marc records) can be imported into Evergreen.

3. If you really want to open the Connexion file in MarcEdit make sure you compile the records into marc afterwards (using the editor -- which will create actual marc records, not marc text representations, which I think is the default if you just 'save'), creating a file that can be imported into Evergreen. It's been a really long time since I've looked into that feature of MarcEdit however ...

Regards,

Mark Cooper
Open Source Software Coordinator
Sonoma County Library
Santa Rosa, CA
mcooper at sonoma.lib.ca.us
707-545-0831 x1521

On Apr 23, 2013, at 2:31 PM, "Kent, Alexander D" <alexander.kent at mnsu.edu> wrote:

> What’s the best way to import the .db files from Connexion Client to Evergreen?  Does anyone have documentation on this? I’m having some issues with the MarcEdit program (5.9) and getting it to save the .db as .mrc, not sure what I’m doing wrong.  Thanks. 
>  
> Alex Kent
> Cataloging and Metadata Support and Training Specialist, PALS
> Email: alex.kent at mnsu.edu
> Phone (work): 507-389-1813
>  
> From: evergreen-catalogers-bounces at list.evergreen-ils.org [mailto:evergreen-catalogers-bounces at list.evergreen-ils.org] On Behalf OfMark Cooper
> Sent: Friday, April 19, 2013 4:20 PM
> To: Evergreen Community Catalogers
> Subject: Re: [Evergreen-catalogers] Importing Bib Records/Authorities through MARC Batch Import/Export: File type question (.db, .dat?)
>  
> Hi Alex,
>  
> With files in general it doesn't matter what the extension is really, it's all about what's in it. Those .db files from Connexion really are database files. Aside from reading them in Connexion you can also use MarcEdit (I believe) to open them up and get the records. Evergreen, as you've found will not read and import from them.
>  
> Evergreen at the very least supports marc and marcxml for import. Doesn't matter what the files are called, or even what the extension is (.mrc, .dat, .xml, .wooh etc.), so long as you really have marc records in a compatible format in the file.
>  
> Mark Cooper
> Open Source Software Coordinator
> Sonoma County Library
>  
> 
> On Fri, Apr 19, 2013 at 1:58 PM, Kent, Alexander D <alexander.kent at mnsu.edu> wrote:
>  
> Do bibliographic records or authority records being imported into Evergreen with the MARC Batch Import/Export need to be a certain file type?
> Using both 2.3.3 and 2.3.5 I’ve noticed that if I use a .db (Data Base File, from OCLC Connex) that the records in that file do not seem to get imported.   A screenshot: 
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
> 
> Then I click Upload, and it quickly takes me to the next screen, where it’s clear (I think…) nothing has been imported:
> Is this a bug? Is Evergreen not able to import .db files from OCLC Connexion?   Has anyone else run into this?  Am I doing something wrong here, maybe in how I’m exporting from OCLC Connexion?
>  
> Importing works fine when I use the .dat files:
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
>  
> 
> I’ve also attached both .dat files and .db files to the email, if you get a chance to test them please let me know! 
> Thanks!
>  
>  
> Alex Kent
> Cataloging and Metadata Support and Training Specialist, PALS
> Email: alex.kent at mnsu.edu
> Phone (work): 507-389-1813
>  
> 
> _______________________________________________
> Evergreen-catalogers mailing list
> Evergreen-catalogers at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
> 
>  
> _______________________________________________
> Evergreen-catalogers mailing list
> Evergreen-catalogers at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-catalogers/attachments/20130423/8b6d1d04/attachment.html>