Massive import batch process

[bazu]

Hy Guys,

I need to import 800 books' titles from a csv file. I've developed a routine that read this list and print ino a file (addBooks.py) a list of python commands blocks like the following one:

# coding:utf-8
from calibre.library.database2 import LibraryDatabase2
from calibre.ebooks.metadata import MetaInformation

db      = LibraryDatabase2("G:/dloads/Ebooks")


#BLOCK repeated
m1 = MetaInformation("Memoria delle mie puttane tristi", ["Garcia Marquéz Gabriel"])
m1.tags = ["BlueBook"]
m1.series = "BlueBook(49)"
db.add_books(["C:/fake.doc"], ["doc"], [m1], add_duplicates=True)
#END OF BLOCK repeated

I try to feed Calibre with the following command:

calibre-debug -e c:\addBooks.py

But it fails because of the “é” accent in the author's name:

[...]You must not use 8-bit bytestrings unless you use a text_factory that[ecc.]

If I remove that accent and I add it to the book's title, no errors are presents but the accent in the sqllite db is borken.

How can I solve the problem? Have I other ways to import from my csv list?

Thanks
bazu

[kovidgoyal]

Stick a u before each string

so use:

u"Garcia Marquéz Gabriel"

or safer replace non ascii chars with their unicode code points

u'Garcia Marqu\xe9z Gabriel'

[bazu]

Goog shot Kovid! All works!

Thank you very much