Importing .txt file with variable name

3 messages Options
Embed this post
Permalink
Stephen Bennett-3

Importing .txt file with variable name

Reply Threaded More More options
Print post
Permalink
Hi,

We have a file that is placed into out FTP server at random intervals.
The files are updates and additions to a file of 400000+ records
against which financial transactions are verified. The process is
currently a manual triggering of the script so that the user can
select the latest upload. The naming structure is
FILE_NAME_090701_00580.txt the next file will be
FILE_NAME_090702_00581.txt where FILE_NAME is always the same, 090702
is the date the file is created so ther may be several of these a day
and 00581 increments by one with every transaction. The import scripts
work fine but we would like to fully automate the process using a
plug-in to call the Filemaker script at 60 minute intervals. Does any
one have thoughts on how to acheive this? We are Filemaker 9.0 running
on server 9 Advanced Windows environment. We have a small .exe
programme that can remove the file once imported.

Thanks in advance EYET Team
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
VanBuskirk, Patricia

RE: Importing .txt file with variable name

Reply Threaded More More options
Print post
Permalink
I use ZippScript (a free plug-in) which works great.  The only caveat ..
we had to set up a FileMaker machine whose only purpose was to run the
script every 1/2 hr.  It needs to stay on all the time.



-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Stephen
Bennett
Sent: Thursday, July 02, 2009 10:33 AM
To: Filemaker Experts
Subject: Importing .txt file with variable name

Hi,

We have a file that is placed into out FTP server at random intervals.
The files are updates and additions to a file of 400000+ records
against which financial transactions are verified. The process is
currently a manual triggering of the script so that the user can
select the latest upload. The naming structure is
FILE_NAME_090701_00580.txt the next file will be
FILE_NAME_090702_00581.txt where FILE_NAME is always the same, 090702
is the date the file is created so ther may be several of these a day
and 00581 increments by one with every transaction. The import scripts
work fine but we would like to fully automate the process using a
plug-in to call the Filemaker script at 60 minute intervals. Does any
one have thoughts on how to acheive this? We are Filemaker 9.0 running
on server 9 Advanced Windows environment. We have a small .exe
programme that can remove the file once imported.

Thanks in advance EYET Team
_______________________________________________
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
Stephen Bennett-3

Re: Importing .txt file with variable name

Reply Threaded More More options
Print post
Permalink
Thank you very much, we have 5 servers on all the time so not an
issue, will give it a try.

On Fri, Jul 3, 2009 at 12:39 AM, VanBuskirk,
Patricia<[hidden email]> wrote:

> I use ZippScript (a free plug-in) which works great.  The only caveat ..
> we had to set up a FileMaker machine whose only purpose was to run the
> script every 1/2 hr.  It needs to stay on all the time.
>
>
>
> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of Stephen
> Bennett
> Sent: Thursday, July 02, 2009 10:33 AM
> To: Filemaker Experts
> Subject: Importing .txt file with variable name
>
> Hi,
>
> We have a file that is placed into out FTP server at random intervals.
> The files are updates and additions to a file of 400000+ records
> against which financial transactions are verified. The process is
> currently a manual triggering of the script so that the user can
> select the latest upload. The naming structure is
> FILE_NAME_090701_00580.txt the next file will be
> FILE_NAME_090702_00581.txt where FILE_NAME is always the same, 090702
> is the date the file is created so ther may be several of these a day
> and 00581 increments by one with every transaction. The import scripts
> work fine but we would like to fully automate the process using a
> plug-in to call the Filemaker script at 60 minute intervals. Does any
> one have thoughts on how to acheive this? We are Filemaker 9.0 running
> on server 9 Advanced Windows environment. We have a small .exe
> programme that can remove the file once imported.
>
> Thanks in advance EYET Team
> _______________________________________________
> 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
>
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au