RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

2019-04-23 Thread Kevin J Cully
I'm going to reply but in a different direction. Yes, this approach might require a DBA (or data structure change). I'm currently working on a system that has Pricing Calculation rules. These rules can be configured ahead of time to go into effect at a future date. For example, you can

RE: [NF] Looking for current summary of VFP clones

2019-03-14 Thread Kevin J Cully
I think this is key. You all know that I'm a huge Xojo fan, however I can't ever believe that rewriting an application for something other than a real concrete reason is a good idea. Basically if you are wondering if you should rewrite a VFP application, then the answer is "no" already. If

RE: [NF] Migrating Skills From Foxpro to Xojo

2019-02-25 Thread Kevin J Cully
may as well. -Kevin -Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kevin J Cully Sent: Friday, February 22, 2019 4:57 PM To: ProFox Email List Subject: RE: [NF] Migrating Skills From Foxpro to Xojo There's a lot there. I'm out of time for the day unfortunately

RE: [NF] Migrating Skills From Foxpro to Xojo

2019-02-22 Thread Kevin J Cully
a library of tools, forms and code across hundreds of similar custom applications. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin J Cully Sent: Friday, February 22, 2019 8:11 AM To: profoxt...@leafe.com Subject: RE: false news

RE: false news....

2019-02-22 Thread Kevin J Cully
Well, a lot of that article is correct, even though I don't want it to be. VFP as a *language* is as secure as the programmer programmed it to be. VFP as a *database* isn't secure itself. You can encrypt fields. You can encrypt the directory that the data is stored in. But DBF data isn't

RE: SPT and Remote Views

2018-11-07 Thread Kevin J Cully
I was looking for an old blog post but I couldn't find it. At times there may be a problem with the ODBC connection and using CAST(), especially with VARCHAR(max). If you ever experience problem using CAST() and accessing a field of type VARCHAR(max), take a look at CONVERT(). This will work

RE: IBM to buy RedHat

2018-10-30 Thread Kevin J Cully
Mailing List Subject: Re: IBM to buy RedHat On Oct 29, 2018, at 8:24 AM, Kevin J Cully wrote: > > On one side, I think this adds legitimacy to Linux operating in business here > in the USA, which hasn't seemed to publicly be Linux friendly up to this > point. On the oth

RE: IBM to buy RedHat

2018-10-29 Thread Kevin J Cully
Yes, I was a bit disappointed to hear the news. I always held up RedHat as a champion of Linux and as a successful business model riding on top of open source offerings. I like that. I would guess I'd say that I have guarded optimism. Unfortunately I think this is IBM's ball to fumble. On

RE: IMAP via VFP

2018-09-21 Thread Kevin J Cully
For sending email: https://www.mailgun.com/ -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, September 21, 2018 1:42 PM To: profox@leafe.com Subject: RE: IMAP via VFP And my research is telling me this is a silly request because

RE: alter column in sql server

2018-09-06 Thread Kevin J Cully
Take a look in the Downloads area for the Stru2PostgreSQL and Stru2MySQL_2 program. It should be pretty easy to modify those to get the structures generated. http://leafe.com/download/stru2postgreSQL.PRG http://leafe.com/download/stru2mysql_2.prg -Kevin -Original Message- From:

RE: Office 2016 Outlook Problem: Throttled Output

2018-09-04 Thread Kevin J Cully
Instead of using Outlook automation, and risking it breaking during every upgrade, and potentially being marked as a spammer, perhaps using a transactional email service might be an approach to consider. Depending on how many invoices you are sending, it could cost less than $40 per month.

RE: Sad news

2018-06-04 Thread Kevin J Cully
I didn't know John very well. I got to know him over a few days at the conference I was hosting called Fox Forward. John contacted me ahead of the conference and said that he couldn't afford the conference but asked if he could come up and just hang out in the hallway, not go to any of the

RE: Testing tells the tale (SYS 3054) -- "BETWEEN(a, b, c)" equivalent to "a BETWEEN b and c"

2018-03-19 Thread Kevin J Cully
I was working at a place that did ran batch processes at night using VFP. One of the managers came up to me and told me of a process that used to take 30 minutes now was taking 5 hours. Combined with the other processes, this meant we couldn't complete the processing overnight any longer and

RE: Automated email utility recommendations

2018-03-05 Thread Kevin J Cully
On Mon, Mar 5, 2018 at 12:49 PM, Kevin J Cully <kjcu...@cherokeega.com> wrote: > Hey Joe, > > I'm hearing a Ted-ism coming along as a "It depends", but ... > > 1. For sending massive amounts of individual emails to external email > addresses, look at a service

RE: Automated email utility recommendations

2018-03-05 Thread Kevin J Cully
Hey Joe, I'm hearing a Ted-ism coming along as a "It depends", but ... 1. For sending massive amounts of individual emails to external email addresses, look at a service such as Mandrill. (https://mandrill.com/) It costs money but will keep your domain from getting black-listed, keeping you

RE: Displaying Content on a TV

2018-02-21 Thread Kevin J Cully
I'd purchase a Raspberry PI. The power for this $30 computer can come from the USB port on the TV. Output from the Raspberri PI is from the HDMI port into the HDMI port on the TV. I'd have the Raspberry PI boot and load a browser full screen with no menu. That browser would be configured to

RE: Shrinking/compressing PDFs

2017-12-21 Thread Kevin J Cully
We use a PDF markup tool called BlueBeam. Within that program that have the ability to shrink PDFs. I think I remember there is a way to automate BlueBeam but I've never done it myself. Not free, but not badly priced either. https://www.bluebeam.com/ -Kevin -Original Message-

RE: [NF] Disappointed in Dell

2017-12-01 Thread Kevin J Cully
It's been a while since I've purchased a new computer from Dell. I have purchased a lot of refurbished computers from Dell however. It seems that their new order computers get a delayed delivery date, and then ... the computer will be delivered earlier and without notification and then ...

RE: How to monitor PCs on local Windows network???

2017-10-20 Thread Kevin J Cully
We use OpManager to manage our 1,000pcs and many servers. https://www.manageengine.com/network-monitoring/?MEtab -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Matt Slay Sent: Friday, October 20, 2017 1:08 PM To: profox@leafe.com Subject: How to monitor

RE: VFP - What upgrades would VFP10 have had...

2017-10-20 Thread Kevin J Cully
1. 64bit VFP IDE for access to virtually unlimited RAM 2. 64bit compiled applications 3. Simultanous compilation to multiple target platforms: Linux, Mac, Windows 4. Add the target platform of Web and allow me to cross use business objects I also use in desktop applications. 5. Make it as easy to

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-09-19 Thread Kevin J Cully
I use Radmin with one of my clients. $49 per PC as a one-time fee. The only trick is that you need to open a port on their firewall. The port can be of your choosing. Example: port 4899. I've used TeamViewer to connect to their PC, and then use their PC to connect to their firewall and set

RE: Curved monitors

2017-08-24 Thread Kevin J Cully
Our plan review people just got some big, high resolution monitors when looking at these incredibly detailed plans. I think these are the ones: http://www.dell.com/en-us/shop/accessories/apd/210-aiyz?c=us=19=en=210-AIYZ I think the idea was to have a curve to the monitor to keep the user from

[NF] Xojo 2017 Release 2 now available

2017-08-15 Thread Kevin J Cully
I thought this would be of interest to the ProFox members. Xojo 2017 Release 2 was released today. Release features include: * 64-bit support for XojoScript * 64-bit string handling is faster and more consistent * 64-bit support for Windows icons and version information * GTK3

RE: VFP9SP2 apps on Citrix

2017-08-14 Thread Kevin J Cully
Good luck. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, August 11, 2017 10:02 PM To: ProFox Email List Subject: RE: VFP9SP2 apps on Citrix On 2017-08-11 14:55, Kevin J Cully wrote: > W

RE: VFP9SP2 apps on Citrix

2017-08-11 Thread Kevin J Cully
We used Citrix at a healthcare company I worked at around 2005. Basically everyone came in to an office, just to telecommute into our hosted servers that was in a city 30 minutes north of our office. It was a valid approach to better securing workstations. I was doing a good bit if VFP9 at

RE: [NF] FileMaker Pro

2017-08-01 Thread Kevin J Cully
I know a lot of FileMaker developers that are abandoning FM because of the outlandish licensing fees that FM/Apple are now charging. Here's a blog post (from 2015) about looking for a new development platform and eventually returning to Xojo. http://timdietrich.me/blog/going-with-xojo/ Web,

RE: Validating email addresses

2017-07-14 Thread Kevin J Cully
If you want to check if an email address is in a valid format, there are many RegEx expressions that you can use. Easy and free. If your client is sending out lots of emails and is worried about bounces and "Unsubscribe" functionality, then I'd use a mailing service such as Mandrill by

RE: Syncing data locally from a remote database

2017-07-12 Thread Kevin J Cully
"It depends." - Ted Roche Why reinvent the wheel? https://mariadb.com/kb/en/mariadb/setting-up-replication/ What is an acceptable delay in the replication process? And what is the size of the data and how much data is changing daily? Hourly? -Kevin -Original Message- From: ProFox

RE: [NF] What do you use to manage your clients & notes/work for each?

2017-07-12 Thread Kevin J Cully
uage', but there doesn't seem to be one for Linux unless you subscribe to some proprietary system. If you are the former (like me), what O/S, Language, Database did you use? I've been looming for about 22 years. John On 07/11/2017 01:22 PM, Kevin J Cully wrote: > When I started my business in

RE: [NF] What do you use to manage your clients & notes/work for each?

2017-07-11 Thread Kevin J Cully
When I started my business in 2000, I looked around and couldn't find anything that I like and was as integrated as I'd want. I ended up building my own system that had contacts, companies, projects, activities, invoices, and accounts receivable with reporting mostly to help pay taxes. Don't

RE: VFP and Gmail

2017-06-07 Thread Kevin J Cully
I think MailJet and Mandrill are offering similar services with a different pricing structure. Let me see if I can get this math correct for a couple of example scenarios. If you were to send out 1,000 emails per month ... ... for MailJet at $7.49/mo * 12mo = $89.88/year ... for Mandrill at

RE: [NF] Find table where last record was added

2017-06-06 Thread Kevin J Cully
dro...@gmail.com> wrote: > Is it possible you can turn on a log, make your change, turn it off, > and read the log? > > On Tue, Jun 6, 2017 at 4:46 PM, Kevin J Cully <kjcu...@cherokeega.com> wrote: >> Hello all, >> >> I'm trying to (partially) reverse engineer

RE: VFP and Gmail

2017-06-06 Thread Kevin J Cully
I'd recommend looking into a service such as Mandrill (by MailChimp). https://mandrill.com/ $20 / 25,000 emails. I've seen it demonstrated and it's wicked fast to send individual emails to individual recipients around the globe. For that price, it'd be worth the expense. -Original

RE: [NF] Sending Large Files...

2017-05-10 Thread Kevin J Cully
Of Stephen Russell Sent: Wednesday, May 10, 2017 1:13 PM To: ProFox Email List Subject: Re: [NF] Sending Large Files... What are the security concerns on either side when it is either on your side or theirs? On Wed, May 10, 2017 at 11:38 AM, Kevin J Cully <kjcu...@cherokeega.com> wrote: >

RE: [NF] Sending Large Files...

2017-05-10 Thread Kevin J Cully
Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Wednesday, May 10, 2017 12:19 PM To: ProFox Email List Subject: RE: [NF] Sending Large Files... On 2017-05-10 08:31, Kevin J Cully wrote: > I've been using this software for sending large video files between > computers in my organization. It's nice b

RE: [NF] Sending Large Files...

2017-05-10 Thread Kevin J Cully
I've been using this software for sending large video files between computers in my organization. It's nice because you aren't relying on a service by another company. Very fast at syncing files. https://syncthing.net/ -Original Message- From: ProFox

RE: [NF] Online databases

2017-05-02 Thread Kevin J Cully
I would recommend opening a DigitalOcean account, running a PostgreSQL database with either a NodeJS, or LEMP server. $5/month. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Garrett Fitzgerald Sent: Tuesday, May 02, 2017 7:22 AM To: ProFox Email List

RE: Text file import

2017-04-20 Thread Kevin J Cully
We had a file format that was coming from a mainframe where it was impossibly long line, but the first two characters told the line type. We knew the line wasn't more than 2000 characters long including the delimiters. We came up with this approach and it works blazingly fast with VFP. Step

RE: [NF] Gartner predicting things "dead" again and the user community reaction....deja vu?

2017-04-18 Thread Kevin J Cully
I think if you count the Raspberry Pi (and compatibles) then I think it may very well be the year of the Linux desktop. It might just be something different than what we were thinking when we said "desktop"! :P -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf

RE: Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)

2017-03-16 Thread Kevin J Cully
I've used Bullzip at several companies. The price is right. http://www.bullzip.com -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, March 16, 2017 12:43 PM To: ProFox Subject: Printing native VFP

RE: R.I.P. Marcia Akins

2017-03-14 Thread Kevin J Cully
A very sad day. I had the pleasure of getting to know Marcia and Andy over the years at many Foxpro events. Marcia was always quick to laugh and crack a joke. The love between Andy and Marcia was always apparent, especially when they gently were kidding each other after a few drinks. I'll

RE: [NF] Unbiased Cyber Security Resources

2017-02-24 Thread Kevin J Cully
I thought his main point was "don't bother scaring yourself, if you're not going to do anything about it." As Ted Roche always says "Security is a process". If you find a reasonable security hole, fix it reasonably. I leave it up to you all to determine what is 'reasonable'. -Original

RE: [NF] Unbiased Cyber Security Resources

2017-02-24 Thread Kevin J Cully
How about actively testing your systems with penetration testing? https://www.kali.org/ When being offensive is a good thing! -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Friday, February 24, 2017 4:19 AM To: ProFox Email List

RE: Copy Excel worksheet to another workbook

2017-02-17 Thread Kevin J Cully
I hadn't seen anyone mention this, but this class library may be helpful. Greg Greene was attempting to manipulate XLSX files without the need for Excel at all. https://vfpx.codeplex.com/wikipage?title=XLSXWorkbook=Home -Original Message- From: ProFox

RE: So what tech do you like to work in nowadays? (was Re: TaskPane entry for ProFox outdated)

2017-02-14 Thread Kevin J Cully
I'm going to chime in for Xojo ... again. I find it's really fun to develop in. I'm using it at my new job working with my county government. The Xojo web application that I built for them is "invaluable" for them to accomplish their job in the Building Department. Here's my check list: -

RE: [NF] LogMeIn Pro raising price to $149 from $99

2016-11-28 Thread Kevin J Cully
I've been using RAdmin with a client and it has been very reliable. You do need to set up port forwarding with the router. With TeamViewer you need someone on the other end to tell you what the password is each time you connect. RAdmin allows for remote connection at any time as long as the

RE: [NF] EXTERNAL SSD hard drives

2016-11-14 Thread Kevin J Cully
Remember not to plug in any USB 2.x devices into a shared USB 3.0 controller because all devices will then slow to the USB 2.x speed. Example: If you plug in a mouse beside the SSD External HD, you've just slowed down the speed of the HD. -Original Message- From: ProFox

RE: Do you rebuild your indexes every night or do you leave them alone.

2016-11-09 Thread Kevin J Cully
Every night? I've gone years without reindexing DBF tables. Perhaps I'm weird but if the network and server are in a good, healthy shape then I think that the CDXs can be left alone under a moderate load. -Kevin -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On

RE: Friday Poll: What framework(s) do you use?

2016-11-04 Thread Kevin J Cully
I've done some work with Codebook, but by far I've done the most work with the West-Wind Web Connection framework. I've even worked some of the classes into my desktop applications. Light weight framework that just clicked with the way I thought. I've had many many clients buy that framework

RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

2016-11-03 Thread Kevin J Cully
riday Poll (while dl'ing MS Flash Patch)) On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of

RE: Friday Poll (while dl'ing MS Flash Patch)

2016-10-28 Thread Kevin J Cully
X PostgreSQL - CULLYTechs system runs on PostgreSQL for years now without a hiccup. Big fan. X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a

RE: [NF] Save Video from cable TV

2016-10-18 Thread Kevin J Cully
You may want to look at a device such as this: https://amzn.com/B00TF9MCXU It would sit between your cable box and your TV to record the stream from the HDMI cable. I haven't tried this but was considering this for our users group(s). I could record any presentation (Windows / Mac / Linux )

RE: [NF] Looking for Alpha 5 (Alpha Anywhere) users

2016-09-08 Thread Kevin J Cully
When I walk into a store, and prices aren't listed on the products ... I know I'm out of my comfort zone. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren Sent: Thursday, September 08, 2016 10:09 AM To: profox@leafe.com Subject: RE: [NF] Looking for

RE: Flat file to Excel....but it's got more than 255 columns!

2016-08-18 Thread Kevin J Cully
Sweet. Thanks Tracy. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, August 18, 2016 3:26 PM To: profox@leafe.com Subject: RE: Flat file to Excelbut it's got more than 255 columns! 0 You can

RE: Flat file to Excel....but it's got more than 255 columns!

2016-08-18 Thread Kevin J Cully
Thank you for the help with that class Christof. I've converted it to be used in Xojo as well. Is there a way to do calculations into a cell in the export? Example: To put the formula "=SUM(D2:D10)" into a cell so Excel evaluates the expression? -Original Message- From: ProFox

RE: Flat file to Excel....but it's got more than 255 columns!

2016-08-18 Thread Kevin J Cully
Thinking outside of the box... Don't use the Excel automation. Convert the flat file into an XML string, and spit that out into a file named "MyFile.xls" and then have Excel open that. It'll be wicked fast. Excel will load the XML as if it was an Excel spreadsheet. I think Christof had a

RE: Common File Document Validation

2016-08-18 Thread Kevin J Cully
Not a silly question. Some background: We have to archive documents for various lengths of time. For a murder case, it's basically forever. When searching for a file from 2007, the file wasn't valid. Not a problem in this case in that they still had the hard copy of the file so they

RE: Common File Document Validation

2016-08-17 Thread Kevin J Cully
The thought was to keep an MD5 of each file (or similar), and if that changes then trigger the actual validation. First run would be intense, but most files don't change much. Perhaps ever. It's funny you mention LibreOffice, because a suggestion I received was to use the command line tool

Common File Document Validation

2016-08-17 Thread Kevin J Cully
I work in a Windows Network environment. We're interested in purchasing or building a system that does document validation on our documents across our servers. We're needing a system that goes through our servers and file systems, logging directories of documents, performing a hash on the file