AMC and Movietrack databases

T C · Post by **T C** » 2006-06-23 19:33:10

Hello and congrats for this wonderful program!

I'm a new AMC user and I have one question. I did some searching on this forum, but didnt found the answer. I'm looking for a (easy) way to convert my old Movietrack database to an AMC database or some way to import it. Can you give me some advices?
Maybe it has to do with some XML or CSV templates, but i can't find any for Movietrack.

Thank you in advance and sorry for my precarious English.

Post by **antp** » 2006-06-23 23:02:03

What kind of file does Movietrack use for storing info?
Does it allow to export to another file format, like plain-text, Excel, etc. ?

T C · Post by **T C** » 2006-06-24 08:00:02

1. My profile directory contains some .dat and .bak files.

2. Movietrack allows export to html, xml and csv, but it needs templates. I guess i need an xml or csv file that is compatible with AMC, but i can't find such templates since the Movietrack site/forum is down and Snille's forum doesnt have any.
And my knowledge in this domain equals zero.

Post by **antp** » 2006-06-25 10:03:32

XML will probably not help as AMC only supports its own XML structure.
For CSV, I guess that this is the solution, but isn't there any info in help file or sample CSV template that would allow to guess what has to be done?

T C · Post by **T C** » 2006-06-25 14:49:18

Unfortunately no info in the help file about creating templates and no sample CSV template.
Only a list of available tags (for all export templates, i guess):

Code: Select all

{EXPORT_IMAGE} - IMDb cover image (not currently supported by printer)
{EXPORT_MOVIENUMBER} - Movie number/tag
{EXPORT_MOVIEID} - Movie ID
{EXPORT_MOVIECOUNT} - # of exported movies/page (not currently supported by printer)
{EXPORT_MOVIECOUNTTOTAL} - Total # of exported movies (not currently supported by printer)
{EXPORT_MOVIENAME} - Movie name/title
{EXPORT_GENRE} - Genre
{EXPORT_MEDIUM} - Medium
{EXPORT_LOCATION} - Location
{EXPORT_STATUS} - Status (present/absent)
{EXPORT_COMMENTS} - Comments
{EXPORT_YEAR} - Year
{EXPORT_DIRECTOR} - Director
{EXPORT_TAGLINE} - Tagline
{EXPORT_SUMMARY} - Summary
{EXPORT_ACTORS} - Actors
{EXPORT_LANGUAGE} - Language
{EXPORT_RUNTIME} - Runtime
{EXPORT_MPAA} - MPAA rating
{EXPORT_IMDBRATING} - IMDb user rating
{EXPORT_ENTRYDATE} - Entry date
{EXPORT_VIEWNUMBER} - # of times viewed
{EXPORT_DISCNUMBER} - # of discs
{EXPORT_WIDTH} - Video width (resolution)
{EXPORT_HEIGHT} - Video height (resolution)
{EXPORT_LENGTH} - Video length
{EXPORT_VIDEOBITRATE} - Video bitrate
{EXPORT_AUDIOBITRATE} - Audio bitrate
{EXPORT_VIDEOCODEC} - Video codec
{EXPORT_AUDIOCODEC} - Audio codec
{EXPORT_AUDIOCHANNELS} - Audio channels
{EXPORT_AUDIOFREQUENCY} - Audio frequency
{EXPORT_TRAILERS} - Trailers (not currently supported by printer)
{EXPORT_DISCOUNTTOTAL} - Total # of discs (not currently supported by printer)
{EXPORT_DISCCOUNTTHISPAGE} # of discs/page (not currently supported by printer)
{EXPORT_TRAILERCOUNTOTAL} - Total # of trailers (not currently supported by printer)
{EXPORT_TRAILERCOUNTTHISPAGE} - # of trailers/page (not currently supported by printer)
{EXPORT_RATING} - Rating (assigned)
{EXPORT_IMDBURL} - IMDb info URL
{EXPORT_AKA} - Also known As
{EXPORT_FILEPATH} - Filepath
{EXPORT_FOOTERNAVIGATION} - Navigation menu linking pages (CSS class = footernavigation)
(not currently supported by printer)

I guess the solution could come from someone who has used Movietrack and is now using AMC and has more programming skills.

Post by **antp** » 2006-06-25 16:49:14

Maybe you just have to put the fields that you want + a separator, e.g. :

Code: Select all

{EXPORT_MOVIEID};{EXPORT_MOVIENAME};{EXPORT_YEAR}

?

T C · Post by **T C** » 2006-06-25 18:33:56

I managed it!

I made a CSV Templates directory in Program Files/MovieTrack/Export Templates and created there 3 .txt files: csv_body.txt, csv_footer.txt, csv_header.txt (The Movietrack export procedure requests 3 files). csv_footer and csv_header are empty, in csv_body i put the tags with the ; separator.

I exported to .csv and obtained a file that AMC recognized. Not perfectly of course since AMC and Movietrack tags/fields are not identical. But by assigning the fields to the columns i obtained a much better database that will be much easier to update/modify. And it spared me a lot of time.

Thank you antp!