The farmer historical information field is a free text field. It should be converted to a format that is searchable.
Run an analysis to check that the text is well formatted and can be migrated to a date + description tabular format. Generate a report of badly formed text. Users can fix badly formed data. Well formed data has the following format:
N. DD/MM/YYYY Lorem ipsum
For example:
10/11/2020 Application for consent to transfer commercial plantation interest in CFRs
10/11/2020 Receipted UGX 504,794632 on NFA receipt no 266741 as 1% transfer fees for consent to transfer plantation
Once analysis report passes, migrate the data to a multivalue paragraph field
The farmer historical information field is a free text field. It should be converted to a format that is searchable.
Run an analysis to check that the text is well formatted and can be migrated to a date + description tabular format. Generate a report of badly formed text. Users can fix badly formed data. Well formed data has the following format: N. DD/MM/YYYY Lorem ipsum For example:
Once analysis report passes, migrate the data to a multivalue paragraph field