You could use MooPlug (
http://mooplug.com) a free windows plugin to do this.
More specifically use the Moo_FolderList() function to return a list of
all text files in the import folder, then loop through them, import and
then delete if required.
Adam Dempsey
(MooPlug Developer)
Message: 10
Date: Fri, 3 Jul 2009 00:33:15 +1000
From: Stephen Bennett <
[hidden email]>
Subject: Importing .txt file with variable name
To: Filemaker Experts <
[hidden email]>
Message-ID:
<
[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1
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__________ Information from ESET NOD32 Antivirus, version of virus signature database 4209 (20090702) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com--
This email and any attachments are confidential. It is intended for
the recipient only. If you are not the intended recipient, any use,
disclosure, distribution, printing or copying of this email is
unauthorised. If you have received this email in error please
immediately notify the sender by replying to this email and delete the
email from your computer.
The contents of any attachment to this e-mail may contain software
viruses which could damage your own computer system. While we have
taken every reasonable precaution to minimise this risk, we cannot
accept liability for any damage which you sustain as a result of
software viruses. You should carry out your own virus checks before
opening the attachment.
Mark Wilkinson Furniture a Division of Canburg Ltd
Registered Office 207 Marsh Wall London E14 9YT.
Registered in England & Wales, Number 6841786
Telephone 01380 850004 Fax 01380 850184 www.mwf.com
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
