Back To Release Notes List



Back To Release Notes List

#17162

21. Mar 2018

6.3 SP 1

  • 0 Warnings
  • 1 Features 0 Features
  • 5 Other changes
  • 30 Bug fixes

Welcome to 6.3 Service Pack 1 Release - please at least read the "Details" below each chapter in this "top" section of the Release Notes.

v6.3 SP1 Release rev. 17162, released 22. March 2018

Contains:
- 3 more very important Bug fixes since 6.3 SP1 RC3 rev. 17091

Summary of all changes since v6.3 Release rev. 16881:
- 1 Feature
- 5 Other important changes
- 30 very important Bug fixes

------------------------------------------------------------
v6.3 SP1 RC3 rev. 17091, available since 5. February 2018; and released the same day.

Contains:
- 1 Other change

------------------------------------------------------------
v6.3 SP1 RC2 rev. 17075, available since 26. January 2018; released 29. January 2018.

Contains:
- 1 Other change
- 6 very important Bug fixes

------------------------------------------------------------
v6.3 SP1 RC1 rev. 16994, available since 17. November 2017; released 20. November 2017.

Contains:
- 1 Feature
- 3 Other changes
- 21 very important Bug fixes

------------------------------------------------------------
v6.3 Release rev. 16881, was released 15. June 2017

See the full list of all logged changes on our website: https://www.farmerswife.com/releasenotes/

Native v6.3 changes:
- 6 HOT Features
- 15 Features
- 6 Other changes
- 32 Bug fixes

... and also take a look into the new highlights summary "Whats New in v6.3": https://blog.farmerswife.com/farmerswife-release-v6.3

Check out our Getting Started videos for new Advanced Users joining your team! https://www.youtube.com/playlist?list=PLA74zQEGurSW7WY9LJqO0jWLjaQnMXxPI

How to upgrade to version 6.3 and later, click on "+" to see the details.

Basics
- You need to have a "Version 6.3" license at hand, before starting the upgrade process.
- To be eligible for a 6.3 license you need to have a valid support subscription (Gold or Silver) with us, at least up to 15. June 2017 or later.
- If you do not yet have a v6.3 license, then please request this from license@farmerswife.com once you are ready to upgrade.
- Note: the "Public Installers" section is open; see more info below!

The built-in auto-upgrade IS supported for all WIFE Clients on 5.2 Release or later!

MANUAL WIFE Client upgrade needed for OLD version BELOW v5.2
The auto-Client-upgrade functionality will NOT work for WIFE Clients below v5.2.
The SSL-based communication protocol was implemented on v5.2. Any WIFE Client has to be manually upgraded once to 5.2 Beta 4 or later.
The auto-client upgrade will work again for any WIFE Client which was once manually upgraded past 5.2 Beta 4.

Any WIFE Client which was NOT manually upgraded will state this message when trying to log-in:
"Connection to the Server Timed Out"

Upgrading
- Your WIFE Server needs to be running on version 6.2 Service Pack 1 rev. 16524 to be ready for the upgrade.
Every farmerswife version contains specific upgrade code. To ensure a properly running system, you need to always upgrade the farmerswife Server application to the last Public released version!
Here the general upgrade path for all farmerswife Server's since v5.2:

v5.2 SP1 rev. 13660 => v6.0 SP5 rev. 15600
v6.0 SP5 rev. 15600 => v6.1 SP2 rev. 16490
v6.1 SP2 rev. 16490 => v6.2 SP1 rev. 16524
v6.2 SP1 rev. 16524 => v6.3 SP1 Release rev. 17162

Please contact support@farmerswife.com should you have any questions.

- Inform your colleagues about this new version BEFORE you upgrade.
- Run a "Full Backup" BEFORE the upgrade.
- While the Full Backup is taking place, you could now take a look into the documents provided in the "Read And Use Me Upgrade Package" you were issued together with your license of the previous Released version.
- The upgrade itself might require a couple of "Forced Shutdowns" for it to finish.
- If needed, see more detailed information in the Upgrade Instructions.
- Ensure you have the latest Java version (JRE on Windows/Linux, JDK on Mac OS X & macOS) installed, for the Web Client and Mobile Web Client and Play to work properly and in the most secure way. Watch out on Windows: here you can run the fw Server application in 32bit mode (farmerswife.exe) or 64bit mode (farmerswife 64bit.exe); and depending in which mode you're running the WIFE Server, you _must_ have JRE installed in the corresponding 32bit or 64bit version.

farmerswife Server upgrade on Mac:

For your information: Known "download, un-pack and launch issues" on macOS "High Sierra" 10.13 (started with "El Capitan"):
Due to: macOS > System Preferences > Security & Privacy > General > "Allow apps downloaded from: App Stored and identified developers", we recommend that you follow these steps, because the farmerswife Server application in its current state, can't comply for it to come from an "identified developer". The fw Client application on the other hand, complies and does not require the below steps.

Download the "IntelMac_farmerswife_603_xxx_revxxx_ServerWithAutoClientUpgrader.zip" package from our website to your "Downloads" folder.
Copy this still zipped file from your "Downloads" folder to your "Desktop" and ONLY un-pack it there!
Do a test-launch here on the Desktop: right-mouse click and use "Open"; follow the instructions on the macOS pop-up windows. If the fw Server application now launches, all is good, "Cancel" the full launch. Continue with the following steps:

- Un-zip (if not already done) and rename it to include "NEW" in the package name; e.g. now called "NEW farmerswife Server"
- Place it in the same location as the previous running farmerswife Server.
- Quit the running farmerswife Server.
- Rename the previous "NEW farmerswife Server", to now include "OLD" in the package name; e.g. now called "OLD farmerswife Server"
- On both packages do <Control> + click and select "Show Package Contents" in the pop-up menu.
- In the OLD package select the "system" and "files" folders* and use <Control> + click and select "Copy 2 Items".*
- In the NEW package use <Control> + click and select "Paste 2 Items".
- Now copy the new 6.3 license files into the "system" of the NEW WIFE server.
- Double click on the NEW farmerswife Server package icon to start the actual upgrade process.
- Once everything worked out fine, remove or update any Dock or Desktop links. And if needed remove the OLD Server package; because up until now, this was a working "roll-back" backup, just in case something went wrong.
- After the upgrade, start the farmerswife Server as usual.

* You might also need to copy the "html_templates" (only if used and if it contains customized templates) folder. And if you are using any 3rd party integration scripts, don't forget to manually migrate these from OLD WIFE Server package > Contents > "Show Package Contents" > lib > scripts > ... and then here only copy the integration script files from the according sub-folder and not the whole "scripts" folder.
Note: The "files" folder might not even be there, since it was broken out, to reside on some other storage device within your network.

farmerswife Server upgrade on Windows and Linux:
- Make sure you are logged into the host machine with the same admin user as on the initial installation of the farmerswife server application.
- Copy the NEW farmerswife Server installer file to the machine hosting the WIFE Server.
=> On Windows this is a .exe file
=> On Linux 64bit, this is also an executable file; use in a command shell: chmod +x Linux64_...
- Quit the running farmerswife Server.
- Now copy the new 6.3 license files into the "system" of the NEW WIFE server.
- Double click to run the installer file in the same manner as the previous installation (for example did you use "Run As Administrator" on Windows?).
- Follow the instructions of the install wizard.
- After the upgrade, start the farmerswife Server as usual.

The farmerswife Clients will auto-upgrade ...
... if already on version 5.x or later: ... by using the "simple in-application" auto-upgrade process; "normal user" Operating System permissions (Read / Write) are sufficient.

... if BELOW version 5.x:
... by using the "FULL" Client upgrade process; OS admin user permissions Read, Write AND Execute are necessary on the initial upgrade to version 5.x.

IMPORTANT for the supported auto-upgrade functionality in later versions:
For the farmerswife Client applications the "simple in-application" auto-upgrade process to work (once supported in later versions), "normal user" Operating System permissions (Read / Write) are sufficient. You log-in, you confirm that you want to upgrade, the needed files are transferred, the WIFE Client restarts, done.
But when auto-upgrading on Mac with a mix of Admin and Standard users, make sure to be logged-in as a Standard user. Then after mounting the .dmg file, drag-and-drop it to the Applications folder. You then need to authenticate with the Admin users credentials! The farmerswife Client will not work for the Standard user, if installed while being logged-in as the Admin user.

IMPORTANT when upgrading the WIFE Client on Mac: If you have a mix of Admin and Standard users on a Mac, make sure to be logged-in as a Standard user. Then after mounting the .dmg file, drag-and-drop it to the Applications folder. You then need to authenticate with the Admin users credentials! The farmerswife Client will not work for the Standard user, if installed while being logged-in as the Admin user. For the farmerswife Client applications the "simple in-application" auto-upgrade process is supported, "normal user" Operating System permissions (Read / Write) are sufficient. You log-in, you confirm that you want to upgrade, the needed files are transferred, the WIFE Client restarts, done. This upgrade process is not explained in any further detail.

For customers on lower versions than 5.x:
5.x and 6.x are facelift versions! The user interface has changed, but it's still farmerswife.
If you have not seen it before, simply first try it out on your own local machine https://www.farmerswife.com/ and click on the "Free Trial" button.

Very important: The WIFE Client application requires a Full installation if upgrading from below 5.2 Release!

Once you've successfully upgraded, please inform us by sending a short email to support@farmerswife.com; this is very helpful information for us.

Latest free universal iOS farmerswife app v5.0.802 on Apple's App Store - since March 7. 2018, click on "+" to see the details!

The latest iOS farmerswife app is v5.0.802 version and available since 7-March-2018.
NOTE: iOS 9 required since iOS farmerswife app v5.0.706.

IMPORTANT:
Due to security changes on iOS 8.4 by Apple, these changes can only be supported on farmerswife v6.0 SP2 and later versions!

This means:
You should upgrade as soon as possible to v6.0 SP2 or later.
If you can't upgrade your fw Server application to v6.0 SP2 or later (released 15. July 2015), then you can't use the latest iOS farmerswife app on iOS 8.4 or later.
You will get a "Error Failed To Connect" message.

IMPORTANT for older versions:
The latest v5 universal iOS farmerswife app for iOS 7 or later: v5.0.59 is available on Apples App Store since 12-September-2014.
Your WIFE Server needs to be at least on version 5.0 SP4 or 5.1 SP1 or later to use version v5.0.59 and later.

How to install the iOS farmerswife app:
On your Apple mobile device go to the "App Store" app and search for "farmerswife"; depending what iOS version you have installed, it will show you different iOS farmerswife app versions.
Latest iOS farmerswife app version is 5.0.802; it requires iOS 9 and later (ideally you're always on the latest iOS version).
Version 5.0.59 requires iOS 7 or later. This is the iOS 7 optimized version.
For iOS 6, the latest iOS farmerswife app is still version 5.0.34.

IMPORTANT:
Once more: The iOS farmerswife apps v5.0.59 to v5.0.802 are compatible to login to WIFE Servers on 5.0 SP4, 5.1 SP1 or later, 5.2 or later, 6.0 or later ... except if on iOS 8.4 or later; here you need to be on v6.0 SP2 or 6.1 Beta 1 or later.
Per logged-in WIFE Server version, it will then allow using the latest supported features up to that point per that version.

NOTE: The 4.11.1 iOS farmerswife app will NOT work with a v5.x WIFE Server or later versions!

How to use the "server.cfg" when working with a separate TEST farmerswife Server, see details.

This chapter describes the recommended best practice on working on and with a separate TEST WIFE Server.
This might be needed when running on Beta versions, or new Service Packs or in general when you first want to run an upgrade check
or evaluate new modules or new functionality on a separate TEST WIFE Server installation.

You can always use a WIFE Server in "demo mode" (also with your DB files) and it will run for 60 min. and you have 40 sessions.
An additional "TEST Server" license can be provided upon request, available for customer with a valid service agreement in place;
include in your request the Company Name, the info of the local static IPv4 address and the used Operating System of the machine to host the TEST WIFE Server.

IMPORTANT:
farmerswife supports Push and Feed functionality, and various other email notifications (if enabled); and it can be integrated to various other 3rd party systems; and you can also break out folder structures to network shares which are normally locally hosted on the WIFE Server's host machine, etc.
All this functionality is therefore also enabled by default on a separate new TEST WIFE Server environment you might be using. And if not handled with care and turned OFF in a good way, this will lead to duplicate or wrong notifications to your users, or update wrong information on your real live Production farmerswife system.
Please read on.

For a "half way realistic" test environment, copy the "system" folder from your WIFE PRODUCTION Server, more info below!
Depending on how you use farmerswife, you might also need to copy other files or folders.

Use the "server.cfg" file to control certain vital parts of your separate TEST Server:
This "server configuration" file (server.cfg) provides the option to change certain "General tab" settings "outside" of the actual WIFE Server application.
You use this file to ensure certain settings are not enabled on your TEST WIFE Server.

These settings/variables are available by default:

FW_IP
FW_PORT
EXTERNAL_PORT
HTTP_PORT
HTTP_HOME
USE_SSL
HTTP_SSL_PORT
HTTP_UPLOAD_PORT
FTP_ALLOW
FTP_PORT
FTP_PASV_PORT
FILE_PORT
FILE_PORT_LOW
FILE_PORT_HIGH
MAIL_OK
MAIL_SERVER
MAIL_PORT
MAIL_USER
MAIL_PASSWORD
USE_SQL
SQL_USER
SQL_PASS
SQL_DB_HOST
SQL_DB_NAME
SQL_PORT
PRJ_CHECK_FOLDERS
LDAP_DEBUG
HTTP_DEBUG
EXCHANGE_DEBUG
MAIL_DEBUG
APNS_ENABLED
BARN_ACTIVE
HTTP_XML_PORT
WEBCLIENT20_ENABLED
WEBCLIENT20_PORT
WEBCLIENT20_COM_PORT
ALLOW_FORCE_RUN_NIGHTLY_SCRIPT
ALLOW_FORCE_RUN_PLAY_BILLABLES
TIMED_SCRIPTS_INTERVAL_SECONDS
MSAD_ENABLED
USE_EXCHANGE
READ_SCRIPTS_AS_UTF8
GOOGLE_SYNC
CIRKUS_ENABLED
FORCE_SHUTDOWN
USE_MSAZUREAD

Note: Only licensed features and their variables will be effected by any changes within this .cfg file.

A proper WIFE Test installation works like this:

- Quit your farmerswife PRODUCTION WIFE Server.
- Create a file called "server.cfg" within your PRODUCTION WIFE Server's "system" folder.
- Start up your PRODUCTION WIFE Server for the first time with the "server.cfg" file in place, then Quit it again, to trigger flushing your existing configuration settings into this "server.cfg" file.
- Install the TEST WIFE Server application on your test machine.
- Now copy at least the "system" folder from your WIFE "production" Server to within your "test" WIFE Server's installation folder. If you have the time, feel free to also copy the "files" folder; and if you have customized anything within the "html_templates" or "/lib/scripts/...", copy these sub-folders, and IF you are using anything "customized" within these folders, the related files might need to be copied as well.

BEFORE (!!!) the first start-up of the TEST WIFE Server, edit the server.cfg file with a text editor application within your TEST WIFE Server's "system" folder and add or set at least these variables to "0", like this:
MAIL_OK 0
USE_SQL 0
APNS_ENABLED 0
MSAD_ENABLED 0
USE_EXCHANGE 0
GOOGLE_SYNC 0
CIRKUS_ENABLED 0
USE_MSAZUREAD 0

Save the server.cfg file. Copy it again to a "safe" location on your test machine, so you can re-use it for the next DB file updates. Please read on.

Now start your TEST WIFE Server application.

VERY IMPORTANT after the first launch and after each update of database files of a separate TEST Server
Go to the running fw Server application > Setup > General tab > "Full Backup Time" and set it to "Never"!
The "server.cfg" does not yet support this feature, and if you do not turn it off, this might interfere with your actual real "Full Backups" from your "in-production" farmerswife system!

NOTE: to test "Allow Mail" functionality from a "test" WIFE Server, you can use for example a service like "Mailtrap" (http://mailtrap.io).
You then need to update this variables with your access details:
MAIL_OK
MAIL_SERVER
MAIL_PORT
MAIL_USER
MAIL_PASSWORD

Repeat the above steps, for any upgrade or repeated update of the "system" folder on your Test WIFE Server.
We recommend to save the correctly configured "server.cfg" file for the TEST environment in a good way, and then simply replace it prior to the first start-up.

NOTE: Once you have properly configured your TEST WIFE Server as mentioned above, you can save time in the future and only copy these files from your PRODUCTION WIFE Server > from within the "system" folder:
- current45.efdb
- fwdb.db3
- histories.db3
- despatches.db3

About these Release Notes, Disclaimer and Legal Information.

The content of this Release Notes document is subject to change without notice. The information in this document is furnished for informational use only and should not be construed as a commitment by farmerswife. farmerswife assumes no responsibility or liability for any errors or inaccuracies that may appear in this document or any software that may be provided in association with this document. Except as permitted by such license, no part of this document may be reproduced, stored in a retrieval system, or transmitted in any form or by any means without the express written consent of farmerswife.

Bookings

Changed that now the Toolbox > Setting "Use Time Range" options are respected, when replacing an Object on a Booking by drag & drop in the Long Form or Hourline, see details.

See Details

In fw Client > Toolbox > Settings > Booking Defaults > "Use Time Range" this feature has these three options:
- Ask
- Booking Time Range
- Marked Time Range

Now, these "Use Time Range" options are respected, when replacing an Object in a Booking by drag & drop, either in the Long Form or in the Hourline and they work like this:

- If "Use Time Range" is set to "Ask" (recommended), then the dialog pop-up window "Use Time Range? Yes/No" appears if at least 1day is marked/highlighted on any of the timelines (In Long Form or Hourline). "Yes" replaces the Object only on the marked day/s. "No" replaces the Object for the complete duration of the Booking.
If no days are marked/highlighted, the dialog is not shown and the Object gets replaced for the complete duration of the Booking.

- If "Use Time Range" is set to "Booking Time Range", then the Object gets replaced for the whole Booking duration, even if some days are marked in Long Form or Hourline.

- If "Use Time Range" is set to "Marked Time Range", the Object gets replaced just for the marked days in the timeline. If no days are highlighted, the Object gets replaced for the whole Booking duration.

 

Budgeting

#218843

Fixed a bug by which Actuals were not being correctly attached to Budget Lines when creating a Booking from multiple lines in Budget > Scheduling Mode, see details.

See Details

In the Budget > Scheduling Mode (Active Budgets), when selecting multiple Budget Lines and then dragging them onto the timelines, wrong Objects would be linked or they would sometimes not get attached to the corresponding Budget Line from which being dragged from.

 

Fixed multiple bugs by which Actuals were wrongly booked if using Activities via the Budget > Scheduling Mode, see details.

See Details

Now when using the Budget > Scheduling Mode and dragging more than one Budget Detail (that is an Object Class with Activity) to the timelines to create a Booking, each line is now correctly booked and gets attached to the correct Budget Detail.

Also if the same Object Class is added twice to a Budget, when dragging it to one of the timelines to create a Booking, each Object gets attached to the correct Budget Detail.

 

Class Bookings

Fixed a wrong Confirmation message when replacing an Object Class with an External Object on a Booking from the Edit Project window, see details.

See Details

When replacing an Object Class with an External Object from a "Supplier" (Contact type Global > Supplier Details) on a Booking from the Edit Project window, the Confirmation pop-up window was not displaying the details of the External Object and the Supplier it was being replaced with.

 

Client

Fixed a bug fw Client login-crash bug wrongly caused by revoked "Requests" Permissions, see details.

See Details

The issue was caused, because a a user with the Requests tab open within the Toolbox logged out and then the Permissions for Receiving Requests were revoked. This then caused that the "Requests" tab was removed and this caused the login-crash bug.

 

Fixed a bug which could cause the fw Client to crash in certain scenarios when deleting a repeated Task Booking.

 

Contact Import

#225744

Fixed a bug wrongly causing a "Error Server Modify Please Report This Bug" on fw Server-side imported Contacts.

See Details

Now after doing a CSV import through fw Server > Setup > Contacts > Import Contacts, the issue on not being able to modify imported Contacts is fixed.

 

Contacts

Fixed a bug by which certain Contacts couldn't be edited after the implementation of "Hash & Salt" on Contacts passwords.

 

Fixed a bug wrongly causing the "External Objects" list on Contact type Globals > Supplier Details to get corrupted, after removing a related Object Class.

 

Custom Fields

Fixed a bug which now gets Booking Object Custom Fields when using "Value For Date" to be re-calculated to show the correct values per date range.

 

Dispatch Module

Fixed a bug by which the Dispatch Module was wrongly leaving a gap between Dispatch Numbers when doing auto-Check-In, see details.

See Details

The auto-Check-In requires this setting to be enabled: fw Client > Toolbox > Settings > Server Setup > Dispatch Module > "Offer User To Import Objects From Original Check Out For Object If Its Out".

 
#225793

Fixed multiple bugs related fw Client > Toolbox > Settings >...> "Adjust Booked Object´s Out Day/Time When Checking Back In", see details.

See Details

Fixed multiple bugs related fw Client > Toolbox > Settings > Server Setup > Dispatch Module > Adjust Booked Object´s Out Day/Time When Checking Back In:
- MacKiosk: Missing/Lost items were not being adjusted.
- 1 day Dispatches were not being adjusted correctly.

 
#225793

Implemented support for "minute precision" when creating Dispatches to fix Check-In/Out conflict situations, see details.

See Details

Before the Bookings linked to the Dispatches were being created using the standard 15 minutes precision, causing wrong conflicts when doing a Check Out immediately after the Check In of the same Objects.

 

Financial Report

Fixed a bug that showed date values wrongly within the Financial Reports, see details.

See Details

This bug was introduced with the 6.3 feature of being able to create "Alarms" with Custom Fields type Date, because this "alarm dates" data was not properly cleaned up before printing. Now it is.

 
#225792

Fixed a fw Client crash bug when clicking on fw Client > Long From > Objects tree icon > Reports > Financial Reports On Objects, with no Objects loaded, see details.

See Details

This fw Client crash bug would happen, when clicking on fw Client > Long From > Objects tree icon > Reports > Financial Reports On Objects, with no Objects loaded into the Objects tree and doing this immediately after the login.

 

Hourline

Renamed the dialogue options on "Use Time Range?" when replacing an Object on a Booking and days are marked in the Time Range: "Cancel" => "No" and "Confirm" => "Yes".

 

Fixed a bug on Saved Hourline Views not allowing special characters like apostrophes on "Grouping" names.

 

Fixed a bug where it was no longer possible to drag an Object from the Hourline onto a Booking, see details.

See Details

The bug could occur if the user previously would open the Booking and remove an Object from the Involved tab. On closing the Booking, the Hourline would become un-responsive and it would no longer be possible to drag and drop items.

 

Labour Rules

Fixed a crash when using "working periods" that only cover weekends, see details.

See Details

Working periods are defined in the "Edit Labour Rule" window, and control how many hours an employee is expected to work.
If there was a working period whose range didn't cover any *normal* (non weekend/holiday) work days, it would crash when calculating some Labour Rules related numbers, e.g. when generating reports.

 

MacKiosk

#225798

Fixed a bug by which deactivated Objects that belonged to a Group were causing "Missing Emails" to be sent when doing a Check Out from MacKiosk.

 
#225771

Fixed a bug wrongly allowing to set an earlier Return Date as the actual Dispatch Date, see details.

See Details

This fix is related to the setting in fw Client > Toolbox > Server Setup > Dispatch Module > "Set Date To Today And Actual Time When Setting Status To Dispatched" and only applies to MacKiosk.

 

Media Orders

Fixed a bug causing that "Saved Media Orders" wrongly couldn't be used anymore.

 

Fixed a fw Client freeze bug, when generating a Media Order Report with a Media Order that has Sell price but no Media or Entries attached to it.

 

Mobile Web Client

#219777

Fixed a bug for the "Open Bookings On Involved Tab In The Web Client, iOS and Mobile Web" feature to work on the Mobile Web, see details.

See Details

To enable this setting, go to fw Client > Toolbox > Settings > Server Setup > Open Bookings On Involved Tab In The Web Client, iOS and Mobile Web"

 

PDF Printing (server side)

Fixed a bug in the Invoice Manager when batch-emailing PDF Invoices, which sometimes could wrongly cause Invoices to be sent to the wrong address.

See Details

This fix ensures, that the batch-print process can not be un-blocked until finished.

 

Play

Added on fwplay.com support to modify, delete and sort Comments and implemented video play hotkey support, see details.

See Details

- Added support for dditing and deleting Comments.
- Added support for sorting comments by date and time code.
- Hotkey support added to the video player:
- Space: play/pause
- M: mute
- Left and Right arrow: skip 1 second
- Shift + Left and Right arrow: skip 10 seconds

 

Price Agreements

Implemented a fw Client-side "Price Agreements Integrity Checker" to allow users to remove "Price Agreements" with "Not Yet Applied" status, see details!

See Details

In certain scenarios it can happen that certain Projects within a farmerswife database accumulate thousands of "Price Agreements", which are on a "Not Yet Applied" status. This can happen from a combination of using:
- Virtual Bookings
- Saved Quotes
- Fixed Price Agreements
- and using "New Project From: ..."

The result can be, that multiple hundreds or thousands of "Price Agreement" financial lines get created. These wrongly bloat the affected Projects and thus the farmerswife database. This new "Price Agreements Integrity Checker" now allows the user with "Server Setup" permission to clean-up the most affected Projects.

BEFORE using this feature:
- Carefully read the complete info on this release note!
- Ensure you have run a fw Server-side "Full Backup".
- Check and log size of your main database (DB) file, it's the "current45.efdb" located within the fw Server root installation folder, inside the "system"; it will be larger than 100MB, 150MB or even 250+ MB.
- If you are hosting the fw Server application on Mac and your main DB file (current45.efdb") is bigger than 150 MB and you have experienced fw Server or fw Client crashes as mentioned above, you need to approach this clean-up in steps, one Project at a time. More info below.
- Ensure, that no other user is working on any Project while running this checker. Part of the nature of this issue is, that on opening affected Projects it not only takes a long time (5+ minutes) before all data is loaded, but this can also lead to fw Server and fw Client crashes, due to extreme memory consumption. Typical crash info will state "Fatal error in wish - Unable to alloc xxx bytes".
- A helper to identify "bloated" Projects is, to go to fw Client > module bar "Projects" > go to the sub-menu "Edit View" > and only temporarily add the column "Project / Database Size"; use drag and drop to move it close to the columns "Project / Name" and "Project / Number" for easier use. Also ensure that in the same sub-menu on "Maximum Hits When Searching" is set to "No Limit". Use the "Search" button and click on the column header "Database Size" to sort until you see the "biggest" Projects at the top. You're now set to move on with the below steps. Take a screen shot or use "Open As Spreadsheet" as reference for later.
- Only Advanced Users with "Server Setup" Permission will have access to the "Price Agreements Integrity Checker"!

To use this new "Price Agreements Integrity Checker" go to:
fw Client > Toolbox > Settings > Server Setup > "Price Agreements Integrity Checker" > "Start Checker" button.
This will trigger all Active Projects to be analysed and will alllow on a Project by Project basis to clean up Price Agreements in the "Not Yet Applied" status or inside "Saved Quotes" according to the following rules:

- If a Project View contains more than 100 Price Agreements on status "Not Yet Applied" this checker will remove them.
- If a Saved Quote contains more than 100 Price Agreements on status "Not Yet Applied" this checker will remove them.

For each Project, which applies to the above rules, you'll get a pop-up window, which will list each issue.
You then have three options to choose from:
- "Yes": This will clean-up the listed issues.
- "No": This will skip the clean-up process and move on to the next Project.
- "Cancel": This will stop the "Checker" process and also revert any previous "Yes" or "No" choices.

Special info on BIG DBs in general and specifically if the fw Server is hosted on Mac OS:
The fw Server application on Mac OS is a "32bit" application. This means, it can only allocate max. 3GB of Memory.
When using the "Price Agreements Integrity Checker" you therefore need to approach this clean-up process in smaller steps:
- Know the size of your main database (current45.efdb, see info above).
- First do a "dry run" on using the "Start Checker" button. Because depending on the size of your system and the processing power of the host system, running this checker can take more time than expected for the initial Project analysis to be finished! During this "dry run" we strongly recommend that you take screen shots of every detected Project. This extremely helps, on identifying the Projects, which need to be cleaned-up first.
- Then on using the "Start Checker" button the 2nd time, only use "Yes" on one of the Projects which contains the most "Price Agreements on Not Yet Applied Status" across all Views and Saved Quotes. Use "No" on all following detected Projects. Once the checker is done (= no more pop-up windows), use "Quit" on your fw Client AND use the "Quit" button on the fw Server application.
- Now check the size of your database (current45.efdb) again, and log the reduced size.
- Keep on repeating these exact steps until your database (current45.efdb) has been cleaned up to below 100MB!
- Once your database (current45.efdb) is below 100MB, run the "Start Checker" one more time and use "Yes" on all following Projects.

NOTE: Even after running this checker, there might still be Projects in your system, which have too many Price Agreements on "Not Yet Applied" status.
These might be Archived! You should now unarchive these Projects one-by-one, where you start with he next Project only after having run the "Start Checker" button, clean it by using "Yes" and archiving this cleaned-up Project again.
Or, on some Projects or some Saved Quotes, there were less than 100 "Price Agreements" on "Not Yet Applied" status. It's now possible to manually clean these up, by clicking on the Trashcan icon to the right of each Price Agreement.

This checker will considerably reduce the time needed to load and open the Edit Project window, and avoid extreme memory usage problems on some databases with too many Price Agreements and Saved Quotes.

Contact support@farmerswife.com with reference to this "Price Agreements Integrity Checker" if you require assistance.

 

Project Window

Fixed a bug that was wrongly changing the Sell Rate to "0" in a specific scenario, when replacing the Object Class with an External Object, see details.

See Details

This bug only happened if the setting "Ignore Accessory Rate" (in fw Server > Setup > Financial tab) was set to "Yes".

 

Resources

#225799

Fixed a bug wrongly causing "Incorrect User Or Password" for Contact type Resources who's Web Access was activated AFTER the upgrade to v6.3 Release, see details.

See Details

If a Contact type Resources' Web Access was activated AFTER the upgrade to v6.3 Release, and the Resource used the "Welcome To farmerswife - invitation email to set the password" and setting the password, then on trying to log-in e.g. to the Web Client the resource would wrongly receive the message "Incorrect User Or Password".
This is now fixed.

IMPORTANT:
a) Contact type Resources who set their password BEFORE the upgrade are NOT affected; their passwords work.
b) All Contact type Resources who were invited AFTER the upgrade to v6.3 Release, will encounter the "Incorrect User Or Password" issue. They need to be invited again after the upgrade past 6.3 rev. 16889!
=> Open each Resource and un-tick the check-box for "Web Access" > click on the "Save Changes" button > then tick the "Web Access" check-box again > "OK" button to send the invite > click on the "Save Changes" button.
This will trigger a new "Welcome To farmerswife - invitation email to set the password". This time, setting the password and the subsequent log-ing will work.

 

SQL

Fixed the no longer working "MySQL data interface" by updating outdated 3rd party libraries, see details.

See Details

The internally used TCL MySQL libraries have been updated to the latest stable version of "libmariadbclient".
In order to use "MySQL data interface" on a Linux environment the system should be able to find and load "libmariadbclient.so.18".

For Ubuntu/Debian install package "libmariadbclient18".

 

Server

Added a new variable to the optional fw Server-side "server.cfg" called "PROXY_FILE_PORT", see details.

See Details

If the optional fw Server-side "server.cfg" file is in use, the fw Client error during auto-upgrade "Full Download Installer" process could fail, if this new variable "PROXY_FILE_PORT" would be missing.

 

Fixed a low level fw Server crash bug which contained "key "socket" not known in dictionary" within the stack trace information.

 

Time Report

Fixed a Timereport-icon color refresh bug when using the feature "Set Time As Booked For Missing Timereports On Selected Days", see details.

See Details

Now, when Timereport is completed using the "Set Time As Booked For Missing Timereports On Selected Days" functionality in the fw Client > Long Form > Personnel tree, the Timereport-icon how is correctly updated from red to green in the Edit Project window.

In the Long Form, the Timereport-icon color updated is not "real time" as in the Hourline. In the Long From this is either updated by using the "Refresh" button, or It gets update with every normal "fw Server update" process; typically every 15 seconds.

 

Web Client

Implemented a patch for a reported "clickjacking vulnerability" on Web Client, Mobile Web Client and Play.

See Details

Added a custom handler to Jetty to add "X-Frame-Options: SAMEORIGIN" to the headers of every response.

 

Windows Binaries

Added support for the "LARGEADDRESSAWARE" flag for the 32bit fw Client's "farmerswife.exe" when installed on a Windows 64bit environment, see details!

See Details

In some cases a lot of Memory is needed fw Client side, e.g. when generating Financial Reports or running Labour Rules Closing Point calculations, etc. The fw Client is a 32bit application, and thus limited to the amount of memory it can "address" or "allocate".

In order for the 32bit fw Client application to be able to allocate the needed amount of memory (max. 3GB), finally now the required "LARGEADDRESSAWARE" flag has been applied on the "farmerswife.exe".

IMPORTANT: For this change to take affect on v6.3 SP1 a manual installation or "manual over-installation" of the fw Client application using the existing path is required.

NOTE: To verify if the "Application can handle large (>2GB) addresses" you need to use the Microsoft Visual Studios Command Prompt "dumpbin" tool (dumping /headers pathToFWClients_farmerswife.exe). And then you should see within the "FILE HEADER VALUES" this new information: "Application can handle large (>2GB) addresses".

 

Work Orders

Fixed an fw Client crash bug, when selecting a Project Work Order Custom Field Template.

 

Previous Releases

#16881

14. Jun 2017

6.3 Release