Обсуждение: data entry
For years I am using dBASE to compute payroll of employees. Required data entry is number of days present and overtime if any. This is done record by record. Data entry person sees employee number and name, and boxes with prompt, where the data is entered. For Postgresql is there any user interface available, that could help a non technical person to make the data entry? vijay
A web interface can be programmed very easily. That is the only way I have ever placed anything into a Postgresql database. -----Original Message----- From: deval [mailto:deval@giaspn01.vsnl.net.in] Sent: Tuesday, September 05, 2000 9:38 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] data entry For years I am using dBASE to compute payroll of employees. Required data entry is number of days present and overtime if any. This is done record by record. Data entry person sees employee number and name, and boxes with prompt, where the data is entered. For Postgresql is there any user interface available, that could help a non technical person to make the data entry? vijay
Here is a list of utilities and things from the PostgreSQL CD. I know there are a few tools for data entry. PGAccess I think is what you are looking for.
Software : ODBC (Click here to browse directory)
Webpage : ftp://ftp.postgresql.org/pub/odbc/index.html
Contact :
Software : DBD-Pg (Click here to browse directory)
Webpage : http://www.perl.com/CPAN/modules/by-module/DBD
Contact : E.Mergl@bawue.de
Software : GtkPGA (Click here to browse directory)
Webpage : http://www.geocities.com/CollegePark/3807/GtkPGA.html
Contact : darkhonor@geocities.com
Software : GtkSQL (Click here to browse directory)
Webpage : http://www.multimenia.com/bbrox/GtkSQL
Contact : mailto:bbrox@multimania.com
Software : JDBC Driver (Click here to browse directory)
Webpage : http://www.retep.org.uk/postgres
Contact : http://www.retep.org.uk/contact
Software : KPGsql (Click here to browse directory)
Webpage : http://home.primeusnetz.de/mgeisler/kpgsql
Contact : geisler@primeusnetz.de
Software : Keystone (Click here to browse directory)
Webpage : http://www.stonekeep.com
Contact : http://www.stonekeep.com/support.php3
Software : dbengine (Click here to browse directory)
Webpage : http://www.cis-computer.com/dbengine
Contact : ciechowski@cis-computer.com
Software : HaruspeX (Click here to browse directory)
Webpage : http://www.linux.it/ospiti/haruspex
Contact : abaldoni@racine.ra.it
Software : KMySql (Click here to browse directory)
Webpage : http://www.xnot.com/kmysql
Contact : kmysql@penguinpowered.com
Software : kpsql (Click here to browse directory)
Webpage : http://www.mutinybaysoftware.com/kpsql.html
Contact :
Software : mpsql (Click here to browse directory)
Webpage : http://www.mutinybaysoftware.com/mpsql.html
Contact : mailto:keidav@mutinybaysoftware.com
Software : PgAccess (Click here to browse directory)
Webpage : http://flex.flex.ro/pgaccess
Contact : teo@flex.ro
Software : pgAdmin (Click here to browse directory)
Webpage : http://www.vale-it.demon.co.uk/freeware
Contact : support@vale-housing.co.uk
Software : wui-mod_postgresql (Click here to browse directory)
Webpage : http://www.yamanasi.net/~kenji
Contact : kenji@yamansi.net
Software : PHP 4 & 3 (Click here to browse directory)
Webpage : http://www.php.net
Contact : http://www.php.net/support.php3
-----Original Message-----
From: deval [mailto:deval@giaspn01.vsnl.net.in]
Sent: Tuesday, September 05, 2000 11:38 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] data entry
For years I am using dBASE to compute payroll of employees. Required
data entry is number of days present and overtime if any. This is done
record by record. Data entry person sees employee number and name, and
boxes with prompt, where the data is entered. For Postgresql is there
any user interface available, that could help a non technical person to
make the data entry?
vijay
I've got several applications where I use a PostgreSQL database running on a
Linux server with a MS Access front end application running on the
individual PCs. It was pretty painless to build, although knowing something
about Access would have been nice, and it provides a nice user interface for
the individuals that enter the data. Then I have Perl CGI scripts written
on the server to provide read only reports to the web site.
Pat
Patrick C. Wolf
Test Manager
Aerojet
Socorro Plant
-----Original Message-----
From: deval [mailto:deval@giaspn01.vsnl.net.in]
Sent: Tuesday, September 05, 2000 10:38 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] data entry
For years I am using dBASE to compute payroll of employees.
Required
data entry is number of days present and overtime if any.
This is done
record by record. Data entry person sees employee number and
name, and
boxes with prompt, where the data is entered. For Postgresql
is there
any user interface available, that could help a non
technical person to
make the data entry?
vijay
Poul,
There are really 3 pieces to it as I see it:
1) get PostgreSQL running on your server with the -i option to support
internet sockets (see man postmaster). Configure pg_hba.conf to allow
connections from whatever host or hosts you want to run MS Access on (see
the pg_hba.conf file for info and examples).
2) Load the ODBC driver on your Windows box (see
ftp://ftp.postgresql.org/pub/odbc/ for tips and the driver. This driver was
being maintained by Insight Distributors, but they seem to have moved
everything to the postgresql site recently).
3) Link the tables in MS Access and write your applications (read about
link tables in MS Access).
Of course, that being said, it took me some time and quite a bit of trial
and error to figure out all the particulars to make my apps work.
Pat
Patrick C. Wolf
Test Manager
Aerojet
Socorro Plant
-----Original Message-----
From: Poul Kristensen [mailto:bcc5226@vip.cybercity.dk]
Sent: Tuesday, September 05, 2000 2:13 PM
To: WOLF, PATRICK
Subject: Re: [NOVICE] data entry
VERY INTERESTING!
How did you get through from MS Access to the PosgreSQL
database on the
Linux server?
TIA
Poul
Poul Kristensen
The Danish National Institute of Social Research
Copenhagen
Denmark
WOLF, PATRICK wrote:
>
> I've got several applications where I use a PostgreSQL
database running on a
> Linux server with a MS Access front end application
running on the
> individual PCs. It was pretty painless to build, although
knowing something
> about Access would have been nice, and it provides a nice
user interface for
> the individuals that enter the data. Then I have Perl CGI
scripts written
> on the server to provide read only reports to the web
site.
>
> Pat
>
>
> Patrick C. Wolf
> Test Manager
> Aerojet
> Socorro Plant
>
>
>
> -----Original Message-----
> From: deval
[mailto:deval@giaspn01.vsnl.net.in]
> Sent: Tuesday, September 05, 2000 10:38 AM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] data entry
>
>
> For years I am using dBASE to compute
payroll of employees.
> Required
> data entry is number of days present and
overtime if any.
> This is done
> record by record. Data entry person sees
employee number and
> name, and
> boxes with prompt, where the data is
entered. For Postgresql
> is there
> any user interface available, that could
help a non
> technical person to
> make the data entry?
>
> vijay
>
>
>
On 05 Sep 2000 12:38 deval wrote: > >For years I am using dBASE to compute payroll of employees. Required >data entry is number of days present and overtime if any. This is done >record by record. Data entry person sees employee number and name, and >boxes with prompt, where the data is entered. For Postgresql is there >any user interface available, that could help a non technical person to >make the data entry? I use HTML/CGI for almost everything, but I once whipped up a quick and dirty interface using a perl script that ran in aterminal in a manner similar to typical dBASE III apps. -- Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Linux. The choice of a GNU Generation. <http://www.linux.org/>
This is what I've been doing with a personal project at home. Since I do a lot of development in Access but wanted to give PostgreSQL a try. The big problem with using Access is paying for the license. How about a good BASIC & PostgreSQL combination to give you something along the lines of Ardent's UniVerse? Anyone? -----Original Message----- From: pgsql-novice-owner@hub.org [mailto:pgsql-novice-owner@hub.org]On Behalf Of WOLF, PATRICK Sent: Tuesday, September 05, 2000 2:03 PM To: 'deval'; pgsql-novice@postgresql.org Subject: RE: [NOVICE] data entry I've got several applications where I use a PostgreSQL database running on a Linux server with a MS Access front end application running on the individual PCs. It was pretty painless to build, although knowing something about Access would have been nice, and it provides a nice user interface for the individuals that enter the data. Then I have Perl CGI scripts written on the server to provide read only reports to the web site. Pat Patrick C. Wolf Test Manager Aerojet Socorro Plant
Anyone know of an interface for some form of Basic? -----Original Message----- From: pgsql-novice-owner@hub.org [mailto:pgsql-novice-owner@hub.org]On Behalf Of Windy Elliott Sent: Tuesday, September 05, 2000 12:38 PM To: 'deval'; pgsql-novice@postgresql.org Subject: RE: [NOVICE] data entry A web interface can be programmed very easily. That is the only way I have ever placed anything into a Postgresql database.
Is the problem with license that the developer doesn't want to pay the
license? If I remember correctly you can "compile" the MS Access
application into an MDE file and then distribute that file with the free,
run-time only MS Access. Is that right? I've not tried it because all of
my applications run on systems here at work and we have a site license to MS
Office Pro 97 which includes Access.
Pat
Patrick C. Wolf
Test Manager
Aerojet
Socorro Plant
-----Original Message-----
From: Kevin Berrien [mailto:kberrien@javanet.com]
Sent: Tuesday, September 12, 2000 10:15 PM
To: pgsql-novice@postgresql.org
Subject: RE: [NOVICE] data entry
This is what I've been doing with a personal project at
home. Since I do a
lot of development in Access but wanted to give PostgreSQL a
try. The big
problem with using Access is paying for the license.
How about a good BASIC & PostgreSQL combination to give you
something along
the lines of Ardent's UniVerse? Anyone?
-----Original Message-----
From: pgsql-novice-owner@hub.org
[mailto:pgsql-novice-owner@hub.org]On
Behalf Of WOLF, PATRICK
Sent: Tuesday, September 05, 2000 2:03 PM
To: 'deval'; pgsql-novice@postgresql.org
Subject: RE: [NOVICE] data entry
I've got several applications where I use a PostgreSQL
database running on a
Linux server with a MS Access front end application running
on the
individual PCs. It was pretty painless to build, although
knowing something
about Access would have been nice, and it provides a nice
user interface for
the individuals that enter the data. Then I have Perl CGI
scripts written
on the server to provide read only reports to the web site.
Pat
Patrick C. Wolf
Test Manager
Aerojet
Socorro Plant
I don't think the "run-time only MS Access" thing is right. I'm pretty sure you still need Access to run an MDE file. Converting to an MDE file just prevents users from modifying the database. What is Ardent's UniVerse, anyway? David Boerwinkle -----Original Message----- From: WOLF, PATRICK <patrick.wolf@Aerojet.com> To: 'Kevin Berrien' <kberrien@javanet.com> Cc: 'pgsql-novice@postgresql.org' <pgsql-novice@postgresql.org> Date: Wednesday, September 13, 2000 3:33 PM Subject: RE: [NOVICE] data entry >Is the problem with license that the developer doesn't want to pay the >license? If I remember correctly you can "compile" the MS Access >application into an MDE file and then distribute that file with the free, >run-time only MS Access. Is that right? I've not tried it because all of >my applications run on systems here at work and we have a site license to MS >Office Pro 97 which includes Access. > >Pat > >Patrick C. Wolf >Test Manager >Aerojet >Socorro Plant > > > > -----Original Message----- > From: Kevin Berrien [mailto:kberrien@javanet.com] > Sent: Tuesday, September 12, 2000 10:15 PM > To: pgsql-novice@postgresql.org > Subject: RE: [NOVICE] data entry > > This is what I've been doing with a personal project at >home. Since I do a > lot of development in Access but wanted to give PostgreSQL a >try. The big > problem with using Access is paying for the license. > > How about a good BASIC & PostgreSQL combination to give you >something along > the lines of Ardent's UniVerse? Anyone? > > -----Original Message----- > From: pgsql-novice-owner@hub.org >[mailto:pgsql-novice-owner@hub.org]On > Behalf Of WOLF, PATRICK > Sent: Tuesday, September 05, 2000 2:03 PM > To: 'deval'; pgsql-novice@postgresql.org > Subject: RE: [NOVICE] data entry > > > I've got several applications where I use a PostgreSQL >database running on a > Linux server with a MS Access front end application running >on the > individual PCs. It was pretty painless to build, although >knowing something > about Access would have been nice, and it provides a nice >user interface for > the individuals that enter the data. Then I have Perl CGI >scripts written > on the server to provide read only reports to the web site. > > Pat > > > Patrick C. Wolf > Test Manager > Aerojet > Socorro Plant >
M$ sells "Development Kit", which includes run-time libraries to run
Access database as stand-alone. It compiles run-time libraries and
database to installable package and you can distribute it royalty free.
Allthou, the making of the setup program is slow and it is even slower to
install. Nastiest point to Patrick is that M$ doesn't sell "Developer
Kit" to Office 97, only to Access 2k / office 2k.
> I don't think the "run-time only MS Access" thing is right. I'm pretty sure
> you still need Access to run an MDE file. Converting to an MDE file just
> prevents users from modifying the database.
>
> What is Ardent's UniVerse, anyway?
>
> David Boerwinkle
> -----Original Message-----
> From: WOLF, PATRICK <patrick.wolf@Aerojet.com>
> To: 'Kevin Berrien' <kberrien@javanet.com>
> Cc: 'pgsql-novice@postgresql.org' <pgsql-novice@postgresql.org>
> Date: Wednesday, September 13, 2000 3:33 PM
> Subject: RE: [NOVICE] data entry
>
>
> >Is the problem with license that the developer doesn't want to pay the
> >license? If I remember correctly you can "compile" the MS Access
> >application into an MDE file and then distribute that file with the free,
> >run-time only MS Access. Is that right? I've not tried it because all of
> >my applications run on systems here at work and we have a site license to
> MS
> >Office Pro 97 which includes Access.
> >
> >Pat
> >
> >Patrick C. Wolf
> >Test Manager
> >Aerojet
> >Socorro Plant
> >
> >
> >
> > -----Original Message-----
> > From: Kevin Berrien [mailto:kberrien@javanet.com]
> > Sent: Tuesday, September 12, 2000 10:15 PM
> > To: pgsql-novice@postgresql.org
> > Subject: RE: [NOVICE] data entry
> >
> > This is what I've been doing with a personal project at
> >home. Since I do a
> > lot of development in Access but wanted to give PostgreSQL a
> >try. The big
> > problem with using Access is paying for the license.
> >
> > How about a good BASIC & PostgreSQL combination to give you
> >something along
> > the lines of Ardent's UniVerse? Anyone?
> >
> > -----Original Message-----
> > From: pgsql-novice-owner@hub.org
> >[mailto:pgsql-novice-owner@hub.org]On
> > Behalf Of WOLF, PATRICK
> > Sent: Tuesday, September 05, 2000 2:03 PM
> > To: 'deval'; pgsql-novice@postgresql.org
> > Subject: RE: [NOVICE] data entry
> >
> >
> > I've got several applications where I use a PostgreSQL
> >database running on a
> > Linux server with a MS Access front end application running
> >on the
> > individual PCs. It was pretty painless to build, although
> >knowing something
> > about Access would have been nice, and it provides a nice
> >user interface for
> > the individuals that enter the data. Then I have Perl CGI
> >scripts written
> > on the server to provide read only reports to the web site.
> >
> > Pat
> >
> >
> > Patrick C. Wolf
> > Test Manager
> > Aerojet
> > Socorro Plant
> >
>
>
- Keep it simple and stupid -