[ antp.be > Forum ]

[ FAQFAQ - SearchSearch - MemberlistMemberlist - UsergroupsUsergroups - ]

[ RegisterRegister - ProfileProfile - Log in to check your private messagesLog in to check your private messages - Log inLog in ]


Yet Another "Ant Music Catalog" (MP3)
Goto page Previous  1, 2, 3  Next
 
Post new topic   Reply to topic    www.antp.be Forum Index -> Ant Movie Catalog > Mods
Author Message
pollewops
PostPosted: 2007-09-04 20:30:58    Post subject: Reply with quote
View user's profile Send private message Hi Sracer....I found an issue which I think can be solved easily...

When you do an export to SQL from the Music database, then the output can't be imported within SQL since there are all duplicate fileds in there. Could you change this in the language file, so that every field (also if not used) is unique.

Below a dump of my music.sql file:
Code:
DROP TABLE IF EXISTS music;
CREATE TABLE music (NUM INT NOT NULL, CHECKED TEXT, MEDIA TEXT, MEDIATYPE TEXT, SOURCE TEXT, DATEADD DATE, BORROWER TEXT, RATING FLOAT, ORIGINALTITLE TEXT, TRANSLATEDTITLE TEXT, FORMATTEDTITLE TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, CATEGORY TEXT, YEAR INT, LENGTH INT, ACTORS TEXT, URL TEXT, DIRECTOR TEXT, COMMENTS TEXT, DIRECTOR TEXT, VIDEOBITRATE INT, AUDIOFORMAT TEXT, AUDIOBITRATE INT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, PICTURENAME TEXT, PRIMARY KEY (NUM));
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('1', 'True', 'Dire Straits - Alchemy: Dire Straits Live', 'CD', '', '2007-08-28', '', '6.0', 'Alchemy: Dire Straits Live', 'Dire Straits', 'Alchemy: Dire Straits Live (Dire Straits)', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Rock', '1984', '94', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:difoxqr5ldfe', 'Warner Bros.', 'Review by William Ruhlmann\nThere is an interesting contrast on this 94-minute double-disc live album (recorded at London''s Hammersmith Odeon in July 1983) between the music, much of which is slow and moody, with Mark Knopfler''s muttered vocals and large helpings of his fingerpicking on what sounds like an amplified Spanish guitar, and the audience response. The arena-size crowd cheers wildly, and claps and sings along when given half a chance, as though each song were an up-tempo rocker. When they do have a song of even medium speed, such as "Sultans of Swing" or "Solid Rock," they are in ecstasy. That Dire Straits'' introspective music loses much of its detail in a live setting matters less than that it gains presence and a sense of anticipation. Alan Clark''s keyboards help to fill out the sound and give Knopfler''s spare melodies a certain majesty, but Dire Straits remains an overgrown bar band with a Bob Dylan fixation, and that''s exactly how the crowd likes it. (The CD version of the album contains one extra track, "Expresso Love," which adds a needed change of pace to the otherwise slow-moving first disc).', 'Warner Bros.', '1', 'Achat', '', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'music_1.jpg');
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('2', 'True', 'Marillion - Season''s End', 'JewelCase', 'England', '2007-09-04', '', '9.0', 'Season''s End', 'Marillion', 'Season''s End (Marillion)', 'Never', 'Never', 'Never', 'Rock', '1989', '99', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:g9frxqq5ld0e', 'Never', 'Review by Jeri Montesano\nAfter Fish''s departure, Marillion teetered on the brink of collapse: The frontman''s distinct voice and poetic prose made him the defining member of the band. One can only imagine how record executives held their collective breath as Steve Hogarth was brought in to take the reins. His first outing with band, 1989''s Season''s End, removed all doubts about the band''s future. Hogarth''s unique, expressive voice fit Marillion perfectly; on the full-throttle rock assault of "The Uninvited Guest" or the emotional "After You," Hogarth''s singularity is unmistakable. The heartfelt "Easter," with its imaginative electric-acoustic arrangement, is another showcase for Hogarth''s talents. Marillion''s ability to write music whose ideals live and breathe in the listener continues on Seasons End, particularly on the inspiring "Holloway Girl," which dissects the injustice of incarcerating mentally ill female inmates (at England''s Holloway Prison) instead of placing them in appropriate psychiatric facilities. The beautiful "Easter" is the band''s plea for peace in Ireland, while "The King of Sunset Town" has its lyrical roots in the massacre at Tiananmen Square. Hogarth''s flexible range and beautiful phrasing shine on the entire album. In 1999 Marillion released a remastered version of Seasons End, including a bonus disc of outtakes and alternate versions as well as the previously unreleased "The Bell in the Sea" and "The Release." Both are strong tracks and are welcome additions to the Marillion catalog. While 1995''s Afraid of Sunlight is the peak of Marillion''s growing, impressive body of work, Season''s End shouldn''t be missed either.', 'Never', '1', 'Achat', '', 'Never', 'Never', 'Never', 'Never', 'Never', 'Never', 'music_2.jpg');
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('3', 'True', 'Marillion - Brave', 'CD', 'England', '2007-09-04', '', '6.0', 'Brave', 'Marillion', 'Brave (Marillion)', 'IRS', 'IRS', 'IRS', 'Rock', '1994', '71', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:gjfrxqqgldse', 'IRS', 'Review by Dale Jensen\nRebounding from the inconsistent Holidays in Eden, Marillion retreated to the studio for 15 months to write and record the concept album Brave. Telling the story of an abused girl wandering on Severn Bridge, the album is a solid mix of symphonic tracks with a pronounced rock edge. A band known for trilogies, the final set of "The Great Escape," "The Last of You," and "Falling From the Moon" form one of the most dynamic showcases for vocalist Steve Hogarth and guitarist Steve Rothery. Brave remains the most complex Marillion release to date, with layers and layers of sound. A full-length movie of Brave, directed by Richard Stanley, was released in Europe in conjunction with the album.', 'IRS', '1', 'Achat', '', 'IRS', 'IRS', 'IRS', 'IRS', 'IRS', 'IRS', 'music_3.gif');
sracer
PostPosted: 2007-09-04 21:31:58    Post subject: Reply with quote
View user's profile Send private message I'll be happy to make the changes once I find out which ones they are. lol
pollewops
PostPosted: 2007-09-05 08:15:41    Post subject: Reply with quote
View user's profile Send private message
sracer wrote:
I'll be happy to make the changes once I find out which ones they are. lol


Hi Sracer,

Easy....it has something to do with the undefined fields you put within the language file....just give them a name.
Do not remove them ! I want to use your Ant Music Database after it is finished to try swl exports to the PK-Movie-DB and try to change that php code for making a PK-Music-DB....just trying ;-)
So do not remove them, bacuase else i think PK-Music-DB will fail.

Code:
Fields.Strings.String[0]=Number
Fields.Strings.String[1]=Checked
Fields.Strings.String[2]=Artist
Fields.Strings.String[3]=Media Type
Fields.Strings.String[4]=Source
Fields.Strings.String[5]=Date added
Fields.Strings.String[6]=Borrower
Fields.Strings.String[7]=Rating
Fields.Strings.String[8]=Track Name
Fields.Strings.String[9]=Album
Fields.Strings.String[10]=Formatted Title
Fields.Strings.String[11]=
Fields.Strings.String[12]=
Fields.Strings.String[13]=
Fields.Strings.String[14]=Genre
Fields.Strings.String[15]=Year
Fields.Strings.String[16]=Length
Fields.Strings.String[17]=Tracks
Fields.Strings.String[18]=URL/Filename
Fields.Strings.String[19]=
Fields.Strings.String[20]=Comments
Fields.Strings.String[21]=
Fields.Strings.String[22]=Track Number
Fields.Strings.String[23]=Audio Format
Fields.Strings.String[24]=Audio Bitrate
Fields.Strings.String[25]=
Fields.Strings.String[26]=
Fields.Strings.String[27]=
Fields.Strings.String[28]=
Fields.Strings.String[29]=
Fields.Strings.String[30]=
antp
Site Admin
PostPosted: 2007-09-05 09:10:06    Post subject: Reply with quote
View user's profile Send private message Visit poster's website The fields are not undefined if removed from the language field, they just keep their English name.
But anyway I do not think that these have any role in the SQL export.
Seeing your SQL export sample I think to something else that I forgot: if you have duplicate numbers it may fail because the "num" column is defined as primary key (which has to have unique values).
pollewops
PostPosted: 2007-09-06 21:10:04    Post subject: Reply with quote
View user's profile Send private message Hi sracer....I just wanted to show here the export of Ant Music Catalog to SQL and after then uploaded to the PK's Music Database ;-)

Looks good to me.
http://www.pollewops.nl/musicdb/

The track listing needs to be changed and ordered nice in a list.
**EDIT: just found out by exporting mention that the LF should be <br> solve this issue ;-)

I also changed the language file a bit, so the fields are displayed correctly and I changed the Actors with the Description. Now the AllMusic.ifs script also imports the tracks at the right "Description" place.

My used language file can be downloaded from http://www.pollewops.nl/MusicCatalog-English.lng

Some thing still needs to be changed to the language file if we want to use the allmusic.ifs script....see an example import within the next picture:

Some rearrangement needs to be done.....


Last edited by pollewops on 2007-09-07 08:42:13; edited 1 time in total
sracer
PostPosted: 2007-09-06 23:35:01    Post subject: Reply with quote
View user's profile Send private message OK. I made the changes to name all fields as suggested. I downloaded the AllMusic.ifs file (written by FrenchFrog2) and tweaked it for use with my AMC-MP3 mod.

Here's a link to: AntMusicCatalog-MP3 v0.90 w/AllMusic-AMCMP3 mods.
pollewops
PostPosted: 2007-09-07 08:39:59    Post subject: Reply with quote
View user's profile Send private message
sracer wrote:
OK. I made the changes to name all fields as suggested. I downloaded the AllMusic.ifs file (written by FrenchFrog2) and tweaked it for use with my AMC-MP3 mod.

Here's a link to: AntMusicCatalog-MP3 v0.90 w/AllMusic-AMCMP3 mods.


Hi Sracer,
I tested your ifs. script..if worked fine. The changes I made to my language file are not required then. Perfect.
But some recommendations:
- AllMusic AMC MP3 (EN).ifs: change the title within this file, so it is displayed different then the original allmusic.ifs.
e.g. Title=AllMusic AMCMP3
- MusicCatalog-English.lng:
- remark the line: LoriginalTitle.width=70
it makes the input box looks better
- remark the line: LURL.width=70
it makes the input box looks better
- change the layout a bit. Make the track listing box wider. Look at mines ;-)

Question: you have added 4 pictures within your package. Where are they used for....I do not see them appear within the program.
pollewops
PostPosted: 2007-09-07 13:35:13    Post subject: Reply with quote
View user's profile Send private message I would like to tell all that I managed to create a Dutch Moviemeter script special for the AMC MP3 mod ;-)
The name is: MusicMeter AMC MP3 (NL).ifs

I will upload the file this weekend.
sracer
PostPosted: 2007-09-08 20:14:48    Post subject: Reply with quote
View user's profile Send private message
pollewops wrote:
Hi Sracer,
I tested your ifs. script..if worked fine. The changes I made to my language file are not required then. Perfect.
But some recommendations:
- AllMusic AMC MP3 (EN).ifs: change the title within this file, so it is displayed different then the original allmusic.ifs.
e.g. Title=AllMusic AMCMP3

Thanks... forgot to do that... now it is done.
pollewops wrote:
- MusicCatalog-English.lng:
- remark the line: LoriginalTitle.width=70
it makes the input box looks better
- remark the line: LURL.width=70
it makes the input box looks better
- change the layout a bit. Make the track listing box wider. Look at mines ;-)

I've commented out a section in the .lng file where anyone can drop in their overrides to the default layout that I provide. You only need to put those elements and attributes that changed. This will allow people to tweak the layout to their liking (different screen resolutions cause the default layout to look goofy). When an update to the .lng file is released, simply cut-n-paste that section into the updated version.

My goal is for AMC-MP3 to provide a specific database field mapping "standard" for CD/MP3 cataloging. Anyone using this will be able to alter the entry form layout, create/tweak scripts and reports. I know that this can be done with other mods too, but I plan on making documentation available that will assist others in expanding and extending AMC-MP3.

Once this AMC-MP3 mod has been tested with a significant amount of "live" data/collections, I'm planning on creating a little companion tool for graphically modifying the .lng files. Imagine being able to visually drag and drop the various fields and have the tool generate all of the attributes automatically for the lng file.

pollewops wrote:
Question: you have added 4 pictures within your package. Where are they used for....I do not see them appear within the program.

Those are icons for individual use. You can use a tool like exescope to patch the executable, or you can assign them to the shortcut (safer way) to visually differentiate AMC-MP3 from Ant Movie Catalog.
pollewops
PostPosted: 2007-09-08 20:29:03    Post subject: Reply with quote
View user's profile Send private message
pollewops
PostPosted: 2007-09-12 20:14:43    Post subject: Reply with quote
View user's profile Send private message Hi Sracer,

I am going to change your language file a bit since I want it to be compatible with the PK Movie Database web scripts.
Basically I am going to swap some fields. That's all....

Any problem with that...hopefully not ;-)
sracer
PostPosted: 2007-09-13 15:20:53    Post subject: Reply with quote
View user's profile Send private message
pollewops wrote:
Hi Sracer,

I am going to change your language file a bit since I want it to be compatible with the PK Movie Database web scripts.
Basically I am going to swap some fields. That's all....

Any problem with that...hopefully not ;-)

No problem! If you'd like, download version 0.91. I've started adding some comment sections for assisting people (just like you) who would like to tweak some things. Eventually, all you will need to do is to keep your changes (for each section) together and simply cut-n-paste into those "override" areas when an updated .lng file is released.
Yochanan
PostPosted: 2007-11-24 00:24:16    Post subject: Reply with quote
View user's profile Send private message How do I use this? There's no executable in the ZIP file, so do I put this in the AMC folder?
antp
Site Admin
PostPosted: 2007-11-24 11:53:26    Post subject: Reply with quote
View user's profile Send private message Visit poster's website Yes, these files will give new translation and scripts to use with AMC.
But if you still want to use it for movies too it is better to make a copy of AMC's folder to have both versions useable.
Alf Neuman
PostPosted: 2009-02-02 02:14:50    Post subject: Can't get mod to work Reply with quote
View user's profile Send private message The one thing I like about ANT is I don't need to insert the bleedin' disc. Unfortunately, when I try to use any of the Music Cat mods, they don't work.
This time when I use the AllMusic script, I get this error:
"HTTP/1. 1 404 Not Found"
I dropped revised language, script, and template files into the respective folders. The program header still says Ant Movie Guide as well.What am I missing?
Alf Neuman
PostPosted: 2009-02-02 02:31:54    Post subject: Re: Can't get mod to work Reply with quote
View user's profile Send private message
Alf Neuman wrote:
The one thing I like about ANT is I don't need to insert the bleedin' disc. Unfortunately, when I try to use any of the Music Cat mods, they don't work.
This time when I use the AllMusic script, I get this error:
"HTTP/1. 1 404 Not Found"
I dropped revised language, script, and template files into the respective folders. The program header still says Ant Movie Guide as well.What am I missing?


DUH!!! It helps to select the correct Language File. Man! It's already been a long month today! The mod works great!
Alf Neuman
PostPosted: 2009-02-02 16:56:50    Post subject: Re: Can't get mod to work Reply with quote
View user's profile Send private message
Alf Neuman wrote:
Alf Neuman wrote:
The one thing I like about ANT is I don't need to insert the bleedin' disc. Unfortunately, when I try to use any of the Music Cat mods, they don't work.
This time when I use the AllMusic script, I get this error:
"HTTP/1. 1 404 Not Found"
I dropped revised language, script, and template files into the respective folders. The program header still says Ant Movie Guide as well.What am I missing?


DUH!!! It helps to select the correct Language File. Man! It's already been a long month today! The mod works great!


Okayyy, I'm still getting the 404 Not found error. Sometimes running the script a second time clears it, other times, nothing will help.
Alf Neuman
PostPosted: 2009-02-03 03:10:11    Post subject: Mod do allmusic.ifs not working Reply with quote
View user's profile Send private message Hello, SRACER. I thought I'd try to create a script based on your Allmusic script. All I did was replace every instance of AllMusic or allmusic with either Gracenoet or gracenote. While I did not get the 404 Not Found error, I do get "Error while reading selection page". (Of course, wouldn't you know it, when I ran the script to get the error message, I got the http: 404 not found error.) What might I be missing?
By the way, this was my first attempt at any sort of coding or script writing in a "modern" language. I'm still trying to get over that COBOL isn't the standard language any more.
bad4u
PostPosted: 2009-02-03 07:53:05    Post subject: Re: Mod do allmusic.ifs not working Reply with quote
View user's profile Send private message
Alf Neuman wrote:
Hello, SRACER. I thought I'd try to create a script based on your Allmusic script. All I did was replace every instance of AllMusic or allmusic with either Gracenoet or gracenote.


The script downloads the source code of a website, then tries to find and retrieve appropriate data from this source. So replacing an URL with anoter one will only work if both sites have nearly the same or at least a very similar layout. For a Gracenote script you might try to start with an existing (but probably outdated, I did not try it) gracenote script from another topic:

http://forum.antp.be/phpbb2/viewtopic.php?t=1845
http://forum.antp.be/phpbb2/viewtopic.php?t=2212

It might be easier to repair such a script, if the layout of the website did not change too much.

For the AllMusic script it might be good to ask for help on an older topic http://forum.antp.be/phpbb2/viewtopic.php?t=2212 , as then previous script writers probably get notified about new postings on the forum then. Maybe one of them can help on the script.

Scripting itself is not that hard to learn if you have previous programming skills, so that you might be able to understand what is going on. But you might not want to start with a quite complex script like AllMusic, as this one uses functions from external files (e.g. StringUtils7552.pas), too. For learning scripting read "Technical information / Script files creation" from AMC helpfile, it's not a tutorial, but makes it easier to understand the functions. For help on specific Delphi commands you could use a website like http://www.delphibasics.co.uk/index.html then.
fulvio53s03
PostPosted: 2009-03-01 09:43:55    Post subject: Reply with quote
View user's profile Send private message
Display posts from previous:   
View previous topic :: View next topic  
Post new topic   Reply to topic    www.antp.be Forum Index -> Ant Movie Catalog > Mods All times are GMT + 1 Hour
Goto page Previous  1, 2, 3  Next
Page 2 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
Template made by antp