Export File

HI

I need to export or create a file on a specific path folder on the server
HD... in FM6 I was using the file plugin 1.2 by Troi and it work perfecly...
now all I want to do is to create a text file with 2 fields without having
to upgrade another plugin, just to do a simple task.

with this exact format

User_name (and I need a carriage return HERE)
Texte_Field

This is require to send SMS message to a pager service on the server.
The export fonction doesn't support the "return" even if it's in the field,
when the export file is create, and it will always export all the found set,
is there a way to export the carriage return and only export the current
record ?? without having to create a script that will make a found set of
this record only.

Thank you

JF

Re: Export File

In article , "JF Fortier"
wrote:

> HI
>
> I need to export or create a file on a specific path folder on the server
> HD... in FM6 I was using the file plugin 1.2 by Troi and it work perfecly...
> now all I want to do is to create a text file with 2 fields without having
> to upgrade another plugin, just to do a simple task.
>
> with this exact format
>
> User_name (and I need a carriage return HERE)
> Texte_Field
>
> This is require to send SMS message to a pager service on the server.
> The export fonction doesn't support the "return" even if it's in the field,
> when the export file is create, and it will always export all the found set,
> is there a way to export the carriage return and only export the current
> record ?? without having to create a script that will make a found set of
> this record only.

Create a separate Table with a single Text field, and only ever two
records.

When you want to crate the export file, you then go to this table and
set the two records with the appropriate data - one with that has "User
Name" in the Text field and one that has "Text" in the text field. Then
export the file from this Table.

FileMaker will automatically put the carriage return character between
the records itself ... or at least it will on the Mac. On Windows you
might get an extra "End of Line" character in there which might cause a
problem, but test it and see what happens (I rarely use Windows).



Another way would be to have a script that exports the data to a
temporary folder with a unique string instead of the carriage return
(eg. "*-*-*"). The the FileMaker script runs an AppleScript or Windows
equivalent that uses a text manipulator like Grep to replace the
"*-*-*" with a carriage return and move the file to the correct folder.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)