MobileRead Forums - View Single Post

Pete69 · 07-02-2013, 01:33 PM

I have a lot of magazine that I try to add to calibre.

This are all in the following way:
MagazineName YYYY-MM.pdf - MyMagazine 2013-07.pdf

I try to set the published date also automaticly, but it dosn't work.

first try:
"C:\Program Files (x86)\Calibre2\ebook-meta.exe" "C:\Users\Documents\Calibre Bibliothek\MyMagazine 2013-07.pdf" --date 2013-07
-> only errors, also with other formats like 2013-06-30 00:00:00

second try:
I set up an ODBC connection to the metadata.db. I can connect to the database and get all the data I want, but when I try to use the SQL update-statement I get a SQL error

third try:
I try to change the information in the metadata.opf. But calibre do not reconize this, cause all the meta-data come from the db and not from the metadata.opf-file

fourth try:
I spend a lot of time on regex. I try to split the filename in title and pubdate. This fails also cause it is difficult to made string operations with regex and I don't find any information if the placeholder "pubdate" is correct to do this

Have anyone an idea to solce this problem?

07-02-2013, 01:33 PM	#1
Pete69 Junior Member Posts: 2 Karma: 10 Join Date: Jul 2013 Device: Kindle	Set pubdate by script I have a lot of magazine that I try to add to calibre. This are all in the following way: MagazineName YYYY-MM.pdf - MyMagazine 2013-07.pdf I try to set the published date also automaticly, but it dosn't work. first try: "C:\Program Files (x86)\Calibre2\ebook-meta.exe" "C:\Users\Documents\Calibre Bibliothek\MyMagazine 2013-07.pdf" --date 2013-07 -> only errors, also with other formats like 2013-06-30 00:00:00 second try: I set up an ODBC connection to the metadata.db. I can connect to the database and get all the data I want, but when I try to use the SQL update-statement I get a SQL error third try: I try to change the information in the metadata.opf. But calibre do not reconize this, cause all the meta-data come from the db and not from the metadata.opf-file fourth try: I spend a lot of time on regex. I try to split the filename in title and pubdate. This fails also cause it is difficult to made string operations with regex and I don't find any information if the placeholder "pubdate" is correct to do this Have anyone an idea to solce this problem?