My library consists of hard copies of dvd's and video files from my computer. I need to be able to export all of my entries to excel so I can update data that relates to the dvds in excel and reimport the updated data back into xmm via csv import. The key problem is that I cannot map the exported data from File1 back to the same field again upon import. The reason that I don't want to just rescan my video library is that I have fixed many of the values interpreted by xmm because my folder and file names are not uniform. I want to be able to use the scan feature only to find new or location changes for existing files now. Does anyone have suggestions of how to manage this as a single database?
Well, that's really a hard question... Why don't you edit the database directly by Access? But I don't understand what your fixed values are that you have to edit the database by a 3rd party program. Can you give an example, please. Otherwise any advice would be only a guess.
In order to achieve what is possible, you have to try the impossible over and over again. Hermann Hesse
I needed to populate some fields such as title and episode manually because when I scanned my hard drives it did not populate the data correctly due to the folder/file naming of my library which is massive and was built over a decade. Maybe I can try to edit some of the data in Access instead but I just don't understand why I would be able to export the data from the [File1] field to excel but would not be able to reimport the unchanged data? I had read that this field is not importable because you can assign multiple episodes to a single title but this is not how mine is managed. I have a unique record for each of my video files.
I never have used that so I'm not familiar with what XMM does on that. If it does not import the correct files or paths then it's certainly a bug. To help you on a work-around I need to have a concrete example. Maybe I can make a plugin for you if only one field or table is affected. Best with the content of the field before export and after import and how the excel field looks like.
In order to achieve what is possible, you have to try the impossible over and over again. Hermann Hesse
Based on reading another post I learned that this data is housed in the "MovieFilesLinks" table so I just did a saveas of my new mdb file with this table blank then in another window I opened the old one with this information intact and copied this table from the old to the new. This only problem that I can think of is that I added a few new records to the new db so the links may be off by a few records but if that is the only problem then I can just delete out those records and import them from csv afterwards. I am at work right now so can't open it in xmm but will report my findings later tonight.
Need to be able to import values from File1 field
Posted - 23 Aug 2015 : 23:35:23
