If you can I would change the database but I understand that is harder than changing the SLD.
So change the fields in the SLD to uppercase and try it. BUT if you reload the style at a later date it will stop working again. Hence, might be better to make the database match the SLD rather than the other way round. Russ On 28 Mar 2014, at 09:46, Ismail, Mark <[email protected]> wrote: > I am loading the data direct from an Oracle database – created by a piece of > software from PBBI called geostore > > All the database fields are in upper case though – is there any way to fix it > ? I cant really change the database, maybe I can change the sld ? > > I did notice there was a folder called osmmsymbolsfull of svg files that came > with the download from os which didn’t get copied to geoserver > > Is that significant > > Mark Ismail > Principal IT Officer > Tel: 0151 443 3021 > Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL > > Save time – use the IT Service Desk Self Serve Application > > From: Russell Hore [mailto:[email protected]] > Sent: 28 March 2014 09:37 > To: Ismail, Mark > Cc: Jody Garnett; [email protected] > Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance > survey with geoserver? > > Are you loading the data from Postgres? If so I suspect it is the field names > in the database are upper case and the SLD is expecting lower case. (I have > been there myself) > > Russ > > On 28 Mar 2014, at 09:28, Ismail, Mark <[email protected]> wrote: > > > I tried what you suggested and it did submit but its not very happy > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE ServiceExceptionReport SYSTEM > "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> > <ServiceExceptionReport version="1.1.1"><ServiceException> The requested > Style can not be used with this layer. The style specifies an attribute of > os_cat and the layer is: Geostore:TOPOGRAPHICAREA > </ServiceException></ServiceExceptionReport> > > I am new to this and haven’t a clue what that means – can anyone suggest why > it isn’t happy ? > > Mark Ismail > Principal IT Officer > Tel: 0151 443 3021 > Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL > > Save time – use the IT Service Desk Self Serve Application > > From: Jody Garnett [mailto:[email protected]] > Sent: 28 March 2014 00:54 > To: Ismail, Mark > Cc: [email protected] > Subject: Re: [Geoserver-users] can you use the SLD provided UK Ordnance > survey with geoserver? > > That does look like the filename is incorrect. I have not seen TopoArea.sld > so I do not know if it compatible. Try copying and pasting the content into > a new style and see how you go? > > Jody Garnett > > > On Fri, Mar 28, 2014 at 2:56 AM, Ismail, Mark <[email protected]> > wrote: > I have tried to upload the sld provided by uk ordnance survey but although > they validate I get the following error when I click submit > > org.apache.wicket.WicketRuntimeException: java.io.FileNotFoundException: > C:\GeoServer25\data_dir\styles\C:\GeoServer25\data_dir\styles\TopoArea.sld > (The filename, directory name, or volume label syntax is incorrect > > Mark > This e-mail and any attachments are confidential. It may contain privileged > information and is intended for the named recipient(s) only. It must not be > distributed without consent. If you are not one of the intended recipients, > please notify the sender immediately and do not disclose, distribute, or > retain this email or any part of it and do not take any action based on it. > > Unless expressly stated, opinions in this email are those of the individual > sender, and not of Knowsley MBC. Legally binding obligations can only be > created for, or be entered into on behalf of, Knowsley MBC by duly authorised > officers or representatives. > > Knowsley MBC excludes any liability whatsoever for any offence caused, any > direct or consequential loss arising from the use, or reliance on, this > e-mail or its contents. We believe but do not warrant that this e-mail and > any attachments are virus free. You must therefore take full responsibility > for virus checking and no responsibility is accepted for loss or damage > arising from viruses or changes made to this message after it was sent. > Knowsley MBC reserves the right to monitor and/or record all e-mail > communications through its network in accordance with relevant legislation. > > ------------------------------------------------------------------------------ > > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > This e-mail and any attachments are confidential. It may contain privileged > information and is intended for the named recipient(s) only. It must not be > distributed without consent. If you are not one of the intended recipients, > please notify the sender immediately and do not disclose, distribute, or > retain this email or any part of it and do not take any action based on it. > > Unless expressly stated, opinions in this email are those of the individual > sender, and not of Knowsley MBC. Legally binding obligations can only be > created for, or be entered into on behalf of, Knowsley MBC by duly authorised > officers or representatives. > > Knowsley MBC excludes any liability whatsoever for any offence caused, any > direct or consequential loss arising from the use, or reliance on, this > e-mail or its contents. We believe but do not warrant that this e-mail and > any attachments are virus free. You must therefore take full responsibility > for virus checking and no responsibility is accepted for loss or damage > arising from viruses or changes made to this message after it was sent. > Knowsley MBC reserves the right to monitor and/or record all e-mail > communications through its network in accordance with relevant legislation. > ------------------------------------------------------------------------------ > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > This e-mail and any attachments are confidential. It may contain privileged > information and is intended for the named recipient(s) only. It must not be > distributed without consent. If you are not one of the intended recipients, > please notify the sender immediately and do not disclose, distribute, or > retain this email or any part of it and do not take any action based on it. > > Unless expressly stated, opinions in this email are those of the individual > sender, and not of Knowsley MBC. Legally binding obligations can only be > created for, or be entered into on behalf of, Knowsley MBC by duly authorised > officers or representatives. > > Knowsley MBC excludes any liability whatsoever for any offence caused, any > direct or consequential loss arising from the use, or reliance on, this > e-mail or its contents. We believe but do not warrant that this e-mail and > any attachments are virus free. You must therefore take full responsibility > for virus checking and no responsibility is accepted for loss or damage > arising from viruses or changes made to this message after it was sent. > Knowsley MBC reserves the right to monitor and/or record all e-mail > communications through its network in accordance with relevant legislation.
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
