Spectrum Spatial (SSA/LIM)

Hello everyone.

I've come across an issue with templates and View Tables.
I've got a bunch of view tables created and wanted to append custom templates to them, but every time I click one of the view objects on the map I get the following error:

Anyone else come across this issue? I find it weird that you can pick a View table to create a template, but it then doesn't work when the template is pinned to the layer through Project settings. It works fine if I base the template on the source table, but because we need flexibility to do this to View Tables, as it would prevent having to create multiple source tables.

------------------------------
Maria Sousa
Network GIS Analyst
WOOLWORTHS GROUP LTD
Bella Vista
------------------------------

Hello Maria,
thank you for your post.
May I ask you for giving us more information about the View Table you have created, the release number of Spectrum Spatial you are using, and if you have customized the custom template outside the Template Designer, please? We might need to know also the type of columns you are using in the View Table.

I can confirm you the custom templates created with the Template Designer  works fine also with View Tables. We and our customers use them regularly - so probably there is something going wrong in your data.
We're going to investigate. Talk to you soon.

kind regards
Monica

------------------------------
Monica Di Martino
EMEA LI/GIS Presales Engineer
Pitney Bowes
------------------------------

Hi Monica.

We're running on 2018.2. I didn't customize template outside, as it was giving an error.
The template is using fields pretty ordinary. I should mention that the source table is extracted from SQL server and uploaded as a flat file (not a direct connection for now)
Let me know if you need more info.

------------------------------
Maria Sousa
Network GIS Analyst
WOOLWORTHS GROUP LTD
Bella Vista
------------------------------

Original Message:
Sent: 02-26-2020 05:51
From: Monica Di Martino
Subject: Template Designer for table Views

Hello Maria,
thank you for your post.
May I ask you for giving us more information about the View Table you have created, the release number of Spectrum Spatial you are using, and if you have customized the custom template outside the Template Designer, please? We might need to know also the type of columns you are using in the View Table.

I can confirm you the custom templates created with the Template Designer  works fine also with View Tables. We and our customers use them regularly - so probably there is something going wrong in your data.
We're going to investigate. Talk to you soon.

kind regards
Monica

------------------------------
Monica Di Martino
EMEA LI/GIS Presales Engineer
Pitney Bowes
------------------------------

Hi Maria,

We would need to take a closer look at the problem. Therefore, please open a case with Technical support (software.support@pb.com) and we shall help you.

------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com

Pitney Bowes
Davidson House, Forbury Square
Reading RG1 3EU
Berkshire, United Kingdom
pitneybowes.com
------------------------------

Original Message:
Sent: 02-26-2020 17:25
From: Maria Sousa
Subject: Template Designer for table Views

Hi Monica.

We're running on 2018.2. I didn't customize template outside, as it was giving an error.
The template is using fields pretty ordinary. I should mention that the source table is extracted from SQL server and uploaded as a flat file (not a direct connection for now)

The View Table was created using MISQL function within Spatial Manager.

Let me know if you need more info.

------------------------------
Maria Sousa
Network GIS Analyst
WOOLWORTHS GROUP LTD
Bella Vista
------------------------------


Original Message:
Sent: 02-26-2020 05:51
From: Monica Di Martino
Subject: Template Designer for table Views

Hello Maria,
thank you for your post.
May I ask you for giving us more information about the View Table you have created, the release number of Spectrum Spatial you are using, and if you have customized the custom template outside the Template Designer, please? We might need to know also the type of columns you are using in the View Table.

I can confirm you the custom templates created with the Template Designer  works fine also with View Tables. We and our customers use them regularly - so probably there is something going wrong in your data.
We're going to investigate. Talk to you soon.

kind regards
Monica

------------------------------
Monica Di Martino
EMEA LI/GIS Presales Engineer
Pitney Bowes

Hi Susan.

I'll raise a ticket then.
Thanks.

------------------------------
Maria Sousa
Network GIS Analyst
WOOLWORTHS GROUP LTD
Bella Vista
------------------------------

Original Message:
Sent: 02-27-2020 08:01
From: Susan Bardet
Subject: Template Designer for table Views

Hi Maria,

We would need to take a closer look at the problem. Therefore, please open a case with Technical support (software.support@pb.com) and we shall help you.

------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com

Pitney Bowes
Davidson House, Forbury Square
Reading RG1 3EU
Berkshire, United Kingdom
pitneybowes.com
------------------------------


Original Message:
Sent: 02-26-2020 17:25
From: Maria Sousa
Subject: Template Designer for table Views

Hi Monica.

We're running on 2018.2. I didn't customize template outside, as it was giving an error.
The template is using fields pretty ordinary. I should mention that the source table is extracted from SQL server and uploaded as a flat file (not a direct connection for now)

The View Table was created using MISQL function within Spatial Manager.

Let me know if you need more info.

------------------------------
Maria Sousa
Network GIS Analyst
WOOLWORTHS GROUP LTD
Bella Vista


Original Message:
Sent: 02-26-2020 05:51
From: Monica Di Martino
Subject: Template Designer for table Views

Hello Maria,
thank you for your post.
May I ask you for giving us more information about the View Table you have created, the release number of Spectrum Spatial you are using, and if you have customized the custom template outside the Template Designer, please? We might need to know also the type of columns you are using in the View Table.

I can confirm you the custom templates created with the Template Designer  works fine also with View Tables. We and our customers use them regularly - so probably there is something going wrong in your data.
We're going to investigate. Talk to you soon.

kind regards
Monica

------------------------------
Monica Di Martino
EMEA LI/GIS Presales Engineer
Pitney Bowes