| Author |
 Topic  |
|
|
martel
Starting Member
Canada
14 Posts |
 Posted - 25 Oct 2012 : 23:39:05
|
Bonjour,
I am new to this software (and by the way, I like it very much).
One of the problems I have is that after importing about 500 movies, I realise that the program create a few duplicate entries (for example I have 4 entries for "Peter O'Toole" in the "Actors" database.
Is there any way to consolidate them? I guess there is since there is a special filter to find them...
Also, (variation on the same question), in the "Country" field for the movies, I have a bunch of "USA" and a bunch of "United States of America", any way to consilidate them into "USA"?
Merci,
Yves |
Yves Martel |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 26 Oct 2012 : 08:26:31
|
Hello Martel,
I will make soon a function to "Merge" more actors together, in order to consolidate duplicates.
About the Country, you can use the "Fields Manager" function under the Tools menu.
Here use the "Replace a word on all fields" function.
Select all movies and then put the word to search "United States of America" and the new word "USA"
|
http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
 |
 |
|
|
JDommi
Administrator
Germany
4657 Posts |
Posted - 26 Oct 2012 : 10:54:15
|
Outch, that would even change this phrase where it should not be changed. Like in title, plot or quotes!
|
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
JDommi
Administrator
Germany
4657 Posts |
Posted - 26 Oct 2012 : 14:39:47
|
| But maybe there is a situation in which such a replacement is not wished. As example I have seen a documentary called "The United States of America". That would be result in the Title "USA". I think that even in the Alphabetical Order that would make a little but fine difference. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
martel
Starting Member
Canada
14 Posts |
Posted - 26 Oct 2012 : 16:39:46
|
Hum...
Renaming the country field is not the same as consolidating both entries. It would still leave 2 separate ID for the countries. Granted if you do a sort, it would look the same since both USA and USA would be side by side, but since you are contemplating a function to "merge" duplicate actors and movies, wouldn't this be also a case of merging 2 values in the database?
Yves |
Yves Martel |
|
|
| |
Topic |
|
How to consolidate duplicate entries?
