Author Topic: Exporting Text and Filenames  (Read 13910 times)

Offline Wolvie

  • Member
  • **
  • Posts: 77
    • View Profile
Exporting Text and Filenames
« on: November 28, 2006, 04:41:27 PM »
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.

Offline gajones

  • Member
  • **
  • Posts: 61
    • View Profile
Re: Exporting Text and Filenames
« Reply #1 on: November 28, 2006, 06:21:21 PM »

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25025
    • View Profile
    • Camera Bits, Inc.
Re: Exporting Text and Filenames
« Reply #2 on: December 06, 2006, 06:24:42 AM »
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

Offline Wolvie

  • Member
  • **
  • Posts: 77
    • View Profile
Re: Exporting Text and Filenames
« Reply #3 on: December 11, 2006, 10:04:08 PM »
Beautiful!!!!  Thanks Kirk!

Offline Wolvie

  • Member
  • **
  • Posts: 77
    • View Profile
Re: Exporting Text and Filenames
« Reply #4 on: April 06, 2007, 01:32:17 AM »
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?

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25025
    • View Profile
    • Camera Bits, Inc.
Re: Exporting Text and Filenames
« Reply #5 on: April 06, 2007, 06:54:34 AM »
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

Offline Wolvie

  • Member
  • **
  • Posts: 77
    • View Profile
Re: Exporting Text and Filenames
« Reply #6 on: April 07, 2007, 12:33:09 PM »
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.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25025
    • View Profile
    • Camera Bits, Inc.
Re: Exporting Text and Filenames
« Reply #7 on: April 07, 2007, 01:23:19 PM »
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

Offline Wolvie

  • Member
  • **
  • Posts: 77
    • View Profile
Re: Exporting Text and Filenames
« Reply #8 on: April 07, 2007, 02:24:18 PM »
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