jwcolby
jwcolby at colbyconsulting.com
Wed Mar 17 10:49:16 CDT 2010
> As Shamil suggests, let this app (win- or webform) communicate with a web service you set up. LOL, all I have to do is learn how to do web services. John W. Colby www.ColbyConsulting.com Gustav Brock wrote: > Hi John > > OK, then you could create a standard WinForms application and deploy it as a ClickOnce application. It works extremely well. > See the old threads (subject: ClickOnce) from 10. and 24. of Oct. 2008. > > However, as this sounds so simple a UI, you could as well consider this being your first web application. The advantage is, of course, zero installation at client side. > > As Shamil suggests, let this app (win- or webform) communicate with a web service you set up. > > /gustav > > >>>> jwcolby at colbyconsulting.com 17-03-2010 16:30 >>> > I can do that. I am looking more toward something that runs directly on their computer, takes the > list, shovels it across the internet, processes the data and hands back a count. They are pretty > much just looking for something like: > > Zip Cnt : Household Count : Population > 56 127,435 437,329 > > Thus if I can devise a program that runs on their machine, talks to my servers, feeds a zip list > across to my server, receives these counts back and displays them I am gold. This would allow me to > potentially get rid of a bunch of stuff on my end. ATM I have to: > > 1) Create a working directory using the order number > 2) Save the spreadsheet they send me into that directory > 3) Copy a template database to the name of the order (not strictly required but what I am doing) > 4) Import the data into that order database > 5) Run the queries and get the counts > 6) Paste the numbers into email and send the email. > > This whole thing could be shrunk down to (on my end): > > 1) Receive a stream of zips and save to a standard database. > 2) Run the queries and send back the numbers > > No more manual labor (on my end), no order directories, no order databases, no email. > > I am thinking a "service" as Shamil suggested, talking to a C#.Net program running on their computer. > > They would be THRILLED with this. > > John W. Colby > www.ColbyConsulting.com > > > Gustav Brock wrote: >> Hi John >> >> Too bad. >> Could you persuade the client to send the file via FTP to your server? Then you could have a folder change service running picking up the uploaded file and pass it on to be processed. >> >> /gustav >> >> >>>>> jwcolby at colbyconsulting.com 17-03-2010 16:00 >>> >> It appears that ordinarily they get a list of zips directly from their client, in a CSV. >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> Gustav Brock wrote: >>> Hi John >>> >>> The big question is how the lead data get into the worksheet. Are they extracted/exported from somewhere or are they typed in manually? >>> >>> If the latter, they could as well type data into a (web)form of yours. If you are not in the mood for creating your first web application, the simple method is to create a winform in a small Windows app which you leave running on a (virtual) machine for which you grant the client remote access. A splendid and free method for this is to use LogMeIn Free. >>> >>> /gustav > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >