Exporting Text and Filenames

[Wolvie]

Kurt (or any on in the know) -
I want the text export function to export files to a tab deliminated or xls file.  Is there a way to do this in PM.  I want to be able to create a file that I can import into a database application I am creating.

If it isn't possible to do this now, can it be added as a feature in later in PM?

Thanks.

[gajones]

this might do the job:

http://peccatte.karefil.com/software/Catalogue/CatalogueENG.htm

[Kirk Baker]

I want the text export function to export files to a tab deliminated or xls file.  Is there a way to do this in PM.  I want to be able to create a file that I can import into a database application I am creating.

You can definitely use the Export Text function to export all data as a tab delimited text file.  Just enter tabs between the variables you are exporting like so:

{filename}[tab]{caption}[tab]{date}...etc...

HTH,

-Kirk

[Wolvie]

Beautiful!!!!  Thanks Kirk!

[Wolvie]

I want the text export function to export files to a tab deliminated or xls file.  Is there a way to do this in PM.  I want to be able to create a file that I can import into a database application I am creating.

You can definitely use the Export Text function to export all data as a tab delimited text file.  Just enter tabs between the variables you are exporting like so:

{filename}[tab]{caption}[tab]{date}...etc...

HTH,

-Kirk

Is there a variable for filepath?

[Kirk Baker]

I want the text export function to export files to a tab deliminated or xls file.  Is there a way to do this in PM.  I want to be able to create a file that I can import into a database application I am creating.

You can definitely use the Export Text function to export all data as a tab delimited text file.  Just enter tabs between the variables you are exporting like so:

{filename}[tab]{caption}[tab]{date}...etc...

Is there a variable for filepath?

No, but you can build it:

{folderpath}/{filename}

If your system uses backslashes for path separators, use '\' instead of '/' like I did above.

-Kirk

[Wolvie]

That works.

For anyone who is doing this, if you want to generate tab delimited list for importing into a database, make sure you use {tab} instead of [tab] as shown in the earlier part of the thread.

[Kirk Baker]

That works.

For anyone who is doing this, if you want to generate tab delimited list for importing into a database, make sure you use {tab} instead of [tab] as shown in the earlier part of the thread.

When I used [tab], I meant for you to type the Tab key.

-Kirk

[Wolvie]

That works.

For anyone who is doing this, if you want to generate tab delimited list for importing into a database, make sure you use {tab} instead of [tab] as shown in the earlier part of the thread.

When I used [tab], I meant for you to type the Tab key.

-Kirk

Yep, tried that, but at least in 4.5 and in XP, when the tab key is depressed, the cursor advances to the  saving dialog area of the Exporter menu. This is what I got when I pressed the tab key between each bracket:
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\07laxilvind_001.jpg
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\07laxilvind_002.jpg
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\07laxilvind_003.jpg

This is what I got and needed by using the {tab} command:
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_001.jpg
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_002.jpg
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_003.jpg

However, if, with XP, you go ctrl-tab then I got the same as above:
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_001.jpg   
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_002.jpg   
H:\2007 Lacrosse\04-01-07 Illinois Lax vs Indiana\   07laxilvind_003.jpg   

Thought I should point that out ;-)

~ W