Opening File
-
- Posts: 15
- Joined: Thu Jan 16, 2014 10:25 pm
Opening File
Forgive how remedial this question is;
I am opening a .csv file with the form:
id,northing,easting,elevation,,hzprec,vtprec,pdop,satellites
in the import window, I use the drop downs to give the form:
ignore, x, y, z, ignore, ignore, ignore, ignore
the open button remains greyed out and inactive.
maybe the points need id names? id is not an option in the drop down. any suggestions?
appologies, I'm a student and would appreciate the help!
I am opening a .csv file with the form:
id,northing,easting,elevation,,hzprec,vtprec,pdop,satellites
in the import window, I use the drop downs to give the form:
ignore, x, y, z, ignore, ignore, ignore, ignore
the open button remains greyed out and inactive.
maybe the points need id names? id is not an option in the drop down. any suggestions?
appologies, I'm a student and would appreciate the help!
Re: Opening File
The minimum requirement is to define at least 2 coordinates (e.g. X and Y). Therefore the issue must be somewhere else.
Is there red lines? (you'll have to skip them with the 'skip lines' spin-box)?
Otherwise can you post (or send me via email) a screen shot of the dialog?
Is there red lines? (you'll have to skip them with the 'skip lines' spin-box)?
Otherwise can you post (or send me via email) a screen shot of the dialog?
Daniel, CloudCompare admin
-
- Posts: 15
- Joined: Thu Jan 16, 2014 10:25 pm
Re: Opening File
There are indeed cells that are coloured red in the import window. I have chosen to "ignore" the first column, as it contains only id names, and i have asked to "skip" for row, as it contains only the field headers (x, y, z, r, g, b, number of satellites, etc). The ok button remains inactive. I will attach a screen capture as soon as possible if this is not helpful.
Great gratitude for the speed of responses! I can't believe I've found this place!
Great gratitude for the speed of responses! I can't believe I've found this place!
Re: Opening File
In fact I realize that the actual version of CC won't accept an invalid column even if it is not assigned to any "property"...This is a bit dumb (I'll try to fix this for the next version).
Meanwhile, you'll have to remove the 'red' columns prior to opening the file in CC (you can do column wise selection/deletion with smart text editors like Notepad++).
Meanwhile, you'll have to remove the 'red' columns prior to opening the file in CC (you can do column wise selection/deletion with smart text editors like Notepad++).
Daniel, CloudCompare admin
-
- Posts: 15
- Joined: Thu Jan 16, 2014 10:25 pm
Re: Opening File
OK!
so, i removed everything necessary and i was able to import, BUT
my cloud is a mirror image of what it should be....
is there a way to flip it?
Thanks!!
so, i removed everything necessary and i was able to import, BUT
my cloud is a mirror image of what it should be....
is there a way to flip it?
Thanks!!
Re: Opening File
If one dimension is mirrored (I'm not sure why but some softwares use non-direct bases) you can use the 'Edit > Multiply/scale' tool to multiply it by '-1'.
Otherwise you can invert the Y and Z coordinates for instance during import (however you won't be able to 'inverse' this process when saving the cloud).
Otherwise you can invert the Y and Z coordinates for instance during import (however you won't be able to 'inverse' this process when saving the cloud).
Daniel, CloudCompare admin
-
- Posts: 15
- Joined: Thu Jan 16, 2014 10:25 pm
Re: Opening File
When you say that I won't be able to invert when I save, do you mean that I cannot reverse the changes, or that the changes will be temporary and I cannot export the correction with the cloud.
This has been very helpful, thank you
This has been very helpful, thank you
Re: Opening File
If you apply the second trick (inverting the columns at loading time) then you won't be able to invert them again when saving the file. But now that I think of it it's not really a problem as the output file has almost nothing in common with the input one!
Daniel, CloudCompare admin
Re: Opening File
If you apply the second trick (inverting the columns at loading time) then you won't be able to invert them again when saving the file. But now that I think of it it's not really a problem as the output file has almost nothing in common with the input one!
Daniel, CloudCompare admin
-
- Posts: 15
- Joined: Thu Jan 16, 2014 10:25 pm
Re: Opening File
Now,
I have been able to execute the transformations. Can you help me further understand what the import is doing when it's flipping my clouds so that I can be sure that I am not altering my data. I have no problem altering the coordinates of my photo clouds because they will be georeferenced anyway, but my reference GPS survey cloud needs to retain its coordinates.
Once I flip the survey cloud -1 in the x, it works. I then save this file. I reopen this new transformed file, and it again the same message as the first time it is imported (about numbers being too long and it wants to make such and such change to it). The translated cloud again renders mirrored as it did before the transformation.
Similarly, when reopened, the translated photo clouds are simply back to where the started.....
What am I doing wrong? It seems like the import is altering them each time...
Thanks in advance
I have been able to execute the transformations. Can you help me further understand what the import is doing when it's flipping my clouds so that I can be sure that I am not altering my data. I have no problem altering the coordinates of my photo clouds because they will be georeferenced anyway, but my reference GPS survey cloud needs to retain its coordinates.
Once I flip the survey cloud -1 in the x, it works. I then save this file. I reopen this new transformed file, and it again the same message as the first time it is imported (about numbers being too long and it wants to make such and such change to it). The translated cloud again renders mirrored as it did before the transformation.
Similarly, when reopened, the translated photo clouds are simply back to where the started.....
What am I doing wrong? It seems like the import is altering them each time...
Thanks in advance