topic Re: Why does DB Browser for SQLite treat stylex content column as blob? in .NET Maps SDK Questions

Why does DB Browser for SQLite treat stylex content column as blob?

Anonymous User — Wed, 08 Apr 2020 22:52:46 GMT

When I open Utilities_en.stylex with DB Browser for SQLite 3.11.2, I can see the Content column in the Items table as json.

However, when I open the ArcGISRuntime2D_Pro25.stylx from the symbol editor sample, it treats the Content column as a Blob.

Can't change the mode either...

Sorry if this is the wrong place to post ... I'm not sure if this is a bug in DB Browser (perhaps this one? ) ... or with ArcGIS pro (which I guess created the stylex file to begin with) or maybe there's a save_stylex hiding somewhere in the SDK ?

Thanks

Re: Why does DB Browser for SQLite treat stylex content column as blob?

MichaelBranscomb — Tue, 14 Apr 2020 19:19:27 GMT

Hi Kirk

Unfortunately we don't know the answer to this one - it appears to be an issue in DB Browser. Perhaps related to a change in the app or perhaps related to the size of the data in the field (suggested by one of my colleagues).

Some other SQLite browsers don't appear to have this issue. One informal suggestion was TkSQLite, but that's not an official recommendation or endorsement.

Thanks

Mike

Re: Why does DB Browser for SQLite treat stylex content column as blob?

MichaelBranscomb — Tue, 14 Apr 2020 20:41:17 GMT

... the Symbol Editor demo is also a great way to see/copy the JSON for symbology: arcgis-runtime-demos-dotnet/src/SymbolEditor at master · Esri/arcgis-runtime-demos-dotnet · GitHub

Re: Why does DB Browser for SQLite treat stylex content column as blob?

ZoltanKelly — Thu, 19 May 2022 14:30:02 GMT

For those that come across this, ‘…For some reason, the json string has a character at the end that makes DB Browser think it's a blob instead of text. If you delete the 00 at the end, it will then display as text and you can get an idea of what the json looks like for a CIMPointSymbol for example...’

from https://community.esri.com/t5/arcgis-pro-documents/how-to-programatically-add-symbols-to-a-stylx/ta-p/921159

that article is good for messing around with stylx files, and I don’t know any other way