This is a project derived from previous #54690 visible here:
[url removed, login to view]
This is about a quizz generator and 3 distinct companies.
The first company will generate a quizz in english and send it to the 2nd company
Through the quizz generator they'll be able to add / change / delete quizzes, questions and answers;
That means everything must be kept into a DB / file / whatever.
The client has php/mysql on local intranet so at first, I thought we could write a web application that would generate the quizz program (flash app, using ming lib) and a side file which would contain the sentences to be translated.
The translation will be made by a 3rd party translation company. I thought we could issue an excel document with field constrains ("enter the translation for this text here... anyway that's the only place you can write it to..." 1 row for each sentence, 2 cols: 1 in english the other in the foreign language)
But it seems complicated... ppl here said that flash would not be able to access xls files, especially if generated with ming... Well maybe, I dunno so I leave it open:
- the main app (quizz gen) can be a standalone process or dev'ed in php/mysql... I don't care as long as the final result is ok
- the quizz app itself can be generated thrhough the main app or simply be issues a ressource file... That ressource file will contain the quizz decisionnal tree structure, the pictures of the product the quizz is based upon, etc...
Moreover, each time a new product is issued, the quizz gen will generate a new quizz/resource file.. Let's say the company I send the quizz to requires quizzes A,B and D... Through the quizz gen, I must be able to specify which quizzes to include in the output file... say I have A, B, C D and E quizzes... I'll check A, B and D and voila ! a file is created..
This file will contain the data for all 3 quizzes (pictures, decisionnal trees, etc). When run (or used as a resource), a menu will invite the user to choose upon Quizz A, B or D and start the chosen Quizz.
Once this is done, they will send the generated file(s) to the second company.
The second company will receive this quizz and have it translated because they need to deliver it in a foreign country (3rd company).
Let's say I'm the guy ho receives the files (the quizz CANT access the DB used for generation...
say I receive the files on a CD and I have no internet connection, ok ?
Well... I'm a chinese guy who needs to have the english sentences replaced with chinese sentences...
I'm not very skilled with computers... So I need to be able to easily "export" the sentences to be translated to a translation company.
(an excel file could have been convenient. If you prefer to use XML, then keep in mind that an interface will have to be written to allow the parsing / updating of this xml file.
Example: I've juste received the files... I need chinese translation... Well if I have a separate translation file that works along with the quizz app, then I can send this file for translation, provided we can make sure that no mistake can be made in that file !
Ok. So I send that file... the translation company does the job and sends me the file back... I include it back in the quizz app... and now, instead of english, I should be able to read chinese !
Well, that being done, I simply burn a few CDS and send them to their final destination: the 3rd company
The last company will receive the final application (Quizz + translations).
In that 3rd company, nobody is able to do any complicated install process nor whatever... So I need a verrry simple solution.
They receive the CD, insert it into the DVD drive of their chinese WindowsXP computer and... well it works... No installation of dll files nor whatever. It runs FROM the CD and does not install anything on the remote computer (that may even not have the rights to install anything)
php/mysql/flash ? director ? standalone exe (vb/c++/C#) ? think of whatever you like but keep in mind that the uid will need high quality graphics (no silly windows "grey" buttons eh ?).
Oh and by the way... I will provide the graphics for the interface, that's why I had thought about going on flash / director because it's easy to design a great uid.
Now it's your turn to talk... what proposals do you have ?
u can catch me there if needed: yanor at hotmail dot com