[Koha] Excel to MARC - Marcedit 5.8

[Paul]

At 05:44 AM 6/26/2012 -0700, amit bondwal wrote:
>HI Sandeep,
>I don't know much about it, but may be this can help, Is your excel
>sheet have three sheets?  then delete the two extra empty sheets in that 
>file and save as the file in text(tab delieted) format.
>marc edit support more text(tab delimeted) format.
>Then try to convert by marc edit in text delimated in addins.

A couple of years ago we tried to use Office97 (we've never had a more 
recent version) to do just that -- but ended up using 
OpenOffice|LibreOffice to open and save the Excel files as tab-delimited 
.csv files. Excel appeared to have difficulties with UTF8 and special 
characters.

Disclaimer:  Terry Reece has done an apparently marvelous job developing 
MarcEdit; we've never been able to run recent versions as our old Windows 
laptop is more of a museum exhibit than a useful tool.  I would strongly 
suggest joining the list at <http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L>.

As an aside, has anyone managed to get MarcEdit to function on a Linux 
box?  We have failed miserably.

Best - Paul


>Regards
>Amit Bondwal
>
>
>On Tue, Jun 26, 2012 at 1:40 AM, Stacy Pober [via Koha]
><ml-node+s1045719n5717713h8 at n5.nabble.com> wrote:
> > There's an excellent support list for MARCEDIT called MARCEDIT-L. Â Terry
> > Reese, the author of the program monitors the list, and he will often offer
> > solutions along with some of the other list subscribers.
> >
> > http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L
> >
> > It's also a good way to give input on features you'd like to see or to find
> > out whether someone already has solved a particular problem you're having.
> >
> > Stacy
> >
> > On Mon, Jun 25, 2012 at 9:18 AM, <[hidden email]> wrote:
> >
> >> As marcedit is proprietary software, unfortunately the only person who
> >> is likely to be able to help is the marcedit author, unless someone else
> >> has seen and solved it before.
> >>
> >
> >
> >
> > --
> > Stacy Pober
> > Information Alchemist
> > Riverdale, NY 10471
> > [hidden email]
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > [hidden email]
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> > ________________________________
> > If you reply to this email, your message will be added to the discussion
> > below:
> > 
> http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717713.html
> > To unsubscribe from Koha, click here.
> > NAML
>
>
>--
>View this message in context: 
>http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717757.html
>Sent from the Koha-general mailing list archive at Nabble.com.
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>