How to move Match-IT between servers

Match-IT is self-contained in a single folder on a server.  There is no client-end software. It is connected from client workstations using one of three methods:-

  1. A simple shortcut. This is how we leave it after the initial install; see match_it\configs for an example.
  2. An overt RDP login.
  3. Some sort of application virtualisation; e.g. a published app.

The latter two are set up by IT and are becoming more popular with the availability of cheap powerful servers.

To move Match-IT between servers, copy the Match-IT folder from one server to another and then repoint the workstation connection solution to the new location.  Users need full control of the Match-IT folder.

There is a service that needs to be started on the new server but it’s easiest to call us to do it; for example over Teamviewer. It takes about 5 mins.

If the printers used by Match-IT now have different URLs, the Match-IT print queues will need a tweak and again it’s easiest if we do that if you let us know what they are.

 

 

Why has Match-IT slowed down?

Sometimes Match-ITs performance is compromised.  Here are the main reasons we have discovered over time:-

1. A virus/malware checker(s) is checking the Match-IT data files in real-time on the server. It is essential that the Match-IT data folder is exempt because the files changes so frequently (many times per second).  This is perfectly safe because the data files are not executable programs.

2. Use of mapped drives to access Match-IT is not recommended for the same reason. Local virus checkers on PCs check mapped drives to other computers by default, so you have to exempt the mapped drives on each PC and in each virus/malware checker on those PCs. This can usually be done with a global policy by your IT guys. But new PCs can still be a problem because they often come with a free one year AV program installed which starts checking mapped drives. We recommend sharing the Match-IT folder on the server and then connecting to it using UNC paths, but this is only of benefit if the mapped drive used to access Match-IT is also removed from each PC.  This also includes any other mapped drives that happen to include the Match-IT folder.  Either exempt the drive or preferably use UNC paths.

3. Dodgy network cards. Surprisingly frequently, network cards fail and while doing so cause problems. We have no idea how to detect this other than start one PC at a time and see when Match-IT slows down.

4. Slow/degrading server disk. Match-IT makes high demands on the server disk and it’s needs to be super-fast and efficient.

5. Use of WiFi.  If you use a laptop to run Match-IT please make sure that it’s physically plugged into the network.  Absolutely do not rely on WiFi.

6. Use a dedicated server.  Because of the relative cheapness of servers these days and the critical nature of Match-IT to our customers, many choose to have a dedicated Match-IT server; especially if the load from other server software components (like ACT) is high. Access is either by UNC paths (no mapped drives) or a published app so everybody is in fact running Match-IT on the server. Note that the latter has outlook licence and printing implications. We have a UK customer with a Match-IT server in mainland Europe and it is ultra-reliable; they use a  published app for access.

See also this article.

 

Applications needed to build Match-IT

Clarion 10 Enterprise Subscription

https://softvelocity.myshopify.com/collections/ide/products/core-subscription-program-for-enterprise-edition-new-license

Take Command

https://jpsoft.com/products/take-command.html

The build scripts need version 8 which you can download on request after buying the latest version.  At some point the scripts should be tweaked to support the later versions, but it’s never been a priority.

Setup Builder Developer Edition

http://www.lindersoft.com/order_dev.htm

This creates the installation file.

SVN client

We use tortoise command line client.  Free.

https://tortoisesvn.net

Help and Manual Professional Edition

https://www.helpandmanual.com/order.html

Only needed to build the product manual.

 

 

 

 

 

Posted in dev

Newsletter October 2017

Hi all,

This newsletter is intended to keep you up to date with Match-IT developments.  It will be published as required; not necessarily every month.

1.  Patton Air enforce very stringent dispatch paperwork/labelling etc requirements, which we have successfully implemented at two sites in the UK.  We have also implemented similar requirements at other sites, including in the USA.  If your customers are also starting to enforce dispatch rules, please do get in touch with us to discuss a solution.

2. To kick off a committed effort to gradually improve CRM capabilities, we have implemented infrastructure that allows qualifiers to be displayed in existing lists.  For example, you may have created qualifier fields for your customer/supplier records.  These can now also be displayed in the list of all customers/suppliers.

3. We would like to try and get everybody up-to-date with the latest version, as it contains several stability improvements.  We are happy to do the upgrades ourselves in the evenings and weekends to avoid any extra down time for you.  Please contact support to arrange your upgrade.

4.  All the the latest changes to Match-IT can be found here:  http://match-it.com/software/release.htm#latest

Newsletter August 2017

Hi all,

This newsletter is intended to keep you up to date with Match-IT developments.

1.  Hours.  Our support hours have changed to be 8am to 4pm which better suits our customers.  If you work in the evenings or weekends there is an emergency number you can ring if you are stopped.  We cannot guarantee to be able to help, but we will if we can.  This number is not published.  Please call and ask for it if you think it would be useful.

2.  SQL backend.  This was a huge undertaking by Dave Nichols and one customer has been trialling it for many months now without problems.  Having a SQL backend opens up Match-IT to generic report writing and the internet; for example your customers could create orders that appear in Match-IT and get their order’s status etc.  It’s also an alternative way of writing scripts if you have any coders in house.  We now have excellent in-house web skills ourselves (PHP, Javascript, node.js etc) and can help you build such interfaces.  We targetted PostgreSQL for it’s technical excellence and it is available for free at the link below.  If you would like us to set up a parallel SQL version of your system for you to trial it, please call on the support line and let us know.  It is available under your existing support agreement.

https://www.postgresql.org

3.  Cus/Sup reviews.  After feedback from auditors we have added a customer/supplier review system which forces you to review their details every N days (default 365).  They are considered to be unapproved if this is not done, which satisfies the auditing requirement.  This is available in builds from February this year.

4. A tip.  Many virus checkers target mapped drives which means that you need to exempt the Match-IT mapped drive on your PCs (imagine tens of PCs all having a virus checker targeting files on the server via a mapped drive).  This can cause problems when you get a new PC or update the virus checker etc.  The probem can be eliminated completely by deleting the mapped drive on the PC and using a “UNC path” in the shortcut to Match-IT instead.  i.e. instead of something like m:\sys\match_go.exe it becomes \\myservername\match_it\sys\match_go.exe.  If you would like this done, let us know your IT contact and we’ll speak to them.

We will leave it at that for now and detail more changes in the next newsletter.  Match-IT is in active daily development; including tracking upsets caused by Windows updates and a full list is always available in the link below; a useful shortcut to add to your browser toolbar maybe.

http://match-it.com/software/release.htm#latest

Why do sometimes have to recover a data file?

When using Match-IT across a network it is essential that the network is reliable because any dropout mid file transaction can cause a corruption the a data file.  Here are some tips to minimise problems:-

  1. On the server and workstations, exclude the Match-IT data folder (or .tps files) from real-time virus checking (etc) scanning.
  2. On workstations, do not use a mapped drive to point at Match-IT in your short cuts; use a UNC path (//servername/…).  If you do have to use a mapped drive make sure it is exempted in real-time the anti-virus software on all PCs.
  3. Do not rely on WiFi.  Make sure all network cables are connected and have not fallen out.
  4. Do not pull the network cable out of laptops before closing Match-IT and also make sure that you wait for Match-IT to exit completely.
  5. Close Match-IT and wait for it to exit completely before shutting down your workstation.
  6. Never under any circumstances click the “shutdown anyway” when shutting down your workstation and Windows says you have left Match-IT running.  Close Match-IT properly first.
  7. A Terminal Services solution (user logs into a server and run Match-IT from there) will provide better stability if any of the above are unresolveable.

See also this article.

How do I remove an Ad Hoc Works Order?

The output batches from an ad-hoc WO are almost always being used to satisfy a demand up the chain, so it is not usually possible to delete the WO itself.

The procedure needed is to go into the detail of the WO, then go to the Schedule tab, clear the Ad-Hoc Order Until date and save the WO.  It is then removed at the time of the next full reschedule – either automatically by the Agent overnight or if you decide to do one manually.

What is a dis-assembly method?

The Product Manual briefly mentions a dis-assembly method, but what does it do in practice and when would you use one?  This article attempts to answer those questions by means of an example.

Say for example that you use parts called A, B and C in your methods, and you can buy them from various suppliers as usual.  However, let’s say that A, B and C are in fact parts of a connector (for example) and you can buy a whole connector cheaper than the component parts.  By using a dis-assembly method attached to the connector, Match-IT will buy it and create a works orders to take it apart as needed; i.e. if it needs to acquire an A and/or B and/or C – which will have been defined as parts in other methods.

If the connector has an our part num of X and the relative value of A, B and C is 40%, 40%, 20%, the setup in the materials catalogue will look like this:-

X (can be purchased ticked and suppliers attached as usual)
METHOD (dis-assembly option selected)
  STEP (normal works order step)
    PART (self)
    OUTPUT A (40%) (the percentages are set manually - only you know the values)
    OUTPUT B (40%)
    OUTPUT C (20%)

A (nothing ticked)
B (nothing ticked)
C (nothing ticked)

“PART (self)” can be added to the method by dragging in a PART record from the list on the right – it defaults to “(self)” – i.e. use myself as the kit.  Similarly the output records can be dragged in and then edited to define what they create; A, B and C in this case.  If the connector cost £10 the cost of A, B and C will be £4, £4 and £2.

Any method requiring a whole connector will just have a “PART X” in its method somewhere as per normal; nothing special will happen; the connector will be bought and used like any other part.

If an A, B or C is required in a method, Match-IT will buy a whole connector X, create a works order to take it apart, using itself as kit and attach 3 outputs A, B and C, which will need to be booked in as the outputs of the works order.

Now say for example that a part called Y requires an A, the eventual schedule will partially look like this:-

WO(Y) < A < WO(X) < X < PO(X)
        B < 
        C < 

Unless of course there is some A in stock, in which case that will be used instead.

This is a very simple example.  The dis-assembly method can also have resources to do the work and they will be costed as per normal.  Other parts and/or tools may also be needed.