« 00017 · Edit Form · 00019 »

Summary: Programm entry in project output mask
Type: Feature

Priority (1<5) = 43
Status: Closed

Raised by: UteWilliges?
Project: CORE Organic
Related to Issues?
Date opened: 2005–07–14
Assigned to HugoAlroe
Hours used (estimates in brackets) = 8
Date closed: 2005–08–16

Description:
In the mask for project entries there is no field for a programm entry but in the final output (grey box) it says Part or full programm. Why is this implemented in the project output?

I implemented that the programme part/full field should be prefilled with “Part”, since this will be the usual entry. But since I, erroneously, did not make it conditional on the eprint type, every new eprint will have this field filled out. And since it is filled, it will also show on the summary page.

Solution

1. make the prefill conditional or remove it.
2. change the fields to NULL in the database and run generate_abstracts for recent eprints. Needs to be done in main archive as well as submission, inbox and deletion.

Implementation

• 15aug2005: The default has been disabled for now. May reimplement it later to add only default for relevant eprint types, when I figure out how to do so … Asked Eprints Tech list.
• 16aug05: removed the Programme type in the database from all eprint types where it was not relevant. Ran generate_abstracts. Reimplement the feature to add default “part programme” for only the eprint type ‘Research Programme’.

SQL code

1. Setting progtype (program type) to NULL for archive, buffer, inbox and deletion:
   1. First do a select to check for archive, buffer, inbox and deletion. Eg:

SELECT *
FROM `archive`
WHERE `progtype LIKE ‘part’ AND `type NOT LIKE ‘researchprogramme’

1. Then update the selection by setting progtype to NULL:

UPDATE `inbox SET progtype=NULL WHERE `progtype LIKE ‘part’ AND `type NOT LIKE ‘researchprogramme’

UPDATE `archive SET progtype=NULL WHERE `progtype LIKE ‘part’ AND `type NOT LIKE ‘researchprogramme’

UPDATE `buffer SET progtype=NULL WHERE `progtype LIKE ‘part’ AND `type NOT LIKE ‘researchprogramme’