Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automating data transfer procedures for a Visual Foxpro
Message
 
 
À
09/11/2000 11:15:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00439715
Message ID:
00440628
Vues:
18
Hi Mario,

I appologize for not answering you promptly enough. When I received you e-mail at work, I was in the middle of the code changes in one of my program, so I could not be interrupted.

Anyway, I basically was going to propose the same, as Houston proposed. I tried Nigel class for Outlook Express and for GroupWise, it works great. I didn' try for Eudora (don't have it installed), so can not garantee the success, but hopefully, this class would work for Eudora too.

You design idea looks good for me too, I would add one logical field in your table lSent and mark it as true (.t.), if file was sent and you received a confiramtion. Then you don't need to process filew for lSent=.t. and can delete those records.

Hope this helps and don't hesitate to ask your questions.

BTW, from my point of view your English is good enough.

>Hi Everyone, greetings from Nicaragua! Tierra de Lagos y Volcanes, I wrote this thread because I want to hear from you any suggestion about the following particular case:
>
>Business: Money Transfer Company
>Location: USA – Nicaragua – Costa Rica – Honduras – Guatemala - Salvador
>Base Language System: Dataflex 2.3
>
>ACTUAL WORKING ENVIRONMENT
>
>A given Client from a given country sends Money to a fellow in another country, Data is processed and stored into a table.dbf, every two hours Data is sent to the destination country where the money has to be deliveried to the target client, for this purpose, Dataflex generates separated Zip files including the particular information every office needs to carry out its money transfers, all Zip files are generated into a single directory named c:\mail. A common Zip file could be named (for example) : USA15115.NIC , This nomenclature indicates the information comes from USA, November 15th, goes to Nicaragua and this is the fifth sending in the current day.
>
>Every two hours, We send all this information to as many branches as money transfers we have received. To do this, one have to use EUDORA, choose the e-mail address of the branch where the client is around, then press the ATTACH button, browse the PC looking for the C:\Mail Directory, then choose the necessary Zip file among thousands of zip files located on this directory. To be able to choose the right zip file, one have to remain the above nomenclature.
>
>If one single country can have 30 different branches, and the information is sent to this individual branches EVERY TWO HOURS , the risk to choose the wrong file is high since all this procedure is done manually, in fact, the procedure itself is wrong since one have to use EUDORA and choose one by one every e-mail address for the target branch on the destination country.
>
>Since I am designing a new computer system for this company, I want to change the entire process from manually to automated, for this purpose, I have the following idea.
>
>PROPOSAL
>
>Base Language System: Visual Foxpro
>
>1 – Create the following directory structure:
>
>c:\mail
> \Nicaragua
> \branch1
> \branch2
> \branch3
> \branch4
> \Costa Rica
> \branch1
> \branch2
> \branch3
> \branch4
> \USA
> \branch1
> \branch2
> \branch3
> \branch4
>
>2 – Take care the new system generates the Zip file on every directory for the destination branch.
>
>3 – I can design a Table where I can store the individual e-mail address for these branches,
>this table would have a structure like this:
>
>Country Directory branch branch dir e-address
>
>Nicaragua \mail\nic Montoya \mail\nic\mont montnic@mail.com
>Nicaragua \mail\nic Masaya \mail\nic\masay masaynic@mail.com
>
>USA \mail\USA Miami \mail\usa\miami miamiusa@mail.com
>USA \mail\USA Texas \mail\usa\texas texasusa@mail.com
>
>...and so on.
>
>4 – Get an e-mail program capable of interpreting this table so that when I Press the key “SEND”, the program takes whatever it finds on each subdirectory and send it to the target office (as attachments) using the e-mail address in the table.dbf.
>
>If this could be possible, all I would have to do is put the files on each subdirectory and the e-mail program would do the rest. Then, after the sending is ok, I would move these zip files to another directory called c:\sentdata and the subdirectories would remain empty ready for the next sending.
>
>Now what I want from you is:
>
>Do you know about a software capable to do what I need?
>If not, Could I contact a software engineer who cuould design the software for me?
>If yes, where can I contact him/her?
>Do you have any better idea to carry out my information transfer?
>
>I apologize for my poor English, this is noy my native language.
>Hope to hear from you soon, thanks in advance.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform