Hi Chris,
Although not quite what you were thinking, As part of playing around with my VoIP PBX a couple of years, I wrote a phone call attendant based program on DP. Unfortunately I do not have any small business that it now applies to, but as a learning exercise I took an old customer's database as the starting point. The database used to manage, production, marketing, customers, and invoicing so was the main source of information for the company. Each customer was assigned an employee as their main contact, but also the last order could have a different employee as the contact. When an incoming phone call comes in, the PBX (an Epygi Quadro CX) makes an HTTP request to a server (an Apache web server) with the phone number of the caller as a parameter. The server starts DP and returns an XML document to the PBX which tells it to which extension to route the call. If the caller ID found a match in the database it routed the call to that extension, meaning that either the person handling their current order, or the person who normally looks after that account would get the call. The whole thing just took one additional report from DP and the addition of the extension number to the employees record. A very simple phone app. But back to your point, gone are they days when we have powerful apps as small as DP. Despite Windows initial promises to developers (and other since) that it would provide the core API's and so programmers needed to write only small amounts of code to make their programs functional, programs have continued to bloat. I remember back to my old Commodore64 with a small spreadsheet program that I typed in from a magazine article in machine code; the code took up about 8k and at the time I thought that was an absurdly huge amount of typing to do. In today's modern languages its hard to get a "Hello World" that would take up less space. Bye Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Chris Pedersen Sent: Wednesday, 22 September 2010 2:44 AM To: [email protected] Subject: Re: [Dataperf] DataPerfect limitations/suggestions To me, the logical application for DP is phone apps. DP has to have about the smallest footprint of any db. _____ From: [email protected] To: [email protected] Date: Wed, 15 Sep 2010 02:55:51 +0000 Subject: Re: [Dataperf] DataPerfect limitations/suggestions I keep meaning to do this.... I get about half way.. .. never get over the mountain.. still thank you again.... Once again it looks *real* cool. Thank you again Brian. Chris _____ From: [email protected] To: [email protected] Date: Wed, 15 Sep 2010 11:09:18 +1000 Subject: Re: [Dataperf] DataPerfect limitations/suggestions Hi Chris, If you web enable DP, you can create queries from Excel. Either as HTML tables or as XML documents. You can readily web enable DP on a local machine, it is the easiest way. Excel can be arranged to poll DP either on opening or through timers, to get near real time data. DP not being event driven cannot "push" data back to a client, you cannot make a persistent connection. The sample tutorial at http://www.brileigh.com/dpweb/tutorial/ includes everything you need to get started on a Windows machine, showing installs, sample databases, script libraries, and details on how it all hangs together. If you do not want the Apache server to be running on the same machine you can map a drive and access the data. It really is not such a big deal, once you get your head around the basics. Web enabling DP really does unshackle you from many of its limitations, but still keeping the ease and reliability. I have had web applications now running for 5 years without a glitch, and zero unplanned downtime. Planned downtime has been the few minutes needed to upload new functionality, changes to reports, new and changed panels, etc. In fact probably less downtime is needed than say most "normal" DP applications, because you write it differently so that the STR for small mods such as reports be made offline, and the STR can be quickly copied over. My last web application was populating a PDF enrolment form, with dynamic data to and from DP. The DP part took negligible time, and it served thousands of users over a few days, again without a glitch. Bye Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Chris Pedersen Sent: Wednesday, 15 September 2010 8:02 AM To: [email protected] Subject: [Dataperf] DataPerfect limitations/suggestions 1. DP has a txx file limitation call it of 500Mb (not exactly right, but close). Can this be increased - I've got a couple of apps sitting at 300M+ 2. DP doesn't work if you print records that are too wide. Something like 255 characters is the limit. And it doesn't fail gracefully.. 3. I'm not at all up to speed on this question: DP used to be able to exchange information via the DP shell. Could a wrapper be written to allow dp to think it was working inside the dp shell, while to the outside world appearing as a dCOM object (or whatever microsoft is calling it today.). Basically, have dp drive real time updates to an excell spread sheet for example, or an acad dwg. _____ Date: Tue, 7 Sep 2010 09:50:43 +0200 From: [email protected] To: [email protected] Subject: Re: [Dataperf] Christchurch Earthquake Charles . . . Colin is in the door business. Buildings needing to be rebuilt, repaired and etc. can only be good for business assuming his factory wasnt badly hurt which it doesnt sound like it was. Don 2010/9/7 Charles G. Wolf <[email protected]> Hi Colin, Good to hear from you. How is your home and business? Charlie Colin Roberts wrote: Hi Charlie, Don, Brian and All, Thanks for your concern - Annaleys and I just got back late last night from a relaxing cruise and a few days in Singapore - so missed all the action - but all family is safe and sound here. Brian and Don summed it up pretty well, its infrastructure and services that is going to take sometime to get sorted. Our earthquake building code is pretty stringent but there are still many buildings which were built before those requirements were brought in. We spent over $80,000 just on the foundations of our beach property north of Auckland to meet the current requirements three years ago. A lot of money to pour into the ground for a once in a lifetime event, but in times like this, one does re-assess the value of doing so. I think the buildings suffering major structural damage would have not been a surprise to the engineers currently accessing the damage in the Christchurch area. Those ones built to the new codes, I believe, have little if any damage. Still it is remarkable that there wasn't loss of life. Timing is everything. At 4.30am the streets were pretty much deserted but there were a few close calls with falling chimneys and roofs etc collapsing inward into bedroom and living areas of homes. Regards Colin Roberts Auckland NZ ----- Original Message ----- From: "Charles G. Wolf" <mailto:[email protected]> <[email protected]> To: "DataPerfect Users Discussion Group" <mailto:[email protected]> <[email protected]> Sent: Sunday, September 05, 2010 4:10 AM Subject: [Dataperf] Colin Roberts Hi Everyone, Has anyone heard from or about Colin Roberts? He lives in New Zealand, and I think it may be Christchurch. As you may have heard, yesterday, they had a 7.0 earthquake. The news says no one has died, which is encouraging. Colin organized our last DP conference in 2004. Charlie Wolf __________ Information from ESET NOD32 Antivirus, version of virus signature database 5414 (20100901) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com <http://www.eset.com/> ---------------------------------------------------------------------------- ---- _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf __________ Information from ESET NOD32 Antivirus, version of virus signature database 5414 (20100901) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com <http://www.eset.com/> _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
