OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Example database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
phasel
General User
General User


Joined: 15 Jun 2008
Posts: 13

PostPosted: Fri Jul 31, 2009 4:36 am    Post subject: Example database Reply with quote

Hello,

Last summer I made a database to be used in my company. It is for a sales department in a company that buys and sells equipment. It is useful in keeping track of the opportunities, and helps making quotations.

It is based on mysql, and I use base to make the forms, and macros.

If you need something similar, take a look at it, as it has quite some features. With a little tuning, it can fit many similar departments.

Inside the zip, you have a README file that will explain how it works and how to install. It is fairly simple, and you can have it up and running in less than 30 minutes.

I have placed it in box.net:

http://www.box.net/shared/fpx2kmqyj7

Thanks to all OpenOffice developpers, and to the people that has shared their knowledge in the forum. I would have never done it without those first steps.

Tested both for linux and Windows (v. 2.3, 2.4 and 3.0).

I hope that it will be useful for someone.

Best regards,

Rodolfo del Moral
Back to top
View user's profile Send private message
phasel
General User
General User


Joined: 15 Jun 2008
Posts: 13

PostPosted: Mon Aug 17, 2009 2:18 am    Post subject: Example database Reply with quote

Hello, the database has some downloads.
Any feedback?

Regards,

Rodolfo del Moral
Back to top
View user's profile Send private message
phasel
General User
General User


Joined: 15 Jun 2008
Posts: 13

PostPosted: Fri Sep 11, 2009 3:33 am    Post subject: feedback Reply with quote

87 downloads, and not a single feedback.
I assume that it works without any trouble Smile

Regards,

Rodolfo del Moral
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Sep 11, 2009 6:28 am    Post subject: Reply with quote

Hello

I cannot open it

Romke
Back to top
View user's profile Send private message
phasel
General User
General User


Joined: 15 Jun 2008
Posts: 13

PostPosted: Mon Sep 14, 2009 3:50 am    Post subject: Open database Reply with quote

Hello,

What exactly can't you open?
The zip file, or the database file?

Regards,

Rodolfo del Moral
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Sep 14, 2009 12:40 pm    Post subject: Reply with quote

Hello

I did not remember exact what it was. But I have looked again.
It is based on MySQL, I don't have that.
When I try to look to the forms It asked a password.
So for me it is not important but I think then most people think like me, next thing.
This reaction is only you asked for it.
I think when you give an example then make it in a way that more people can use it. Special on this site more people who need an example use HSQLDB and not MySQL

Romke
Back to top
View user's profile Send private message
phasel
General User
General User


Joined: 15 Jun 2008
Posts: 13

PostPosted: Fri Sep 18, 2009 1:27 am    Post subject: connection Reply with quote

Dear Romke,

Thanks for the comment. Yes, it is based on mysql, and in the readme explains where to find information on installation and connection (really easy on linux, but not too hard on windows anyway).
With respect to the password for the forms, it is on the macro file on top, 1234 if I remember correctly. As it is connected to mysql it asks for the password of the mysql user (in version 2.X you can actually view the forms with a cancel, but not on 3.X).

The fact of using mysql is that it is far better to use it simultaneously by several users. In my case, we were going to be 5 people using it almost full time, and the HSQLDB just did not work. It has quite a few advantages including the fact that you can make frontends in different ways (some people can connect with openoffice, but some others can connect with a php form from the web to check simple things...). It is more robust and flexible.

Anyway, thanks for the comments.

Best regards
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group