Category Archives: Technical Stuff

Scriptcase 9.2 – The Right Too For The Job ?

This will be a series of posts regarding my experience with Scriptcase 9.2.

Introduction

I am a person who believes that having the right tool for the job will save a person time, money, and what can be a great deal of frustration.  It is for this reason that I tried Scriptcase 7 as a free download, 8 again, and then decided to dive in and purchase a $300 license for Scriptcase 9.2.

Over the years I have purchased a number of code writing tools, scripting tools, libraries and have even written my own program generator that, using my library, one could develop whole Cobol ANSI 85 applications in minutes.  I don’t believe in manually writing essentially the same code over and over again when a code generator can do it for me.

Among the many tools I’ve used over the years are zApp Factory (C/C++) by Rogue Wave Software, the now purveyors of the Zend php tools, CodeCharge Studio – essentially a defunct php generation utility, Zend Studio 12 and framework and, the point of these articles, Scriptcase 9.2.

As I have time, which will be greatly impacted by the amount of time I have to spend learning Scriptcase 9.2, I will post articles on my experience.  This being the first.

Initial Thoughts

I was reluctant to invest in Scriptcase for a number of reasons.  Primarily, the problem for me was the language barrier.  Scriptcase is developed and maintained in Brazil which means the developers speak Portugese.  One may think this shouldn’t be an issue when developing php scripts as the language itself is all English.  This is true, to an extent.

However, even a cursory read of the manual, which as of this date is vastly improved, one gets the impression that the person writing the manual learned their English from the television or uses Google translate to make translations.  The grammar is poor, simplistic at best, and the there are many instances where it is so confusing that it can take you 15 minutes to figure out what the writer is actually trying to say (if you ever do).

The manual, such as it is is, is an extremely sparse reference manual style.  If you are looking for a manual where you can find an example of something done and how to do it, this won’t help.  In the companies favour, they do have a number of videos on YouTube but again, this are rather superficial tutorials, often presented by someone with English as a second language and zero experience making video tutorials.

The Code.  Any good programmer will tell you they can read the code the application generates to figure out what it is doing and how to get it to do what they want.  Normally, this is the case however in the case of Scriptcase 9, you need to be able to understand Portugese.  The variables and labels in the code are by the vast majority in Portugese.  PHP is php, in this case version 7, but you can’t read the coded without the context of the variables, labels and comments (what few there are are also in Portugese).

At this point, I have spent about 40 hours with the product over the past two weeks and I am extremely disappointed.  It took me three installations to get it to function at all and I have now spent well over 15 hours trying to figure out just how to get the security module to work with my own database structure, never mind in the most efficient manner.

Zemana Anti-Malware

I am an experienced technology executive and I have been extremely careful about what I allow onto my computers.  However, and this is a big however, I must confess to finally being the victim of a malware infection.

This is a really hard admission to make, but I am making it because I want to recommend Zemana – http://www.zemana.com/ to you.  I cannot speak more highly of them and honestly, after 35+ years in technology I have not been treated better by anyone.  Not by Dell, Microsoft, Apple, HP, Cisco, Avast, Norton and a host of other companies.  Not by Amazon or eBay, Compaq or Xerox, and I’ve dealt with them all.

To make a long story short, I downloaded something I should not have and after installing it my Opera browser, and only my Opera browser, got hijacked.  I did everything I could think of including uninstalling Opera, manually erasing settings, manually editing the registry.  I ran an Avast scan – I use Avast as my anti-virus software – I downloaded and ran MalwareBytes product and Zemana.  After all was said and done, the malware remained despite Zemana, Avast and MalwareBytes reporting my system was clean.

So, I sent Zemana an email and told them.  To be fair, I did not notify Avast or MalwareBytes so I don’t know how they would have responded but I do know that I immediately received assistance from Zemana.  They didn’t ask whether I had purchased a license, they just helped.  I did as they said, including running First64 from Bleeping Computer and sending Faysal the report.  Within 12 hours Faysal responded with a ‘fixlist’ file and … voila, no more malware, no more browser hijack.

I then received an email from Armagan with a link to purchase Zemana at 40% off.  Yes, I did that.  Good grief, they saved me two or three days of reinstallation.

All this on Microsoft Windows 10 64bit.

My recommendation…go and get yourself a copy of Zemana anti-malware software.  It really is worth it.

Here is the link, you need it.  Go NOW:

Woocommerce Tax Not Calculating

The Woocommerce tax not calculating problem is the result of a poorly designed query.

I have been setting up a new Woocommerce store for a the candle company I work for part time.  During the testing process I discovered that the tax calculation had stopped functioning.  I was convinced that this had worked at one time but suddenly had ceased.  Worse, this seemed to occur after importing all the Zip codes and tax rates.

After much trial and error I discovered that the problem is the algorithm used to determine the tax.

The data is stored in two tables:

wp_woocommerce_tax_rate_locations
wp_woocommerce_tax_rates

The first table is the key.  If you create a Zip code based entry, for arguments sake lets use a California code of 91387 which happens to be include Canyon Country areas, then your entry is going to look like this:

wc-tax-1

 

Here is where the problem starts.  On the Cart page the store doesn’t know which ‘city’ the buyer is from and the query appears to ‘AND’ the two entries so it doesn’t find the tax information provided in the cart by the customer as being in the 91387 Zip code AND Canyon Country.  In the checkout itself, once the customer enters the City and the Zip code the tax should be calculated correctly.

The easiest solution to this problem is to simply leave the ‘City’ blank when adding Zip codes and tax rates.