pocolap-developers Mailing List for pocOLAP - the little OLAP project

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Pocolap

http://test.aep-thailand.com/seite_9.php?period=259ept7xa3hyh

todd runstein

Sup pocolap

http://olathetheatre.org/pagination.php?doesnt=k1htkm885mh0eqtg

todd

Hi Mihhail,

Good option is Jasper. You need to: 
- abstract Pocolap data source as Jasper rowset
- define the content of your report (jasper xml)
- export to pixel perfect reports in various formats.
More detailed info in the Jasper API.

What do you think?

Regards,
Doichin

PS: Todd, hope you're doing fine. 

 >-------- Оригинално писмо --------
 >От:  Mihhail Novik 
 >Относно: [Pocolap-developers] Saving report
 >До: Poc...@li...
 >Изпратено на: Неделя, 2009, Януари 25 20:19:43 EET

 >Hello, everybody.My name is Mihail. I am J2EE developer from Estonia. This is my first open source project.I start doing ability to save report - selectors/filters from web interface.If anyone has good ideas about this task, write to me.
 >Best regards, Mihail
 >

Hello, everybody.
My name is Mihail. I am J2EE developer from Estonia. This is my first open
source project.
I start doing ability to save report - selectors/filters from web interface.
If anyone has good ideas about this task, write to me.
Best regards, Mihail

Hi all,

My name is Stas and I am going to work on authentication in pocOLAP:

   - Basic authentication
   - LDAP integration
   - and probably CAS and JOSSO support

Think on which items we could use as privileged: Reports, Admin part, etc.I
open for suggestions, discussions and general topics ;)

Don't hesitate - share with me your ideas

Thanks in advance,
Stanislav Makarenko
http://www.linkedin.com/in/stanislavmakarenko

Hi Guys,

I would like to know the team response on what if I migrate our build lifecycle to Maven instead of ANT. I can do the migration and document on how to build and deploy to the JBoss or Tomcat.

Please give me your suggestions.

Regards,
Jothi Shankar Kumar. S

Hi everyone,

Just to inform you the site had a little face-lift.

Also, pocOlap is now compatible with the javascript library jQuery. A great
table plugin, Ingrid (http://reconstrukt.com/ingrid/index.html), has been
used and adapted for data visualization.
Columns are now resizable.

Wouter

Hi Axel,

I am glad that Todd's excellent idea for light-weight OLAP could be further developed. While my current schedule will probably not allow me to contribute to the project, I am interested to see your ideas for extension and how things are going.

Best Regards,
Doichin

 >-------- Оригинално писмо --------
 >От:  Axel Minck 
 >Относно: [Pocolap-developers] Readable message - Giving pocOLAP a new start
 >До: poc...@li...
 >Изпратено на: Събота, 2008, Ноември 22 23:48:33 EET

 >Here is a more readable message ... at least I hope :-) 
 >
 >
 >Hi everybody, 
 >
 >First let me introduce myself. My name is Axel, I live in Switzerland, and work for a company specialised in Rich Internet Applications. The philosophy of my company is to customize and install open source programs for our customers, making them only pay for the customisations we do to the tools, the install, and the support. My company is named Connect-i ( www.connect-i.ch - sorry the website is only in French, translation is in process). 
 >One of the tools proposed by my company is a reporting tool, and we had the idea to integrate pocOLAP to this tool. We indeed really appreciated pocOLAP, very simple to use and efficient. 
 >
 >That's why I contacted Todd to tell him that we would be interested to contribute to the development of this tool. 
 >
 >We share of course the common vision to keep pocOLAP Open Source, under LGPL licence, since we appreciate and believe in Open Source projects. 
 >
 >Our contribution would be: 
 >- for coding and design : make the community benefit from the new improvements we developed following some of our customers' requests 
 >- collect feedbacks from end users to bring some ideas of improvement 
 >
 >Of course any help from the community would really be appreciated. The more we are working on a project, the more fun we have, and the more intelligent ideas we have, which makes the power of Open Source projects. 
 >
 >What I would like to do for beginning is to reactivate the community, host a demo for pocOLAP so that people can have a better view of what it is, make a little refresh on the project's image in order to attract people motivated to start continue pocOLAP's adventure with us ! I also have in mind lots of further developments that could make pocOLAP even better, while keeping it very simple to use and fast as it is now. 
 >
 >Please don't hesitate to tell me what you think about that, if you are motivated to help again for pocOLAP development, and to share we all of us your vision about pocOLAP development. Even if he is very busy, Todd told me he would always try to find a little time to give his opinion about further developments we plan to do, which is very important for the project: the more we are to reflect about it (all the more so for people who followed the project from beginning), the most valuable it is. 
 >
 >
 >I look forward to hearing from you ! 
 >Thanks in advance and kind regards, 
 >Axel 
 >
 >-------------------------------------------------------------------------
 >This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 >Build the coolest Linux based applications with Moblin SDK & win great prizes
 >Grand prize is a trip for two to an Open Source event anywhere in the world
 >http://moblin-contest.org/redirect.php?banner_id=100&url=/
 >_______________________________________________
 >Pocolap-developers mailing list
 >Poc...@li...
 >https://lists.sourceforge.net/lists/listinfo/pocolap-developers
 >

New version contains the ability for users to generate
PDF's of the information in the report grid.  There
are 4 styles to choose from and the whole thing can be
disabled if the admin wishes.

Thanks to Rashmi for putting this together!!!

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Between demo server problems and a bunch of other
projects, I finally found the time to get version
0.2.0 released.  An announcement has also been posted
on JavaLobby.

Now that 0.2.0 is finalized, we're open to adding new
features.  If you're working on something, or want to
pick up a new task, let me know.  

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Make Yahoo! your home page 
http://www.yahoo.com/r/hs

The live demo has been moved to a new server and
upgraded to version 0.1.7.  Our home page on
sourceforge has been updated as well, so visitors will
be directed to the new demo.

If you have any suggestions, comments, or notice any
problems, please let me know.

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Personals - Better first dates. More second dates. 
http://personals.yahoo.com

We have a new host for the demo app.  While the
current host was very useful, it's extremely difficult
to update the site (the hot swap feature has never
worked correctly).  The new host will make it easier
to update the demo application and is also being
offered to us for free.

When we release version 0.2.0, we want to
simultaneously update the demo site.  Since the new
site is available to us, but not public, I wanted to
give you guys a chance to take a look at it before we
change the links on the pocolap web site.  There are
still some improvements to be made, but what's posted
now is a big improvement over the published demo.

If you haven't updated pocOLAP lately and want to see
the newer features we've been working on, I encourage
you to go check it out.  Feel free to poke and prod at
this thing before we change the link on our home page.
 If it breaks, it's better to find out now!  Let me
know if you find a problem.

The url for the demo site is:
http://198.145.29.4:8080/pocolap/ReptPage.jsp

We recently purchased "pocolap.com", so we'll be able
to use "www.pocolap.com" before we go public with this
site.  

Todd

The only "dumb question" is the one you were too
afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners,
cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little"
OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Easier than ever with enhanced search. Learn more. 
http://info.mail.yahoo.com/mail_250

Rashmi brought to my attention a cvs script that
allows automatically generation of emails when commits
are made.  As such, you do not need to send a message
to the cvscommit mailing list after committing - it
will occur automatically (whether you want it to or
not).

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Wow!  We've been making some very good progress
lately.  Version 0.1.7 is very close to being
complete, and includes some very nice new features. 
If you have a chance, update your code from CVS, build
it and test the heck out of it.

The biggest addition to version 0.1.7 is the
introduction of saved reports.  It's now possible to
create a list of column, row and filter elements, and
have them applied to the report grid with a single
click!  If you find user picking and clicking the same
drilldowns and filters on a repeatative basis,
defining a few saved reports will save them time and
potential errors.  Thanks to Rashmi for putting this
together!

The other really cool feature is the ability to add an
image to the report page.  In and of itself, this is a
"no big deal" sounding feature, but consider that the
image can be "dropped" into the internal database,
instead of inside the web application.  This means
that images can be added, updated or removed without
having to open the war file.  Thanks to Ming for the
ability to make this feature a reality!

Of course, bug fixes and updated documentation will
also be included.  Because we have a nice, stable set
of features, we will be releasing version 0.2.0 before
including any new major features.

Once we start improving version 0.2.0, it would be
extremely helpful to have a more complete database for
developers and testers to use.  If you are interested
in helping to create sample data, or have ideas or
suggestions, please send a message to the list (or
contact me offline).  If you know of a company that
might be willing to trade installation and
configuration services for an export of data (we'll
take great care to remove or modify any sensitive
data), it would go a long way to improving the
project.  

Finally, there is a new mailing list that all active
developers and testers should subscribe to.  All CVS
commits should be posted to the list, along with a
list of the files being committed.  You can subscribe
to it from the pocOLAP project page on sourceforge.

Thank you for your continued contributions and support
of pocOLAP.  

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

New code has been committed to CVS which includes
changes to the internal database.  A "resources"
directory has been added which will allow
administrators to "drop" images for use in decorating
reports.  

Ming created a ResourceServlet which is able to locate
and display image files in the resources directory. 
This allows us to create <img> tags that refer to
these images as if they were inside of the web
application.  Very cool - thanks Ming!

To test the servlet on your system, recompile the war
file and create the new directory in the internal
database.  Copy a gif, jpg or png file into the
resources directory (make sure the extension matches
.gif,.jpg or .png) and call the servlet like (assuming
your web server is on port 8080 and the image file
name is image.png):
http://localhost:8080/pocolap/servlets/Resources?type=image&name=image.png

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search. 
http://info.mail.yahoo.com/mail_250

We have a new developer, Ming Wu, who is a software
engineering student in Ontario, Canada.  Ming wants to
get more programming experience before hitting the job
market next year.  

There is new code in CVS (thanks to Ming) which should
help ensure that cross-platform efforts continue to be
easy and robust.  He is also working on updating the
unit tests so that the path statements don't need to
be manually edited by developers working on windows
systems.  

Todd

The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/

Hello All!

I have committed quite a few changes to the code in CVS. The
configuration file parsing process now uses XMLBeans. You will need
xbean.jar to build it. XMLBeans can be downloaded from
http://xmlbeans.apache.org

Also, please note the following changes for configuration file: 
-Root element for config file - <reptconfig> tag is replaced with
<crosstabdef> (CrossTab Definition)
-The <source> tag is now an empty element. You'll need to use dbString
attribute to specify dbStrings.

Please feel free to write any comments/questions/suggestions.

Thanks and Regards,
Rashmi

You are correct.  There is an HSQLDB database that is
distributed with pocolap, but the Derby based one is
more current.  We will continue to distribute both (at
least for the foreseeable future).

If you're interested in creating a new sample
database, then the scripts\pocOLAPsample.sql is the
correct file.  There are notes on building the
database in userdocs/sampledata.

Todd

--- husky <my...@gm...> wrote:

> hi, 
>      From project homepage Tasks, looks like we are
> using Derby as our
> sampleDB database. just to make sure, the script
> that create sampleDB
> is pocolap\src\scripts\pocOLAPsample.sql, right?
>     if I create the new sampleDB, I should just
> modify with
> pocOLAPsample.sql with proper example data, right?
>     Thanks
> 
> -- 
> regards,
> Ming
> 
> 
>
-------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT
> Products from real users.
> Discover which products truly live up to the hype.
> Start reading now.
>
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Pocolap-developers mailing list
> Poc...@li...
>
https://lists.sourceforge.net/lists/listinfo/pocolap-developers
> 

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250

hi, 
     From project homepage Tasks, looks like we are using Derby as our
sampleDB database. just to make sure, the script that create sampleDB
is pocolap\src\scripts\pocOLAPsample.sql, right?
    if I create the new sampleDB, I should just modify with
pocOLAPsample.sql with proper example data, right?
    Thanks

-- 
regards,
Ming

use "pocolap"

--- husky <my...@gm...> wrote:

> Can anyone tell me which modulename I should use to
> checkout the source code?
> 
> cvs -z3
>
-d:pserver:ano...@cv...:/cvsroot/pocolap
> co
> -P modulename
> 
> 
> -- 
> regards,
> Ming
> 
> 
>
-------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT
> Products from real users.
> Discover which products truly live up to the hype.
> Start reading now.
>
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Pocolap-developers mailing list
> Poc...@li...
>
https://lists.sourceforge.net/lists/listinfo/pocolap-developers
> 

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com 

Can anyone tell me which modulename I should use to checkout the source code?

cvs -z3 -d:pserver:ano...@cv...:/cvsroot/pocolap co
-P modulename

-- 
regards,
Ming

Version 0.1.3 has been released.  Lots of internal
changes - see the release notes.

Make sure you look at how the crosstab definition
files (previous called whs_ files) are located by the
application.  You no longer define these in web.xml -
they go in the internal database in a folder called
crosstabdefs.

Thanks to everyone who worked on this, and especially
to Rashmi who spent time cleaning up my old stale
code.  This work will make adding new features much
easier, and without risking the overall stability of
the application.

Let me know if you have any question, find any
problems or have suggestions.

Todd

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250

Rashmi has been kind enough to post several tasks on
our sourceforge page.  This provides a look at what
we're working towards in the near/mid term.  

If you are interested in being assigned one of the
tasks, or working on a portion of a task, let me know
(just to make sure we don't get multiple developers
working on the same thing).  If there's another task
you feel should be added, please bring it to my
attention.

The task page can be found at
http://sourceforge.net/pm/?group_id=99051

Todd

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

The deployment for pocOLAP has changed.  If you update
your code from CVS, please note that the build will
create a war file that will no longer work with the
sample databases.  You will also need to change the
way you incorporate your own crosstab definition files
(these were previously referred to as "whs_" files).

Perviously, you copied the pocOLAPinternal directory
(which was the Derby sample database) and 2 nss.*
files (which were the HSQLDB sample database) to the
C:\ or /tmp directories.  Now, there is a pocolapDB
directory (located in CVS in userdocs/sampledata). 
Copying this entire directory to C:\ or /tmp enables
logging and sets up the sample databases.  

Previously, in order to tell the application about
crosstab definition files, you would create a "whs_"
init-param that pointed to your definition file.  Now,
you simply drop your crosstab definition files into
the crosstabdefs directory in the internal database
(pocolap/crosstabdefs).  Restarting the application
will cause the definitions to be read in.

The only need to edit web.xml at the current time
would be if you want to move the internal database
(the pocolapDB directory).  Within web.xml, set the
value of the "pocolap.DB.location" init param to the
new location/name of the internal database directory.

This is all included in the INSTALL.txt file in CVS. 
The config_file_how_to.pdf is still out of date, but
will be updated prior to our next release.  If you are
able to test the new code, please do so and let me
know if there are any problems.

Todd

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 

I just commit some pretty major changes to the code in
CVS.  The entire parsing process has been replaced. 
You will need jdom.jar in order to build the project
now. 

If you have any questions, or encounter any problems,
please let me know as soon as possible.

Thanks! 

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________

__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250

2004	Jan	Feb	Mar (8)	Apr (10)	May (2)	Jun (2)	Jul (8)	Aug (2)	Sep	Oct	Nov (1)	Dec (3)
2005	Jan (11)	Feb (8)	Mar (5)	Apr (2)	May (1)	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2008	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (4)	Dec
2009	Jan (9)	Feb	Mar	Apr	May	Jun	Jul (2)	Aug	Sep	Oct	Nov	Dec
2016	Jan	Feb	Mar	Apr	May	Jun	Jul (1)	Aug	Sep	Oct	Nov	Dec (1)
2017	Jan	Feb	Mar	Apr (1)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

pocolap-developers Mailing List for pocOLAP - the little OLAP project

pocolap-developers — Discussion of development issues