How Do I Properly Import CSVs?

[kmcgill]

Hi everybody,

I'm having issues importing csv files and am pretty sure it's due to an error on my end.

The CSV is an exported frame from a pcap file (see attachment "Exported-Frame"). Whenever I import the csv in question, I get something like (see attachment "CSV-Import).

Specs:
CloudCompare v2.11.1
MacOS Mojave 10.14.6

Any insight would be greatly appreciated!

[daniel]

I don't see any attachment/image?

Can you maybe paste the first lines of the file at least?

[kmcgill]

Apologies. It looks like every time I attempt to attach a file (within file size limits) it displays a warning "Sorry, the board attachment quota has been reached."

Here are the first few lines of the csv.

Code: Select all

"intensity","laser_id","azimuth","distance_m","adjustedtime","timestamp","vertical_angle","Points_m_XYZ:0","Points_m_XYZ:1","Points_m_XYZ:2"
21,0,9,2.992,937935195,937935195,-25,0.07051020860671997,2.710756063461304,-1.264473795890808
90,1,9,5.376,937935195,937935195,-1,-0.3852474689483643,5.361357688903809,-0.09382414072751999
68,2,10,6.100000000000001,937935197,937935197,-1.667,0.1596118062734604,6.095328807830811,-0.1774522513151169
22,3,10,4.7,937935197,937935197,-15.639,-0.1026829332113266,4.524837970733643,-1.267004251480103
7,4,11,4.976,937935199,937935199,-11.31,0.1285782903432846,4.877674102783203,-0.9758796095848083
80,5,11,5.708,937935199,937935199,0,-0.1285033226013184,5.70655345916748,0

[kmcgill]

Apologies once again. I found the solution.

I am a designer, not an engineer. My technical acumen, while growing, is still very small in this space.
I discovered that upon opening the csv and setting the cloud attributes that it was auto-assigning the XYZ coords to the intensity / laser_id / and azimuth (columns 1, 2, 3), while the actual XYZ coords had been given scalar values (columns 8, 9, 10). I switched these and applied RGB values to 1, 2, and 3, and voila! I saw my beautiful point cloud!

This solution came to me after reading this troubleshoot question elsewhere in the Questions topic here:
http://www.danielgm.net/cc/forum/viewtopic.php?t=811

[daniel]

Ok, I increased the forum attachement quota!