Naming of Country data?

My countries are actually watersheds and are named as follows:  X 1, X 2, X 3 , Y 1, Y 2, Z 1, Z 2, Z3 - I'm able to import the shapefile without any issue but when I try and import data the input seems to skip values.

 Here's a sample of my "country" watershed shapefile>

WS_NAME
DSHBRD_ID

Allison Creek 1
A1

Allison Creek 2
A2

Allison Creek 3
A3

Allison Creek 4
A4

Arrastra Creek
A5

Asp Creek
A6

Belgie Creek
B7

Blakeburn Creek
B8

Britton Creek
B9

Bromley Creek
B10

Champion Creek
C11

Cook Creek
C12

Copper Creek 1
C13

Copper Creek 2
C14

Dillard Creek
D15

 

Any advice would be most appreciated.

 Thanks

Dan

Thanks Frank but it still

Thanks Frank but it still doesn't work.

How does Statplanet deal with numbers in the Territory Names? It seems this is where the issue for me. I believe it might be dropping the numbers in the namess when the data is imported and therefore is not populating the columns correctly. Any other things I can try?

Thanks again,
Dan

Hi Dan, You are right, that

Hi Dan,

You are right, that must the issue, I did not realize this earlier. It does drop numbers in names, the reason for this feature is that many data sets have footnotes (i.e. numbers) next to territory names which prevent them from being imported correctly, so it omits these. You could either check the underlying visual basic code (it's open source) and delete the lines removing 'footnotes' from the names (it is removed in the same section of code where special characters/symbols in territory names are removed). Alternatively (perhaps easiest), you could replace the numbers in your territory names with the letters 'a' 'b' 'c' etc in both 'Import names' sheet and in your data file.

Best,

Frank

Hi Dan, For importing data

Hi Dan,

For importing data you would need to ensure that the names in 'Import names' match your data file (and 'Import names' should be in the same order as the actual names in the 'data' sheet). There are more details in the user guide. StatPlanet tries to set this up automatically using the shapefile but it may need modification according to your data files.

As long as the above is correct, importing should work correctly (depending also on the structure of the data file, if it has a complex structure see the example complex data file structure included with StatPlanet Plus).

Best,

Frank