By Chan - 11/11/2008
Hi,
How could I deploy SF built-in framework localization data to SQL Server using DDT?
Thank you
|
By Ivan George Borges - 11/11/2008
Hi Chan.Use the Deployment Package Wizard.
|
By Trent L. Taylor - 11/12/2008
Yup, Ivan is right. The DDT has the ability to import and existing localization package and deploy it for you. The DDT docs explain more. The same thing can also be done for the Role-Based Security data.
|
By Chan - 11/12/2008
Hi,
I have tried it. However, only MessageLangauges data is deployed. No data in MessageItems table.
Please advice. I am using 1.6.6.
|
By Trent L. Taylor - 11/12/2008
This has nothing to do with 1.6.6 and has been implemented for a very long time, so I am very confident in this. Double check your Deployment Data Packages. There will be one for each of the tables involved here. So make sure that the MessageItems is pulling from the correct location, etc.
|
By Chan - 11/12/2008
Hi,
I have read the docs but still unable to find out what steps I have missed out. I have uploaded a video here to show the steps I do.
Beside, I checked StarataFrame database, I didn't see any localization data for built-in framework. It just contains commonRepository (empty) and few sample localization project.
Please advice. Thank you
|
By Ivan George Borges - 11/12/2008
Chan, why didn't you include your VfsLocalization Project when the Deployment Data Wizard asked you for?
You asked for data only from the Common Repository, which is probably empty.
|
By Chan - 11/13/2008
Hi,
I tried to include VfsLocalization project also, but still the same.
May I know where does SF built-in framework localization data stored?
|
By Ivan George Borges - 11/13/2008
I know it is gonna sound a silly question, but you do have Text or Message keys entries in your project, right?
|
By Ivan George Borges - 11/13/2008
By the way, don't forget that this is not the recommended way to add Localization into your application. You probably have a good reaoson to add the Message and Localization tables into your Database, but if not, have a look at the help file under "Using Embedded XML Files", which is the recommended way, and will probably give your application a performance boost.
|
By Chan - 11/13/2008
Hi,
Thank you for reply.
I just re-try at home and also the same.
I think the confusing part is, where is the source? Ivan, you are right, I don't have any data in my project/table.
In my case, I just want to deploy the localization data shipped with SF framework ONLY, not include my project.
As I could see a lot of localization XML file stored under MicroFour folder. However, if I really want to use SQL Server as data source for localization data, how could I do so?
Thank you
|
By Chan - 11/13/2008
Hi,
One more thing is that, if SF only provide localization data in XML format, its fine. However, I prefer to have my project localization data in SQL Server. How to have two type of data source for localization?
Thank you
|
By Ivan George Borges - 11/13/2008
For the pre-localized SF components, it should be working already if you added different languages into your Localization project. Just create a way to change the current language and you should be fine. Do a search in the forum and you will find many posts about it.Now, for you application texts and messages, you need to create the keys in the Localization project in order to be able to export them to your Deployment package, and use them thoughtout your solution.
|
By Chan - 11/13/2008
Hi,
I tried to add new language yo my localization project, add new entry to text values portion and try deploy package to server again. This time, I included my localization project and CommonRepository. The result is
Deploying data for MessagingItems complete: 1 records (Previously is 0)
Deploying data to MessagingLanguages complete: 3 records.
Seem like SF pre-localizaed component is not included.
Please advice.
Shall you show me something like video?
Thank you
|
By Ivan George Borges - 11/13/2008
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.
|
By Chan - 11/13/2008
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
|
By Ivan George Borges - 11/13/2008
Could you post the the Stack Trace, Chan?
|
By Chan - 11/16/2008
Hi,
Please find the attached screenshot.
Thank you
|
By Ivan George Borges - 11/16/2008
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.
|
By Trent L. Taylor - 11/17/2008
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.
|
By Chan - 11/17/2008
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.
|
By Dustin Taylor - 11/18/2008
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.
|
By Chan - 11/18/2008
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
|
By Dustin Taylor - 11/19/2008
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.
|