Search found 16 matches

by DriverJC
Mon May 29, 2017 7:14 pm
Forum: Support
Topic: Amazon Search for Book/CD/DVD Pedia
Replies: 38
Views: 121447

Amazon Search for Book/CD/DVD Pedia

I'm having an issue with book/CD/DVD pedia in that they will not search Amazon for information any longer. I added my AWS information and it worked great for several years and is now not working. I have added another Secret Key but it still gives me the following error "Your [Access Key] is not...
by DriverJC
Sun Aug 05, 2012 12:06 pm
Forum: Support
Topic: Database Fields
Replies: 1
Views: 2417

Database Fields

I'm having a bit of a problem. In my database I have several Collections that are excluded in the main library. I would like to be able to move items from these collections into the main library with out opening the actual program. Can you tell me what field holds the collection information? and wha...
by DriverJC
Thu May 24, 2012 10:03 am
Forum: Support
Topic: Can DVDpedia tag .m4v files with iTunes meta data?
Replies: 14
Views: 18026

Re: Can DVDpedia tag .m4v files with iTunes meta data?

At the moment I use DVDPedia to provide the Tags for my MP4 Files that I have in my iTunes Library and SublerCLI to write the tags prior to import into iTunes. I use a Bash script to do everything and it will run on every file in the folder selected. I'm pasting my bash script below. This works grea...
by DriverJC
Thu May 24, 2012 9:38 am
Forum: Support
Topic: Modify Database
Replies: 2
Views: 2853

Re: Modify Database

For anyone that is interested in how I accomplished this here it is. For my Movies All movies in iTunes are named in this format. <Series Title> <Series Index>: <Series Subtitle> (for example: Star Trek series of Movies is labeled like this, Star Trek #01: Star Trek The Motion Picture, Star Trek #02...
by DriverJC
Sat May 19, 2012 1:34 pm
Forum: Support
Topic: Modifying iTunes Import
Replies: 1
Views: 2039

Modifying iTunes Import

Is there a way to pull the Encoded With and Grouping fields from the iTunes Library?

I would like to put them in zUPC and zCustom1 respectively

Thank you for a great program
Joel
by DriverJC
Sat May 19, 2012 1:28 pm
Forum: Support
Topic: Modify Database
Replies: 2
Views: 2853

Modify Database

I'm trying to get a handle on my DVDPedia Database. I have imported my iTunes Library File into DVDPedia and now I need to fix the entries. For example My iTunes Library file lists "Batman Returns" as "Batman #02: Batman returns". Is there a way for me to use SQLLIte to search th...
by DriverJC
Fri Dec 23, 2011 12:02 am
Forum: Support
Topic: Changing the Delimiter when dumping the database
Replies: 4
Views: 4664

Re: Changing the Delimiter when dumping the database

Apperently if you change the delimiter in sqlite3 using the .mode command (which I did) it keeps that setting even after closing the program and rebooting the computer. All I have to do now is use the command sqlite3 /Users/joel/Library/Application\ Support/DVDpedia/Database.dvdpd "select * fro...
by DriverJC
Sun Dec 18, 2011 2:35 pm
Forum: Support
Topic: How can I import my collection?
Replies: 2
Views: 3065

Re: How can I import my collection?

Open dvdpedia on your new Mac then close it.
Copy the folder ~/library/application support/Dvdpedia from your old Mac to the new one and place it in ~/library/application support/
Open dvdpedia on new Mac everything should be there.


Joel
by DriverJC
Sun Dec 18, 2011 2:30 pm
Forum: Support
Topic: Changing the Delimiter when dumping the database
Replies: 4
Views: 4664

Re: Changing the Delimiter when dumping the database

Great. How do I go about putting those into a bash script to run when I run the converting script I use?

I've tried replacng the .dump with each of those and can't get it to work.
by DriverJC
Fri Dec 16, 2011 7:16 pm
Forum: Support
Topic: Changing the Delimiter when dumping the database
Replies: 4
Views: 4664

Changing the Delimiter when dumping the database

At present I dump the database with the following script sqlite3 /Users/joel/Library/Application\ Support/DVDpedia/Database.dvdpd '.dump ZENTRY' My question: is there a way to modify this script so that it outputs a "|" as the delimiter for the fields? The problem I'm running into is that ...
by DriverJC
Tue Nov 22, 2011 10:48 am
Forum: Support
Topic: Update Database with sqlite
Replies: 4
Views: 4888

Re: Update Database with sqlite

Thank you that worked great. I love the pedia programs you all put out and can't wait until you get a new release of pocket pedia.

Thanks
Joel
by DriverJC
Fri Nov 18, 2011 11:35 am
Forum: Support
Topic: Update Database with sqlite
Replies: 4
Views: 4888

Re: Update Database with sqlite

Thank you for the script. It worked great. it Turned Title: Mythbusters; Season: 9; Episode: 19 into #919: Location Location Location. with is what I wanted it to do. Unfortuantely it also changed Title: The Secret Circle; Season: 1; episode: 9 into #19: Balcoin. After looking at my prior post I see...
by DriverJC
Fri Nov 11, 2011 10:32 am
Forum: Support
Topic: Update Database with sqlite
Replies: 4
Views: 4888

Update Database with sqlite

I just upgraded to version 5.0 and am liking it so far. I especially like the searching of TVDB for tv show information. That being said, I have a question. I would like to run an update script in sqlite that would take the entries in Title, Season, and Episode and format it into "#<Season><Epi...
by DriverJC
Sun Oct 24, 2010 1:16 pm
Forum: Support
Topic: Looking up TV Show Information
Replies: 2
Views: 2759

Looking up TV Show Information

At present I use DVDPedia on a Daily basis to catalog my collection of Movie and TV Show. The problem I have is that I have to manually check Wikipedia/TVRage/TVDB for the Episode Information i.e Episode Name, Episode Number, Airdate, etc.. Is there any way to get the information downloaded by a Plu...
by DriverJC
Sat Sep 04, 2010 7:27 pm
Forum: Support
Topic: Timstamp fun
Replies: 1
Views: 2086

Timstamp fun

I am working on a way to tag the movies that I convert and put into iTunes. Presently I have to manually export the database to a txt file and query that in bash. this works great and gives me the format of the dates that I want (i.e YYYY-MM-DD). I am able to have sqlite dump the database to a text ...