OK..sorry to bug the group again but just trying to make sure I use all best practices when available.

 

I have figured out the localization of questions with no problem but the localization of the list options (combo box, radio buttons, etc) is another story. 

I added another column to the "lists" table which allows me to specify the language but that is not maintainable as I would have to create question events for ever single language. 

Is the correct table to use for this DynamicForms_QuestionOption or the list table..or some combination of the two?

 

Thanks for any help! You guys rock!

 Sorry to be more specific about my issue..(don't want to waste y'alls time).

I have a form in which I have a couple of places where I allow the user to remain anoymous (IE hide name questions if they choose not to share it). I am doing the form in 35 different languages. I need to be able to present the caller with the option of YES for a radio button in their native language and then hide the questions or present them based on their answer in their native language. 

I have figured out how to have a list option or radio option for the languages but my problem would be that I have to create a question event for every single version of the word yes for that question event to present or hide the questions..

I am racking my brains about this..so let me know your thoughts.

Hi,

You might already have this figured out for localizing combo boxes but if not...

You can do this use the SQL Options for the dropdownlist and then also using the '$(CurrentLanguage)' token. Check out this forum thread: http://www.datasprings.com/Products...fault.aspx and here... http://www.datasprings.com/Products....aspx#2408

Now... As far as question events and so forth what you can do is bring in the QuestionOption which represents the 'Text' (what the user sees) in different languages but the QuestionOptionoValue can always be the actual value of 'Yes' or 'No' etc... So the user would see the question option which is the text and the question events would always be fired based on Yes and No etc...

Hope that helps... To 'create' question events you can't use $(Tokens) in the query. My suggest would be to temporarily hard code the current language token in the query and then go save the question event/completion events etc... Then go back and replace it with the token.

-Chad

 Thanks for the reply Chad..

 

I guess I am still a bit confused on how the lists table interacts with the questionoptions table? Do I use both? Only one?

I read both suggested threads prior to posting my original question and don't fully understand how to do this? Should I modify the "QuesitionOptions" table to include language so I could just select by that. 

If you could provide a couple of line example of what the query would look like I would greatly appreciate it! 
Thanks!

Ryan

Greetings Chad-

 

I also tried your suggestion to have QuestionOptionValue stay the static answer of "Yes" and have QuestionOption be the one that can change based on language. 

Unfortunately this does not work. The options selectable display the one from the QuestionOption  when trying to choose your question event trigger answer..not the one from QuestionOptionValue.

Example..

I put in YES as the QuestionOptionValue  and YES in as the QuestionOption. I then put in Si' as the QuestionOption and YES in as the QuestionOptionValue. 

This would result in several different list options (assuming i have 30 languages to present). 

Any help would be awesome! Thanks

Hi Ryan,

The 'Lists' table and the QuestionOptions table really don't have anything to do with each other. Here is some quick feedback on this:

1. The QuestionOptions table is ONLY for when you manually enter options and not related to SQL Options at all.

2. The lists table is just a table that DNN has under host/lists. You can use and reference this table or you can create your own table... Basically if you use your own table or you query against the host/lists table you are just using a query to reference that table.

3. During execution of the form the module looks and replaces the $(CurrentLanguage) token at run time with the actual language code that the user has chosen. So you can reference your table where a specific column matches that language.

Here are a few examples, if you need us to be more directly involve (such as writing SQL or something) we can do this via Premium Support hours which you can pick up at http://www.datasprings.com/Premium-Support. IF you want to setup a quick example of this on Beta Springs you can do that as well and we can try and take a peak. (sign in as host/dnnhost).

Check out these examples:

Content Localization Thread

Content Localization Thread 2

Thanks,

-Chad

 Thanks Chad for the detailed response.

 

I understand what you are saying now. Thanks for clarifying the list vs. question options.

 

I am one step ahead of you on the premium support option. I got approval yesterday to buy a bank of 6 hours from you guys. Assuming we purchase this could I setup time for Thursday afternoon to go over what we are trying to accomplish with you guys so you can help me understand how to best attack it?

Would it be you helping talking with me or Candace or Ryan? 

Let me know and I will go ahead and purchase the time later today. Thanks!

Hi Ryan,

That is great to hear!

I could probably meet with you sometime on Thursday (late afternoon) or on Friday. It might depend on what your specific needs are but I am sure Candace and Ryan can also help (depending on your needs I might assign it to one of them or I might handle it directly).

Thanks, and I look forward to working with you!


-Chad

Awesome..one last broad question.

Chad..I don't need to know exactly how it would be done, but my boss is asking me to confirm that if we buy the premium support that we will be able to accomplish what we want to do. A simple yes is all I need

We are basically trying to build a form that is the same form but able to be translated into 35 different languages (both the label and the list options) all on one page--with the language being passed in with a token. We are basically trying to make sure the entire page of questions is table driven..and also making sure that the question events only have to be set once vs. setting the answers to each of the 35 translated words/phrases. (Like in my question above I want to be able to be able to trigger a question event on the answer YES, even though yes might appear as Si' or Oui depending on the language.

 

Thanks again--and I am stoked about working with you and/or your team.

Assuming the above is OK I would like to chat tomorrow afternoon (I will of course process the payment prior to us talking). I would like to show you what we are trying to reproduce (currently we have 35 pages--one for every language) and we are trying to get to one page that gets translated from the tables and presents the local version. Perhaps you can share your email address so I can send you a link to our current page so we can review tomorrow afternoon (unfortunately I will be off Friday).

Thanks!

Hi Ryan,

Yes, this can definitely be done, with some tweaks that we can apply.   Please use the Contact Us form to send us additional details.  That way, we'll all get the email and be able to review it.   Thanks!

Candace

 Cool! I will get the payment in to you guys today. Can schedule some time on Monday to get cranking?

Thanks!

Ryan

Hello Ryan,

 

Thank you for your business, and we will have someone contact you about scheduling time to work on this for you, if you haven't already spoken to someone.

 

Thanks,

 

Ryan