ProFox March 2016

profox@leafe.com

53 participants
65 discussions

Need help with parsing XML
by Paul Newton 30 Mar '16

30 Mar '16

Hi all I have the following simplified XML <Formats> <Bank id="1" name="AIB"> <Content text = "line1" value="value1"/> <Content text = "line2" value="value2"/> </Bank> <Bank id="2" name="Barclays"> <Content text = "line1" value="value1"/> <Content text = "line2" value="value2"/> <Content text = "line3" value="value3"/> </Bank> </Formats> With the following code I can iterate through the banks and display their names as follows goXML = CREATEOBJECT('MSXML2.DomDocument') goXML.Load("Formats.XML") gcolElements = goxml.getElementsByTagName("Bank") For Each element In gcolElements ? element.attributes.item(0).text,element.attributes.item(1).text EndFor But for each bank I need to iterate through the content entries for that bank and extract the text and value attributes. So far I cannot see how to do it. Any suggestions would be very welcome Many thanks Paul Newton

7 15

Used ReFox...CVW files?!??
by mbsoftwaresolutions＠mbsoftwaresolutions.com 30 Mar '16

30 Mar '16

On my way out the door now but wanted to start a thread on this. Used ReFox on Jeff's EXE and it seems to have worked for the most part (at least it extracted files and folders). I'll review them later today but noticed a bunch of files with a CVW extension. Binging it shows it to be a CaseView document type. Never heard of that one. Anybody here ever use Caseview documents? https://www.bing.com/search?q=CVW%20files&qs=n&form=QBRE&pq=cvw%20files&sc=…

2 1

Email using .NET
by Laurie Alvey 30 Mar '16

30 Mar '16

I currently use CDO to send email from my apps but I'm thinking of using a .NET component to do it. I have little experience with .NET and none using .NET Interop. I've got Visual Studio Express 14.0 and VFP 9.0 SP2 and would appreciate any pointers. Laurie --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 10

Re: [NF] VoIP Phone Systems and PSTN Signalling
by Ken Dibble 29 Mar '16

29 Mar '16

We took a bid from an Asterix vendor. I actually would have preferred a Linux-based system, but they were even smaller and less experienced than the vendor we went with. >I think folks have gotten pretty lackadaisical with "acceptable level >of service" for computers these days. The phone industry operates at a >different level. > >I hope you've got some good leverage in emphasizing this message to >your vendor. > >I know a few locals who design/build/install/support Asterisk >installations and them tell me it's a tough business. > >On Tue, Mar 29, 2016 at 12:40 PM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > > Thank you to everyone who responded. > > > > I spent most of the day yesterday researching this. I think the problem is > > related to implementation of "early media" and SIP Code 183 messaging. We > > are not using SIP trunks; we are interfacing with the PSTN via a Level 3 > > (formerly Time-Warner Telecom) PRI. I think there is/are a configuration > > issue(s) related to this messaging somewhere either in the Level 3 service, > > the Patton gateway, the 3CX VoIP software, and/or the YeaLink phones. > > > > This vendor lowballed the bid because, in part, they were not highly > > experienced in this type of work. They're a white-box computer and IT > > administrative services vendor who only recently got into phone systems. > > Ours is, by a few orders of magnitude, the largest phone installation > > they've ever done, and they had only done a literal handful before us. We > > trusted them because they've been very good on strictly computer stuff. > > Their management is failing to accept that this is different: They did not > > sell us a server, software, switches and phones, separately. They sold us a > > phone *system*, and they are responsible for all aspects of the system > > functioning properly. > > > > Digital phone systems are also computers, and some of them, including the > > one we just replaced, also have separate hardware and software components. > > The fact that VoIP PBX software can run on a Windows computer > does not, IMO, > > change the "business model" with regard to the sale of phone systems in any > > respect. A digital PBX vendor would immediately accept responsibility for > > failing to deliver a properly-configured system and fix it, for no charge. > > > > I suspect that a more experienced provider would understand this > problem and > > would not have had much difficulty in getting the configuration(s) done > > correctly. This vendor, due to inexperience, underbid the > installation labor > > cost, and underestimated the difficulty of properly configuring our system, > > and is now trying to recoup its losses. > > > > I sympathize with them, but I am not going to pay them to learn how to > > design and install phone systems properly. > > > > Ken Dibble > > www.stic-cil.org > > > > [excessive quoting removed by server]

3 2

[NF] VoIP Phone Systems and PSTN Signalling
by Ken Dibble 29 Mar '16

29 Mar '16

Hi folks, If anyone here has worked with VoIP PBX systems (after all, I'm told, it's "just a computer"), can you answer this question? Is it an "industry standard" for these systems to fail to pass through basic signaling from the PSTN (public switched telephone network) to the ears of people using the phones? We recently purchased such a system and, while it transmit a "ringing" signal when we dial a number outside our system, it does not transmit "busy" signals when the line we dialed is engaged. It also does not transmit fax tones when we dial a fax number (useful for diagnosing faxing problems), nor does it transmit recorded audio from a phone company, such as "The number you have reached is no longer in service" (useful for what should be obvious reasons). The vendor claims that our expectations that a PBX phone system should do these things are unrealistic, and that if we want it fixed, we should pay for "support". My contention is that these failures are product defects that should be repaired under warranty. What is your experience on these things? Thank you very much. Ken Dibble www.stic-cil.org

5 6

problem with calculations with VFP9 and MSSQL Server
by rafael copquin 26 Mar '16

26 Mar '16

A few months ago I posted the following: quote I am selecting a bunch of invoices from a MS SQL Server table. I just want to add the total of all invoices. In the management studio I do this: Select sum(total) as total from terbo.dbo.invoices I get 212649.17 When I do the same calculation in VFP cCmd = ‘Select sum(total) as total from terbo.dbo.invoices’ sqlexec(thisform.nHandle,cCmd,’curTotals’) nTotal = curTotals.total nTotal is 212.65 How can I get the correct amount? unquote I would still know the answer to this problem, because the weird thing is that it only happens with the tables of just one database. That is, I have two similar databases, with similar tables. However, the vfp cursor obtained from this particular database table gives the above error where a similar table in another database does not. In both my Windows 10 and VFP9 SP2 the regional settings are a dot as a thousands separator, a comma as a decimal point and a semicolon as lists separator. These are the Spanish language settings for numbers The numerical fields in the tables are defined as numerical (18,2) not null with a default value of 0 A select statement such as this: cCmd = 'select invtotal from mydatabase.dbo.invoices where invid = '+transform(nPK) sqlexec(nHandle,cCmd,'curInvTotal') brings a cursor where a browse shows 12.256,85 (note the dot shown as a thousands separator. It should show as 12256,85) If I place the mouse over the invtotal column on the browse, the number shows as 12.25 I am really baffled and do not know what to do. Any leads on where to tweak the database on SQL Server, or configure the software would be appreciated Any help? Happy Easter Rafael Copquin Rafael Copquin

4 5

VFP9SP2 grid display nuisance
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Mar '16

24 Mar '16

http://screencast.com/t/dTqWXFqmr17W The data in the job name column appears to be top center justified, but as soon as you click in the column's textbox, it centers on the row as it should have displayed from the start. Anybody seen this and know how to resolve? tia, --Mike

4 3

ReFox to reverse compile a VFP9 EXE?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Mar '16

24 Mar '16

I'm trying to help one of Jeff Johnson's (RIP) customers and sadly, they don't seem to have the source code. (Good lesson to be learned here.) Can I use ReFox to somehow get the source code from the distributed EXE (assuming he didn't use ReFox to encrypt it)? Other suggestions? tia, --Mike

6 8

RE: An Excel Automation Insert Issue...
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Mar '16

24 Mar '16

On 2015-12-12 18:50, Richard Kaye wrote: > The one I specifically mentioned to Kurt, ASSERT .f., will. I used > this quite extensively just recently where I was working on a form > that, for better or worse, has a lot of optional configurations and > I'm moving or hiding controls. Sometimes I wanted to let the code run > after making some changes and other times I wanted to step through. > Using ASSERT .f. instead of SET STEP allowed me to do that as desired. I recall working for this insane woman at IDP in Wyncote, PA years ago who liked to rip me a new one every time I left my ASSERTS in code. She swore that the customer would see those messages. I showed her the VFP manual that clearly stated it's only in the VFP IDE.

1 0

Which server for VFP9 app
by Peter Cushing 23 Mar '16

23 Mar '16

Hi, We are currently running a VFP9 SP2 app on a windows 2003 server, which has been virtualised. We want to move to either 2008 server or preferably 2012 server. The app has a DBC and DBFs and has been running happily for over 10 years. The problem we have when transferring the data over to a virtualised 2008 or 2012 server is that we get index corruption once or more a day. We then have to move the data back. We have tried a few different configurations but do not know why this is happening. I just want to check what servers people are using for their networked VFP app and any problems (or not) they have had. Please let me know what version of windows you are using and what version of VFP and if the server is virtualised or not. TIA Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960

9 11

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox March 2016