Re: [ADMIN] SSL Issues

2019-04-23 Thread Ed Leafe
On Apr 23, 2019, at 6:21 PM, Ted Roche wrote: > >> I have a dead link plugin for Wordpress that marks all the active, good >> links as broken . What is your blog running? > > https://wordpress.org/plugins/broken-link-checker/ Huh, that’s what I’ve been using. It finds dead links, sure, but I

Re: [ADMIN] SSL Issues

2019-04-23 Thread Ted Roche
On Tue, Apr 23, 2019 at 5:39 PM Ed Leafe wrote: > > I've got a great plugin that makes expired links pretty easy to manage, > > even suggesting a matching archive.org site when available. > > I have a dead link plugin for Wordpress that marks all the active, good > links as broken . What is your

Re: [ADMIN] SSL Issues

2019-04-23 Thread Ed Leafe
On Apr 23, 2019, at 2:36 PM, Ted Roche wrote: > >> BTW, I'm almost ready to release an entirely new website. I created the >> current one back in the early 2000s, and it is written in what was the >> leading Python framework of the day. Now that Python 2 is EOL'd, and that >> framework doesn't

Re: [ADMIN] SSL Issues

2019-04-23 Thread MB Software Solutions, LLC
On 4/23/2019 3:36 PM, Ted Roche wrote: I've been maintaining a 16-year-old blog and it is AMAZING how few links are left. I've got a great plugin that makes expired links pretty easy to manage, even suggesting a matching archive.org site when available. I'm sure that at least 23.7% of the

Re: [ADMIN] SSL Issues

2019-04-23 Thread Ted Roche
On Mon, Apr 22, 2019 at 11:11 PM Ed Leafe wrote: > > My Let's Encrypt certs auto-renewed over the weekend, and somehow the > https redirect was lost. I'll see about getting it corrected I've fixed up the permalinks from my side. > BTW, I'm almost ready to release an entirely new website. I

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

2019-04-23 Thread Ted Roche
What Kevin said, but in the opposite chronological direction, looking back instead of forward. (We do have a forecasting and analysis and price list management module, but history is simpler than that.) In our vertical, order details have individual rows for each: items, quantities AND THEIR

Re: Landscape PDFs using XFRX

2019-04-23 Thread Joe Yoder
I reread what what I wrote and realize that The first sentence should have been "Using XFRX in VFP to convert Reports to create PDF files" - sorry - Joe On Tue, Apr 23, 2019 at 1:33 PM Joe Yoder wrote: > I have an older version of XFRX that I am converting to create PDF files > instead of

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

Landscape PDFs using XFRX

2019-04-23 Thread Joe Yoder
I have an older version of XFRX that I am converting to create PDF files instead of printing reports directly. All reports are working well except the one that requires Landscape output. Apparently XFRX just ignores the printer orientation information in the Tag1 and Tag2 fields in the Report.frx

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

2019-04-23 Thread Fletcher Johnson
Mike, Your question has evoked answers that address 2 separate issues. 1) How are changes to data saved so an audit can identify who changed what and when? 2) How can someone have time appropriate data? For the first, the answers on audit all appear quite good. Separate tables that can be

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

2019-04-23 Thread Stephen Russell
I think you need to focus on the request to define a history of item prices. I wouldn't go into triggers to do this but actually do it via code. You have a history of an item's price over time via your Orders detail currently. Just query that table for the minimum date for that item & price.

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

2019-04-23 Thread Charlie-gm
Some good points below. But lets clearly delineate the requirement responsibilities. Many business cases are addressed by "dating" data elements. Price is a good example, but it could be anything (I did applications that had "text explanations/rules" that could change on a monthly basis).

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

2019-04-23 Thread Frank Cazabon
In my experience the date of the price change is important. So I maintain a table with the price and a date. Invariably someone makes a mistake and puts the wrong date in so they need to go back and change it. In the scenario you seem to be not letting the user put the correct date but are

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

2019-04-23 Thread Alan Bourke
> but then I got > to wondering if simply putting code in the ON UPDATE trigger to send the > old record to a "history" table would be a more complete (and long term > EASIER) solution, whereby my app would query the "history" table for > changes. I have a custom add-on to our core product