Hi Kieran
Two things to check:
1. Are you running the latest version of EasyLoader? I think lately, we have started distributing EasyLoader with MapInfo Pro so as long as you are using that version of EasyLoader you should be fine.
2. EasyLoader comes with its own projection file (MapInfow.prj). Can you check that this projection file holds a line for GDA2020-MGA54, and also make sure that it has been assigned an EPSG code. If that's not the case, you can copy the projection file from the MapInfo Pro installation folder into the EasyLoader folder.
EasyLoader should be installed under your profile, here: %localappdata%\MapInfo\MapInfo\Professional\1900\Tools\MapInfoEasyLoader
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 06-01-2021 20:18
From: Kieran McGowan
Subject: EasyLoader - SQL 2014 GDA2020 - MI 2019
Hi Peter,
I've never had this issue before but this is the first time I've attempted to put in anything epsg:7854 into sql. I tested using the same layer in gda94 & WebMercator publishing through EasyLoader and had no problems.
If i insert the tab into SQL using FME (although it doesn't populate the MATCATALOG) it correctly updates the SP_GEOMETRY.STSrid to 7854, whereas Easyloader leaves it zero.
I thought maybe it was related to permissions (e.g. creating something in the GEOMETRY_COLUMN system table maybe) but having full db admin doesn't seem to help.
Thanks
Kieran
------------------------------
Kieran McGowan
Corangamite Shire Council
Camperdown VIC
Original Message:
Sent: 06-01-2021 08:31
From: Peter Horsbøll Møller
Subject: EasyLoader - SQL 2014 GDA2020 - MI 2019
Hi Kieran
Is it only data using that specific coordsys that give you issues?
Does it work if you save a copy of your table using a different coordsys and then upload that copy using EasyLoader
Does it work if you save a copy as your table into SQL Server directly from within MapInfo Pro?
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
Original Message:
Sent: 05-31-2021 02:37
From: Kieran McGowan
Subject: EasyLoader - SQL 2014 GDA2020 - MI 2019
Hi All,
Anyone any insight as to why when i use EasyLoader to upload a GDA2020-MGA54 tab into SQL it will work fine, however from what i can tell it won't enter a value in the Map Catalog for the COORDINATESYSTEM.
I'm guessing because of this, when i go to create a sql connection from MI to the table i can only browse the table with no spatial data available.
I can't see any errors in the EasyLoader Log file either.
Cheers
Kieran
------------------------------
Kieran McGowan
Corangamite Shire Council
Camperdown VIC
------------------------------