Sormas-project: Make the event title mandatory in place of event description

[kwa20]

Feature Description

cf. #2904

Problem Description

When replacing the description column with title in the event directory, all previously entered events are no longer easily identified since the descriptions haven't been migrated to the titles. A user would have to open each event individually to see its context.

Proposed Change

Migrate all previous description entries to the event titles. If the limited character count for titles is problematic for long descriptions, display (...) in the titles (and directory column) and show the rest in the description.

I also propose to make the title field compulsory rather than the description field.

Possible Alternatives

Leave the description column in the event directory.

Additional Information

Version: 1.50.0
Server: test1401.sormas-oegd.de

[bernardsilenou]

@kwa20 I agree with you:

• make title compulsory and description not
• clone description and set is as title if the events that has no title. If there is a validation on character length for the tittle, clone the first n characters from the description as title
• set a max default column width for title (see figure)

[markusmann-vg]

Can we do it with an SQL-Script:
Migrate (Copy) all old Event descriptions to the event Titles.
Best case:
Copy the first 75 chars of the description and paste it to the title. If the description is longer than 75 char, we show the first 75 chars plus a "..." in the title.
This way they can find the events again and see the detailed description, when clicked on.

[MateStrysewske]

• Only do this if there is no title yet
• Change date also has to be adjusted to the current date to make sure that the data is properly synchronized

[MateStrysewske]

This has been fixed directly in the database for the servers where this was a problem.

[kwa20]

@MateStrysewske Could we however still make the title field compulsory rather than the description? This might have gotten lost maybe.

[MateStrysewske]

@kwa20 Makes sense, I'll reopen and relabel the issue accordingly

[MateStrysewske]

• [x] Make the event title mandatory
• [x] Event description should not longer be mandatory

[AndyBakcsy-she]

Verified issue on SORMAS Version: 1.51.0-SNAPSHOT