goiken
About
- Username
- goiken
- Joined
- Roles
- Member
Comments
-
OS=Ubuntu 11.04 Disabling (& re-enabling) addons did the Job. Thx. then
-
Thank you so much! This is the winning candidate for the particular problem, in case anybody else's looking for it. (again I had to comment the "ia.linkMode=1". wouldn't give me output if i don't) echo 'SELECT /* Any fields that we use to buld the…
-
From this output I can figure that the title-ID is "110". But I can't find any authors in this output. How do i make the SQL-query if I know the IDs?
-
I want to include this script in a piece, that syncs external devices for me. (Reader, phone) Hence I need Copies instead of sym-links. Can you tell me how I get the author and the title from an Item out of the database?
-
I got the copy-part and I think I know how I would change the target path, but I have still no Idea how I get the "author" and the "title" from the database.
-
If I change the script to my $sth = $dbh->prepare('SELECT idv1.value, idv2.value, i2.key, ia.path FROM itemDataValues idv1, itemDataValues idv2, itemData id1, itemData id2, items i, items i2, itemAttachments ia WHERE i.itemID=id1.itemID AND i.it…
-
I think I found the place, where it hangs up: This works: echo 'SELECT idv1.value, idv2.value, i2.key, ia.path FROM itemDataValues idv1, itemDataValues idv2, itemData id1, itemData id2, items i, items i2, itemAttachments ia WHERE i.itemID=id1.itemI…
-
When I disable the add on, I can execute the first three sql-queries and i get output that looks like this: Zotero Quick Start Guide|Zotero Quick Start Guide|ABCD2345|storage:1279666769962.pdf Zotero Quick Start Guide|Zotero Quick Start Guide|ABCD23…
-
My first time using SQL. I can only gues what the querry actually means ;-). The first statement gives me this: $ echo 'SELECT idv1.value, idv2.value, i2.key, ia.path FROM itemDataValues idv1, itemDataValues idv2, itemData id1, itemData id2, items…
-
No. I get no output with both the command line sqlite and with the perl script. The additional ';' doesn't help either. I'm on Ubuntu 11.04, using FF 3.6.13 and zotero 2.09, if that helps…
-
When I do this i get: The program 'sqlite3' is currently not installed. I installed "sqlite" when I was setting up the script. After I install sqlite3 it executes without errors. When I then go on & run the full script again, I get: problem …
-
Nice. This seems to be what I was looking for. But I can't really get it to work for me. When i run: #!/usr/bin/perl use DBI; my $zoterostorage="/home/goiken/.mozilla/firefox/f20c4v0e.default/zotero"; my $target="/home/goiken/Dropbox/lib"; my $db…