[dba-VB] Goin' for the (browser based) gold

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
> 
> 



More information about the dba-VB mailing list