#27781 TLScript: JSON parser, PDF text extraction

Enhancement

Critical

#27091

Object representation in the form via HTML templates

#27199

New theme: "Core"

Major

#25539

Mega Menu

#25644

TL-Script: Macros "Stored Expressions"

#27480

JMS connection

#27517

Refactoring of User Management

#27676

Tree and table components: Extended drop function

#27705

TL-Script: Graph-Traversal

#27736

Display for log of the current session

#27770

Layout editor: Toggle buttons

#27781

TLScript: JSON parser, PDF text extraction

#27814

Performance: Preload for I18N attributes

#27820

Performance: Preload for bulk operations in TL script

#27841

TL script: Access to user/session-local state

#27846

Standardize scrollbars & prevent them from taking up space

#27909

Be able to swap components to a separate window / separate screen if required

#27967

Integration of the application name in the footer for both themes and adjustments in the sidebar

#27979

Core Condensed Theme

Detail

#26463

Form editor / Model: Dynamic Mandatory Annotation

#27410

Declare TextInput HTML templates

#27455

Label provider for objects without ID column/name

#27507

Replace old hover implementations

#27532

Log the active thread if threads time out in the RequestLock

#27614

Re-enable Spotbugs

#27618

TLScript: instanceof() with dynamic type

#27669

Tree components: New component channel "selectionPath"

#27679

TLScript: Function $givenType.isCompatible($expectedType)

#27701

Standardized naming "TopLogic" and "TL-Script"

#27720

Extend log entries to include the session

#27733

Excel export for the "Log entries" view

#27751

Improve the behavior of Enter in dialogs

#27757

MetaConf: Comment out lines with #

#27762

SQL migration: H2 as a fallback for PostgreSQL

#27763

Better error message if calculated attribute returns incompatible values

#27794

Escape in dialogs should close them

#27819

TL-Script: Formatted output (HTML) of info

#27863

Edit components: Extended configuration of the "Apply" command

#27864

Note when saving forms - what is a standard form?

#27866

Access to the model for dynamic and calculated columns

#27871

Further UI actions: Refresh and jump

#27873

Maximize layout component: Possibility for in-app configuration of maximizable layouts

#27877

Display of the TopLogic logo in all applications

#27906

Formats for currencies and other units

#27939

Display of a classification attribute in the form as a radio button list

#27941

TL script: Access to icons, e.g. of specialized objects

#27946

Set initial values in the ConfigItems editing dialog

#27986

Add a theme variable for the font family in the core theme

#27988

Select field with CSS class

Nice to have

#27723

Remove other unnecessary type parameters (recognized by Eclipse 4.30)

Bugfix

Major

#27755

Error when using a form template

#27887

Incremental model upgrade may remove inverse references

#27913

Crash when restarting services

#27914

Core theme: Grid rows have different heights in edit mode/on selection

#27915

TL-Script function registry: StackOverflow for recursively calling functions

#27917

Incorrect creation of an inverse reference during migration

#27953

Core theme: Fields in ID columns do not fill the column width

#27984

Core theme: New application does not have the core theme as default theme

#27990

Core theme: Dependence on the Legacy Modern theme

Detail

#27649

Default values for attributes of transient objects are not taken into account

#27662

Singletons can be deleted in the instance browser

#27674

I18N string as name attribute of structure returns error

#27714

Fix SpotBugs Warnings

#27739

Update ActiveMQ dependencies

#27775

Missing treegrid updates for many object creations

#27777

Missing "historyType" for migrated references

#27785

Design mode burger menu disappears in tile views after form editing

#27827

Core theme: Error in form editor in tl-demo (type A)

#27828

Core theme: Superfluous scroll bars

#27830

Core theme: Missing formatting for theme names

#27832

Component sizes in tl-demo not adapted to the core theme

#27833

Core theme: Sort column asymmetrical

#27837

Inconsistent behavior of the TL script function sort()

#27843

Missing annotation @Retention(RUNTIME) at the annotation @NoDialogContentCheck

#27861

Annotation "Visible columns" is confusing

#27872

Correction of the restore functionality for maximized layout components and bug fixes in the administration view

#27884

NPE when creating an enum in the diagram

#27892

Problems with displaying and updating the mega menu

#27895

Obfuscated configuration values: Prefix 'unencrypted:' sometimes does not work

#27898

Core theme: Title field too small

#27901

Model editor: Diagram disappears when creating a supertype

#27905

Support UTF8 characters in the password (and user name)

#27912

Error when displaying transient objects in tables

#27918

I18N fields cannot be emptied

#27932

Data type "Time" does not work

#27940

HTML templates: Foreach attributes cannot access variables that are not defined in the model

#27942

HTML templates: Access to properties of variable content directly in the template

#27944

Unnecessary annotation update for data types

#27945

TL-Script: date() Constructor returns value with current time

#27949

GridTreeTableNodeLabelNaming records path that cannot be resolved

#27954

Button "Current version" cannot be removed

#27955

Grid allows editing of historical objects

#27958

FormContainer: Adding new members not observable

#27969

Missing authorization for standard views of all users in the user settings menu

#27971

Setting components do not hide if no authorization is assigned

#27974

Buttons in the button menu do not indicate whether they are executable

#27985

Help ID and content visually indistinguishable

#27987

Components in tile views cannot be maximized

#27992

Mandatory I18N attributes require input in all languages

Nice to have

#27870

Missing paragraph spacing in tooltip content

Enhancement

Major

#27781

TLScript: JSON parser, PDF text extraction

JSON PDF TLScript

Two new functions pdf2txt and parseJson for text extraction from PDF and parsing JSON structures from text.

The necessary external tools can be installed on a Debian system with

apt install poppler-utils apt install python3-pdfminer apt install tesseract-ocr

can be installed.

test

/com.top_logic.demo/src/test/java/test/com/top_logic/demo/scripted/tlscript/TestParseJson.script.xml

For pdf2txt: External tools are required, which must be installed on the application server: pdf2txt, pdftopmn, and tesseract.

If these tools are installed, the following expression, for example, can be evaluated:

"JVBERi0xLjUKJeLjz9MKNCAwIG9iago8PC9GaWx0ZXIvRmxhdGVEZWNvZGUvTGVuZ3RoIDE4Mj4+c3RyZWFtCnicdZAxC8IwEIX39ytu1OVMQpKmjoIOgmIh4CAOQq2lWqVF8O+bVCu0IDe9y73v8q7BwkOQ05JTRT7H0iNDA8Ha0QuK1uG1ghS0weEoKIdWrDQlacrWUQ1jFKe217deK8dRfYYH4jdZYo87JMVqL2PuwDmEjleWKMInYwVMiDNbSTKcWPJFwMe+JK3ZRrpkE2LWmGxP9Xk+9VUM3HnUP0/i2NjOs2sf1fn6JPn1xUNleAMdukKVCmVuZHN0cmVhbQplbmRvYmoKMSAwIG9iago8PC9Db250ZW50cyA0IDAgUi9UeXBlL1BhZ2UvUmVzb3VyY2VzPDwvRm9udDw8L0YxIDIgMCBSL0YyIDMgMCBSPj4+Pi9QYXJlbnQgNSAwIFIvTWVkaWFCb3hbMCAwIDU5NS4yIDg0MS45Ml0+PgplbmRvYmoKMiAwIG9iago8PC9TdWJ0eXBlL1R5cGUxL1R5cGUvRm9udC9CYXNlRm9udC9IZWx2ZXRpY2EtQm9sZC9FbmNvZGluZy9XaW5BbnNpRW5jb2Rpbmc+PgplbmRvYmoKMyAwIG9iago8PC9TdWJ0eXBlL1R5cGUxL1R5cGUvRm9udC9CYXNlRm9udC9IZWx2ZXRpY2EvRW5jb2RpbmcvV2luQW5zaUVuY29kaW5nPj4KZW5kb2JqCjUgMCBvYmoKPDwvS2lkc1sxIDAgUl0vVHlwZS9QYWdlcy9Db3VudCAxPj4KZW5kb2JqCjYgMCBvYmoKPDwvVHlwZS9DYXRhbG9nL1BhZ2VzIDUgMCBSPj4KZW5kb2JqCjcgMCBvYmoKPDwvTW9kRGF0ZShEOjIwMjMxMTIyMTYwOTMwKzAxJzAwJykvQ3JlYXRpb25EYXRlKEQ6MjAyMzExMjIxNjA5MzArMDEnMDAnKS9Qcm9kdWNlcihPcGVuUERGIDEbase64Decode().pdf2txt()

The expected result is Name: Project 1.

A simple OCR test can be performed with this expression:

"JVBERi0xLjYKJcOkw7zDtsOfCjIgMCBvYmoKPDwvTGVuZ3RoIDMgMCBSL0ZpbHRlci9GbGF0ZURlY29kZT4+CnN0cmVhbQp4nD2MIRKAMAwEfV9xGhGa0NDEY5AoHsAggSmG70OnM9jb243EeEJBRKQoBnUlyQpLTDYy7j2sHc6woEBESDGqkZmDWShDjIb/VNqotdZIVVJzfHBsR+jnI2G6sHzJF1HQGe8KZW5kc3RyZWFtCmVuZG9iagoKMyAwIG9iago5OQplbmRvYmoKCjQgMCBvYmoKPDwvVHlwZS9YT2JqZWN0L1N1YnR5cGUvSW1hZ2UvV2lkdGggMTk5IC9IZWlnaHQgNTAgL0JpdHNQZXJDb21wb25lbnQgOCAvQ29sb3JTcGFjZS9EZXZpY2VSR0IvRmlsdGVyL0RDVERlY29kZS9MZW5ndGggMzcxNz4+CnN0cmVhbQr/2P/gABBKRklGAAEBAQBgAGAAAP/bAEMAAwICAwICAwMDAwQDAwQFCAUFBAQFCgcHBggMCgwMCwoLCw0OEhANDhEOCwsQFhARExQVFRUMDxcYFhQYEhQVFP/bAEMBAwQEBQQFCQUFCRQNCw0UFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFP/CABEIADIAxwMBIgACEQEDEQH/xAAbAAEAAwEBAQEAAAAAAAAAAAAABQYHBAMCCP/EABoBAAMBAQEBAAAAAAAAAAAAAAADBAIBBQb/2gAMAwEAAhADEAAAAf1SU7FNxKYFzG5jM5Gf2L2jJN/lB3AAAAAzBV2nlK0q6qjJZZOBsTG9kx+P6OwU7W8vR6U1Cwd0XfxSsRL7knaLK2NkkHoWQbI2DN4XliIfqb1zeHOyP4tMdHdz38GmZlufvqMxYk+h8yXpK1/PzQs+dVizsPVe0ArFf0cuyD5LO2iuVfS2HwU6NhqUvLMvr/LanO5/Yp5xnhVLk0ivUzVGK4H2mG4wZMAAAAAbase64Decode().pdf2txt()

The expected result is "Hello world!".