MapInfo Pro

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------

Hi Martin

Not sure how helpful this advice is but let me give it a try anyhow.
1. I'm sure you are aware that MapInfo Pro will try to use relative paths in workspaces. Would it be possible to save the workspace in the OneDrive folder above the folder with your tables? In that way the Open statement might look like:

Open Table "reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

if you save the workspace in the folder C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\.

Another consideration is to alter the paths using Windows aliases. Admitted I haven't tried that myself, and it would also require that you make this change manually to the workspace. %USERPROFILE% should take you to your user folder in C:\Users: C:\Users\martin.burroughs\.

So maybe changing the path in Open statement in your workspace to would work:
Open Table "%USERPROFILE%\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

How does editing the tables work for you when they are located in the OneDrive folder? I'm wondering if you get into a situation where the file gets locked by OneDrive when it tries to syncronise it?

Try to raise the support for the HTTP path as an idea on the Precisely Ideas. You can find a link in the Precisely Sites dropdown at the top of this page.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 09-24-2020 06:44
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------

There is an Idea logged for Sharepoint on the site - just add your votes, comments or start a new one.
https://ideas.pitneybowes.com/ideas/MIPRO-I-396

------------------------------
John Ievers
CDR Group
Hope Valley, United Kingdom
------------------------------

Original Message:
Sent: 09-25-2020 08:44
From: Peter Horsbøll Møller
Subject: Mapinfo with Sharepoint/OneDrive

Hi Martin

Not sure how helpful this advice is but let me give it a try anyhow.
1. I'm sure you are aware that MapInfo Pro will try to use relative paths in workspaces. Would it be possible to save the workspace in the OneDrive folder above the folder with your tables? In that way the Open statement might look like:

Open Table "reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

if you save the workspace in the folder C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\.

Another consideration is to alter the paths using Windows aliases. Admitted I haven't tried that myself, and it would also require that you make this change manually to the workspace. %USERPROFILE% should take you to your user folder in C:\Users: C:\Users\martin.burroughs\.

So maybe changing the path in Open statement in your workspace to would work:
Open Table "%USERPROFILE%\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

How does editing the tables work for you when they are located in the OneDrive folder? I'm wondering if you get into a situation where the file gets locked by OneDrive when it tries to syncronise it?

Try to raise the support for the HTTP path as an idea on the Precisely Ideas. You can find a link in the Precisely Sites dropdown at the top of this page.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 09-24-2020 06:44
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------

Thanks Peter.

Just been trying the first example. I can't save in that folder, but I can save in \insight and intel and then do a relative link from there
Open Table "\GIS\10000.TAB" doesn't work

second one
Open Table "%USERPROFILE%\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive
Best so far...it asks me to locate the file, but it has navigated me to the folder the file is in! Frustatingly close.

When I do locate the files, however, it then isn't producing maps or layouts.

Editing tables seems ok actually, just tried one, the edit seems to persist and the file is marked as synced.

I'll try raising an idea as you say. Feels like it's all on the brink of achievable.


------------------------------
Martin Burroughs
Oldham Council
------------------------------

Original Message:
Sent: 09-25-2020 08:44
From: Peter Horsbøll Møller
Subject: Mapinfo with Sharepoint/OneDrive

Hi Martin

Not sure how helpful this advice is but let me give it a try anyhow.
1. I'm sure you are aware that MapInfo Pro will try to use relative paths in workspaces. Would it be possible to save the workspace in the OneDrive folder above the folder with your tables? In that way the Open statement might look like:

Open Table "reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

if you save the workspace in the folder C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\.

Another consideration is to alter the paths using Windows aliases. Admitted I haven't tried that myself, and it would also require that you make this change manually to the workspace. %USERPROFILE% should take you to your user folder in C:\Users: C:\Users\martin.burroughs\.

So maybe changing the path in Open statement in your workspace to would work:
Open Table "%USERPROFILE%\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

How does editing the tables work for you when they are located in the OneDrive folder? I'm wondering if you get into a situation where the file gets locked by OneDrive when it tries to syncronise it?

Try to raise the support for the HTTP path as an idea on the Precisely Ideas. You can find a link in the Precisely Sites dropdown at the top of this page.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 09-24-2020 06:44
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------

Now present as an idea.
https://ideas.pitneybowes.com/ideas/MIPRO-I-1373

------------------------------
Martin Burroughs
Oldham Council
------------------------------

Original Message:
Sent: 09-24-2020 06:44
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------

Updated link to Ideas - vote now!

https://ideas.precisely.com/ideas/MIPRO-I-1373

------------------------------
John Ievers
CDR Group Limited
Hope Valley, United Kingdom
------------------------------

Original Message:
Sent: 09-25-2020 11:43
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Now present as an idea.
https://ideas.pitneybowes.com/ideas/MIPRO-I-1373

------------------------------
Martin Burroughs
Oldham Council

Original Message:
Sent: 09-24-2020 06:44
From: Martin Burroughs
Subject: Mapinfo with Sharepoint/OneDrive

Given the Covid situation, I'd guess a lot of organisations like mine are looking to shift all or most servers onto Sharepoint, which works way faster remotely.

I've been experimenting with this and Mapinfo. The "Mapinfo doesnt work with Sharepoint" line in other posts doesn't seem to be true, I guess because MS have changed their systems.

• OneDrive works fine (but see below!)
• Sharepoint has a "sync" option. This syncs Sharepoint docs/folders to OneDrive. They are then accessible through file explorer etc, and fast in Mapinfo.

So that's all great.

Only problem is, the way that Mapinfo stores file references in workspaces. So for a Sharepoint folder, shared across a team and sync to Onedrive, it looks like this (for example)
Open Table "C:\Users\martin.burroughs\Oldham Metropolitan Borough Council\reformsps - Documents\Insight and intel\GIS\10000.TAB" As _10000 Interactive

So it's taking the shared location but referencing it with a path that is only useful to a single user- not good if we are sharing workspaces.

There is an alternative path syntax, which Excel uses
='https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/[filename]sheetname'!$B$1
referring back to the sharepoint location not the Onedrive sync

This is better as it isn't dependent on the single user specific path.

I've tried replicating that sort of filepath into a workspace using notepad without success.
I tried
Open Table "https://oldham365.sharepoint.com/sites/reformsps/Shared Documents/Insight and intel/GIS/10000.TAB" As _10000 Interactive
it just asks for the file location

So my question is, how do I achieve that shared link? Or is it a minor fix that could be delivered in a future Mapinfo version?

Martin


------------------------------
Martin Burroughs
Oldham Council
------------------------------