Xtract - Data Cube - V0.91 (Ready for release!)

Utilities like DBU, Make, IDE written in HMG/ used to create HMG based applications

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5068
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 86 times
Been thanked: 101 times
Contact:

Re: Xtract - Data Cube - V0.91a (Ready for release!)

Post by Rathinagiri » Sat Nov 14, 2009 12:36 pm

Here comes the new bug fixed version of Xtract Data Cube - 0.91a

Kindly give your comments.
extract0.91a.zip
(20.46 KiB) Downloaded 278 times
Change Log:

- Fixed bug - double clicking filter prior to selecting row/col/data fields crashed Xtract. (Thanks Sudip and Fernando Chirico)
- Introduced tool bar buttons (Auto calc, Refresh, Print and Exit)
- Introduced Short-cut keys (F2 for auto calc, F5 for refresh, Ctrl+P for printing, Esc for Exit)
- Fixed some bugs
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Post by fchirico » Sun Nov 15, 2009 12:56 am

rathinagiri wrote:Hi Fernando Chirico, Sudip and Vanguarda

Now coming to your suggestions:
fchirico wrote: 2 - In a new version would be interesting if there is a button "REFRESH" for when you change a filter, as
Otherwise it should click on the DATACUBE and then click in the fields of filters to "REFRESH" to the DATACUBE.
rathinagiri wrote: I had given the toolbar buttons to either auto-create the cube or cube is created only after pressing the refresh button. I think this would be enough.
I think the same.
fchirico wrote: 3 - To select filters sometimes (when there are many records) you must double-click quickly on the field
to be filtered, otherwise it displays the message "please wait while Tabulating ..." but do not bring the values
(in control) to select the value for which you want to filter. If I double click it brings
rathinagiri wrote: This happens for a long table, especially having more number of rows/more number of columns. In that case, it is better to switch auto-cube off.
Sorry I dont understand "auto-cube off". How i do it this?


fchirico wrote: 4 - When analyzing data with dates, such as sales, must be analyzed by date ranges, so the
Current Filter DATE fields in not comfortable, it might be advisable before pressing the power button XTRACT
so select "SET FILTER TO" or similar.
rathinagiri wrote: Filter options are just primitive. Soon you can expect a better filtering interface and options.
The filters are right, and i think this are very helpfull. And I think they should be. Only i think that if existing a button, that making double click, work like a "set filter...".

fchirico wrote: 5 - To avoid having to run each time the same cube or to analyze the result in another time or to work with
other tools would be useful to export it to what you want.
rathinagiri wrote: I am planning to export the result to MS Excel/Openoffice Calc. Do you have any other options?

No, it's ok.




Now i'm going to prove your new version, than you.

Saludos, Fernando Chirico


Saludos, Fernando Chirico.

User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Post by fchirico » Sun Nov 15, 2009 2:08 am

rathinagiri wrote:Here comes the new bug fixed version of Xtract Data Cube - 0.91a

Kindly give your comments.
extract0.91a.zip
Change Log:

- Fixed bug - double clicking filter prior to selecting row/col/data fields crashed Xtract. (Thanks Sudip and Fernando Chirico)
- Introduced tool bar buttons (Auto calc, Refresh, Print and Exit)
- Introduced Short-cut keys (F2 for auto calc, F5 for refresh, Ctrl+P for printing, Esc for Exit)
- Fixed some bugs

I was evaluating the new version (09a), and is really expectacular, is fast and accurate.

1 - I wish I could choose the colors of the rows, columns and data
2 - would be great if they can save and load the settings of the skeleton of the cube

With these two new items requested, and export to Excel/Open Office, the tool becomes truly professional use. :ugeek:

My congratulations. :P

Regards, Fernando Chirico.
Saludos, Fernando Chirico.

User avatar
Rathinagiri
Posts: 5068
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 86 times
Been thanked: 101 times
Contact:

Post by Rathinagiri » Sun Nov 15, 2009 3:42 am

Thanks a lot Fernando. Now I am enhancing the features of filters. After that I shall implement your essential suggestions.

Thanks again.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1443
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Post by sudip » Wed Nov 18, 2009 4:56 am

Hi Rathi,
I tested it. Problem solved. :)
Thanks a lot :)
And sorry for the delayed feedback ;)
With best regards.
Sudip
With best regards,
Sudip

User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Post by fchirico » Thu Oct 14, 2010 12:40 am

rathinagiri wrote:Thanks a lot Fernando. Now I am enhancing the features of filters. After that I shall implement your essential suggestions.

Thanks again.
SPANISH:

Rathi:

Quisiera solicitarte autorización para incluir el programa "xTract" que tu has desarrollado, en una aplicación mía. Si me da su autorización le pido por favor me indique qué datos suyos quisiera que muestre el botón de "About" de su programa Xtract.

Desde ya muchas gracias!

ENGLISH:

Rathi:

I would like to ask you for permission to include the "Xtract" that you've developed in my application. If you give me permission I ask please tell me what information about you want to show the button "About" of your program Xtract.

thank you very much!
Saludos, Fernando Chirico.

User avatar
Rathinagiri
Posts: 5068
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 86 times
Been thanked: 101 times
Contact:

Post by Rathinagiri » Thu Oct 14, 2010 3:50 am

Hi Fernando Chirico,

It is my pleasure that my small part of code is useful to you. I have started this Xtract as an open source project. Therefore, you don't require my permission at all.

A simple mention of my name anywhere (like readme.txt/license file) is enough.

Thanks again for you.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Post by fchirico » Thu Oct 14, 2010 11:56 am

rathinagiri wrote:Hi Fernando Chirico,

It is my pleasure that my small part of code is useful to you. I have started this Xtract as an open source project. Therefore, you don't require my permission at all.

A simple mention of my name anywhere (like readme.txt/license file) is enough.

Thanks again for you.
Very thanks!
Saludos, Fernando Chirico.

User avatar
bpd2000
Posts: 904
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 72 times
Been thanked: 14 times

Post by bpd2000 » Sat Oct 22, 2011 4:08 am

Dear Rathinagiri

Excellant Data Cube
Sir, any latest development
This is partof HFCL or separate utility ?
BPD
HMG Convert Dream into Reality

User avatar
Rathinagiri
Posts: 5068
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 86 times
Been thanked: 101 times
Contact:

Post by Rathinagiri » Sat Oct 22, 2011 4:33 am

Thank you BPD.

I am just developing Xtract as a general UDF for analyzing grid/array/dbf data in a single command call. Please wait for the new release.

Thanks again for your interest.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest