Forum

Author Topic: Adding markers from excel or csv  (Read 9397 times)

Targaryen

  • Newbie
  • *
  • Posts: 2
    • View Profile
Adding markers from excel or csv
« on: August 17, 2020, 06:22:44 AM »
Hi all,

I'm basically trying to do what the title says. I have an orthomosaic which covers a large area, and small plots within it are the areas of particular interest. I have an excel file with the gps co ordinates of the plot corners, and going through and marking the points manually seems like a huge waste of time. Is there any way to use the excel file to automatically place markers on each point?

TIA

Davier

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Adding markers from excel or csv
« Reply #1 on: August 17, 2020, 06:24:33 AM »
Easiest way is to turn the file into a shapefile and import it to Agisoft

Targaryen

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Adding markers from excel or csv
« Reply #2 on: August 17, 2020, 07:20:58 AM »
Thanks, did it with qgis and it worked perfectly.

geomaticist

  • Newbie
  • *
  • Posts: 14
    • View Profile
Re: Adding markers from excel or csv
« Reply #3 on: September 16, 2020, 02:32:59 AM »
You also can import markers from a .csv file. it is very easy to do. I do it sometimes.

DayGeckoArt

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: Adding markers from excel or csv
« Reply #4 on: April 16, 2022, 02:30:42 AM »
You also can import markers from a .csv file. it is very easy to do. I do it sometimes.

But how? I found that you can export a .shp and then you can display them on the ortho and select them. You can right click and choose "attach markers" which doesn't work. How do you get the program to read the points and the fields and use those to create markers?

Paulo

  • Hero Member
  • *****
  • Posts: 1359
    • View Profile
Re: Adding markers from excel or csv
« Reply #5 on: April 16, 2022, 04:14:09 AM »
Hello Day,

from reference pane, just use Import Reference (1st button), navigate and select CSV file, define the separator, fields and CS et voila you can import a marker for each valid line in your CSV....

It suposes you have a Pro version of Metashape
Best Regards,
Paul Pelletier,
Surveyor

DayGeckoArt

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: Adding markers from excel or csv
« Reply #6 on: April 16, 2022, 11:01:04 AM »
Thank you, I don't think I'd ever have found that tiny button

dpitman

  • Full Member
  • ***
  • Posts: 246
    • View Profile
Re: Adding markers from excel or csv
« Reply #7 on: April 16, 2022, 06:07:24 PM »
Importing Reference files for the images and the Markers is also available from the FILE menu.  FILE > IMPORT > IMPORT REFERENCE.

You might find some tips here:  https://agisoft.freshdesk.com/support/solutions/articles/31000153696

DayGeckoArt

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: Adding markers from excel or csv
« Reply #8 on: April 16, 2022, 09:33:59 PM »
I found that page and couldn't find "import button the reference pane" because I was expecting something looking like an import button. I think they need usability streamlining

PROBERT1968

  • Sr. Member
  • ****
  • Posts: 370
  • Hello !
    • View Profile
Re: Adding markers from excel or csv
« Reply #9 on: April 17, 2022, 11:10:45 PM »
From the Help inside the Software Metashape:

You would need to do this MS Excel or any that can read  or save as with  .csv.

See screenshot.