List of Contributions

Miquel Roy Sunyer

Kirklees Council

Contact Details

Kirklees Council
United Kingdom

My Content

1 to 20 of 49 total
Posted By Miquel Roy Sunyer Aug 19, 2020 11:48 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Duri, that worked perfectly fine.  Thanks a lot, ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------ ------------------------------------------- Original Message: Sent: 08-16-2020 22:04 From: Duri Bradshaw Subject: Use a MSSQL database in Locator ...
Posted By Miquel Roy Sunyer Aug 13, 2020 6:40 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hello,  For years, we've been using the Locator Uploader CommandLine Utility to upload addresses that can be search in the Analyst's search bar, using a csv file as opposed to a database source. Now we're exploring the option of uploading the addresses straight from the database, instead of creating ...
Posted By Miquel Roy Sunyer Aug 12, 2020 12:22 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hello Peter, sorry for delaying my answer for so long. After many months I have found some peace around to spend more time in this issue. First off, this is how the tab file I'm using looks like: !table !version 1000 !charset WindowsLatin1 Definition Table Type ODBC begin_metadata "\IsReadOnly" = ...
Posted By Miquel Roy Sunyer Jun 19, 2020 3:21 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hello, Can you specify where the web.xml file is and which parameter have you modified? Thanks ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------
Posted By Miquel Roy Sunyer Jun 17, 2020 3:43 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Kieran, We're at 2018.2 and we've been having this issue or similar since the beginning, and still haven't been able to tell whether if it is a problem with our IT infrastructure or with SSA itself. The sessions time out even though they are not "real" timeout, because the timeout message itself doesn't ...
Posted By Miquel Roy Sunyer May 22, 2020 7:14 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Duri, thanks for the tip. The square bounds worked, but don't understand why. We've been using non-square bounds for other tiles and we never had this issue. Anyway, as long as it works, that's fine. Thanks, ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ---------- ...
Posted By Miquel Roy Sunyer May 20, 2020 2:42 PM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hello, I'm creating a new project that needs a fresh new basemap, which will be a Spectrum Tile, as usual. The raster to use is OS Miniscale. I have created the map and uploaded it successfully in the repository. The map looks good when loaded as a map, but once converted into a Tile, it reprojects: ...
Posted By Miquel Roy Sunyer May 20, 2020 2:39 PM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Trying to create a post with some images but the assistant doesn't allow me to load any, either by copy pasting (it gets stuck) or clicking the "insert image" button, wich brings a window that doesn't allow to upload anything. Hopefully somebody from PB sees this thread and fixes the issue. It used to ...
Posted By Miquel Roy Sunyer May 19, 2020 4:18 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hello Timothy, I had exactly the same issue one week ago with SQL tables. I logged a call to support, but haven't been able to find a solution yet. We use SSA 2018.2. ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------
Posted By Miquel Roy Sunyer Mar 25, 2020 5:07 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Eric, Thanks for your comments. I acknowledge that there are mistakes in the formulation of the initial question, and I apologise as I am not entirely confident with MapInfo terminology. So yes, I meant to ask about Live tables, and without cache. The original point for the question was to understand ...
Posted By Miquel Roy Sunyer Mar 25, 2020 4:43 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Peter, I've tried using the SQL Server Native Client 11.0, as suggested by Duri, but no luck. I get exactly the same performance. This is the code I use: "\IsReadOnly" = "FALSE" "\DATALINK" = "" "\DATALINK\Query" = "select * from DATABASE.dbo.TABLE" "\DATALINK\ConnectionString" = "DRIVER=SQL Server ...
Posted By Miquel Roy Sunyer Mar 25, 2020 4:38 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Duri, I have tried using the SQL Server Native Client 11.0 in the tabfile as you suggested but I get exactly the same performance. Kind regards, ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------
Posted By Miquel Roy Sunyer Mar 20, 2020 1:11 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Andrei, I have modified the live access tab file to include MARS_Connection=Yes but no luck. This is what I currently use: "\IsReadOnly" = "FALSE" "\DATALINK" = "" "\DATALINK\Query" = "select * from DATABASENAME.SCHEMANAME.TABLENAME " "\DATALINK\ConnectionString" = "DRIVER=SQL Server;SERVER= SERVERNAME ...
Posted By Miquel Roy Sunyer Mar 20, 2020 12:55 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Sorry, I have to rectify. Just noticed that in the TAB file, the connection string uses "DRIVER=SQL Server;....". What's the string to use SQL Server Batuve Client 11.0? ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------
Posted By Miquel Roy Sunyer Mar 20, 2020 11:58 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hello Duri, we always use the SQL Server Native Client 11.0 ------------------------------ Miquel Roy Sunyer Kirklees Council HUDDERSFIELD ------------------------------
Posted By Miquel Roy Sunyer Mar 20, 2020 11:55 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hello, I have setup the fields in the MapCatalog manually so the tables load initially in a very restricted location, so MapInfo doesn't get stuck loading a huge quantity of features, if this is what you mean... But this is only a partial solution because once I start zooming out, it gets more an more ...
Posted By Miquel Roy Sunyer Mar 19, 2020 5:00 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Oh, of course the zoom layering... No, I don't think this will sort it. My concern is about general MapInfo performance. Because we have plenty of users that will struggle opening these tables in their projects and they won't be setting up a zoom layering every time. Our goal is to enable general access ...
Posted By Miquel Roy Sunyer Mar 19, 2020 4:04 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hello Peter, Sorry, I missused the term Linked table. What I actually mean is Live table. The question is what @Alejandro Hernandez has pointed out ( " The question is why other software download thouthands of records just in seconds and MapInfo Pro delay minutes. "). While other software load same data ...
Posted By Miquel Roy Sunyer Mar 13, 2020 1:23 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hello, we have some tables in a SQL Server database that are read in MapInfo17 using tab files that have the DDBB connection string embedded (Windows Authentication). They have about 20-25 fields and a varying amount of records from 2000 to 250000. The problem is that it takes ages to load in MapInfo, ...
Posted By Miquel Roy Sunyer Feb 3, 2020 12:17 PM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hello,  We tested this morning with an iPhone and it works in that device. However, in the following devices, it didn't work: Android 7.1.2; Redmi note 5A Build/N2G47H; Chrome 79.0.3945.136 Android 9; Samsung Galaxy J5 ; Chrome 79.0.3945.136 Android 9; Samsung Galaxy A20E ; Firefox Android 9; Samsung ...