Some subplots not editable

bexis / Module_ResearchAreaManagement

A tool to manage research areas. You can define the shape of your main plots and draw subplots inside. You can plan the localization of field experiments. You can use maps for orientation in the field. As you will keep the history of the subplots, you will always be able to distribute prospective subplots. Module for Core @BEXIS2.

0 stars 0 forks source link

Some subplots not editable #82

Closed EleonoraPetzold closed 3 years ago

EleonoraPetzold commented 3 years ago

Error:

Reason: line breaks and "" in subplot description

EleonoraPetzold commented 3 years ago

Replace line breaks in db: update public.pmm_geometryinformation set description=regexp_replace(description,E'[\\n\\r\\f\\u000B\\u0085\\u2028\\u2029]+', ' ', 'g')

EleonoraPetzold commented 3 years ago

Replace quotes: update public.pmm_geometryinformation set description=REPLACE(description, '"', '')