File Name by Calc

[Francisco Soto]

Hello List,

I need to export data comma separated and need to assigned a different
name to the each output file.  Any idea?

Thank You,

F.Soto
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[esaline]

In FileMaker 5 we exported the file titled Untitled.xls then renamed  
it using an external plugin called Troi File Plugin.  It allowed us to  
name it with any calculation or field contents we wnated.  I am sure  
there is something similar in FileMaker 9 or higher.


On Nov 4, 2009, at 8:35 AM, Francisco Soto wrote:

> Hello List,
>
> I need to export data comma separated and need to assigned a different
> name to the each output file.  Any idea?
>
> Thank You,
>
> F.Soto
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Ibrahim Bittar Torres]

Hi Francisco

FM Version?

Saludos

Ibrahim Bittar Torres
Director General
Eikonsys
FileMaker 10 Certified Developer
http://www.eikonsys.com
FileMaker Business Alliance




On 04/11/2009, at 10:35, Francisco Soto wrote:

> Hello List,
>
> I need to export data comma separated and need to assigned a different
> name to the each output file.  Any idea?
>
> Thank You,
>
> F.Soto
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Francisco Soto]

my version is 10

2009/11/4, Ibrahim Bittar Torres <[hidden email]>:

> Hi Francisco
>
> FM Version?
>
> Saludos
>
> Ibrahim Bittar Torres
> Director General
> Eikonsys
> FileMaker 10 Certified Developer
> http://www.eikonsys.com
> FileMaker Business Alliance
>
>
>
>
> On 04/11/2009, at 10:35, Francisco Soto wrote:
>
>> Hello List,
>>
>> I need to export data comma separated and need to assigned a different
>> name to the each output file.  Any idea?
>>
>> Thank You,
>>
>> F.Soto
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

--
Blog: sotopaz.blogspot.com
Chat: [hidden email]
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Darren Terry-3]

On Nov 4, 2009, at 8:35 AM, Francisco Soto wrote:

> I need to export data comma separated and need to assigned a different
> name to the each output file.  Any idea?

Hi Francisco:

I would store the file's path and name in a variable like so:

Set Variable [ $path ; Case ( Abs ( Get ( SystemPlatform )) = 1 ;  
"filemac:" ; "filewin:" ) & Get ( DesktopPath ) & "theFileName" &  
".XXX" ]
// where ".XXX is the file extension you wish to use
Export Records [ $Path ]

In the Export Records script step, where you can specify an export  
file, you can type the path to the file there.  You can also type  
"$path" for a variable there, and the dialog will accept it.  Just  
construct the appropriate path in $path and you're in business.

regards,
Darren

******************************
  Darren Terry                               [hidden email]
  Pacific Data Management, Inc.              http://www.pdm-inc.com/
  111 W. St. John St.                      Phone: [phone] x303
  Suite 404                                  Fax:   [phone]
  San Jose, CA 95113
***** FileMaker 10 Certified Developer *****

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Francisco Soto]

Darren,

Thank you very much!  You made my day!
I have been reading posts for so long and never tried before posting a
question.  I feel I should do this often as there are so many people
on this forum with so much experience.

Thank You!

Francisco Soto
Dominican Republic

2009/11/4, Darren Terry <[hidden email]>:

>
> On Nov 4, 2009, at 8:35 AM, Francisco Soto wrote:
>
>> I need to export data comma separated and need to assigned a different
>> name to the each output file.  Any idea?
>
> Hi Francisco:
>
> I would store the file's path and name in a variable like so:
>
> Set Variable [ $path ; Case ( Abs ( Get ( SystemPlatform )) = 1 ;
> "filemac:" ; "filewin:" ) & Get ( DesktopPath ) & "theFileName" &
> ".XXX" ]
> // where ".XXX is the file extension you wish to use
> Export Records [ $Path ]
>
> In the Export Records script step, where you can specify an export
> file, you can type the path to the file there.  You can also type
> "$path" for a variable there, and the dialog will accept it.  Just
> construct the appropriate path in $path and you're in business.
>
> regards,
> Darren
>
> ******************************
>   Darren Terry                               [hidden email]
>   Pacific Data Management, Inc.              http://www.pdm-inc.com/
>   111 W. St. John St.                      Phone: [phone] x303
>   Suite 404                                  Fax:   [phone]
>   San Jose, CA 95113
> ***** FileMaker 10 Certified Developer *****
>
>

--
Blog: sotopaz.blogspot.com
Chat: [hidden email]
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Mike Duncan-2]

Or you can just set the variable like this:

"file:" & Get ( DesktopPath ) & "theFileName" & ".XXX"

and avoid the platform testing, this works cross platform.

On Wed, Nov 4, 2009 at 12:34 PM, Darren Terry <[hidden email]> wrote:

>
> On Nov 4, 2009, at 8:35 AM, Francisco Soto wrote:
>
>> I need to export data comma separated and need to assigned a different
>> name to the each output file.  Any idea?
>
> Hi Francisco:
>
> I would store the file's path and name in a variable like so:
>
> Set Variable [ $path ; Case ( Abs ( Get ( SystemPlatform )) = 1 ; "filemac:"
> ; "filewin:" ) & Get ( DesktopPath ) & "theFileName" & ".XXX" ]
> // where ".XXX is the file extension you wish to use
> Export Records [ $Path ]
>
> In the Export Records script step, where you can specify an export file, you
> can type the path to the file there.  You can also type "$path" for a
> variable there, and the dialog will accept it.  Just construct the
> appropriate path in $path and you're in business.
>
> regards,
> Darren
>
> ******************************
>  Darren Terry                               [hidden email]
>  Pacific Data Management, Inc.              http://www.pdm-inc.com/
>  111 W. St. John St.                      Phone: [phone] x303
>  Suite 404                                  Fax:   [phone]
>  San Jose, CA 95113
> ***** FileMaker 10 Certified Developer *****
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Darren Terry-3]

On Nov 5, 2009, at 8:38 AM, Mike Duncan wrote:

> Or you can just set the variable like this:
>
> "file:" & Get ( DesktopPath ) & "theFileName" & ".XXX"
>
> and avoid the platform testing, this works cross platform.

Hi Mike:

In my experience, that works cross-platform only for local files. For  
hosted files, it fails in my tests.  (For hosted files, the "file:"  
path points to the server that's hosting the file, which is almost  
never a valid export destination).

Thus, I find it much safer to use the more verbose platform-specific  
test.

regards,
Darren

******************************
  Darren Terry                               [hidden email]
  Pacific Data Management, Inc.              http://www.pdm-inc.com/
  111 W. St. John St.                      Phone: [phone] x303
  Suite 404                                  Fax:   [phone]
  San Jose, CA 95113
***** FileMaker 10 Certified Developer *****

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Mike Duncan-2]

I use this on hosted files, and on cross platform solutions, it works
fine. "file:" doesn't point back to the server at all, not sure where
you got that.

Maybe you're thinking of using something similar in a webveiwer url?

On Thu, Nov 5, 2009 at 2:11 PM, Darren Terry <[hidden email]> wrote:

>
> On Nov 5, 2009, at 8:38 AM, Mike Duncan wrote:
>
>> Or you can just set the variable like this:
>>
>> "file:" & Get ( DesktopPath ) & "theFileName" & ".XXX"
>>
>> and avoid the platform testing, this works cross platform.
>
> Hi Mike:
>
> In my experience, that works cross-platform only for local files. For hosted
> files, it fails in my tests.  (For hosted files, the "file:" path points to
> the server that's hosting the file, which is almost never a valid export
> destination).
>
> Thus, I find it much safer to use the more verbose platform-specific test.
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au