Text export

Started by DigPeter, February 17, 2016, 04:21:40 PM

Previous topic - Next topic

DigPeter

How can I output fields in Text Export on separate lines, as indicated in this example:

{File.Name}    {File.MD.XMP::dc\title\Title\0}
{File.AT.Notes.Note}



I have searched help in both Variables and Export Text topics, but can find no reference to this.

sinus

I do not know, what you mean exatly.

You can write in a new line with "Ctrl Enter"

[attachment deleted by admin]
Best wishes from Switzerland! :-)
Markus

DigPeter

Quote from: sinus on February 17, 2016, 04:28:40 PM
I do not know, what you mean exatly.

You can write in a new line with "Ctrl Enter"
Thanks Markus.

Using the variables as shown in my OP, the result is, for instance

Croatia SS 0524    The Roman arena    Estimated to be the best preserved and one of the largest Roman arenas.


Required layout is:
Croatia SS 0524    The Roman arena    
Estimated to be the best preserved and one of the largest Roman arenas.


I have just tried "Ctrl Enter", but it makes no difference.  My Text export dialog is attached

[attachment deleted by admin]

JohnZeman

I don't know that it is possible to do what you want.  The text export uses the basic format of outputing your information in multiple rows, with each row showing the text information each one of the files you have selected and sent to text export.

JohnZeman

This is why I generally use the HTML export instead, it better organizes my information in a table (see attached).

[attachment deleted by admin]

DigPeter

Quote from: JohnZeman on February 17, 2016, 05:02:05 PM
This is why I generally use the HTML export instead, it better organizes my information in a table (see attached).
Thanks John.  As you might have gathered from previous posts of mine, I am computer illiterate.  Scripting and HTML are over my head!  I guess I will have to edit the output in Word :-)

Mario

Quote from: DigPeter on February 17, 2016, 04:21:40 PM
How can I output fields in Text Export on separate lines, as indicated in this example:

{File.Name}    {File.MD.XMP::dc\title\Title\0}
{File.AT.Notes.Note}



I have searched help in both Variables and Export Text topics, but can find no reference to this.

You can't. The text export module produces one line (aka 'record') from each file you feed into it. Each line contains one to many columns and is delimited by the chosen line delimiter.
What you have in mind would require IMatch to produce two (or even more) records for each input file. This is outside of the design for the text export module. The text export's main purpose is to provide data for other applications and services in one of the common CSV, JSON or XML formats.

Ger

Use the Copy Data App. It's in the Help under the Sample Apps in the Apps panel.

Type your variables in the window, select the images you want to export, click copy and paste the results in the application you want to have it (e.g. text editor)

Example:
{File.Name}[tab]{File.Rating}
{File.AT.FotoGY.Page}

Result in the text editor for 2 images:
Image1      3.00
Page 2006-23
Image2      4.00
Page 2006-31

Aubrey

Quote from: Mario on February 17, 2016, 06:34:51 PM
Quote from: DigPeter on February 17, 2016, 04:21:40 PM
How can I output fields in Text Export on separate lines, as indicated in this example:

{File.Name}    {File.MD.XMP::dc\title\Title\0}
{File.AT.Notes.Note}



I have searched help in both Variables and Export Text topics, but can find no reference to this.

You can't. The text export module produces one line (aka 'record') from each file you feed into it. Each line contains one to many columns and is delimited by the chosen line delimiter.

Mario,
I suppose the same applies to the text in annotations. I was about to start a thread to ask this question.
One cannot define a new line  within the text. I thought \n might work but it doesn't

Aubrey

Mario

IMatch 'escapes' the content before exporting it. Otherwise a line-break character that happens to be in the text would ruin the resulting file, by adding new records in the middle of a record.

The text export module was not designed to allow you to output 'formatted' output, at least not when it comes to line feeds. All text formats have a special meaning attached to line feeds, and use it as a record delimiter.

If you would be a programmer I would suggest you output the data as JSON or XML and then transform it to get the format you need. Or to write a script which produces formatted text data from your records.

Otherwise, the Copy Data App allows you to copy formatted data into the clipboard. From there, paste it into whatever document/application you want.
See also this IMatch knowledge-base article:

http://www.photools.com/3211/copy-data-app-office-application/

and the IMatch help for more info about this powerful feature.

You may also check out the HTML Report, which produces HTML files. Here you can use HTML tags like <br/> to introduce line breaks if you want.

DigPeter

Quote from: Ger on February 17, 2016, 08:12:29 PM
Use the Copy Data App. It's in the Help under the Sample Apps in the Apps panel.

Type your variables in the window, select the images you want to export, click copy and paste the results in the application you want to have it (e.g. text editor)

Example:
{File.Name}[tab]{File.Rating}
{File.AT.FotoGY.Page}

Result in the text editor for 2 images:
Image1      3.00
Page 2006-23
Image2      4.00
Page 2006-31
Thanks for the input, Ger.  This is not transferable to Text Export - see Mario's posts.

Ger

I'm not sure what you want to achieve; but the Text Export module simply writes image information in variables to a text file. The Copy Data Apps basically does the same, but instead of writing to a text file, it copies the data to the Windows Clipboard. From there you can paste the information in different Windows applications. So you altogether skip the Text Export module.

DigPeter

Quote from: Ger on February 18, 2016, 01:38:12 PM
I'm not sure what you want to achieve; but the Text Export module simply writes image information in variables to a text file. The Copy Data Apps basically does the same, but instead of writing to a text file, it copies the data to the Windows Clipboard. From there you can paste the information in different Windows applications. So you altogether skip the Text Export module.
Thanks Ger.  I want to print out attribute notes for all selected files.  Some notes are long and do not fit conveniently in tabular format.  So for each file I want the file name and title on the first line and the notes starting on the 2nd line.

I have just tired the copy data app and it doe the job.  I was not aware of this before starting this thread.  IM is like Aladdin's cave - there are no end of treasures there!  Mario is the genie with the magic lamp.

Mario

Quote from: DigPeter on February 18, 2016, 04:46:55 PM
I have just tired the copy data app and it doe the job.  I was not aware of this before starting this thread.  IM is like Aladdin's cave - there are no end of treasures there!  Mario is the genie with the magic lamp.

I recommend you have a look at the IMatch knowledge base:

http://www.photools.com/category/imatch5/imatch-5-knowhow/

It highlights certain features, giving usage tips etc. You may find other features or actions which are useful for your work.

DigPeter