After A LOT of experimenting =]
Exporting in Excel format (could be, and probably is, affecting other formats as well)
No note/warning that it appends instead of overwriting
There are BIG inconsistencies between the field names used withing XMM and the Export field names. Figuring out which field names do what is difficult.
Problems:
Export - XMM
====== - ===
Actors - Starring
CatalogNo - Box ID
Features - Edition
Genre - Category
InternetID - Site ID
Language - Media Language
Mode - Video mode
Musician - Music
Position - Starting Position
Rating - Rated
ReferenceNo - Movie ID
Ripped - Ripper
Type - Movie Type
URL - Official Web
Major problem here:
Packaging - PersonalRating
Packaging - Packaging
And Here:
Review - Resolution
And Here:
VideoDVD - VideoSeries
And Here:
Screen Ratio - Screen Ratio
These didn't even put ANYTHING in the CSV (not even a blank)
ChainUsed
MovieMD51
MovieMD52
MovieMD53
MovieMD54
MovieMD55
MovieMD56
SerieName
Song
TrailerMD51
TrailerMD52
In order to make this list, I filled out each field for a fake movie with the fieldname in the textbox.
Thanks
Donny
(Proudly Registered)
Added: The original .CSV data:
"Actors";"AquiredFrom";"AudioBitRate";"AudioCodec";"AudioDVD";"Awards";"Bitrate";"CatalogNo";"CDLabel";"ChainUsed";"Channels";"Chapter";"Codec";"Color";"Comments";"Country";"Cover";"Custom1";"Custom10";"Custom11";"Custom2";"Custom3";"Custom4";"Custom5";"Custom6";"Custom7";"Custom8";"Custom9";"DateDue";"DateInsert";"DateLoan";"DatePurchased";"Director";"Disk";"Distributor";"DolbyCodec";"DualLayer";"DualSide";"DVDID";"DVDYear";"Edition";"Features";"Filesize";"FPS";"FreeTime";"Genre";"InternetID";"Language";"Length";"Loan";"Loaner";"Location";"Marked";"Media";"Mode";"Modified";"MovieFile1";"MovieFile2";"MovieFile3";"MovieFile4";"MovieFile5";"MovieFile6";"MovieID";"MovieMD51";"MovieMD52";"MovieMD53";"MovieMD54";"MovieMD55";"MovieMD56";"MPAA";"Musician";"Notes";"OriginalLanguage";"OriginalTitle";"Owner";"Packaging";"PersonalRating";"Photographer";"Player";"Plot";"Position";"Price";"Producer";"Rating";"ReferenceNo";"Region";"Resolution";"Review";"Ripped";"SampleRate";"ScriptUsed";"Season";"Seen";"SeenWhen";"SeenWhere";"SerieName";"Song";"Status";"Studio";"Subgenre";"Subtitles";"TagLine";"Title";"TrailerFile1";"TrailerFile2";"TrailerMD51";"TrailerMD52";"Type";"UPC";"URL";"Value";"VHSAdv";"VHSID";"VideoDVD";"VideoSeries";"VideoStandard";"WebImported";"WebLinkScript";"Writer";"Year";
"Starring";"Aquired From";"A.Bitrate";"Audio";"Audio Format";"Awards";"Bitrate";"Box ID";"Media Label";"Channels";"Chapters";"Codec";"1";"Comments";"Country";"Cover";"Custom Field 1";"Custom Field 10";"Custom Field 11";"Custom Field 2";"Custom Field 3";"Custom Field 4";"Custom Field 5";"Custom Field 6";"Custom Field 7";"Custom Field 8";"Custom Field 9";"Custom Field 9";"11/12/2004";"Date Last Loan";"Date Purchased";"Directory";"NoCDs";"Distributor";"True";"False";"False";"DVD ID";"DVD Year";"Edition";"Edition";"Total Filesize";"FPS";"Free Time";"Category";"Site ID";"Media Language";"Length";"True";"Last Loan";"Location";"False";"Media";"Video mode";"11/12/2004";"Movie File 1";"Movie File 2";"Movie File 3";"Movie File 4";"Movie File 5";"Movie File 6";"0";"MPAA";"Music";"Notes";"Orig. Lang";"Original Title";"Owner";"Packaging";"Packaging";"Photographer";"Player";"Plot";"Starting Position";"Price";"Producer";"Rated";"Movie ID";"Region";"Resolution";"Resolution";"Ripper";"S.Rate";"Script Used";"True";"Date Seen";"Seen At";"Seen At";"Status";"Studio";"SubCategory";"SubTitle";"Tagline";"Title";"Trailer File 1";"Trailer File 2";"Movie Type";"UPC Code";"Official Web";"Value";"False";"VHS ID";"Screen Ratio";"Screen Ratio";"Video Standard";"True";"Web Link";"Writer";"Year";
EXPORT problems
Posted - 13 Nov 2004 : 07:44:35
