Problem:
I have CSV files that includes line breaks within the data. When I load such files into Signals Inventa using Publish Measurement App, multiple warnings regarding missing values are produced. As a result, datasets in SDF have missing values and missing rows in unexpected places.
Missing value for <column name>
How can I load line breaks in my data files without running into these warnings?
Resolution:
By default, Publish Measurement Apps cannot detect multiline data and will always use Multiline: false when loading data. Go through the following instructions to change the option to true.
1. In the Inventa management view, open the dataset page in SDF (Data > Projects > Datasets)
2. Select the dataset and click on File Settings.
3. Enable the Multiline option. Click on Save Change, then select Update All Files.
4. Now the file will be loaded and line breaks will correctly be handled.
5. Perform these steps for all datasets containing line breaks.