[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Display box view like Divivions
CAUTION: This e-mail originated outside the University of Southampton.
Hi David,
There is an error like below :
Possible attempt to put comments in qw() list at (eval 162) line 36.
Starting EPrints Repository.
Connecting to DB ... done.
DBD::mysql::db do failed: Duplicate column name 'course' at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3052.
SQL ERROR (do): ALTER TABLE `eprint` ADD `course` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin
SQL ERROR (do): Duplicate column name 'course' (#1060)
Failed adding course to dataset eprint
if an error like that appears, do I have to create a new field? if for example I want to create a new field and the 'course' field is deleted, what should I do?
On Tue, Mar 21, 2023 at 4:03?PM David R Newman <drn at ecs.soton.ac.uk<mailto:drn at ecs.soton.ac.uk>> wrote:
Hi Agung PW,
You need to make sure you add this configuration before the end of the eprint_fields.pl<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Feprint_fields.pl%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=A0Xv2hJeZy4s39FSy0PmpHX5A7DIxGNmTmYVgrzR7XI%3D&reserved=0> file. In particular before the last line which should just be:
];
If not it will not pick this up as a new field. Also, I would expect there to be a syntax error, if you put this right at the end of the file. If you have a lot of eprint records, this will take a long time to run. However, I would expect some output at the end even if no fields are added. This is what I saw when I ran epadmin of a test repository I knew needed no new fields needed adding:
0 datasets added
0 fields added
0 counters were added
If it had added a new field (assuming it is called 'course') I would have expected to see something like:
Added course to dataset eprint
0 datasets added
1 fields added
0 counters were added
Regards
David Newman
On 21/03/2023 8:55 am, Agung Prasetyo W. wrote:
CAUTION: This e-mail originated outside the University of Southampton.
Hi David,
I have tried to enter the field into eprints_field.pl<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Feprints_field.pl%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HXavtW7MzluNL%2F%2BX%2FveC%2FAdf6JX%2F0iNsp12Opgd5ttY%3D&reserved=0>, but when I run the epadmin update ArchiveID command, the process takes a very long time and no notification has appeared.
Regards,
Agung PW
On Tue, Mar 21, 2023 at 3:14?PM David R Newman via Eprints-tech <eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk>> wrote:
Hi,
Subjects and Divisions boxes are subject type fields that include a part of the subject tree. Therefore you would need to add a new sub-tree to your subject tree to include all your course options. (You can use the Edit Subject page [1] linked from the Admin page to do this). Then you would need to add some configuration like the following to your archive's cfg/cfg.d/eprint_fields.pl<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Feprint_fields.pl%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=A0Xv2hJeZy4s39FSy0PmpHX5A7DIxGNmTmYVgrzR7XI%3D&reserved=0> file:
{
name => 'course',
type => 'subject',
top => 'courses',
browse_link => 'courses',
},
I have made some assumptions here:
1. That your would only ever need to store one course value against and eprint record. If you need more you may need to add the line:
multiple => 1,
to the above configuration.
2. That the subject ID for the top of your courses sub-tree is 'courses'.
3. That you intend to create a browse view for courses like by default you will have for subjects and divisions.
Once you have added this configuration you will need to run the following command (substituting EPRINTS_PATH and ARCHIVE_ID) as appropriate:
EPRINTS_PATH/bin/epadmin update ARCHIVE_ID
Next you will need to add this field to your workflow. This will need a line like the following at the point you want this to appear in your workflow:
<component><field ref="course" /></component>
You may at this point also want to add some phrases. You can does this via the Phrase Editor page link from the Admin page or edit a phrases file from the command line. The minimum phrases you will need are eprint_fieldname_course and eprint_fieldhelp_course.
Once you have done all the is you will need to test the configuration is valid an reload the web server:
EPRINTS_PATH/bin/epadmin test
apachectl graceful
I have been working on improving the documentation pages about different types of metadata field as listed at https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FCategory%3AEPrints_Metadata_Fields&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=lQ0JcsFgxwO5JsyY801j6yT5CIskUHVAIJUpynPtJvU%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FCategory%3AEPrints_Metadata_Fields&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=lQ0JcsFgxwO5JsyY801j6yT5CIskUHVAIJUpynPtJvU%3D&reserved=0>. I have not got to updating the subject field [2] yet but hope to do so today or later this week. However, I hope to add some useful configuration examples to help when it comes to questions like yours here.
Regards
David Newman
[1] https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FAdmin%2FConfig._Tools%2FEdit_subject&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=cW51GXkb%2BIKp6w7%2FZQR1WbQYBNQh6rNJRuuCYrC83aE%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FAdmin%2FConfig._Tools%2FEdit_subject&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=cW51GXkb%2BIKp6w7%2FZQR1WbQYBNQh6rNJRuuCYrC83aE%3D&reserved=0>
[2] https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FSubject_field&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uqJeAJsF%2Fky3POrIvdN%2Fvo4g6v52HDIrP4BIJV%2FzD7M%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FSubject_field&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uqJeAJsF%2Fky3POrIvdN%2Fvo4g6v52HDIrP4BIJV%2FzD7M%3D&reserved=0>
On 20/03/2023 7:17 am, Agung Prasetyo W. via Eprints-tech wrote:
CAUTION: This e-mail originated outside the University of Southampton.
Hi,
I just added a field for a course with a lot of data. How can I make the view in the Details section so that it displays the course data like the divisions view or like Subject ?
[image.png]
Thank you.
Regards,
Agung Prasetyo WIbowo
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Lveup5yJe%2Bk0PU3Qx%2B1ktI0VCxvb3egR9pJDVf7n4pA%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Lveup5yJe%2Bk0PU3Qx%2B1ktI0VCxvb3egR9pJDVf7n4pA%3D&reserved=0>
*** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XVEsBYvTbjnb%2FJ%2BNHsAJzTL6vdhMuH606St0b3Ko%2Bgw%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XVEsBYvTbjnb%2FJ%2BNHsAJzTL6vdhMuH606St0b3Ko%2Bgw%3D&reserved=0>
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Lveup5yJe%2Bk0PU3Qx%2B1ktI0VCxvb3egR9pJDVf7n4pA%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Lveup5yJe%2Bk0PU3Qx%2B1ktI0VCxvb3egR9pJDVf7n4pA%3D&reserved=0>
*** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XVEsBYvTbjnb%2FJ%2BNHsAJzTL6vdhMuH606St0b3Ko%2Bgw%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C549cc8eb3c554412899d08db29eda42d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638149872858294158%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XVEsBYvTbjnb%2FJ%2BNHsAJzTL6vdhMuH606St0b3Ko%2Bgw%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230321/e5008027/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 40191 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230321/e5008027/attachment-0001.png