dbTalk Databases Forums  

"Export to Filemaker" script step on server

comp.databases.filemaker comp.databases.filemaker


Discuss "Export to Filemaker" script step on server in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chap Harrison
 
Posts: n/a

Default "Export to Filemaker" script step on server - 07-06-2005 , 06:53 PM






Hi,

I have a report-generating script that uses Export Records to create a temp
file in the process. It worked fine in a single-user setting but when I
moved the database files onto Filemaker Server 5, the Export Records step
fails. The message is:

"'TempFile.fp5' could not be created on this disk. Use a different name,
make more room on the disk, unlock it, or use a different disk."

I don't have direct access to the server, but I am reasonably sure that (a)
the file name is not the problem; (b) there is plenty of room on the disk;
(c) it is not a case of unlocking the file because the export step is
actually creating the file; (d) most likely the problem has to do with
trying to create a file on the server.

Is what I'm trying to do reasonable? Should it be redesigned for a server
environment? I realize there could be a can of worms if multiple users
tried to run the script at the same time, but only one person will be able
to run the script in this situation.

Most gratefully,
Chap


Reply With Quote
  #2  
Old   
42
 
Posts: n/a

Default Re: "Export to Filemaker" script step on server - 07-06-2005 , 08:27 PM






In article <BEF1D940.3F0A%clh (AT) pobox (DOT) com>, clh (AT) pobox (DOT) com says...
Quote:
Hi,

I have a report-generating script that uses Export Records to create a temp
file in the process. It worked fine in a single-user setting but when I
moved the database files onto Filemaker Server 5, the Export Records step
fails. The message is:

"'TempFile.fp5' could not be created on this disk. Use a different name,
make more room on the disk, unlock it, or use a different disk."

I don't have direct access to the server, but I am reasonably sure that (a)
the file name is not the problem; (b) there is plenty of room on the disk;
(c) it is not a case of unlocking the file because the export step is
actually creating the file; (d) most likely the problem has to do with
trying to create a file on the server.
Actually, its trying to export the file to the local hard drive, the
machine where Filemaker Pro is running, not on the Filemaker Server at
all.

A possible simple solution would be to create a shell tempfile.fp5 and
host it on the server, and then have the script open it, purge it, and
then *import* to it. This way you are just 'using' a file hosted on the
server, instead of actually creating one on the fly.

HTH.




Reply With Quote
  #3  
Old   
Chap Harrison
 
Posts: n/a

Default Re: "Export to Filemaker" script step on server - 07-06-2005 , 10:16 PM



On 7/6/05 8:27 PM, in article
MPG.1d3624e148866413989bba (AT) shaw....shawcable.net, "42"
<nospam (AT) nospam (DOT) com> wrote:

Quote:
Actually, its trying to export the file to the local hard drive, the
machine where Filemaker Pro is running, not on the Filemaker Server at
all.

A possible simple solution would be to create a shell tempfile.fp5 and
host it on the server, and then have the script open it, purge it, and
then *import* to it. This way you are just 'using' a file hosted on the
server, instead of actually creating one on the fly.
Thanks for correcting me about where the file is being created! I should
probably let it show the user a Save dialog for the export file - who knows
what location it's defaulting to.

I'll keep in reserve your suggestion about a permanent tempfile shell. If I
can get it to create the tempfile on the local disk, without incurring too
much performance hit from the network, that would be preferable.

Thanks again,
Chap



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.