Apr 02
Mike Dano [FMPro] Automating import of Excel file with changing name?
Apr 02, 2012; 03:39
Mike Dano
[FMPro] Automating import of Excel file with changing name?
I have a customer that is emailing an Excel file once per week. Each week
the name of the file changes. I need to import the file into a FM database
and I need to auto-fill a field with a file=B9s name. Can this be done from
FMS11A without 3rd party plug-ins?
Somehow I need to get the files onto the computer. I was thinking that I
could just run Apple=B9s mail program and save the attachments to a folder
that triggers the import script when the folder=B9s contents changed.
Two things have me stumped:
1.) How can I import a file with a script if the file name is unknown.
2.) How do I move the file after it has been imported to prevent it from
importing multiple times?
Thanks.
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>
Apr 02
Edwin Bullock Re: [FMPro] Automating import of Excel file with changing name?
Apr 02, 2012; 11:55
Edwin Bullock
Re: [FMPro] Automating import of Excel file with changing name?
Apr 02
Mike Dano Re: [FMPro] Automating import of Excel file with changing name?
Apr 02, 2012; 07:11
Mike Dano
Re: [FMPro] Automating import of Excel file with changing name?
Apr 02
Agnes Riley Re: [FMPro] Automating import of Excel file with changing name?
Apr 02, 2012; 09:56
Agnes Riley
Re: [FMPro] Automating import of Excel file with changing name?
Apr 02
Diana Simonson Re: [FMPro] Automating import of Excel file with changing name?
Apr 02, 2012; 10:03
Diana Simonson
Re: [FMPro] Automating import of Excel file with changing name?