Toools

(0 votes)
Gantt chart

With Toools you can program a job and create a Gantt chart connected with a database, the HSQLDB integrated in OOo by default or MySQL by using the instruction of User's Manual, and update the chart in real-time, by one (HSQLDB) or more (MySQL) users. The chart can be copy-pasted and also manually modified.
Toools also create a Python service into OOo, wich will be extended in the future.
Now it offer a list of printers, accessible simply from OOoBasic.
New! Click here to get the free Tutorial
Translate the extension in your language!
Get here the instructions

In the User's Manual it will be clarified how to do this, without Python experience.

Click here to get User guide

This is "commercial" open source: what this means? and why?
1. It means that the program is licensed as LGPL and is free, in every case, but there's the possibility to have commercial services, like the User Guide and other ones, that will be availables in the future.
2. The scope of this way of working is to give a chance to this extension to be developed more and more in the future, with other functions that, for example, could be:
- executing an automatic poll via mail, using Python's integrated mail functions;
- integrate FastMailMerge extension improving it with the possibility to save models;
- manage your inventory with the creation of movements for loading and unloading;
and others.
It will be developed a way of votation for let the users decide which function to create.

(Italiano) Con Toools è possibile programmare un lavoro e creare un diagramma di Gantt collegato con un database, HSQLDB integrato in OOo, o MySQL utilizzando le istruzioni del Manuale d'uso, e aggiornare il grafico in tempo reale, da uno ( HSQLDB) o più (MySQL) utenti. Il grafico può essere copiato ed incollato e anche modificato manualmente.
Toools crea inoltre un servizio di Python in OOo, che sarà esteso in futuro. Per adesso offre un elenco di stampanti, accessibile semplicemente da OOoBasic. Nel Manuale utente è chiarito come effettuare questa operazione, senza alcuna esperienza di Python.
Clicca qui per ottenere il manuale utente

Questo è open source "commerciale": cosa significa? e perché?
1. Significa che il programma è concesso in licenza LGPL ed è libero, in ogni caso, ma c'è la possibilità di ottenere servizi commerciali, come la Guida per l'utente e altri, che saranno disponibili in futuro.
2. Lo scopo di questo modo di lavorare è quello di dare una possibilità a questa estensione di svilupparsi sempre di più in futuro, con altre funzioni che, per esempio, potrebbero essere:
- L'esecuzione di un sondaggio automatico via posta elettronica, utilizzando le funzioni integrate di mail di Python;
- Integrare l'estensione FastMailMerge migliorandola con la possibilità di salvare dei modelli;
- Gestire un magazzino con la creazione dei movimenti di carico e scarico;
e altri.
Sarà sviluppato un modo di votazione per permettere agli utenti di decidere quali funzioni creare.

Mixed OOoBasic/Python powered.
Languages:
English,
Italiano,
Hungarian (thank to Juhász Dezső).

Download extension
Operating System: System Independent
Compatible with: OpenOffice.org 2.4 | StarOffice 8 Update 9 or higher.
Official release: 0.1.10
Date: 2009-Nov-21
Size: 90.24 KB
License: opensource
Further product information: Screenshots | Product details
Provider: Sergio Corato

Comments

Latest version do not install properly (windows)

Sergio,

Your latest version do not install properly on my Windows machine
- no comments in the Extension managaer
- no "itctools" in the Top menu bar

Fernand

removed

removed

The extension works fine in

The extension works fine in my Vista and Ubuntu too, so try to remove and reinstall it.
If you don't solve the problem, please let me know.
I saw a mis-function in Ubuntu: the Save position button work only until OOo is not closed, I don't know why (this not happen in Vista)
Xergio

select auitomaticly OOdialogs

Hi Sergio
please find some code to automaticly selecting OOdialogss
"Hoe" means "how" and must bean true for use of "SystemDialogs and false for using OOdialogs
hope it helps
Fernand

Sub UseSystemFileDialogs(Hoe as boolean)
dim aArgs(0) as Object
dim aPropValue as new com.sun.star.beans.PropertyValue
xconfig = createunoservice("com.sun.star.configuration.ConfigurationProvider")
aPropValue.Name = "nodepath"
aPropValue.Value = "org.openoffice.Office.Common/Misc"
aArgs(0) = aPropValue
xAccess = xconfig.createinstanceWithArguments("com.sun.star.configuration.ConfigurationUpdateAccess",aArgs())
aIsSystemDialog = xAccess.getHierarchicalPropertyValue("UseSystemFileDialog")
xAccess.replaceByName("UseSystemFileDialog", Hoe)
xAccess.commitChanges
End Sub

Thank you Fernand, very

Thank you Fernand, very useful!
I'll include in my code asap.
Xergio

hm - a mini-help, that could

hm - a mini-help, that could be fair enough, but it does not help me - and I guess the screenshots will come later .
I gave it a try under ooo-portable german, and looks, it is not working:

Setting up: You mean: at first go to CALC and the new menu-item "icstools" and "settings" to try to build the .odb?
it terminates with the missing mysql-facilities - as the connector is not available, whereas it should have used the HSQLDB. Also I did not understand what you mean by "go first to MACRO/Dialog-settings ... )
At actual: I regret, to me it is not working

Martin

Test the last

Test the last release.
Simply open IcsTools -> IcsGantt -> Project and select a directory.
Nothing else to do!
Hope it helps.
N.B. If you have registered a MySQL db without having created it, remove it. MySQL db creation is not automatic, only registering is.
Xergio

tja - what to say, you

tja - what to say, you should not use the extensions-board as a playground, 3 versions for today, but of none them working.
I gave it a try with 0.1.9
at actual the hsql-odb is build, but it has no content (data-file with table-structure or forms is missing - all sitting unused in the UNO-cache)
First run of macro gives a "illegal Argument - it.icstools..." not registered.

hmm ..

Martin

I've hidden the 2 releases

I've hidden the 2 releases you refer, they should be invisible...
I tried the extension in my newest installed Ubuntu 9.10, and the creation of Hsqldb works fine, as Windows Vista too. I haven't an XP by hand.
Perhaps the error you encountered could help me, would you give me the entire message? If too long, feel free to send me a mail.
Xergio

as said before

the extension is not working
I just started it - this time from a new empty .odb and the error is the same as above;
see screenshot on:
http://www.bilder-speicher.de/09111901144833.gratis-foto-hosting-page.ht...

You could be proud of having 1500 downloads, however, why is nobody else commenting on this issue?
Nobody gave it a try?

Martin

yes - better to hid outdated stuff

but trust me, the 0.18 is not working too

the board is blocking screenshots, so you please read the above mail and try to understand the error-message:
the skript is brooken in the first line (Function OpenForm without arguments)
and thereon the reports that it.icstools.toools is no registered extension

1500 downbloads but no comments, looks as nobody gave it a try sofar

Martin

0.18? Do you mean

0.18? Do you mean 0.1.9?
0.1.8 had a problem, download the 0.1.9 if you haven't done yet.
If you have the non registered extension problem, please try to remove the extension, close OOo and reinstall the extension (0.1.9).
Please let me know if you don't solved.
Xergio
(n.b.: for the download, I hope it's because the extension usually works fine)

ehem ...

it would be very kind if you could show some willingness in understand me.
As written above, I tried 0.18. aswell as 0.19 - both not working.
Well, didn't you receive direct support from SUN? However, it is not working, a withdrawl might be a good decision.

Martin

I posted a new release,

I posted a new release, whithout no news, only redone, hoping to solve the problem of Martin.
I am aware that this system of reporting bug is not efficient and is impossible to know the real usability and use of the extension, so I am working to a facility to send feed-back on the extension with a button. Is also impossible to know if what Martin is saying is experienced from other users (@Fernand: you solved?), as I am unable to repete the error.
For now, on reporting bug please let me know the o.s. and version of OOo.
Xergio

somewhat incomplete - sofar

hm - rather useless, with a nonworking homepage, missing screenshots and without any hint on the how-to-use, meaning with a link to the user-guide available as a commercial e-book only.
Martin

Ok, you're right, I think so

Ok, you're right, I think so too. I was waiting for someone who asked me :-)

So I've done two things:
1. I put a free Tutorial (part of the User Guide) on the link above (or here);
2. I put some screenshots on the home-page.

Xergio