I have 3 CSV files that are having the issue showed in the post.
In this one: Comparação Dif de cotas.zip (766 Bytes) I had the issue after i edited the last two points and only these two points had issue, i removed a colon ( : ) i inserted when writing the description and these points came messed up, where de colon was is when the line break.
This one PORTO BELO.zip (from point 208 to 1142) (95.4 KB) and this one PORTO BELO 2.zip (28.0 KB) (from point 331 to 364) are a client’s job, and he didn’t edited the description. I asked to him to check teh point inside the ReachView 3 and all looks fine.
Any thoughts on what could be the issue?
Me and the client are in the latest ReachView 3 version (5.10) Follow my report file form ReachView 3 database_report.zip (244.4 KB)
Follow the image of point 208 and 209 from Porto Belo Project:
I couldn’t reproduce the issue with ReachView 3 5.10 on Android. Could you please tell me the Android version and phone model that you and your client use?
At the moment, it’s hard to find out the root of the issue since we couldn’t reproduce such behavior with our receivers and Android devices. We’ll conduct more tests to check what might be wrong. To check that we use the same workflow, could you please elaborate on the following:
Do I understand correctly that the blank lines in the CSV file appear in random places unrelated to the description entered in ReachView 3?
Do you see the blank lines in the CSV files downloaded from the app if they are opened in a simple text editor? It will help check if Excel may modify the files.
Depends, some times it jumps a line, sometimes creates a empty line between the points, since in smartphone is a bit awkward to change default apps to open certain file extensions, i can only check those inside Windows.
I’ve made some tests with a colleague and we found a potential cause for the issues.
The Android devices have the Enter button on the digital keybord and using it during the typing will result in the error.
We made tests in the latest ReachView 3 v6.1 and we found that using the Enter button and typing a description makes the CSV file export with the blank spaces in the lines.
The more lines with description, more lines are jumped in the CSV file
Also the " " only appear when a character that is used in the column configuration is used in the description. One example is the (,), if used the description is exporte wit a " ".
Example: TN,MF >>> Wil be exporte as “TN,MF”, since the (,) is used as a column separator.
Since the Enter is a paragraph brake character and is used in the CSV model, ReachView 3 may be understanding theses paragraph brakes as new lines and then missing the information that come after it.
Thank you for the detailed description of your findings!
I’ve checked that blank lines appear in a CSV file if the Enter button was pressed while filling in a description. I’ll pass all the information to the team for further investigation and write back once there is news.
I just wanted to let you know that our devs are looking into the issue. We hope to fix it in one of the future releases, but I can hardly provide an ETA for now.
We’ve recently released the ReachView 3 6.5 version with a fix for this issue. If you have a chance to check it, I will be glad to hear if everything works fine.
