[Gambas-devel] Migration from VB6 To gambas. A Case of a Business Intelligence Tool

Benoit Minisini gambas at ...1...
Fri Feb 8 21:37:41 CET 2008


On vendredi 8 février 2008, Rotator Software wrote:
> Hi!
>
> We are a software development team located in Caracas, Venezuela,
> trying to find options to migrate a Client Server, Bussines
> Intelligence application from Microsoft Visual Basic 6 to Gambas, or
> other Basic-like  development tool …. In the analysis process we have
> found some advantages of Gambas, which include easy of use, good
> documentation and high productivity for developers. Nevertheless we
> have some concerns regarding the following:
>
> 1. The GridView seems very basic compared to the original FarPoint 's
> used in the VB6 application. Our question is….Is there any other more
> advanced grid option or grid that can be implemented without going too
> deep at lower levels.

If you need a spreadsheet-like widget, the Gambas GridView will not be 
sufficient. 

It cannot span cells, but you can change the background color of any cell, the 
foreground color, the font, and you can display a picture on the left of the 
cell. You assign data to one cell, not to a full row or a full column.

>
> 2. As far as you know, is there any easy option to integrate Gambas to
> any open source Spreadsheet, like "Open Office' Calc".  For example
> passing data cell by cell to Calc. Have any one done this before?. We
> found nothing over the Web.
>

OpenOffice documents are just a zip of XML files. Unzip one OpenOffice 
document, and you will find a 'contents.xml' file. Just insert the data 
inside it.

For example, I made a OpenOffice spreadsheet export this way:
- I created a void OpenOffice spreadsheet, and I put some arbitrary data in 
it, following the final presentation I wanted.
- I unzipped the document, and opened the 'contents.xml' file. The structure 
is easy to understand, you don't have to read the doc! Then, you can remove 
the arbitrary data, zip the document back.
- After that, I generated my export by using the previous document as a 
template. I copied it, unzipped it, put in contents.xml the exported data by 
following the structure I understood above, then zipped the result.

But I'm not sure this is what you need. Please provide more details.

> We hope to see Gambas being a powerful substitution for VB6, and we
> know it'll happen, but in the mean time, we have to act…
>
> We are sending a PNG of one of the main screens so you can have an
> idea of what we are daling with…
>
> http://rombo.zarate.net.ve/Gambas_Questions.png
>
> The whole program has been written in spanish... but we're planning to
> translate it to other languages
>
> if you'd  like to colaborate us, we're able to have phone conversation
> in spanish or english also we can use IRC or any other ways of chat.

If you have questions, just send them to the mailing-list, this is the better 
way for me.

>
> Please help us…we don't see a light….
>
> Hugs
>
> Santiago Zarate
> Abraham Barrientos

Regards,

-- 
Benoit Minisini




More information about the Devel mailing list