Re: [Koha] Excel to MARC - Marcedit 5.8
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+s1045719n571771...@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@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Excel to MARC - Marcedit 5.8
I haven't tried running MarcEdit in Wine. I've been amazed at what Wine will run. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Paul pau...@aandc.org Sent 6/26/2012 9:13:32 AM To: amit bondwal bondwal.a...@gmail.com, koha@lists.katipo.co.nz Subject: Re: [Koha] Excel to MARC - Marcedit 5.8 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+s1045719n571771...@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@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Excel to MARC - Marcedit 5.8
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, koha-requ...@lists.katipo.co.nz 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 stacy.po...@manhattan.edu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Excel to MARC - Marcedit 5.8
Respected All I am trying to convert the data of 5 books ( Marathi, Hindi, English), Marathi Hindi data I have converted to Unicode through Suvidha software. I am using MarcEdit for converting the data from Excel to Marc but facing the following error system.data.oledb.oledbexception (0X80004005): Make sure that it does not include invalid characters I already have deleted the characters like , : ! - . Kindly guide -- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@ email: sandeep.bhav...@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
