Quote:
Originally Posted by itimpi
if the output of the calibredb command has the information you want, then I would have thought it was much easier to load the csv file into the spreadsheet and manipulate it from there? A bit of VBA (rather than a recorded macro) could trivially re-arrange columns, apply formatting etc. That would avoid the need to construct complex ODBC queries (as well as the problem of getting the ODBC driver to work in the first place).
|
Yes, calibredb list command does have the info I want and VB would certainly be easier for me to work with. Earlier I hadn't realized how complex it would be to get the right ODBC driver. Or that I'd have to build the driver from source - since I'm new to development in OS X and rusty in unix, I'd need a lot of help. So i'll probably crash and burn on the ODBC driver build. But wouldn't it be whimp-ish to to give up on ODBC/SQL method at this point? Wouldn't it be nice to say to calibre users (particularly power users working with huge datasets) who might want or need it: there is this capabilty to work the SQL thing, and here is how to do it?