[Koha] Exporting Excel data to MarcEdit to Koha help request
Indranil Das Gupta
indradg at gmail.com
Fri Mar 2 02:01:03 NZDT 2018
Hi Matt,
On Thu, Mar 1, 2018 at 6:18 PM, Matt Rose <library at halswaymanor.org.uk> wrote:
> Hi folks,
>
>
> I have spent many weeks attempting to install a Virtual Mac on my PC so that I can run Koha. Koha finally works but I find I can't export my data via MarcEdit. Any suggestions would be most appreciated.
Hope you are using the latest version of MarcEdit.
Call it a personal preference, but I like working with a TSV (tab
separated value) file exported from the spreadsheet when passing it to
MarcEdit.
> It does not like my Excel Sheet Name. I am following this guide: Importing Excel data into Koha:
>
> http://manual.koha-community.org/3.2/en/marceditexcel.html
>
> On page three, when I enter into Excel Sheet Name box: libsys (or any name for my .xls file) I get a long error message that says: "System.Data.OleDbException (0x80004005): $ is not a valid name. Make sure that it does not include invalid characters or punctuation and that is it not too long." etc
IIRC, the sheetname is the *actual* name you gave to the sheet from
which among others in your XLS file that MarcEdit is supposed to read
from.
By using a CSV or TSV file, I simply avoid that sheet part in most cases.
hope that helps
Indranil Das Gupta
L2C2 Technologies
More information about the Koha
mailing list