Sounds like a job for a perl script with then using the csv features of MC or similar to import the data. Actually with "All My Movies" you just need a list of movie titles, one per line, in a text file to import them.
You can use any scripting language you want. I personally like perl since it is available on Windows, OS X, Unix, and Linux...
Something like the following would work:
--------------------------------------------------------
#!/usr/local/bin/perl
# Change the following two lines to the path/locations that you want
my $movies_location = "C:\\path\ o\\movies\\directory\\";
my $output_file = "C:\\Users\\my_username\\Desktop\\movielist.txt";
# Opens the output file to start writing to it or exits on error
open(OUT, ">$output_file") || die "Could not open output file: $output_file :$!";
# Checks that the $movies_location is a directory
if (-d $movies_location) {
# Opens the $movies_location directory or exits on error
opendir(DIR, $movies_location) || die "Cannout open directory: $movies_location : $!";
}
else {
die "Error not a directory: $movies_location";
}
# Reads all files/folders from the $movies_location into an array
my @files_in_dir = readdir(DIR);
# Closes the directory
closedir(DIR);
# Loops over all files in the movie directory and prints them to
# the output file, one per line
foreach my $movie (@files_in_dir) {
chomp($movie);
print OUT "$movie\
";
}
# Closes the output file
close(OUT);
-----------------------------------------------------------------