Vertec version 6.8

Features

• Excel and PowerPoint are searchable with full-text search: Now Excel (.xlsx and .xls) and PowerPoint (.pptx) documents can be indexed and found using the full-text search. This applies to both documents and email attachments.
  • The vtcapp.extractplaintext() method has also been added.
  • The relevant menu items have been adjusted in System settings > Full-text search.
  • After the update, you have to run vtcapp.indexactivities(1) for the documents and vtcapp.indexactivities(2) for email attachments or wait for the next full indexing by scheduled task.
• New scheduled task: We have introduced a new scheduled task called Discard and recalculate full-text search index. It is created inactive and is used in case of problems with the usual scheduled task Recalculate full-text search index to remove the entire index and re-create it. Do not activate and run this task regularly, but only initiate it manually if necessary.
• Display condition for folders: In the folder properties, we have added a new field called Display condition (VisibleExpression), which controls the visibility of the folder in the tree and list. You can find more details about this in the Properties dialog article.
• Global payment import linked to posting right: The Payment import menu item (when installing a financial accounting extension with payment import) appears only if the user has been granted the Posting right.
• Expandability of folders and link containers in new installations: Due to the option introduced in version 6.7.0.17 to define folders and link containers as non-expandable, in new Vertec installations, various folders/link containers are now defined by default as not expandable. If this is a problem, you can reactivate the Expandable checkbox at any time. We have also changed some icons of link containers, so that they better represent the displayed class (e.g. provided them with an address icon, instead of just a folder).
• The favorites in Vertec 6.8 now behave the same as in Vertec 6.7: The new behavior of the favorite view in Vertec 6.8, which automatically switches to the Home view when selecting a favorite in Vertec 6.8, has been adjusted so that it behaves the same way as in Vertec 6.7, i.e. it is shown directly in the favorite view.
• On Premises: Logging and restricted sessions: Sessions that use Restrict Session Process = True could not write logs to disk because they did not have sufficient privileges. Session logs can be written, provided that the Vertec Cloud Server is started with an admin account (not with the local system account). Session processes always log either to the configured log path or to the default folder under %programdata%/<VertecInstance>.

Bugfixes

• SQL parser optimized: We have fixed several problems with the SQL parser that occurred with Vertec 6.8:
  • Sub-select with outer alias: Tables that do not appear in the model are ignored when translating. Together with the code adaptation, select invoice as invoice (instead of only select invoice) in the sub-select, which is rewritten by the parser to select invoice as invoice, the alias invoice may be used again in the auxiliary table.
  • Duplicate translations: Results returned twice are ignored by the parser or used only once.
  • CURRENT_DATE: The variable CURRENT_DATE is now implemented correctly. Statements like e.g. date > CURRENT_DATE (Firebird) resp. date > GETDATE()(MS SQL server) work as expected.
• Receipt with only empty string now returns None: Previously, a receipt (documentData.data) which only had an empty string as content resulted in an error. We have now fixed the problem as follows: Receipt delivers None if (a) no DocumentData is linked, (b) DocumentData with Data = None is linked or c) DocumentData with Data = <emptystring> is linked.
• Writing of receipts takes into account user rights: The writing right for the Receipt member on creditors, expenses and outlays is considered again. For backwards compatibility reasons, the writing right remains linked to the Receipt member (even if it is derived since the switch to DocumentData).
• Cost takes into account Cost perUnit: On AbstractExpenditure (expenses and outlays), Cost is now correctly recalculated if CostPerUnit is changed.
• Vacation row in weekly table shows type text again: In the weekly table, the renderer rndVacationRow again shows the text of the relevant absence type.
• Alias of simple addresses updates correctly: Previously, with a simple address, if Last, First name changed subsequently, the alias did not adapt. We have now fixed this issue.
• Activated is shown again on project: On the Further information page of projects, Activated was no longer shown on the interface. We have now fixed this issue.
• BI calculation is now also possible with over 65535 phases: We have fixed the issue that more than 65535 phases in the system led the BI calculation to crash.

Features

• Search results enhanced: When searching for phases, outlays, services and expenses, the relevant project is shown in the list of search results as of this version.
• Python function extractplaintext() extended: The Python function vtcapp.extractplaintext has been extended with the optional attribute extension. If an extension is passed, it is used to determine the file type. Otherwise, it will try to determine the file type based on the file content passed. Valid extensions are .pdf, .docx, .doc, .eml/mime and .txt. You can find further information in Vertec Python functions.
• Python function setdocumentcontent() extended: The Python function activity.setdocumentcontent sets the creation date of the activity (createdate) as the modification date (documentmodifiedon) by default when saving the document. If you want to change this, you can now use the optional parameter ModifiedDate mit Default None, which can override the modification date. For more information, see Vertec Python functions.
• Moved activity types to other folders: From this version onward, the activity types are saved or managed under Settings > CRM, instead of projects.
• Adjusted the default settings in the zip code folder properties: In the property of the zip code folder (Settings > CRM) the Expandable checkbox is now deactivated by default, instead of activated.

Bugfixes

• Fixed error message in query folder: The error message "Unknown table (...)" appeared when defining queries, if a folder of a class was selected that existed in the data model (class with table mapping "parent") but does not directly exist in the database. The issue was fixed with this version.
• Fixed errors due to overwritten identifiers : With the implementation of the English model language, all identifiers (entry ID for objects or propertyName for properties) have been translated. Importing config sets could lead to overwriting them, (DE > EN) and thus, for example, existing queries with string comparisons resulting in error messages. 
  As of this version, identifiers found in the target database are no longer overwritten and identifiers not yet found are created with a new entry ID or a new propertyName.
• DB convert timeout extended: The DB convert could abort with a timeout when reading the source database on larger Microsoft SQL databases. Therefore, we have increased the timeout when reading the source data to 24 hours per table.
• Query of objects with the same entry ID: If two objects with the same entry ID, but different classes, are queried with the Python function vtcapp.getobjectbyentryid(), it could happen that the object of the correct class was not returned, but instead the topmost object in the cache. With this version, the query checks for the correct class and, if it does not match, the query uses the database to return the correct object.
• Fixed incorrect behavior when entering services via Vertec Outlook App: When entering several services via appointment in the Vertec Outlook App, the service could be unintentionally assigned a service type, or the second service entered applied the service type of the first, even though no service type was selected. We have fixed this issue with this version.
• Fixed Excel export error: The OCL variable varContext could cause an error in Resource Planning when executing an Excel export. This issue has been fixed with this version.
• Removed unintentional checkbox on expression folders: When a query was defined in an expression folder, the Active only checkbox appeared below the search field. This was unintentionally displayed and had no effect. We have fixed this bug with this release. See also: Active only in expression folders.
• Corrected typo in extension code: We corrected a typo in the code of the Abacus Web extension.

Bugfixes

• Create schema with MS SQL is possible again: You can create the Vertec database schema for MS SQL Server via /DC. The exact procedure is described in Microsoft SQL Server.
• setresourceplanvalue() creates new objects instead of overwriting the existing ones: Setting resource plan values via setresourceplanvalue() no longer creates multiple (identical) objects, but overwrites the existing ones. See also: Custom Resource Planning with Python setresourceplanvalue().
• Python dialog shows selection again: The dialog, which is called via the Python function vtcapp.selectobjectintree(), shows the selection in the tree in color again. See also: Current support topics
• Saving receipts on outlays is possible again: In addition to creditors and expenses, receipts can now also be added to outlays. See also: Current support topics
• Texts with more than 32766 UTF-8 characters can be indexed again: Indexing for full-text search was not possible for texts with more than 32766 UTF-8 characters. Consequently, the relevant object could not be found in the search. We have fixed this issue.
• vtcapp.sendmail() fixed: With Vertec installations where vtcapp.sendmail() was not used before 6.7.0.4, the error SetMemberOutOfDate, obj argument is nil could occur when executing the function. We have fixed this issue.
• Improved performance of selection fields in lists: When the spellcheck was activated, some delays were experienced with selection fields in lists, e.g., when selecting a project for time tracking via cmbProjekt. We have fixed this issue. See also: Current support topics
• BI number output in Cloud App with regional setting Germany corrected: In the Cloud App, incorrect values could be shown in the BI view when the Windows regional settings were set to German(Germany). We have fixed this issue.

Features

• Template folder for project search: Start with this version, a separate SQL folder can be defined for project search. It can be stored in the system settings project > Template folder for project search is stored and appears in lists when using the edtProject control. For detailed information, see the article SQL Search Dialog for Project References.
• SQL Logging fully extended: The ability to write log output to the LOGDATA table in the database has been fully extended as announced in the 6.8 release notes. If there are still settings in the Vertec.ini file (SqlLogTable), these are ignored.

Bugfixes

• Full-text search now also possible with / in the search term: The full-text search crashed when searching for terms that a / included. The problem has been fixed with this version.
• Full-text search Sort by relevance corrected: When sorting search results by relevance, there was some ambiguity due to the score displayed in the tooltip, as it is also sorted by date, which could result in a higher score being shown further down. This problem has been fixed and the display of the absolute score has also been removed.
• System setting “Show totals” is taken into account: If the system setting Show totals is disabled, the totals are still shown. This has been fixed in this version.
• Expressions of constraints are no longer overwritten: The expressions of built-in constraints were translated to English in an update to 6.8 and also overwritten existing (and possibly modified) constraints. With an update from version 6.7 to 6.8.0.4, this no longer happens. Installation already updated to 6.8, where the expressions have been changed, has to be manually adjusted again.
• List settings editable in Resource Planning: List settings could not be edited in Resource Planning. The problem only occurred with model language German and has been fixed with this version.

Features

• Python function for full-text search has been extended: The Python function vtcapp.search() now includes the property onlyactive, which you can use to define whether only active or also inactive objects should be found. You can find comprehensive information about this in Vertec Python functions.
• Indexing of phases is now possible: Members of phases can now also be indexed for full-text search.

Bugfixes

• Scheduled task “Recalculation of index statistics” without BI check: The scheduled task threw an error with an unlicensed Business Intelligence module. This has been fixed with this version.
• Fixed the issue with Excel reports: Creating standard Excel reports could trigger the following error message in the Vertec Desktop App and the Vertec Cloud App: The file " could not be saved. The file type " is not allowed to be saved without user dialog. This has been fixed with this version.

Bugfixes

Number format is now correct in Vertec clients. Fixed the problem that the regional settings were not set correctly by the sessions to the value supplied by the client.