Re: File transfer
- From: "Nicholas B" <NicholasB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 15:48:01 -0700
You could also use email for this sending + receiving files as attachments.
I'd suggest Outlook (Not Outlook Express) or idsMail. Neither this or the
FTP option is as simple as scripting but they're what you need for a solution
to be automated.
"Ian" wrote:
> Hi, thanks for your input. This is what I need:
> Say I'm the HOST store and I have 2 other stores A & B. I want to dial into
> store A and grab the daily activity files, then dial into store B and do the
> same thing. When I have all the files from both stores, I'm doing the Grand
> Daily Close (at the HOST updating database with all the transactions- HOST
> and REMOTES) then I want to dial back into both stores and update them
> (inventory, sales etc)
>
> "Edhy Rijo" wrote:
>
> > Hi Ian,
> >
> > If all you need is to poll some data and not get any information back to the POS system you can use an ftp site to host your transfer. I will give you just some ideas of what I would do:
> > a.. Conver your transfer data to XML, if using a database container an table with long field names, converting the data to XML with CURSORTOXML and XMLTOCURSOR will maintain the long field names in the XML file.
> > b.. If needed, compress the XML files using a library like DynaZip or any other, this way you'll only have to upload a single file.
> > c.. Upload the Zip file with any FTP library like the one from Rick Stralth.
> > At the Main Office have your program do the following:
> > a.. Download the Zip file from your ftp host folder.
> > b.. Uncompress the Zip file
> > c.. Go through all XML file and with XMLTOCURSOR convert them to a VFP cursor which you'll use to update the real data using an SCAN..ENDSCAN to validate each record with a primary key.
> > d.. After the validation, send a command to the FTP server to delete the zip file.
> > For the CURSORTOXML & XMLTOCURSOR make sure you create those with an SCHEMA file to make it easier for VFP use the correct data type, check these in the VFP help file.
> >
> > Good luck!
> >
> > --
> > Edhy Rijo
> > www.progytech.com
> > Bronx NY
> >
> >
> > "Ian" <Ian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F11775AB-7274-47CC-8071-B7C66D56DA4C@xxxxxxxxxxxxxxxx
> > > Hi,
> > >
> > > I need a piece of software (I used to use CrossTalk before) where I can
> > > setup some calls (for dialup / modem connection) and write some scripts for
> > > file transfer of certain files between remote locations. This is for a POS
> > > system with multiple stores that I need to update after the "Daily Close" (a
> > > pooling situation). Any ideea much appreciated.
> > >
> > > Ioan
.
- Follow-Ups:
- Re: File transfer
- From: Boas Enkler
- Re: File transfer
- References:
- File transfer
- From: Ian
- Re: File transfer
- From: Edhy Rijo
- Re: File transfer
- From: Ian
- File transfer
- Prev by Date: RE: how to use winsocket to transfer file in vfp?
- Next by Date: RE: Vfp8 and PDF
- Previous by thread: Re: File transfer
- Next by thread: Re: File transfer
- Index(es):
Relevant Pages
|