Release notes for Evatic Service Hub

7.3.14

What's new
Bugfixes
- Calendar integration with Office 365 imported activities from office 365 with the wrong timezone. (45035)

7.3.13

What's new
- Added a new integration for Shipcloud. In this first version of the integration it is possible to export packing slips to Shipcloud. (43939) (* This version also includes a new integration for mail import (M2M Mail Import), this integration is still in development and if you try to use this integration it will not import anything in the current version. (45225))
Bugfixes

7.3.12

What's new
- Added a new jobpart for the clean old data job, the jobpart will delete all tokens where valid until date is older than x months. (44900)
Bugfixes
- REST Api: Fixed issues when setting status to exported on non-invoiceable orders (44265)
- REST Api: Correcting problems and performance for the GetOrders endpoint (44268)
- REST Api: Export Supplier Invoices (45007)
  - Added supplier and supplier order guids to the stored procedure and GetSupplierInvoices result set, it is now possible to filter on status, with or without date constraints.
  - It is also possible to set status E (=exported) on supplier invoices using the UpdateSupplierInvoiceStatus endpoint, with the correct Invoice number, supplier guid and supplier order guid. Using a wrong combination (ie if invoice is not found) will return an error message. Using an invalid status code will also return an error message.
- REST Api: Customer/GetAddresses corrected so Invoice in the result is fetched from the correct database field. (45130)
- Connect by file: Export Supplier Invoices (45007)
  - Export will now filter by status 'F', not by the date of the latest run. On the first run after upgrade, the file will contain all orders/invoices with status 'F'. So before upgrade it could be useful to manually set the status to 'E' for all older supplier orders in both SUPPLIER_ORDER_HEADING and STOCK_ADMIN_ORDER_HEADING tables so only newer supplier orders/invoices are exported.
  - Added field Order_type to the export data. For an existing integration, the field will have to be added manually.
  - Split Supplier invoice headings and lines to separate files in the default config. This happens automatically on a new integration. For an existing integration, you have to edit the configuration strings for the integration for each of headers and lines, and set a different file name for each of them.
  - After export, status will be set to 'E' in both SUPPLIER_ORDER_HEADING and STOCK_ADMIN_ORDER_HEADING tables.
  To get all changes without much manual effort, we recommend you add a new connect by file integration
REST Api - UpdateServiceJob: changed filter on stored procedure esh_get_SERVICE_JOBS so the correct job gets updated. (44276)
REST Api/Swagger documentation for Order/CreateOrder - changed DTO's to indicate which fields are mandatory and optional. (45042)

7.3.11

What's new
- New Rest API endpoints for machine properties (Machine/UpdateMachinePropertyValue and Machine/AddMachinePropertyValue). (43797)
Bugfixes
- FMAudit: service reference is updated for FMAudit Central 4.5 (43367)
- Exchange sync (Azure): Corrected problem iterating more than 10 items from the server. (44390)

7.3.10

What's new
Bugfixes
- COP integration:
  - Export of direct supplier orders - delivery and end-user addresses are now included in the orders data and sent to COP (43823)
  - Supplier orders was sent with hardcoded create order mode add_send_testmode. Now you can configure the COP integration and select between: add, add_send and add_send_testmode (43876)

7.3.9

What's new
- The show password toogle button is removed from connections and edit integration views in ESH. It is no longer possible to see an existing password in the user interface. (43394)
Bugfixes
- REST API: Deprecated endpoint routes: Many of the endpoints have double routes, both {controller} and {controller}/{id}. We have deprecated most of the {controller}/{id} routes. There is a warning on these endpoints in the documentation on https://docs.asolvi.com/evatic/applications/esh/ThirdPartyEshAPI/restapi.html. We plan to remove the obsolete routes during Q3 2021, (late July or early August 2021).
- Improving REST API - GetServiceJob endpoint. (43659)
  - stored procedure esh_get_SERVICE_JOBS added. (43664)
  - removed limitation that EXTERNAL_SYSTEM_OBJ must have a value. (43660)
  - removed hardcoded TASK_NO=1. (43661)
  - missing fields added to the response. (43662)
  - filters added (43665):
    - Received date
    - Last changed date
    - Node text
    - Task number
    - Status
- Improving REST API - GetOrders endpoint. (43666)
  - The SQL stored procedure esh_get_ORDERS_ORDER_HEADING which gets orders has been rewritten to give more accurate data.
  - New filter for Department has been added.
  - An option for running a paged query has been added.
  - The TimeZone filter was never used and has been removed from the request model.
  - Visit https://docs.asolvi.com/evatic/applications/esh/ThirdPartyEshAPI/restapi.html and our swagger documentation which you can find on <your_esh_url>/api/docs, for more information on this and on the ServiceJob endpoints. In the swagger documentation you can also try out the REST API endpoints.
- Improving REST API - UpdateServiceJob endpoint. (43655)
  - Added multiple fields that can be updated
  - Changed so all the fields are now only updated if they are set.
- ECMM:
  - Printfleet (and KFS) group trees changed behaviour: When a parent node is checked, all the child nodes will automatically also be checked. If only some children are checked, the parent will be shown as partially checked (filled square instead of a check mark). (43317)
  - General ECMM integrations - device view:
    Added tool tips to the external meter and consumable name fields in the device view, so the full names are displayed on mouseover.
    Fixed an old issue with the virtual scroll so all external meters and consumables are shown in their respective grids.
- Corrected bugs/error messages running Exchange sync. against a azure server with oAuth. (43650)

7.3.8

What's new
- Orders finished in COP will now also update the quantity on stock in Evatic. (41629)
Bugfixes
- Added a test and a warning if meters for a device from FMAudit are null or empty (43367)
- Improving REST API - Order endpoints, including;
  - changing the datatypes on OrderNo and LineNo to always be int. (42180)
  - changing the HTTP response status when no data is found from 400 to 200. (42179)
  - adding InvoiceCountry to the response data from the GetOrders endpoint. (42167)
  - improving documentation and correcting a bug on the UpdateOrder endpoint. (43492)
  - improving documentation on the SetOrderAsExported endpoint. (43492)
  - adding missing fields and correcting fields not saved correctly in CreateOrder endpoint. (43492)
- Improving REST API - Added a new field called "SearchName" for the Customer/CreateCustomer and UpdateCustomer endpoints. (43262)

7.3.7

What's new
- Datawarehouse integration is removed. (41099)
- HP Smart Device Services integration is removed. (41101)
- SMTP integration is removed. (41100)
Bugfixes
- Connect by file: it was not possible to import articles where ArticleInfo was longer than 256 characters. This is now corrected. (42100)

7.3.6

What's new
- REST Api: added export of supplier invoices with pagination to the GetSupplierInvoices endpoint. Includes order_type in the response. (42400)
- Connect by file: Export supplier invoices includes order_type (42400)
- Improved documentation for the REST API. Both improved https://docs.asolvi.com/evatic/applications/esh/ThirdPartyEshAPI/ and also addded some documentation on your installation "yourinstallationofesh"/api/docs. (38794)
Bugfixes
- Connect by file/Staging tables: import customers - set VAT_CODE as an optional input parameter on a stored procedure, with a default value of null. (41298)
- Xerox - not importing meters and consumables where ExternalModelName is null in the mapping (42605)

7.3.5

What's new
- Calendar sync now supports a more secure connection to Azure using Microsoft.Graph and OAuth 2.0. The reason for doing this is that Microsoft soon only accepts multifactor authentication (MFA) for the online Exchange Web Service.
  This requires registering your app with Microsoft Identity, see our documentation on how to do this. Registering the app will give a TenantId, ApplicationId and User Secret which will replace the existing delegate user. This means we no longer need to save the delegate username and password in the Evatic Service Hub database.
  Access to calendars is configured in Azure on the application, and the delegate user access on email accounts can be removed.
  The sync itself is unchanged and works as before. If you use an on-premise Exchange Server (some of our customers do), nothing will change. You can use the Calendar sync as before. (42048)
Bugfixes
- Problem with timeouts in Third Party ECMM integrations. Added a job to clean up in temporary tables and improved the clean up functionality. (39411)
- StagingTables web service: Added more error handling in the StagingTables.svc Set.. functions, to prevent unhandled Exceptions to be sent back to the caller. (42266)
- FMAudit v.4: number of devices imported now showing in the job log. Also added more error feedback (42304)

7.3.4

What's new
- Improved the REST Api calls for customer, added pagination to the GetCustomers endpoint. Added OrgNo to the result of all calls and ensured that VatCode is set on create and update. (40465)
- Housekeeping - job parts were added to delete old entries in the JobLog table. The "Delete older than (months)" setting on the job indicates which entries are deleted. Indexes are being rebuilt after deletion. See help files for more information on the housekeeping job. (37690)
Bugfixes
- Visma Admin - Address import - Checkboxes for visit and delivery is not "un-set" on the existing addresses from Visma Admin if delivery or visit address is added at a later stage. (40993)
- FM Audit service reference updated, PageCountColorUsageOther is now a valid value for FAMeterNames. (41215)
- CalendarSync - steps taken to improve performance. We have added an index on the timestamp to speed up query for last run fullsync, and avoid timeouts. Also, job parts were added to the housekeeping scheduled job to delete old entries from and to rebuild indexes on the JobLog table. (37690)
- Xerox Managed Print Services API - wrong counters/duplicate counters due to not using model name in the mapping. Also added missing warning about this to log. (42186)

7.3.3

What's new
bugfixes
- Printfleet toner consumables: some new DCAs no longer send the label property. We have changed the code to use the standardType property instead. Display name has been changed from TONERLEVEL_<color> to Cartridge.Marker.<color> in the Devices - consumables view in ESH. Some consumables may need to be re-mapped (39964)
- Calendar Sync: Back-end changes, to prepare for a new Azure application login which will replace the delegate user for our customers using Microsoft Online/ Office 365. No functionality changes. The .NET version has been upgraded to 4.6.1. Most calls to Exchange have been made async, but this should have no visual or functional impact on any customers. (37512)

7.3.2

What's new
- COP integration:
  - New job was added for exporting supplier orders from Evatic to COP. In the integration setup, specify which suppliers to export for. (39686)
  - New job part in the import: Import supplier order status updates from COP to Evatic. Again, only for suppliers specified in the integration setup (37552)
Bugfixes
- Visma Admin: Not required to select stock if stock is not used (38081)
- Staging tables integration:
  - Export: It is now possible to configure which exports will be run from Evatic to the Staging tables.
  - Delete old data: We have done some fixes and alterations to make the delete operations work better.
    - A bug was fixed for the stored procedure which gets transactions to delete. It now returns the correct number of rows.
    - Increased timeout value for the job.
    - A new index is added to the ESH database table to optimise the delete queries
    - It is now possible to configure the batch size for deleting old data.(between 1 and 5000 rows, default is 5000)
    - It is now possible to configure a number of hours back in time for deleting (between 1 and 72 hours, default is 24)
  - It is recommended to not run import/exports when the delete job runs. Deleting a large amount of transactions will take time and set locks on the tables, so maybe only run the delete job a couple of times each day. Plan your jobs in order to run in an optimal way for your business. (38052)
- JetAdvice:
  - Fixed a bug in Test connection in the integration setup
  - Also fixed an error with TLS1.2 which prevented running the ECMM job (40852)
- Staging tables integration: Changed length for column USERNAME to 254. Fixing error=Cannot set column 'USERNAME'. The value violates the MaxLength limit of this column. (37552)
- Rest Api UpdateOrder: fixed wrong error msg 'Unexpected character encountered while parsing value- O.' Properties set to nullable according to table ORDER_HEADING (36177)

7.3.1

What's new
Bugfixes
- Rest API UpdateAddress: able to set invoice, delivery, visit, post and letter from 1 to 0. (38740)

7.3.0

What's new
- COP Integration - We have added the import of articles(parts) from COP to Evatic. It will be displayed as a new integration on the integration list.
Bugfixes

7.2.0

What's new
- Fortnox Integration - We have added the import of customers from fortnox to Evatic. It will be displayed as a new integration on the integration list.
Bugfixes
- Visma Admin AdkNet4Wrapper updated to version 2020.1 (39293)
- Performance improved for Visma Admin integration, export of orders is now much faster, and import of data from Visma Admin will only import changes after last run. (38515)
- Fixed a byte size error when importing from Printfleet. This was caused by a string separation character being saved as an unknown character.(39881)

7.1.11

What's new
- ECMM PrintFleet - We have now changed how we import values for Waste Toner Box, Staple Cartridge and similar consumables from PrintFleet. The system will now look at the supply status from PrintFleet and set the level of the consumable based on this. Currently we get 3 statuses from PrintFleet. OK = 100%, Warning = 25% and Critical = 0%. Toners and other consumables that gives numeric values from PrintFleet is not changed.
Bugfixes

ECMM PrintFleet - Improved error messages and handling of login to PrintFleet (Error messages from GetAuthenticationToken). (37209)

7.1.10

What's new
- Evatic Service Hub REST Api - Contact: new endpoints CreateContact and GetContacts. (36487)
- Evatic Service Hub REST Api - Contact: new endpoints UpdateContact. (37201)
- Improvements and corrections made to the ECMM behaviour related to stop import of consumable levels where all values for a device is 0 (38313) For more information about how the rule now works, see help for the setting "CONSUMABLE ZERO VALUES CHECK ON IMPORT" in Evatic Administration Web.
Bugfixes

7.1.9

What's new
- Evatic Service Hub REST Api - Customer: UpdateAddress added (38120)
- Evatic Service Hub REST Api - Customer: GetAddress added (38121)
- Evatic Service Hub REST Api - Customer: GetAddressByExternalSystemKey added (38122)
- Evatic Service Hub REST Api - Customer: CreateAddress - will not create if ExternalSystemKey already exists (38123)
- Evatic Service Hub REST Api - Customer: Create/Update/Get - vat code (38124)
- Evatic Service Hub REST Api - Customer: Create/Update/Get address with invoice as email invoice as email address (38125)
Bugfixes
- Evatic Service Hub REST Api - CreateCustomer/UpdateCustomer - If customer status is empty or not valid, should be default set to C (37872)
- Consumable reading show no data to display in ESH. (38184)

7.1.8

What's new
- Establish ability to prevent 0 value (non-invoicable) orders to be exported to Visma Admin. (37962)
Bugfixes

7.1.7

What's new
Bugfixes
- Corrected problem with wrong order of lines on some orders exported to Visma Admin (37829)
- Wrong url for documentation on Staging Table integration has been fixed and updates old versions when updated (35117)
- Addresses changed in Visma Admin will now be updated in Evatic. Note: Support must run a sql script on the Evatic database to update existing addresses (37547)
- Use CreateAddress in REST API to update an existing address using ExternalSystemKey without getting "Error creating address". Added message: "Error confirming address" if address create/update cannot be confirmed (37872)

7.1.6

What's new
- Machine REST api: Added endpoints for adding consumable levels (ECMM). (36636)
- Machine REST api: Added endpoints for adding/getting meter readings. (36170)
Bugfixes
- Xerox: When exporting service project, priority code was changed to N. (37466)

7.1.5

What's new
- Stock REST api: Added endpoints for doing stock inventory (UpdateStockInventory). (36850)
Bugfixes

7.1.4

What's new
- Supplier order REST api: Added endpoints for adding supplier invoice information (CreateSupplierInvoice), and for updating supplier invoice status (UpdateSupplierInvoiceStatus). Please see our REST api documentation, section SupplierOrder, for information on how to use. (36645)
- Order REST api: Extended the information given on a GetOrder request. The result now contains information about total sums, customers vat code and bank/IBAN information. (36674)
Bugfixes
- Connect by file/API - import articles: Reduced field length of field ArticleNo. The field length was 40 in the staging database, but now only allows 30 characters to match the field size in the Evatic Database table ARTICLE. (36076)

7.1.3

What's new
- RESTFul Service Api End Point for retrieving and update status/orders numbers on supplier orders added. (36588)
- RESTFul Service Api End Point for receiving parts on supplier orders added. (36644)
Bugfixes
- ESH scheduler: Scheduled jobs may not start automatically after scheduled or unplanned server reboot. Configure some settings in IIS to make sure this happens
  - In Windows Features, under Internet Information services/World wide web services/Application Development features, turn on Application Initialization.
  - In IIS Advanced settings for the application, Set Preload Enabled to true
  - Also in IIS, make sure the application pool is set to Always running (36805/36809)
- Visma Integration - fixed some problems with the general integration (36805)
  - When two or more jobs run consecutively for a Visma integration (export data and import data), the Visma Adk.dll frequently crashes. You would get an "application pool recycled" error in the ESH job log. The best solution would be to schedule the two jobs to not start/ run at the same time, or run all job parts in one job. We have added a check that if one job is running, the other will be skipped. (36938)
  All of the fixes below concern the Visma Administration integration's order export:
  - Visma Order export - handle null value in CUSTOMER_REFERENCE_INFO (36806)
  - Timestamp was removed from the export filter - now all orders with status F or FP are exported. After the export, it will be set to E.(36807)
  - when exporting credit orders as orders, the quantity will now have the correct (negative) sign.(36992)
  - OrderHeading is set delivered if this is an order export and the correct choice is set for Set delivered qty (36811)
  - Added checkbox on the integration to allow user to choose to include contract no on orders. Default unchecked (36810)
  - export of orders crashed when sales/cost price were NULL/empty. Replaced NULL values with 0.0 (36812)

7.1.2

What's new
- RESTFul Service Api End Point for retrieve stock inventory added. (36182)
- RESTFul Service Api End Point for retrieve/update stock transactions. (36183)
- RESTFul Service Api End Point to create a Sales Order (36177)
- RESTFul Service Api End Point to update the Info fields on a Sales Order (36498)
- RESTFul Service Api End Point to update the Priority and TaskTree node on a ServiceProject (36496)
Bugfixes
- ECMM - Duplicates in the meter mapping could in some cases cause meter letter date advancing incorrectly. (34541)
- Connect by file - Custom configuration fix for one customer: An old hotfix (22290) was not implemented in the Insider version (36210)

7.1.1

What's new
- With this release we have implemented a new way to login to ESH, using Auth0 as our identity provider. Auth0 centralises login functionality and offers other benefits that we will explore going forward.
  Users will need a user account and an associated email address in Evatic Admin Web (read more...).
  Also the users will need permission to log into ESH. This permission is given on a role level in EAW. The scheduled jobs and other ESH functionality will work as before. You will still need a SQL user for running the jobs, which will need to be added when installing and upgrading ESH. (32742)
- Have added a new REST API CloseServiceJob which uses functionality from UpdateServiceJob to close a job only #32744
- Included extra returned values from GetServiceProject as per customer request. #35998
- FM Audit integration testet for version 4.4.84 (36097)
- ESH Get Sales Orders api,Retrieves header & connected lines. Filter by Invoice Date range and Not Invoiced, Last Changed Date range, Status (35996)
- Added the table "Log" to the job: "Clean Old Data" to improve performance on handling the log table. (35454)
- RESTFul Service Api End Point for Creating, Updating and Retrieving Articles added. (36178, 36181, 36179)
Bugfixes
- Fixed an error which occurred when installing ESH on a new Evatic database. A search for existing housekeeping jobs failed on a new Evatic database, because a connection had not been installed yet in ESH. (36247)
- Fixed error parameter value out of range for prices when importing articles using connect by file. (35868)
- Running Connect By API and fetching orders the field "InvoiceType" was sometimes wrong. (36180)
- Better error handling on the SetOrderLinePartReceived method in the SupplierOrder web service. Also fixed an error in the same method where it was not possible to update a supplier order line. (36019)
- Fixed Visma Admin Order Export date issue when exporting from Evatic. (36226)

7.1.0

What's new
- With this release we have implemented a new way to login to ESH, using Auth0 as our identity provider. Auth0 centralises login functionality and offers other benefits that we will explore going forward.
  Users will need a user account and an associated email address in Evatic Admin Web (read more...).
  Also the users will need permission to log into ESH. This permission is given on a role level in EAW. The scheduled jobs and other ESH functionality will work as before. You will still need a SQL user for running the jobs, which will need to be added when installing and upgrading ESH. (32742)
- Have added a new REST API CloseServiceJob which uses functionality from UpdateServiceJob to close a job only #32744
- Included extra returned values from GetServiceProject as per customer request. #35998
Bugfixes
- Fixed an error which occurred when installing ESH on a new Evatic database. A search for existing housekeeping jobs failed on a new Evatic database, because a connection had not been installed yet in ESH. (36247)

7.0.0

What's new
- Input checks have being added when creating a new integration on ESH. Name is a required field for saving and warnings are being shown when fields necessary to test and run the integration are missing. (35753)
- A new integration for cleaning old data from the Evatic database has been added, currently implemented for cleaning old Machine Consumables data (3481)
- Various new endpoints created to use CustomerNo and not CustomerGuid in the arguments (35707)
Bugfixes
- Visma Administration integration: Supplier addresses will now be imported with suppliers. (35347)

6.9.2

what's new
- Connect By File: For AOP, create AOP-specific configuration with file paths using database name. Type the keyword AOP in the integration name. NB: This will only happen for new integrations. Existing integrations must be updated manually! (35568)
- Improved feedback on Test connection for all integrations which have a test connection button in the integration setup. When setting up new integrations, it is now possible to test a connection before saving the integration (32013)
- Export to Visma Administration: the field CUSTOMER_REFERENCE_INFO is now transferred to Visma Admin field "Referenskod" (Electronic reference). (35646)
bugfix
- Winserv: Contact name is split into first and last name (32899)
- ECMM: If a new meter reading is the first, higher or the same as an old reading then it is added (33154)
- Visma: Prevented overwriting invoice address when two address entries are exactly the same for a customer. (35485)
- Xerox: Tickets closed in Evatic are also closed in Xerox (34725)
- Staging tables integration: Now exports Post_location as part of address and customer exports to staging_out tables.(35246)
- StagingTables webservice: Bugs in GetCustomersData has been fixed. A bug in GetAddressData was fixed. This method will now also return Post location as part of the address export.(35246)
- ESH Database changes: The Post location was added to addresses in the stored procedure STAGING_select_STAGING_OUT_CUSTOMER_for_TransactionId. 2 new fields for post location have been added to the STAGING_OUT_CUSTOMER table.(35246)
- Xerox: Fixed the corrupted texts on service projects. Also the symptom text and internal comment are no longer added twice.(35740)
- Visma: Corrected problem with wrong contact code set on contacts imported from Visma Admin. (35116)
- Visma Admin integration: Fixed a counter error which gave an error message on some successfull article import runs.(34202)

6.9.1

what's new
- Zapier: As zapier requires separate address fields Return Invoice Address object from Customer search aswell as the invoice address string (35300)
- Zapier: Add Getcountries function (35300)
- Zapier: Add Address to customer (35691)
- M2M - Machine to Machine is changed to ECMM - Evatic Consumable and Meter Management (33936)
bugfix
- Zapier: Customer import fix for boolean values written to the database as T/F rather than 1/0. CalculateVat, UseInvoiceFee, CalculateInterest (35300)
- Importing consumables with zero value is checked for sanity. A warning will be displayed in job log (34680)
- FMAudit integration: Empty field for dealer gives an exception. (29714)

6.9.0

what's new
- Xerox: Service jobs created in Evatic are exported as incidents to Xerox. (34725)
- Xerox: Ability to configure which folder/node a service project generated from Xerox should be saved in. (34130)
- Xerox: Ability to configure a default agent which is to be assigned when tickets are closed in Xerox. (34555)
- Verified that our JetAdvice integration will work with the new version of JetAdvice Manager API v3.0 (34662)
- Zapier: Get list of Departments for customer create (34814)
bugfix
- Kyocera: Connection issues using cookies inside the Kycorea network fixed. (34784)
- Kyocera: The length of the string exceeds the value set on the maxJsonLength property. (35017)
- Evatic Service Hub REST Api - Service: AddressManager - Update additional fields BANK_ID, BANK_NAME, BANK_ACCOUNT, IBAN, BIC, MandateRefNo (34620)
- Allow entry of customer number instead CustomerGuid when creating a service project
- Added text input for default country code on Connect by file, Connect by Api, Staging Tables and Visma integrations.
  Implemented use of a default country when country is missing. Delivery address is now set as visit address when no visit address exists (and vice versa). Mailaddresses are not set as visit/delivery address unless a delivery or visit address is missing. Prevented import of country/postal address with empty country code, post code or postal location. (34940)
- VISMA: Bug fix setting correct value to fields calculate_vat and open_for_invoice. (35307)

6.8.2

what's new
- Verified that our JetAdvice integration will work with the new version of JetAdvice Manager API v3.0 (34662)
bugfix
- Evatic Service Hub REST Api - Service: AddressManager - Update additional fields BANK_ID, BANK_NAME, BANK_ACCOUNT, IBAN, BIC, MandateRefNo (34620)
- Department list Api call (34814)
- Allow entry of customer number instead CustomerGuid when creating a service project

6.8.1

what's new
- Evatic Service Hub REST Api - Service: CreateUpdateServiceJob added (34487)
- Evatic Service Hub REST Api - Service: CreateServiceJob added (34487)
- Evatic Service Hub REST Api - Service: UpdateServiceJob added (34487)
bugfix

6.8.0

what's new
- Xerox: Asset Operability is configurable and set when closing tickets (34133)
- Staging tables integration - OrderLine Export: The fields INFO_01, INFO_02 and ACTIVE_FROM are now exported on order lines and available via the web service (34235)
- Evatic Service Hub REST Api - Customer: GetCustomerByCustomerGuid added (33827)
- Evatic Service Hub REST Api - Customer: GetCustomerByCustomerNo added (33827)
- Evatic Service Hub REST Api - Customer: CreateUpdateCustomer added (34034)
- Evatic Service Hub REST Api - Customer: CreateCustomer added (34083)
- Evatic Service Hub REST Api - Customer: UpdateCustomer added (34083)
- Evatic Service Hub REST Api - Customer: GetCustomers added (34306)
bugfix
- Visma Admin: when no separate delivery or visit address, tick the Visit and Delivery checkboxes on the main address. Added Address name for the main and visit addresses. (34204)

6.7.0

What's new
- Xerox ticket management configuration:
  - Custom properties for closed status now shows which ones are mandatory.(33807)
  - Action codes added to the mapping of resolution type. Configuration view changed for better user experience. (33779)
  - Errors and feedback on update of tickets are presented in job log. (33782)
Bugfixes

6.7.0_patch

Fixed bug
- Connection issue inside the Kycorea network fixed (34784)

6.6.1

What's new
- Xerox ticket management configuration: It is now possible to select a contact person in the configuration setup, but it is still necessary to run the ECMM (M2M) job and map at least one device to be able to set up the other parts of the ticket management configuration. This configuration will be used when updating tickets in Xerox on import of new service projects, and when closing tickets in Xerox after they are closed in Evatic. (33780)
Bugfixes
- Symptomcodes from Evatic did not override problem types, problem sub types and problem resolution types set by Xerox (33244)

6.6.0

What's new
- Xerox: Configure mapping of symptom codes to problem types, problem sub types and problem resolution types (33244)
- Xerox: Configure mapping of bookmarks (using {}) or default values to custom properties (33422)
Bugfixes
- Visma integration, importing articles: Code changes to remove memory leaks. Implemented batch imports on the article import. Fixed an error which occurred when importing articles with stock management when prices had null values ("Input string was not in a correct format"). (33098)
- Visma integration, importing customers: Data for addresses was incomplete. Added fields that were missing. (33420)

6.5.7

What's new
- New REST Api for machine added to pull information from Evatic. (33155)
- VAT is included in the WinServ migration of articles. (32903)
- ConnectByFile: Migrated machine and customer addresses can be set to master/external master in configuration (32208)
Bugfixes
- Calendar sync - a timeout was caused because a query on the JobLog table took too long. This was due to a very large table. A workaround for customers would be to delete old entries from the JobLog table. Now we improved the indexing of the JobLog table to make the query run faster. (32507)
- Calendar sync - error when removing deleted appointments and task. "Unable to cast..." or "The item type returned by the service (Appointment) isn't compatible with the requested item type (Task)" or "The item type returned by the service (Task) isn't compatible with the requested item type (Appointment)". (32061)
- Calendar sync - fixed an error which caused null value exceptions when deleting assignments in Exchange (Cannot cast DBNull.Value to type 'System.DateTime').(31848)

6.5.6

What's new
Calendar sync: fixed corrupted links in appointments. This is a workaround fix which shows clickable links. Exchange does not support HTML in appointments, so they will strip away any url, making the links unavailable. In our fix, the links may be shown differently than the original, but at least be available.(30692)
Winserv pool (bundled) contracts: Removed child machines from the fixed price contract rows.
Added calculate all rows as total volume checkbox for pool contracts (32563)

6.5.5

What's new
- Winserv Migration: Pool contracts (32125)
  - Winserv pool contracts headers have new data imported for contract selection add all volume rows
  - Article number added to information of volume row
Fixed bugs
- Xerox Managed Print Services API (32870)
  - Default configuration for ProblemTypes, ProblemSubTypes, ProblemResolutionTypes when updating tickets (33035)

6.5.4

What's new
- Winserv migration: machines export is now a SQL script. Pool machines and inactive machines are excluded from the export. Country codes from the LAND table are included. Get machine contact (MASKINER.OP) instead of accounts contact (MASKINER.REF) (32562)
- Added model import with model-meters to the machine and model import. (32886)
- Xerox Managed Print Services API (32870)
  - All consumables are calculated to percent
Fixed bugs
- Xerox Managed Print Services API (32870)
  - Faster import of devices. Only devices which are InScope are imported.
  - Faster import of tickets. No update of tickets.
  - Import only tickets with statuses mentioned in configuration (both open and closed).
  - Handling the limit 100 on filter objects when importing devices, meters, consumables and tickets
  - Imported consumables not visible in Evatic. All consumables was mapped to all devices.
  - Used oldest meter readings as last meter reading date

6.5.3

What's new
- Escalating Helpdesk tickets from Zendesk to Evatic service via Zapier and REST API (31510)
Fixed bugs
- Error 'Value cannot be null' when importing tickets and devices from Xerox (32824)
- Fields missing from procedure STAGING_select_OUT_MACHINE_for_TransactionId (32284)

6.5.2

What's new
- Integration to Xerox Managed Print Services API (31849)
  - Added job for update of tickets in Xerox when tickets are imported to Evatic or closed in Evatic (32186)
  - Added import tickets jobpart. Tickets which are imported to Evatic and closed in Xerox are alse closed in Evatic (32185)
Fixed bugs
- Changes to the staging tables import method to prevent the staging tables in the ESH database from growing uncontrollably. (#32170)

6.5.1

What's new
- Integration to Xerox Managed Print Services API (31849)
  - Added jobpart for import of tickets (26132)
  - Changed EXTERNAL_PROJECT_NO in table PROJECT_TASK to alphanummeric. Required for import of tickets from Xerox (32254)
Fixed bugs
- Meter reading is not updated with recent information from fleet system (31300)

6.5.0

What's new
- Integration to Xerox Managed Print Services API (31849)
  - Added jobpart for import of devices (27320)
  - Added jobpart for import of meter readings (32025)
  - Added jobpart for import of consumables (31850)
  - Export package/tool for migration of Winserv data to Evatic. The package contains a set of .wsx export configurations, and a batch file to run the export. There is also a ReadMe.txt file, read this for instructions on how to proceed. Additionally, for the import to Evatic, create a new Connect by file job with the keyword Winserv in name and description. Import configurations will be created which match the Winserv exported files (31418)
- For Winserv, grouped the imports into 4 groups which can be run one-by-one. Added contracts import (32171)
Fixed bugs
- Errors on scheduling for Kyocera Fleet Import (30918).
- For Sage integration. The value 1 was used for all quantities when exporting invoices (31831)
- For Sage integration. Credits did not have the correct format when exporting invoices (31868)
- External Helpdesk API. The API returned a null-value response when errors occurred inside the service. Improved error handling and fixed some small bugs in the service implementation code. Exceptions will now return a SOAP-readable System.ServiceModel.FaultException instead of an unhandled Exception. (31514)
- Missing consumables in M2M for some machines in Print Fleet (32118)

6.4.2

What's new
- Integration to Xerox Managed Print Services API (31849)
  - Added jobpart for getting meter readings (32025)
  - Added jobpart for getting devices (27320)
- Export package/tool for migration of Winserv data to Evatic. The package contains a set of .wsx export configurations, and a batch file to run the export. There is also a ReadMe.txt file, read this for instructions on how to proceed. Additionally, for the import to Evatic, create a new Connect by file job with the keyword Winserv in name and description. Import configurations will be created which match the Winserv exported files (31418)
Fixed bugs
- Errors on scheduling for Kyocera Fleet Import (30918).
- For Sage integration. The value 1 was used for all quantities when exporting invoices (31831)
- For Sage integration. Credits did not have the correct format when exporting invoices (31868)
- External Helpdesk API. The API returned a null-value response when errors occurred inside the service. Improved error handling and fixed some small bugs in the service implementation code. Exceptions will now return a SOAP-readable System.ServiceModel.FaultException instead of an unhandled Exception. (31514)

6.4.1

What's new
- Integration to Xerox Managed Print Services API (31849)
- Export package/tool for migration of Winserv data to Evatic. The package contains a set of .wsx export configurations, and a batch file to run the export. There is also a ReadMe.txt file, read this for instructions on how to proceed. Additionally, for the import to Evatic, create a new Connect by file job with the keyword Winserv in name and description. Import configurations will be created which match the Winserv exported files (31418)
Fixed bugs
- Errors on scheduling for Kyocera Fleet Import (30918).

6.4.0

What's new
- Connect by file and staging in general: Changing the way we do staging - we implemented overwriting existing rows in the STAGING_IN_ tables instead of constantly inserting batches of new rows. Hopefully this will help keep the ESH database at a more predictable size.
  Also when importing from staging to Evatic, we made changes so only transactions with status Waiting are imported. (30864)
  - some changes were done in the import configuration:
    1. Added field ExternalTaskNo for the import of ProjectTasks.
- Default configuration for importing data from Winserv using Connect by file (31505)
Fixed bugs
- Configuration for the Sage Integration is now visible (31869).

6.3.15

What's new
- Connect by file: Added new import of suppliers. Supplier addresses should be imported separately in import of address.
  Address import: Field for CustomerNo has been renamed to SourceNo for the Address object and Data contracts. This field will receive either a CustomerNo or a SupplierNo. The Address code will decide which it is. See documentation for more information. CustomerNo still exists for backwards compatibility, but has been marked deprecated. (30862)
Fixed bugs
- ExternalHelpdesk web service: Fixed a bug which rejected all connections to the service. Was supposed to accept ExternalHelpdesk and PointOfBusiness, but rejected both. (31218)
- VAT calculations on accounting journals: When adding and rounding decimal numbers grouped by account no, small differences may occur. In some cases, the result was a small diffence (< 0.02) between the debit and the credit side. We added a "decimal correction" row for these cases to ensure the debit and the credit side balances when calculations and summations are done on grouped data. Fixed for Sales invoices and Supplier invoices. Also fixed 2 data type errors in one stored procedure for adding journals to the ESH database. (30280)

6.3.14

What's new
- ESH SPA - Connect by file - improved user interface for job configuration. The json string views have been replaced by a grid representation of the data. (30863)

6.3.13

Fixed bugs
- ECMM: Added filter on companies for mapping devices (30694)
- Connect by file, import machines: Added validation on mandatory field Machine_no. If machine_no is missing, import will be rejected (30035)
- Connect by file, import articles: added mapping for field USE_IN_MOBILE (29966)
- Connect by file, wrong record field type. Integer fields To and From removed. DateTime field ValidFrom added (30069)

6.3.12

What's new
- Binary passwords for integrations. Text passwords are encrypted to binary and removed. New functionality for show/hide password for integrations and db connections (27915)
- Import of Articles from Visma Administration SPCS to Evatic (29179)
- Import of Suppliers from Visma Administration SPCS to Evatic (30688)
- Export of orders to Visma Administration SPCS from Evatic (29422)
- New integration to HP Smart Device Services API. Only Test Connection is available (26740)
- BI integration is removed (30854)
- Import Sales Project via API (26793)
Fixed bugs
- Some gui issues fixed in create/edit integration. In add new integration, links pointing to non-existing old documentation changed to point to new documentation (30670)
- Create new integrations: Some fields were not refreshed when creating new integrations. Added clear-functions for input fields for new integrations, including the json config string for ConnectByFile (30436)
- When a notification email is created, the email in FROM_ADDRESS in company settings are used not the hardcoded it@evatic.com (30749)

6.3.10

What's new
- Connect by file - Export supplier invoices. See Connect by file documentation for record descriptions. (29721)
Fixed bugs
- Selected groups are not reset when creating new integration with Printfleet (28747)
- When job terminated for some reason, 'Last run result' was set to 'Success'. It will now change to 'Failed' (29343)
- Connect by file - Export Order Lines. CR/LF was exported with the text to file. CR/LF is now replaced with a space (29834)

6.3.9

What's new
- Connect by file - Stock management: Export Internal Stock Movements from Evatic to file. See Connect by file documentation for record descriptions. (29724)
Fixed bugs
- Connect by file - Address import has now been added as a separate job part. See Connect by file documentation for record descriptions (29701)
- Add new integration in Evatic Service Hub was unsuccessful in some cases. This has now been fixed (22522)

6.3.8

What's new
- Connect by file - Stock management: Export Stock quantities and values from Evatic to file.(29722)
- Connect by file - Stock management: Import Stock quantities and values from Evatic to file.(29723)

6.3.7

What's new
- Import of Contacts from Visma Administration SPCS to Evatic (29718)
Fixed bugs
- Staging Tables integration: Added better error reporting when getting orders for export from the Evatic Database (28465)
- Connect by file integration, Orders export: Added the field Account number from Article to the Orderlines export. (29729)
- Connect by file integration, Projects import: Removed field Date from the default configuration. The field was never used for the project import, but exists and is used in the project tasks import. Other connect-by-file documentation was updated with field lengths corresponding to the field lengths in the ESH database tables. (29952)

6.3.6

What's new
- Integration to Visma Administration SPCS. Test Connectivity (28860)
  - Importing customers and customer addresses from Visma Administration SPCS to Evatic has been implemented. (29178)
Fixed bugs
- Sage Get invoice journals from Evatic service: Invoices with gross sum = 0 will not be exported. (29369)
- Test Connection in FM Audit Integration fails (throws an exception) (29693)
- Integration between Evatic Service Hub and FM Audit Central 4.3.58 has been verified. (29089)

6.3.5

Security
- This version fixes a security vulnerability in Evatic Service Hub. We recommend all customers to upgrade to the latest version. Contact support if you have any further questions. (29376)
Fixed bugs
- Improved warnings in job log for JetAdvice imports (27194)
- M2M Consumable transfer not working for PrintFleet Enterprise REST API version > 3.5.x (29459)
- M2M Consumable transfer not working for multi company integrations (28721)
- The function [sp_update_MACHINE_CONSUMABLE_INFORMATION] used by ExportConsumableJobPart was slow due to missing use of company in some parts of the sql query (28647)
- On importing meter readings to the Evatic database, the system will check that mapped meters exist on the machine they are mapped to. Meter readings for valid meters will be imported. A warning will be given for those that are ignored in the import. (26281)
- Improved warnings in job log for JetAdvice imports (27194)
- Calendar sync: Better handling of malformed id references. When orphaned malformed Ids are encountered, they will be removed from the External_reference table, to avoid checking the same faulty references again and again. (27124)
- AddressRow3 missing in StagingTables.svc (Exposing ADDRESS_3 in table ADDRESS) (29539)

6.3.4

What's new
- Several instances of the same job are not allowed to run at the same time (29105)
- Missing fields added in the Staging database tables for Order_Line, Order_Heading and ADDRESS (28859)

6.3.3

What's new
- Rebranding of Evatic Service Hub (28445)
- Integration information and job name is added to email notification sent from the scheduler after every run if an error occur (28732)

6.3.1

What's new
- KFS service client fails to download meter and consumables values (28006)
- Saving stale information from devices from KFS (27866)

6.3.0

What's new
- Internal stock movements are now available through a web service (Stock.svc) (27367)
- ESH ConnectByFile - Improvements in machine import (27476)
Fixed bugs
- ESH ConnectByFile - missing address in Customer import (25864)

6.2.0

What's new
- Extend the API to save Article discounts (25874)
- Import Discounts on articles linked to customers through API (26930)
Fixed bugs
- Scheduled job "Run M2M with printfleet" failed (25742)
- PrintFleet agent removes group id regardless error type (26266)

6.1.5

Fixed bugs
- Issues with import Article - ESH ConnectByFile (25865)
- Calendar entries get incorrect time when synced from Outlook to Evatic (26119)

6.1.4

What's new
- Company No added when saving Consumables from ESH (25422)
Fixed bugs
- ESH - Mapping devices. All meters are not shown in the dropdown (25380)
- Next letter date is moved to the wrong date when letters are reported using ESH (24978)

6.1.3

Fixed bugs
- Twinfield integration - mandate ref no not transferred (24096)

6.1.2

Fixed bugs
- FMAudit Public API incoming messages size has been exceeded (24470)
- Trailing slash was wrongly added to all api url's. Missing trailing slash is added to EvaticServer and KyoceraFleetSystem (24468)
- Sage Classic interface: invoice lines are not completely exported and has wrong rounding (24589)
- Create integration: Should not be possible to keep selected department on an integration when company is set to null (23194)
- Deprecated: Customer.svc/SearchByName(string customerName) (24127)

6.1.1

What's new
- Make a stop request to BI Tool when transfer of data from ESH Client is done (23494)
Fixed bugs
- Calendar sync: Better handling of duplicates when deleting from Outlook (23544)
- BI Tool: Error Export to Evatic BI (23378)
- upgrade EES to Calendar sync in 6.1.0 : duplicate events get same EXTERNAL_ID (23545)

6.1.0

What's new
- Create Evatic Business Intelligence integration (112171)
- Create new Calendar Sync integration (17426)
- Use Delegate user to connect and sync calendars (18589)
- Google analytics for Web Services (21008)
Fixed bugs
- Version should be displayed in the interface (17674)
- Password visible when adding new DB connection (20822)
- JetAdvice sends LastActiveDate as null (21284)
- PrintFleet global toner name update (22643)

6.0.0

ESH 6.0.0 is based on ESH 4.6.1. Only the version number is changed.

4.6.10

Fixed bugs
- PrintFleet agent removes group id regardless error type (27678)