If you wanted to add extra data to it, you would need to bring what is already in the XML files into your own localization project first manually. This would, again, take some work up front but from that point forward you could modify it as you need to.  As far as combining XML and SQL stores for the localization data, no, you can't combine the two, it is one or the other.

The short answer is that what you are trying to do goes beyond the intended use of the RBS system. You are more than welcome to extend it as you are discussing, of course, but it is simply going to take some work up front to get started, any way you look at it.

Hi,

Thank you for reply.

If I agree to use XML localization data for my web based RBS, how could I include any extra localization data to it (for my custom enhancement)? Can I mix SQL and XML in single application?



Thank you

We don't distribute the internal strataframe localization files in SQL format. If you want to pull out the localization values and bring them into SQL yourself, you can certainly do that. If you open the strataframe source for security, you'll notice there is a "Localization Files" folder containing a number of .xml files (see attatched screenshot.) 

You can copy these files out of the project and modify them as desired, or you can double click on any of these files and manually cut and paste the values into SQL if you so wish. Either way will require some effort, but is certainly possible.

That said, I wouldn't do it this way. The embedded .xml file approach we already use would still work in a web environment and would be much less work all around.

Hi,

I am developing web based RBS which will reuse SF RBS business object, securitybasics and etc. That is reason I was asking how to deploy SF framework predefined localization data.

Beside, in this web based RBS, i also add-in some new feature which suit our environment. Therefore, I am looking for how to have SF predefined localization data in SQL Server.



Please advice.

Chan,

I am confused at this point after reading through this post.  So let's back up and start over here.  Al pre-localized components are embedded in the SF assemblies.  If you are having issues with your localization records, then we can discuss options here as well.  But when and where are you getting a localization error.  If you believe this to be an SF pre-localized key, then which control do you believe is supposed to be getting pulled.  Off of the top of my head, I cannot think of any keys that would be getting pulled on the web side of things.  Most pre-localizations in the framework are for the WinForms controls.  So I would assume here that we are talking about YOUR keys, not the SF keys.  If so, confirm what I have said and we can start from here.

Chan, I have no idea about what you are trying to do with SFSUsersBO, which is probably managed by the Role Based Security, which would have all the keys needed for localization.

Hi,

Please find the attached screenshot.

Thank you

Could you post the the Stack Trace, Chan?

Hi,

If SF localization XML is embedded in DLL, then what should I set for MicroFour.StrataFrame.UI.Localization.MessageKeyType? Currently I set as SqlServer and I hit error when using SFUsersBO - localization key is not found.



Please advice

Thank you

The pre-localized keys for the components are embedded in the SF DLLs. You won't have them in your Message Items table.

And if you generate XML files for your project and embedd them into your projects, you won't need localization tables at all.