My overall goal is to load GPS data from photos and import it onto a Civil 3D file. Like this:
The photos I want to use will live on Sharepoint.
Because I can’t import straight from Sharepoint (403) I’ve synced the folder to my onedrive so i can access it and extract the data, however these hyperlinks will lead to my local folder. I’m trying to use a work around where I download the excel spread sheet of files from the sharepoint (saved as a .csv), find the hyperlinks and match those up with the local files.
With this technique the two lists created are matching in size, but as expected from two ways of sorting, very mixed up. (Because of subfolders, this technique works for a single folder)
Is there a way to match up lists that have different directory paths at the start?
A way to match up similar strings in both lists, even if the whole string isn’t the same?
Or any easier way you could think of doing this I’d love to hear
New to this so hope the question is okay
Insert Photo Map Location Example.dyn (67.7 KB)