gnats help

gnats help

[Iqbal Saima]

Hi all,

I've been having some trouble with gnats.  Using the advanced query option,
I enter a date in the "Required Before" field.  I also select the "Date
Required" column to be displayed.  However, the result shows the date 'Dec
31, 1969' for all PRs in the "Date Required" column.  And the Required
Before query doesn't seem to be working because I'm getting all the PRs
listed before and after the date I specified.  Help please.

Thanks,
Saima


_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

Re: gnats help

[Hans-Albert Schneider]

-----BEGIN PGP SIGNED MESSAGE-----

On Friday 27 June 2003 21:21, Iqbal Saima wrote:
> Hi all,
>
> I've been having some trouble with gnats.  Using the advanced query
> option, I enter a date in the "Required Before" field.  I also
> select the "Date Required" column to be displayed.  However, the
> result shows the date 'Dec 31, 1969' for all PRs in the "Date
> Required" column.

I guess that none of your reports has a "Date Required:" field set.
In this case, the UNIX "epoch" seems to be displayed (that is,
Jan 01, 1970, 00:00:00 GMT = Dec 31, 1969, 20:00:00 in your current 
timezone).

Try this:
1) Edit/view one of the reports and check what is in that field.
2) Create a test report with that field set (let's assume, to July 01, 
2003--you may need to write it as "2003-07-01"), and place it into a 
category that has only a few reports in it ("pending" may be a good 
choice). Search this category with some variations of "Required 
Before" (and/or "Required After") that either include or exclude that 
report (e.g., "Required Before: 2003-06-01", "Required Before: 
2003-08-01"--the former should exclude the test report, the latter 
should include it).

> And the Required Before query doesn't seem to be
> working because I'm getting all the PRs listed before and after the
> date I specified.  Help please.

Once more, this sounds like none of your reports specifies a "Date 
Required" field.  To make absolutely sure, cd to the directory of 
your database, and run this command:
	fgrep Required: */*

Note that the "Date Required" field is not a required field; I think 
that in 3.1xx, it was only present when some compile-time option was 
selected.

If you need more info, please also tell us which version of GNATS and 
Gnatsweb you are using, as a lot has changed with the 4.0pre versions 
(not much in the format of the reports, though).


Hans-Albert

- -- 
Hans-Albert Schneider
Munich, Germany
EMail: Hans-Albert@HA-Schneider.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)

iQEVAwUBPv8f9L5/YryrhGWVAQGlZQf/Sh/p7FhlLdcqBV6RVnfQ/YZ7HQdxZQh1
mMv17DHjKkMO+pPC479SvsiV8GF5FotdnyPxKoiMNHZ3C8l3AVa4ozVp0sjDRfu5
HHS0c92O9eoQhcR8uo8IxHuzs74+lGHg26IG/0c1eNgYcA1z1S+Ha/VrKXiNU6u1
dbg8jW9jFYxUiQirGSsKx6LWxGe7AmPHfn+9m9nfQzT7Ah01p8f2kFj6PUDwUlmP
qGhkLd/KpzQFjfUvbCiquFws5XeR8lv6YkucHyfD5i3M0FiiqX+C8Hh+fEHRGbwY
6Pv01OCC5Q6gNWLIoLqy/wQxcidtLRHaovdUWNXxdmbItPuAuKjCgQ==
=V5RA
-----END PGP SIGNATURE-----


_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

RE: gnats help

[Iqbal Saima]

Hello,

I'm having some trouble adding fields to GNATS.  I'm using GNATS4.  The
field I want to add is enumerated.  I tried adding it to the dbconfig fild
in the gnatsdb directory, but there wasn't a change on gnatsweb that took
affect.  Should I be making the change somewhere else also? 

Also, I modified the 'release' field from being 'text' to
'enumerated-in-file', but for some reason the enumerations don't show up
corresponding to the file.

Any help would be appreciated.  Thanks in advance.

Saima Iqbal

-----Original Message-----
From: Hans-Albert Schneider [mailto:Hans-Albert@ha-schneider.de]
Sent: Tuesday, August 12, 2003 7:03 AM
To: Iqbal Saima
Cc: help-gnats@gnu.org
Subject: Re: gnats help


-----BEGIN PGP SIGNED MESSAGE-----

On Monday 11 August 2003 18:20, you wrote:
> Hello,
>
> I was wondering if I could get some feedback on setting up gnatsweb
> with an SQL database?  Is that something doable?  Any ideas on how
> to connect the two (ODBC, JDBC,  or gnats daemon)?  Would it be
> compatible?

I am not sure what exactly you want to do. GNATS currently supports 
only one "database backend", namely its own format (every report is a 
file of its own, with e-mail headers and the GNATS fields).
So, if gnatsweb shall be able to edit existing reports or to submit 
new ones, it must communicate with gnats the way it currently does.

The SQL stuff in the contrib directory was what somebody used for 
complex reporting, connecting to customer database, etc. The data are 
extracted from gnats and stuffed into the database on a regular 
basis. (See contrib/sql/README.) So this is only a *copy* of the 
gnats database, not the working database.


> I was having trouble adding fields, and tables, to the gnats
> database with v3.xx.  Is adding a field to the gnats database
> easier in Version 4?  If not, any tips on how to handle that?

It is much easier in GNATS 4; all the fields are defined in file 
gnats-adm/gnatsdb (individually for each database). You just add a 
description for each of you additional fields. There are some 
examples in the documentation.

> Thanks in advance for all your help.

You are welcome.

BTW, I have Cc-ed my reply to the mailing list help-gnats@gnu.org
It is generally a good idea to ask the list instead of individuals; 
you usually get faster response. E.g., I have been very busy until 
the end of last week, and I am about to leave for vacation (with rare 
or no e-mail access), so your mail was lucky to hit just the few days 
in between.

All the best,

Hans-Albert
- -- 
Hans-Albert Schneider
Munich, Germany
EMail: Hans-Albert@HA-Schneider.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)

iQEVAwUBPzjJkb5/YryrhGWVAQGR6Af+MB08cCg0ouiCgDc5JgAYyLepxN078mdP
bugJDR6YTQJHe+6pS4sB+s5wxQhJy0sSrmd1a0usMq8GkLrTFBE5Y3475LK6hAL/
Uc6+tTKeSNlz4SdaA33LU33wMP/e8vKIj7SMij+l9R/CXeSj6cmnZvJPnRRiiRVQ
T/8+bHiD/yuYQpdUhTTf2OsUTIBTSJjPIYLac2V3bCpBfPWxAwfafJvpA5JmabKh
95BKf+zm7Ldl4d2nuMU1z7HJP3BnVQRa8Q9uShfyhqci2gR0y2lWwcpktRdzzOfn
IjjnRWPjX+XDffSjcBkma+FaYTAu3X3ly/5vM+sEEeyLX9fsNIMWYA==
=fPae
-----END PGP SIGNATURE-----


_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

Re: gnats help

[Hans-Albert Schneider]

-----BEGIN PGP SIGNED MESSAGE-----

On Monday 11 August 2003 18:20, you wrote:
> Hello,
>
> I was wondering if I could get some feedback on setting up gnatsweb
> with an SQL database?  Is that something doable?  Any ideas on how
> to connect the two (ODBC, JDBC,  or gnats daemon)?  Would it be
> compatible?

I am not sure what exactly you want to do. GNATS currently supports 
only one "database backend", namely its own format (every report is a 
file of its own, with e-mail headers and the GNATS fields).
So, if gnatsweb shall be able to edit existing reports or to submit 
new ones, it must communicate with gnats the way it currently does.

The SQL stuff in the contrib directory was what somebody used for 
complex reporting, connecting to customer database, etc. The data are 
extracted from gnats and stuffed into the database on a regular 
basis. (See contrib/sql/README.) So this is only a *copy* of the 
gnats database, not the working database.


> I was having trouble adding fields, and tables, to the gnats
> database with v3.xx.  Is adding a field to the gnats database
> easier in Version 4?  If not, any tips on how to handle that?

It is much easier in GNATS 4; all the fields are defined in file 
gnats-adm/gnatsdb (individually for each database). You just add a 
description for each of you additional fields. There are some 
examples in the documentation.

> Thanks in advance for all your help.

You are welcome.

BTW, I have Cc-ed my reply to the mailing list help-gnats@gnu.org
It is generally a good idea to ask the list instead of individuals; 
you usually get faster response. E.g., I have been very busy until 
the end of last week, and I am about to leave for vacation (with rare 
or no e-mail access), so your mail was lucky to hit just the few days 
in between.

All the best,

Hans-Albert
- -- 
Hans-Albert Schneider
Munich, Germany
EMail: Hans-Albert@HA-Schneider.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)

iQEVAwUBPzjJkb5/YryrhGWVAQGR6Af+MB08cCg0ouiCgDc5JgAYyLepxN078mdP
bugJDR6YTQJHe+6pS4sB+s5wxQhJy0sSrmd1a0usMq8GkLrTFBE5Y3475LK6hAL/
Uc6+tTKeSNlz4SdaA33LU33wMP/e8vKIj7SMij+l9R/CXeSj6cmnZvJPnRRiiRVQ
T/8+bHiD/yuYQpdUhTTf2OsUTIBTSJjPIYLac2V3bCpBfPWxAwfafJvpA5JmabKh
95BKf+zm7Ldl4d2nuMU1z7HJP3BnVQRa8Q9uShfyhqci2gR0y2lWwcpktRdzzOfn
IjjnRWPjX+XDffSjcBkma+FaYTAu3X3ly/5vM+sEEeyLX9fsNIMWYA==
=fPae
-----END PGP SIGNATURE-----


_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats