[Mapbender-users] demo.sqlite data type srs

[Gal Zsolt]

Hello List!

I have more than ten application in Mapbender. I like to make reports from it as a start point for documenting it.
I download demo.sqlite to my computer and try/use i-net Clear Reports Designerto make this reports. It works fine.
Some fields contains data like this:

a:5:{i:0;s:9:"EPSG:3844";i:1;s:10:"EPSG:31700";i:2;s:9:"EPSG:4326";i:3;s:9:"EPSG:3857";i:4;s:6:"CRS:84";}


(Example from table mb_wms_wmslayersource field srs)I Google it to find out what is this without success.
I guessa:5means array with 5 items,{…}means array content,i:0;s:9:"EPSG:3844"means index 0, string of 9 characters, string: EPSG:3844.I plan to write a Python program wich access the downloadeddemo.sqlitedatabase and transform all the fields in all tables.Ex.:
from
a:5:{i:0;s:9:"EPSG:3844";i:1;s:10:"EPSG:31700";i:2;s:9:"EPSG:4326";i:3;s:9:"EPSG:3857";i:4;s:6:"CRS:84";}

makeEPSG:3844,"EPSG:31700,EPSG:4326,EPSG:3857,CRS:84

My questions: exist better solution? The a:5:{…….}stringis a result of PHP object to string conversion?

Thanks in advance for any answer.

GÁL Zsolt



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230212/337d5dda/attachment.htm>