McPond Software
McPond Software

Fixphet

Features

Fixphet is our utility for locating issues and repairing data in Prophet.

It is similar in result to Attache/Prophet's file recovery function.  It searches Prophet or Attache data files, locates issues, reports on them and fixes them.

We have created this functionality for specific clients because they have been unable to use their systems, and file recovery has not been able to assist. The data sets are large, and the issue can affect many records.  Manual data repair is not feasable.

Fixphet is a word play on Fix Prophet.

Currently Fixphet can handle two specific problems not handled by Prophet.

1.  Long float tails.

These cause Prophet Windows to crash when using next to step through records.
A value of 1.0000000001 or 0.99999999999 stored in Prophet's tables will sometimes cause it to crash.
Even a value of 1.001 when number of decimals is set to 2 will cause a crash. This fix type rounds
all offending values to two decimal places.  1.001 becomes 1.00      0.99 becomes 1.00  

This error can occur in the ICBranch file, typically on OpeningStockMTR, OpeningStockYTD ,but all decimal quantity and amounts fields on all files can be affected.

2. Notepad mismatched text and embedded end of file character combinations.

This happens where the text in the notetext file is a different length
to that specified in the Notepad file. An internal check in Prophet at each notepad read checks for 0A0D
occurring in the file at the expected end of the note. If there is a mismatch, Prophet Windows reports
the problem then dies, making the note unviewable and uneditable.
 The specific error is TMemoByteImage.ReadFromDisk: read past text record end. Record offset: 6828751
  Specifed length: 8751 Length on disk: 8749.     OK (Not really ok is it!)
 Prophet Debug (prophwind) dies with the same error, no additional information is provided.
Prophet incorrectly interprets this as the end of the note, triggering the error, and therefore not being tollerant of some types of pasted data.

  The error can also occur when a lone 0A (LF) or 0D (CR) occurs within the body text of the note, prior to the expected end string length of the note. Prophet eroneously interprets either of these characters as end of note, instead of checking for them as a pair. In Fix mode, Fixphet can correct these issues, by changing the rogue character to a 1B (ESC), which is used as the new line character in notetext.

Licence

Fixphet is free and open source software licenced under the GNU Public Licence v3.

Contributions of code or documentation or use cases happily accepted and added to trunk.

Commecial support and code change for Fixphet is available from McPond Software.

Prerequsites

To run Fixphet on your Prophet data, you must have a licence from Attache for their 3RD module

To amend and recompile Fixphet from source, to change what it does

  • Borland Delphi 7
  • Log4Delphi
  • XDOM 3.2

Usage

Fixphet runs from the command line, so it can be easily scheduled without problematic pop-ups or user intervention.

Fixphet is configured with the config.xml settings file. Use a text editor to set the options.

It does not require installation, or have an installer. Simply extract the files to a directory such as c:\prophet\fixphet\ , set the paths in config.xml, then run the batch files either notepadcheck.bat or notepadfix.bat

See the readme.txt file in the download zip for additional details.

 

Download

 DateVersion Download type
md5sum
2010-Apr-13
1.2.1
Runtime files - Windows executable inside a zip 17b201a20cd8741d9c861b5532d7bd6d
 1.2.1
Source files
e591aa2966995090524b8ac944c701e1

 

 

 

 

 

Last Updated ( Tuesday, 13 April 2010 05:20 )
 
NZ localisation for OpenbravoPOS

We've developed and released a NZ localisation for OpenbravoPOS.

 It adapts the package to NZ spelling, common business terminology and GST wording.

You can access the full package of files, documentation and forum on Openbravo Forge.

 

 
Bluecherry Surveillance

We've delivered and installed two more BlueCherry DVR systems for camera recording and surveillance.

It's a reliable, good looking and richly featured system, with good support.

We were motivated to find a replacement because of the issues we found with ZoneMinder. These are

  • Consistent heavy CPU and disk utilisation, becauseof no hardware compression in the capture card, leading to high power use and heat generation, and the need for expensive high quality components, such as power supplies, fans and disks. This also makes the web interface slow to respond, as the machine is very busy.
  • Poor presentation on the montage screen
  • No unitary recording interface where you can see the camera images, and operate the controls
  • Unreliable remote view in the web interface, it would consistently lock up after a short period of viewing
  • Difficulty in searching for historic events and retrieving them to local video files.

So while ZoneMinder is a good basic solution, it lacks the polish and functionality to make it a great solution, or suitable for important installations.

When people have stock, staff and resources at risk, they need a dependable way to monitor and retrieve event footage. Typically they need video retrieval at a very emotional time, in the aftermath of theft or violence. Having a system that is difficult to use or not gauranteed to get a result is very stressful, and this anger can quickly be passed to the system supplier.

BlueCherry

BlueCherry is not open source, but it runs on an open source platform (Xubuntu), and is quick and easy to deploy.  The cost of the software is incorporated into the cost of the hardware compression capture card, so the overall cost of the system is not expensive.  For the quality of software delivered, it is very good value for money.

We've found BlueCherry doesn't strain the hardware, because of the work done by the compression card.

Search and retrival is good, and users find they can operate it very successfully.  Knowing the exact time of the event is helpful for fast retrieval.

We have seen several crime in progress videos that have been captured and forwarded to police, or stills taken and posted on the customer notice board.

The capture card has a composite TV out plug, which we've found useful for connecting an old television to show the camera either in the shop or in the lunchroom.

Support on the forums has been excellent, with prompt replies to issues from core developers or management.

BlueCherry provide their own apt deb repository, so upgrades are easy to apply, and resolve their own kernal and package version dependencies.

The hardware cards are very good quality, from top Taiwanese video manufacturer Provideo, customised and exclusive for BlueCherry, showing considerable effort in good development by BlueCherry owner Curtis Hall and his team. Driver support with solo6010 is solid, and fully automatic.

Uptime is superb, with no unexpected outages or restarts needed.  We had one problem where the machine wanted to restart, but that was kernel security update, and after the restart service resumed.

Security is very good, and easily supports staff having real time view only access for some cameras, while the owner can access all cameras, search and configuration.

BlueCherry has support for moving PTZ cameras, but we haven't yet purchased or trialed one of these expensive beasts.

The system comes configured for American standard NTSC cameras, but is easily changed to PAL for NZ.  It is very camera friendly, displaying several different cameras with varying capabilities and resolution very clearly.

We are very happy with BlueCherry DRV. It provides a reliable, effective, feature rich recording system, suitable for shops, homes, commercial premises, schools and community facilities. We look forward to installing more systems.

 

 

 

 

Last Updated ( Sunday, 21 February 2010 23:59 )
 
OpenBravo POS

We've just delivered and installed an OpenBravo POS system.

It's very easy to use, with slick key handling, and fast processing.

From a thorough review of the currently available open source point of sale systems, it's definitely the smoothest software for true retail.

Some of the features we found appealing

  • Straight forward setup
  • Simple operation - easy for staff to use
  • Simple administration and organisation
  • Links into more complex OpenBravo ERP if more features are needed
  • Supports images of products in the main sale screen
  • Reliable
  • Looks very good on screen, good graphics, good use of screen real estate
  • Good hardware device support
  • Straight forward database organisation, easy to see what is going on
  • Some documentation, certainly a lot better than many similar open source products.
  • Good activity on the project wiki and forums

 We've installed it with the following components

  • Kubuntu 9.04 Jaunty 64 bit
  • Slimline desktop PC, IBM Lenovo
  • 19" LCD, to be upgraded to a touch screen later
  • Epson TM-T88III serial thermal receipt printer
  • Cash drawer, fired by the printer
  • Motorola LS-2208 USB bar code scanner
  • Winpos WD-304 customer display pole screen
  • HP inkjet printer for occassional reports
  • APC Smart-UPS 1000

The local data is stored in a Derby format database. It runs fast, and is reliable.  We've also hooked up the database to OpenOffice, both Base and Calc, so the user can view the POS data in different ways, and do master file updates in an easy list format.

 A couple of issues we encountered

  • The serial control library RXTX needed to be manually upgraded to a 64 bit version compatible with sun java 6
  • Manually loading the master file took a while, and there was no ready source to download it from. Each stock item and price had to be keyed by hand, and the bar code scanned.  Fortunately being a small shop, there were only 700 items, but it still took a while.
We still have a few changes to make to OpenBravo, to reduce the prominence of the tax amounts, since NZ GST is simple and applies to everything.

The total cost for the whole system with installation, hardware, cabling, support and tuning was $7,000.

 OpenBravo POS

 

Last Updated ( Sunday, 21 February 2010 21:52 )
 
Openbravo Chart 1.01

Version 1.01 of NZ Chart of Accounts.

 http://www.mcpond.co.nz/web/OpenBravo_Accounting_CoA_NZ-Version_1.01.zip

Download contains the source spreadsheet, and output CSV file that is loaded into Openbravo.

 It's the first cut, so has some rough edges, but it does load into OB, allowing you to get underway.  (In Openbravo you can't create a new company data set without a chart of accounts, so you need a basic chart to get started, even if you subsequently completly change it).

Last Updated ( Sunday, 07 March 2010 20:01 )
 
Read more...