| T O P I C R E V I E W |
| eloquintet |
Posted - 23 Aug 2015 : 23:35:23
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? |
| 5 L A T E S T R E P L I E S (Newest First) |
| JDommi |
Posted - 24 Aug 2015 : 16:38:42
Okay, then we'll see what's possible |
| eloquintet |
Posted - 24 Aug 2015 : 15:58:26
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. |
| JDommi |
Posted - 24 Aug 2015 : 10:33:47
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. |
| eloquintet |
Posted - 24 Aug 2015 : 05:09:24
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. |
| JDommi |
Posted - 24 Aug 2015 : 00:22:15
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. |
