Extensis User-to-User Forums
  [Search] SEARCH  |  [Recent Topics] RECENT TOPICS  |  [Members]  MEMBER LISTING  |  [Groups] EXTENSIS HOME PAGE 
[Register] JOIN FORUMS / 
[Login] FORUMS LOGIN 
Adding Keyword list  XML
Forum Index -> Portfolio (single-user)
Author Message
El Guido


Joined: 10/24/2006 03:04:18
Messages: 6
Offline

I want to make a catalog of my "image bank" into Portfolio.

I've already copied all my image CD's (from different providers) to an external hard drive. Some of the CD's have a text file with keywords, some of them have a portfolio database (.fdb file).

I s it possible to import the keywords from the text file automatically?

Is it possible to merge all the .fdb files in 1 "image bank catalog" ?
mwra
Cyberwarrior (1000+ posts)

Joined: 07/25/2006 06:06:13
Messages: 2582
Location: Portsmouth, UK
Offline

Merging files/records - Yes/No - see http://forums.extensis.com/jforum/posts/list/378.page Note too that if you use screen previews, you'll need to re-create these for any records dragging into your main catalogue - the thumbnail travels but not the preview (there is a reason why).

If the Keyword text lists have tab-delim per-record data then a text import merge is possible - though if the CDs/files are old you'll need to re-save the files as Unicode before attempting import. If the lists are just lists of possible keywords rather then per-record info, these can be imported as files to Keywords or any custom field. Imported lists are merged with existing list items. To replace a list, delete the current one before importing.

Regards

Mark Anderson (DAM consultant, PortfolioFAQ author)
Shoantel (Portfolio consulting)
PortfolioFAQ (free stuff!)

Windows XP(SP3): v8.1.x client / v8.5.2 (Client/Svr/NPS)
Mac 10.5.x: v8.5.2 (Client/Svr/NPServer)
[Email] [WWW]
El Guido


Joined: 10/24/2006 03:04:18
Messages: 6
Offline

thanks mwra for the quick reply.

Can you please discribe how to import the keyword text lists? I've attached a sample text file so you'll have an idea how it looks like. Do I have to import the images first and than later import the text file? Or can I do the two things together?

I'm sorry for all these questions, but I'm new to Portfolio.
 Filename SS07.TXT [Disk] Download
 Description Sample of a keyword list I'd like to import.
 Filesize 38 Kbytes
 Downloaded:  180 time(s)

mwra
Cyberwarrior (1000+ posts)

Joined: 07/25/2006 06:06:13
Messages: 2582
Location: Portsmouth, UK
Offline

Manual p136-137 tell you pretty much everything you need to know about import from text file.

OK, your file's a tab-delimited file with Filename/Title/Credits/Information/Keywords field date. If you want the Title/Credits/Information you'll need to create fields for that or decide which existing fileds they'll map to. You'll also want to get the keyword info into the correct format. Add present the keyword info is in comma-delimited form:
Code:
ant,bee,cat,dog,...

whereas it needs to be ASCII character #29 delimited. In the following I've used a % for the #29 character as the actual character is a non-printing one and you'd see nothing.
Code:
ant%bee%cat%dog%...

Note the lack of commas. The easiest way to do this is to know yourself up a Macro in Excel. If you look about in the PortfolioFAQ forums, I think there are some code samples there. IIRC, Excel doesn't do Unicode by default so if you've unusual characters in the data you might want to use a different tool.

An important fact the manual omits [sic] is that Portfolio expects import files to be in Unicode form. On the PC, Notepad allows this as non-default save option. I think you can use TextEdit on the Mac.

That's everything you need. Call back if you get stuck.

Regards

Mark Anderson (DAM consultant, PortfolioFAQ author)
Shoantel (Portfolio consulting)
PortfolioFAQ (free stuff!)

Windows XP(SP3): v8.1.x client / v8.5.2 (Client/Svr/NPS)
Mac 10.5.x: v8.5.2 (Client/Svr/NPServer)
[Email] [WWW]
El Guido


Joined: 10/24/2006 03:04:18
Messages: 6
Offline

Thanks Mark,

it is no longer a problem to import text files via the "Import Field Values..."
(I tried it with simple 1-keyword lists)

The only problem I still have is to convert my comma-devided keyword list into an ASCII #29 devided list. I've already tried several things, both on Mac as PC, but nothings seems to do the trick.

Anyone got an idea how to do this?

(help)
mwra
Cyberwarrior (1000+ posts)

Joined: 07/25/2006 06:06:13
Messages: 2582
Location: Portsmouth, UK
Offline

See this article.

[Post-edit] Mac users - don't be put off by reference to use of Excel - the macro code used should work in Mac versions of Excel too. Saves faffing around with AppleScript or shell scripting (unless you like doing that).

Regards

Mark Anderson (DAM consultant, PortfolioFAQ author)
Shoantel (Portfolio consulting)
PortfolioFAQ (free stuff!)

Windows XP(SP3): v8.1.x client / v8.5.2 (Client/Svr/NPS)
Mac 10.5.x: v8.5.2 (Client/Svr/NPServer)
[Email] [WWW]
El Guido


Joined: 10/24/2006 03:04:18
Messages: 6
Offline

Wow, that's it... many thanks Mark.

PS: thanks to the good help, we were able to test everything we needed to test so we've already bought a full version
mwra
Cyberwarrior (1000+ posts)

Joined: 07/25/2006 06:06:13
Messages: 2582
Location: Portsmouth, UK
Offline

Sadly I'm not on commission!

Good luck with your new Portolio.

Regards

Mark Anderson (DAM consultant, PortfolioFAQ author)
Shoantel (Portfolio consulting)
PortfolioFAQ (free stuff!)

Windows XP(SP3): v8.1.x client / v8.5.2 (Client/Svr/NPS)
Mac 10.5.x: v8.5.2 (Client/Svr/NPServer)
[Email] [WWW]
 
Forum Index -> Portfolio (single-user)
Go to:   
[Logo]

Your privacy is important to us. You may manage your forum email subscriptions by logging in to the Extensis Forums at http://forums.extensis.com/jforum/user/login.page and then going to your My Forums Profile.

For more information, view our Privacy Policy at http://www.extensis.com/en/about/privacy_policy.jsp.
For issues related to the forums please send an email to forums@extensis.com