Import hierarchical locations
First of all, excuse me because I don't speak English very well (French).
I would like to import a location's database into Media Pro. I would like that hierarchical relation is not being lost (for example : France > Ile de France > Paris > Tour Eiffel).
I've found the vocabulary folder (C:\Documents and Settings\username\Application Data\Phase One Media Pro\Plug-ins\Vocabulary\), with text-file for each location category, but there is no relation between each category.
My database can be exported into several format (txt, csv, ...) and structures (SQL languages).
Does someone have an idea to resolve this problem ?
Thanks in advance !
Sylvain M.
I would like to import a location's database into Media Pro. I would like that hierarchical relation is not being lost (for example : France > Ile de France > Paris > Tour Eiffel).
I've found the vocabulary folder (C:\Documents and Settings\username\Application Data\Phase One Media Pro\Plug-ins\Vocabulary\), with text-file for each location category, but there is no relation between each category.
My database can be exported into several format (txt, csv, ...) and structures (SQL languages).
Does someone have an idea to resolve this problem ?
Thanks in advance !
Sylvain M.
0
-
Hello Frenchie !
Maybe more infos about the database...
(Il serait plus simple que tu me contactes par MP, ce sera plus facile dans la langue de Molière et ici, on va se faire fusiller si on jacte pas gb... 😄 )
Lio0 -
Is this information 'connected' to the images on this moment already?
What do you want to acomplish?
I think it's not hard to put this information (France > Ile de France > Paris > Tour Eiffel) into the Keywords field but i think you want something else?
-> When you want to bring the information into the image so it can not loose, it's best to use Keywords. With hierachical Keywords it's even possible to 'build' the hierachy you want. But, the 'scheme' is not transferable (is that a good word?) to other application i think...
-> When you want to use it for organizational purposes, it's best to use Catalog Sets. these are neither transferable but when you stay inside EM or MP, it's very usefull. The question is then, how to translate the information in your present database to these Catalog sets. Somebody must be able to make a script for this, but thats not me 😉
Roelof
(please respond in english, it's not my mohters language eiter but french is a lot harder for most of us..., thanks!)0 -
Thank you for your help ! <French mode> Merci compatriote pour ta sollicitude ! Je vais faire quelques efforts pour partager "in English" mon souci ici d'abord, et si je peine trop avec l'anglais, je n'hésiterai pas à te contacter directement ! 😉 </French mode>
Maybe more infos about the database...
My database is in GIS format (Shapefile, DBF...), but can be exported in every standard DB format.
I 've got all the hierarchical administrative data in France (State / Departments / Cities [more than 36000]), and my wish is to import this hierarchy directly into Media Pro. I've found how to import all the cities in the text file of the vocabulary folder, but this way, they are not in relation with Departments
My ultimate goal is to create an empty catalogue with this hierarchy, so we could assign Department and State with the only city information.Is this information 'connected' to the images on this moment already?
For a few image, yes. But my goal is to create an empty Catalogue for this.I think it's not hard to put this information [...] into the Keywords field but i think you want something else?
For now, location hierarchy is my priority, but I'm interested to know how to import hierarchical keywords to !
Sylvain M.0 -
[quote="Sylvain M." wrote:
Thank you for your help !<French mode> Merci compatriote pour ta sollicitude ! Je vais faire quelques efforts pour partager "in English" mon souci ici d'abord, et si je peine trop avec l'anglais, je n'hésiterai pas à te contacter directement ! 😉 </French mode>
😉
Opening any MP vocabulary file is not a problem, they are all in "simple" text format (you can use NotePadd++, free and wonderful...). However, the hierarchical link between City > State > Country exists only into each jpg file, in IPTC (or XMP) block : this means that MP, reading IPTC/XMP block in jpg files, will be able to rebuild the hierarchical structure.
Note that several dam don't accept the location hierarchy. If I remember well, ACDSee Pro can import location tags, of course, but without hierarchy. Same thing for IDimager, but in this case, there is à little script which rebuild the location hierarchical structure (works fine !)
As your location files are in a special format. it would be possible to do what you want (maybe), but probably with an external script.
I don't agree with moorlag : hierarchical keywords are unofficial (the official IPTC rules do not accept hierarcical keyword). This means that hierarchical keyword structure belongs to a dam, not to others... If you want to change your program one day... Same thing for Catalog Sets : they belong to EM or MP, that's all... In my mind, it is better to follow the IPTC rules when it is possible...0 -
I don't agree with moorlag : hierarchical keywords are unofficial (the official IPTC rules do not accept hierarcical keyword). This means that hierarchical keyword structure belongs to a dam, not to others... If you want to change your program one day... Same thing for Catalog Sets : they belong to EM or MP, that's all... In my mind, it is better to follow the IPTC rules when it is possible...
I'm not an advocate for using unoffical functionality, thats why i asked for the purpose.
However, Keywords can be included into the (IPTC) fields of the images. The added information wil not get lost when sending files over or when you migrate to another DAM. Maybe there is no real standard for hierachical keyword yet i think it's usefull and with good scripting future migrations must be possible...
Catalog sets are another cup of tea indeed. Only to use for organizational purposes in this particulary DAM (EM or MP). There is little chance you ever can use it elsewhere.
However, catalog sets are very powerfull in what the do, bring order in your catalog...
Did you consider the use of the 'place finder' option?
It's not IPTC compliant either i think but it's filling the needs as far i can see.
When the locations are filled, it's sufficient to add the term 'Tour Eiffel', all the other ones (Paris, Ile de France and France are added automated):
http://dl.dropbox.com/u/25580003/PlaceFinder1.JPG
http://dl.dropbox.com/u/25580003/PlaceFinder2.JPG
Roelof0 -
I agree strongly with you, even if my English causes perhaps some misunderstandings.
The added value of metadata standard (IPTC) is no doubt for me.
And I am convinced that the hierarchy proposed by the software is only a "display". But this hierarchy does matter for me (and my company), and I want this to be related to the administrative hierarchy of our territory (nearly 200 municipalities).
I'd like to have an empty catalog set with this hierarchy of places, to "normalize" the information future.
Am I clear in my question?
Thank you in advance.0 -
I'm not sure i understand it correctly this time but let me give it a try 😊
It is possible in MP to fill in all places before so the naming in the future is consistent. You can do this by simply edit some tekst files. These can be found whithin MP. Open the menu option 'Scripts' en go to 'Tools' and 'Reveal Scripts Folder'. Go up one level to the 'Plug-ins' folder and go two folders down (Vocabulary/Default):
http://dl.dropbox.com/u/25580003/PlaceFinder.JPG
(Full image: )
You can add the information from your database to the 4 tekstfiles: Country, State, City and Location.
Alle the information is now available from your MP catalogs but it had to assigned to the images yet to make the 'connection' visible.
By enable the option 'Constrain editing to definied terms ' (Menu/Edit/Preferences/Vocabulary Editor) you can limit the user input to your own options:
http://dl.dropbox.com/u/25580003/VocabularyEditor.JPG
I hope this information is (some) helpfull..
Roelof0 -
Hi Sylvain,
If you are on Windows then there is a scripting solution. You will need to create you own version of the script based on the following example but as you can export your data in a number of ways this should be easy.
The following VB script will create a number of place finder entries. You need to save this into a file with an extension of .vbs. The name is up to you! The location of the file will vary according to operating system. Launch MediaPro and select the Scripts menu. Under the "Tools" option will be a script called "Reveal Scripts Folder.vbs". Run this script and click OK. It should open Windows Explorer in the required folder. Save the script here.
'-------------------------------
' Create Place Finder Hierarchy
'-------------------------------
Option Explicit
Dim app, image
Dim L_title_text, L_message_text
L_title_text = "Phase One Media Pro"
L_message_text = "Please launch Phase One Media Pro."
Main()
Sub Main()
Set app = CreateObject("PhaseOneMediaPro.Application")
' get the active catalog
If (app.Catalogs.count = 0) Then
MsgBox L_message1_text, vbCritical, L_title_text
Else
For Each image In app.ActiveCatalog.Selection
' reset the placefinder details for image
image.Annotations.Location = "" : image.Annotations.City = "" : image.Annotations.State = "" : image.Annotations.Country = ""
image.Annotations.Country = "Australia"
image.Annotations.State = "Western Australia"
image.Annotations.City = "Perth"
image.Annotations.Location = "Murray Street"
image.Annotations.Location = "" : image.Annotations.City = "" : image.Annotations.State = "" : image.Annotations.Country = ""
image.Annotations.Country = "Australia"
image.Annotations.State = "Northern Territory"
image.Annotations.City = "Alice Springs"
image.Annotations.Location = ""
image.Annotations.Location = "" : image.Annotations.City = "" : image.Annotations.State = "" : image.Annotations.Country = ""
image.Annotations.Country = "France"
image.Annotations.State = "Paris"
image.Annotations.City = "ÃŽle-de-France"
image.Annotations.Location = "Champs-Élysées"
image.Annotations.Location = "" : image.Annotations.City = "" : image.Annotations.State = "" : image.Annotations.Country = ""
image.Annotations.Country = "United Kingdom"
image.Annotations.State = "City Of London"
image.Annotations.City = ""
image.Annotations.Location = "Threadneedle Street"
image.Annotations.Location = "" : image.Annotations.City = "" : image.Annotations.State = "" : image.Annotations.Country = ""
Next
End If
End Sub
The important bits of the script are as follows:- You need to select a single image when running it.[/*:2nu2yks9]
- This image should be a dummy one as it will end up with no location details.[/*:2nu2yks9]
- The first important line of code will reset the placefinder details so that nothing is there. It is critical that this is done location first, then city, then state and then country. I've put all of these commands on to a single line, although this appears to wrap when viewed in this forum.[/*:2nu2yks9]
- The next 4 lines will create the first place finder record. It is critical that these are done in country, then state, then city and finally location order. You can put these on a single line if easier, as long as separated by a colon.[/*:2nu2yks9]
- If you don't do these in the correct order you get "hanging" entries in the placefinder which could take a long time to tidy up.[/*:2nu2yks9]
- This process is repeated for each required place. You must reset between each new record otherwise you'll get extra records that are a combination of the last and next details.[/*:2nu2yks9]
- The above example shows that you don't need to have all four details for each image. For example if City isn't appropriate then leave it blank.[/*:2nu2yks9]
- Note that a full reset is done even if just the location was changing. You could reduce the amount of resets done but a single mistake and your placefinder will end up a mess![/*:2nu2yks9]
- The final thing to do is to reset the details, otherwise your dummy image remains assigned to the last values.[/*:2nu2yks9]
- If you have a large hierarchy then the script make take a while to run and bits of the screen might flash. Don't panic![/*:2nu2yks9]
Hope this helps. Have a play!
Ian0 - You need to select a single image when running it.[/*:2nu2yks9]
-
It's a little bit late ton thank you, but I couldn't try your script earlier...
It's succeed !
Thank you very much ! 😄
Sylvain M.0
投稿コメントは受け付けていません。
コメント
9件のコメント