Version: 2024.1.57.4433
Release Date: Not Released
Download Link: Download Currently Unavailable
-
Added the ability to display a popup showing Tractor Zoom comps – In the Tractor Zoom section, a new “See Comps” button was added to the Valuation Equipment Detail page. Clicking on it will get the comps from Tractor Zoom Pro for the specified Make, Model, Year and Hours and display it in the popup.
In the Valuation Equipment Grid (list), a new column captioned “Tractor Zoom” has been added which contains a “See Comps” button. Again, Clicking on it will get the comps from Tractor Zoom Pro for the specified Make, Model, Year and Hours and display it in the popup.
…clicking the button invokes the popup showing comps.
In order to get some results, the minimum required fields are Make and Model. If we invoke the popup without, Tractor Zoom Pro will prompt for a Make and/or Model.
-
Fixed Issue with Website Lookup – If a website lookup was set to have 3 parameters but the equipment didn’t have all 3 parameters as part of the url, it caused a generic error.
- Fixed Issue with Website Lookup – When setting up the lookup, if the user didn’t manually click save, the information was deleted. Chattel now automattically saves when changing fields.
-
Added a System Admin Section – Found under Admin, a new “System Information” option is available on the left pane.
The new option displays 3 blocks of info:
1. Database Information: Edition and Version can be seen in SQL Server management tool (see top left), Name, Size and Space Available are the values you will find by right clicking on your database in SQL Server Management tool and clicking on Properties -> General.
2. Space Used (i.e. Reserved, Index, Unused and Total Data values) are retrieved using sp_spaceused. You can execute it in SQL Server Management by running the following query: EXEC sp_spaceused.
3. Environment Information is of the box/machine where Chattel is Installed.
- Fixed issue with Importing from Iron Solutions – Chattel needed an IssueID which changes every quarter. Iron Solutions provided us with a service that auto updates the IssueID.
-
Fixed Speed Issues with Importing from Iron Solutions –
1) Made it more efficient/faster (bottleneck was on our end). Was taking over a minute to complete.
2) Pre-fetch our lists instead of querying inside the loop ( to speed it up).
3) Report what was added, updated, etc. once done.
4) Enhanced prompt message to let the user know the import action can take a few minutes.
5) Changed the grid cursor to progress while importing to show something is happening.
- Fixed Issue with Depreciated CloseOnOutsideClick – Cleaned up/replaced some deprecated DevExtreme CloseOnOutsideClick items (used on popups).
- Added a Pen Count Tab – A new “Pen Count” tab was added beside the current Valuation Commodity Tab. It contains a gid that looks like:
Pen #
(string)
Appraiser Count
(int)
Customer Count
(int)
Difference
(calculated column)
Commodity
(dropdown)
Location
1
200
210
-10
Heffers 12-18 Months
Location 1
2
180
200
-20
Heffers (xyz)
Grid Explaination:
Pen #: (sting) so they can enter a number or an actual location
Appraiser Count: (int)
Customer Count: (int) example Dairy Comp
Difference: (int) the diff between Appraiser and Customer count
Commodity: A Dropdown allowing the selection of a commodity
Location: A Dropdown allowing the selection of a location
Button Explaination:
Add a new row in the grid
Invokes the Import popup where users will be able to select an Excel spreadsheet to be imported into SubjectPenCount
Pushes the AppraiserCounts to the commodities
Temporary button to help testing this feature. Clears the Subject Pen Counts
In-place Popup for editing Notes
Clicking in the note field will open a popup to add notes.
Adding Pen Attachments:
Click on the image icon in each row to see the pen attachment.
This will open the pen count attachment dialog. Click the trash can associated with the image to delete an attachment.
Import Pen Count from an Excel File:
- Select a spreadsheet via the “Excel file” button.
- Data will be loaded into the grid
- A check will also automatically be performed to validate the data.
- Unrecognized data will be highlighted in red
- Empty cells in light blue
- The user has the opportunity to correct records in this screen prior to import.
- When clicking on ‘Save” the date is imported into the Subject Pen Count table.
- Remaining unknown commodities will be created
NOTE: Unknown location will not be created as we need more info to create a location such as State, County, etc. that may not be available.
Example of a spreadsheet
Import fields Mapping
Ideally, if we have a file with the above column headers, great, the import will be easily mapped to our fields (matches exactly what we need). However, we are somewhat flexible in the column header naming (i.e. we accept column headers that might also make sense).For example: Accepted values are:
Our field
Accepted header values
PrintOrder
“PrintOrder”, “Print Order”, “Order”;
PenNumber
“PenNumber”, “Pen Number”, “Pen”, “Pen #”;
Commodity
“Commodity”, “Commodities”, “CommodityName”, “Commodity Name”, “CommodityNames”, “Commodity Names”, “CommodityId”, “Commodity Id”;
AppraiserCount
“AppraiserCount”, “Appraiser Count”, “Onsite Count”, “Site Count”;
CustomerCount
“CustomerCount”, “Customer Count”, “DC”, “DC Count”;
Difference
“Difference”, “Diff”;
Location
“Location”, “Locations”, “Loc”, “Loc.”, “Located”;
Note
“Note”, “Notes”, “Comment”, “Comments”;
Import help
Import help can be accessed via the Import dialog. Click on the ‘?’ to open the import help screen
- Created API for Pen Counts – An API was needed to download and upload PenCounts on mobile.
- Added the ability to open a subject directly from the mobile Data section – The subject name was visible. But then, if users wanted to go to it, users need to go to the Subject page and search for that name. The SubjectId already existed so we added a link to it in the grid.
- Fixed issue with Pen Count Attachments – If Main Image was already set and another main image was selected, both would be checked. The correct behavior is when a new image is set to Main Image, it will uncheck the current Main Image and check the new one.
- Fixed issue when cloning a subject – Pen counts were not being copied to the cloned subject.
- Added the ability to resolve conflict for pen counts – Just like Equipment, Commodity, Other and Notes, there is the ability to resolve Pen Count conflicts.
- Fixed issue with pen conflicts – There were pen conflicts when uploading a subject even if nothing was changed. This is now resolved.
- Added a difference % column for pen counts – This will display the % difference between appraiser count and customer count.
- Added a Pen Count summary – The pen count tab now shows a summary at the bottom of the Pen Count list with a report group breakdown.
- Fixed issues when pushing pen count to commodity –
1) There was a foreign key violation when pushing to commodity.
2) The commodity screen now refreshes after pushing pen counts.
3) If a user didn’t have any subject commodity and tried to push your pen counts to commodity, the warning message was wrong (shows an incorrect count of created vs updated).
4) The commodity created all had the number 1 instead of the incremental #
- Added the ability to add multiple pen counts at once – When adding new pen count records, Chattel Web now does the same as Chattel Mobile and provide the ability to add multiple records at once.
User clicks on the “Add Pen Count” button
The following dialog is then displayed…
- Fixed Valuation Summary – Overall totals in the summary will now update when a change is made.
- Fixed USDA API Security – The USDA API Key was displayed in full view (unmasked). It is now masked. Additionally, there is now a “Show/Hide” toggle besides the API box.
- Fixed issue with sticky bar – It was not always fully sticky, meaning, it stuck to the bottom (as far as location goes) but sometimes, part of other controls were displayed overtop (ex: grids lines).
- Fixed issue with Chattel Mobile not merging correctly when pushed to Chattel Web – The issue was on the web side, when Merging the mobile subject back to the server.
-
Added Quality to Equipment merge conflict screen.
-
Added Inspection Status on Pen Count.
-
Updated to .NET8 – Updated:
- Developer environment (IDE) to latest Visual Studio.
- ChattelWeb to .NET8 SDK.
- ChattelWeb Nuget packages.
- ChattelWeb Azure Pipeline (develop) to use .NET8 SDK.
- ChattelWeb Azure Pipeline (release) to use .NET8 SDK.
- The build script to use .NET8 SDK.
- Cleaned up some unused using clauses.
- Got rid of deprecated BinaryFormatter.
- Fixed Broken Image – Where the show/hide button (passwords and API keys on the integration screens) , the correct images were shown (at first) but once the button was clicked, the image was broken.
- Fixed Global Sticky Bars –
When the following buttons that invokes a popup were clicked, the sticky bar from the parent window was overlayed on top of the popup:
1) Subject Equipment Import button
2) Subject Commodity Import button
3) Subject Pen Count Import button
4) Valuation Pen Count Import button
5) Valuation Printable Attachment Builder button
6) Valuation Printable Attachment Single Attachment button
7) Attachment Carousel from Subject Attachment
8) Attachment Carousel from Subject Equipment Attachment
9) Attachment Carousel from Subject Commodity Attachment
10) Attachment Carousel from Subject Other Attachment
11) Attachment Carousel from Valuation Equipment Attachment
12) Attachment Carousel from Valuation Commodity Attachment
13) Attachment Carousel from Valuation Other Attachment
14) Tractor Zoom See Comps dialog from Valuation Equipment Detail
15) Tractor Zoom See Comps dialog from Valuation Grid
- Fixed Merging Issue – When merging a Subject (on the web), there were a few pieces missing:
- Subject Equipment – Quality
- Subject Other – Condition and Quality
- If Marking a Subject Other to be deleted (and the record had an attachment) the attachment wasn’t removed link causing an error.
- Fixed issue with conflict resolution – If the server row has been deleted, but there is still a row on the mobile, a conflict is created and the user has the ability to re-add the row. That feature was broken for Pen Counts conflicts (nothing happened).
- Added the number of conflicts on each tab –
- Updated Licensing for GemBox.
- Fixed Sticky bar overlapping – When starting a new valuation and a report scope was selected, the sticky bar overlapped the dropdown.
The Issue..
The fix..
- Fixed Sticky bar overlapping in printable attachments – Part of the Printable Attachment type dropdown was under the sticky bar.
-
Fixed Issue where newly added make in setup did not show in Equipment Detail Search Lookup.
-
Updated GemBox.Spreadsheet Professional License.
- Reconfigured send server logs to send the logs to AgWare’s new ticketing system.
- Fixed issue where conflict tab was not highlighted when a server row was missing.
- Fixed Iron Solutions Import issue.
- Updated installer to include Control Plane – The installer has been modified to include Control Plane. It also installs in a separate folder and product ids as to not overwrite the old install.
There will now be 2 Chattel folders in the agware folder: c:\agware\chattel (the old install) and c:\agware\agchattel (the new).
Two Chattel products will be found when searching for Chattel.
There are also 2 desktop shortcuts for the 2 products.
- (AgWare Internal Information) Tied Web-Dev existing data to a Tenant – The data that existed prior to implementing the multi-tenant feature needed to be available via a tenant.
After the initial migration that added the DBFilter to our tables, the initial DbFilter value was an empty guid (bunch of zeros).
NOTE:Below are the steps needed for getting the old data in a tenant.
STEPS
1) Add a tenant in Control Plane and name it chatteldemo-dev.
In SQL Server Management, query what the TenantId is in the Tenant table for web-dev.
Update (in SQL) the ControlPlane database -> Tenant.DBFilter value to be 00000000-0000-0000-0000-000000000000
SELECT * FROM Tenant
UPDATE Tenant SET DBFilter = ‘00000000-0000-0000-0000-000000000000’ WHERE TenantId = ‘<YourTenantId>’
2) Update (in SQL) the Chattel Database -> Tenant.DBFilter value to be 00000000-0000-0000-0000-000000000000
SELECT * FROM [ChattelDemo-Dev].[dbo].[TenantAuthenticationMetadata]
UPDATE [ChattelDemo-Dev].[dbo].[TenantAuthenticationMetadata] SET DBFilter = ‘00000000-0000-0000-0000-000000000000’ WHERE TenantAuthenticationMetadataId = 1
Form then on, when using the chatteldemo-dev tenant, the old (existing date) will be connected to that tenant. This can be tested by searching for Subject, all the data used to prior to introducing the Multi-Tenant feature will be available.
- Added OpenID for Authentication – In ControlPlane → Auth there is now an OpenIdConnect option.
For documentation on how to configure OpenId connect, see:
Go to Azure App Registrations
Click on Overview → EndPoints and grab the OpenId Connect URL value (near the bottom of the page):
