Version 4.4.14 - a bit of housekeeping

 You've probably seen that a new version of the Wessex Pricing Program is now released (ver. 4.4.14). 

So, what's new?

Really, it's a bit of tidying up, sorting out some things I've been meaning to get around to.

• Making sure that apostrophes are now displayed and printed correctly. Previously they were shown as double apostrophes (ie. O'Brian was O''Brian).
• Correcting as error in Extra Cost where multiple Extra Costs, some including VAT and some not, were incorrectly totalled. 
• The "Moulding Needed" function now takes account of inner mouldings. It also gives better user-feedback while the records are being processed.
• When a supplier's mouldings are being updated the program now checks to see if the supplier's update file is already open and prompts to close it. (Previously an unhandled error.)
• If there is an error on opening the supplier's update .xls file - program suggests checking that the worksheet is correctly titled "gen".
• The Mouldings Needed list and the Jobs list now prints item line in colour (as the list on the screen) not all black text as previously.

Didn't know you could have multiple Extra Costs? Yes, you can, just be sure to rename the Extra Costs to something else (ie. "3 apertures" or "Special Mount") and don't repeat that name. When you select "Extra Cost" the program looks to see if the same name has already been entered in the Sundries list. You are not allowed to select the same item twice, as this would be a definite cause for confusion.

If you haven't already done it - head over to Pricing Program | Wessex Pictures | Picture Framing Wholesaler and download the "Free 30 day Trial" and (having backed up your database and labels/values files) and install this latest version (don't worry, the program will know that you are an existing user).

Enjoy.

What's in a name?

 Managed to get another Shakespeare quote in the blog title! 

Wessex Professional has a very useful facility to rename a moulding supplier. Why might you need to do this?

1. If the supplier has changed their trading name - Arqadia to Larson Juhl for instance.
2. If one supplier has taken over another's mouldings - Wessex now sell what were Frinton mouldings.
3. You have called the same supplier different names - The records for Rose & Hollis could also be listed under R&H for example.

If you leave things alone the program will still issue prices quite happily, the problem comes when you try to update that supplier's mouldings from a (.xls) file. 

Using the "Wessex /Frinton scenario, what will happen is that all the mouldings in the program listed under Wessex will be updated, but when it comes to those records that were Frinton's, they will not be added in with Wessex because their reference number is still listed under Frinton and the database won't allow duplicate reference numbers. So, the final report will say that xxx number of mouldings have failed to be added.

This is where the ability to easily change the supplier's name comes in. While it would be possible to do it the hard way and manually edit each moulding record the change the supplier's name, much better to let the program do the hard work, so -

• Click "Setup", then "Options"
• Select the "Database" tab.
• Top left is "Database Utilities". Click "OK".
• You'll be urged to make a copy of your database just-in-case.
• On the 3rd panel down select "Change Supplier name" and click "Go".
• Select the supplier you want to change from the drop-down menu. Click "OK"
• Enter the new name for that supplier. Click "OK".
• Done!

Pricing App - Importing a moulding file

 Just recently I've had to update the Pricing App to take account of the new Android versions - the old code for importing a mouldings file no longer worked on the newer versions (11 and beyond). So, you will notice that the import mouldings screen looks a bit different (App version 2.2.5 and beyond).

A bit of background to start with. The App can price frames using two different ways of getting the data it needs for the moulding part of the cost. 

The simplest is a price code - this begins with "#" and contains numbers and a letter, eg. #56G (the cost per metre/foot, and the width) This is fine for working out the cost, but it doesn't identify the individual moulding (mouldings with the same width and cost have the same code).

The second method is to use a csv file to list individual mouldings and their data. "csv" stands for comma separated values. It is a very simple file which you could open with Excel (or other spreadsheet program) and edit yourself. The file can list a particular supplier's mouldings or (if you use the Wessex Pricing Program for pc all the mouldings in your database). The good thing about this way of pricing is that it identifies an individual moulding and use a code that you will be familiar with.

But either of these methods needs to be kept upto date. With the csv file it means importing a new file periodically. First of all you need the download the file onto your device, either go the the supplier's website a download the file from there (if they have one) or email yourself with the file attached and download the attachment.

Now, on the App tap "Settings", then "Misc. Values". Tap "Import Mouldings File" and you will see a screen like this -

Select the "Download" folder (where the arrow is pointing) and you will then be shown all the text type files in that folder. (Nb. It may take a few seconds for the file to appear.)

All the downloaded csv files will be listed there. Tap the one you want to use and it will be imported into the App. If you make a mistake simply go back and import the correct one.

Easy!

Note - 

• The csv file can be called anything (it used to have to be called "mouldings", no longer). 
• If you download a file with the same name several times it will be titled name, name(1), name(2) etc. in the Download folder.
• The list of files has the date by them to help identify the one you want.

For further reading see -

Picture Frame Pricing Programs: Top Tips for Using the Mouldings.csv file in the App (stevetheframe.blogspot.com)

and

Picture Frame Pricing Programs: Tips for Updating App mouldings file (stevetheframe.blogspot.com)

Download woes

 Computer security has improved vastly in the last few years. Systems really don't want us to do anything that might cause trouble. For instance if your browser sees you are trying to download a file it doesn't recognize and which has the potential for unwanted consequences it will try and stop you.

I noticed this when I was checking that the correct file for the latest Wessex Pricing Program had been put on the Wessex website.

I'm using Microsoft Edge (so other browsers may be different) when I downloaded the Free Trial (SetupWPP4_4_12.msi) I noticed that there was a yellow triangle against that file in the downloads list.

 Looking directly in the Downloads folder in File Explorer it was labelled as "Unconfirmed download".

So, back to Edge. At the right side of the toolbar is the download list. Select "SetupWPP4_4.msi" and you will notice 3 small dots to the right. Click on those and select "Keep". 

Then yet another warning message appears. This time above the Delete button select "Show more" and then click on "Keep anyway".

You are now treated as an adult and can run the file!

Size Matters

 I'm sure that you have noticed that the size of the Wessex Pricing Program is fixed. There is a reason for that (skip the following paragraph if the brain is feeling a bit tired).

Computer screens are not only measured by size (usually diagonally across the screen) but also by "resolution" stated in "pixels". The more pixels the better detail that the screen can show. The computer I'm writing this on has a resolution of 1920 x 1080. Not too many years ago a resolution of (say) 1200 x 800 more would have been considered good. When you set a size for a form in a program it is set in pixels, not inches or Cm. So it will look smaller on a higher resolution screen, and larger on a lower resolution screen. 

Wessex Professional has stayed the same size ever since it was released. This way it would be good for older monitors. However, the difference between old and new monitor resolution is becoming quite pronounced and although there are things you can do to show the program at a larger size, what is really needed is the ability to resize the program to suit your screen. This is easier said than done. There are at least 27 "controls" (buttons, textboxes and so on) in the main screen and each one needs to be resized in proportion to its neighbour.

The problem is finally solved in the latest version (4.4.12). You can now resize and reposition the main form to suit your screen and the program will remember that for the next time.

The above screenshot shows the standard size, with the program always starting centre-screen.

This screenshot shows the program enlarged and repositioned. It will remember the size and position for next time it starts.

By the way, the computer these screenshots were taken from is running Windows 11. Wessex Professional is perfectly happy running on that.

Also in the new version is an improved "Moulding Needed" section ("Tools" > "Mange Database" > "Mouldings", click "Views" and choose "Moulding Needed" to show the moulding you'll need for your current jobs, and which you're likely to have to order).

The "Save invoice as PDF" in the Print section has had some potential errors corrected and should be more consistent. 

All that remains is to wish everyone a Happy and Prosperous New Year.