[dspace-tech] Re: SQL query to Insert value to a field based from another field if it doesn't exisst
Hello euler, I haven't gone through your problem in detail, but UPSERT might offer some assistance? Something like below: INSERT INTO table_name(list of columns) VALUES(list of values) ON CONFLICT (column_name) DO NOTHING; Again, this is not tested, and I could be wrong. Hope it helps. E. On Sunday, January 23, 2022 at 4:28:41 AM UTC+2 euler wrote: > After doing some Googling around, I managed to insert the value ' > Hypophthalmichthys nobilis' into a new field with metadata_field_id=155. > Below is my SQL: > > insert into metadatavalue > (metadata_field_id,authority,text_value,dspace_object_id,confidence) > select 155,163692,text_value,dspace_object_id,600 > from metadatavalue where metadata_field_id=57 and > text_value='Hypophthalmichthys nobilis'; > > However, I wonder what statement should I add to check if the value > already exists because running the SQL statement above will create a > duplicate value. > > Thanks in advance! > euler > > On Saturday, January 22, 2022 at 2:40:14 PM UTC+8 euler wrote: > >> Dear SQL experts, >> >> I am planning to insert value to a field if and only if it doesn't exist. >> For example, there are items that have the entry 'Hypophthalmichthys >> nobilis' in the dc.subject field. I would like to duplicate this entry to >> another new field dc.subject.scientificName. >> >> I have issued this SQL query to list the items in the dc.subject >> containing 'Hypophthalmichthys nobilis": >> >> select distinct dspace_object_id, metadata_field_id, text_value, >> authority, confidence from metadatavalue where metadata_field_id=57 and >> text_value='Hypophthalmichthys nobilis' >> >> [image: Capture.PNG] >> >> I wonder what would be the SQL query to insert 'Hypophthalmichthys >> nobilis' found in dc.subject with metadata_field_id=57 to another field >> dc.subject.scientificName with metadata_field_id=155 if it doesn't exist >> yet? >> >> My example above is only 4 items but I have hundreds of items to that I >> need to update also. Previously, my method is to export the metadata >> containing the field I want to insert, batch edit the CSV, import it, and >> then do the SQL update, which is quite tedious especially during the batch >> edit because dc.subject contains other terms separated by double pipes >> (||). I thought there must be an easier way to do this via SQL. >> >> DSpace version is 6.3 by the way. >> >> Thanks in advance and best regards, >> euler >> > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/381a5e5f-76e7-4a8a-9e7a-d00340f90040n%40googlegroups.com.
[dspace-tech] Re: Dspace 7 documentation
Hello, I'm having the same problem, I've run basic docker image version 7.0 following the tutorial on the official page. I'm seeing no login fields on index page of localhost:3000, also there is no page for spring-rest on the backend side - localhost:8080/spring-rest. I'm quite new to dspace as well, could anybody help me? Thank you in advance. On Sunday, 23 January 2022 at 18:30:50 UTC+4 giorgi@gmail.com wrote: > Hello, > I am new in Dspace. I have installed Dspace docker image on manjaro linux > but didn't manage to login. > Is there any documentation or video, from where I can get how to start > working with Dspace? > Thank you in advance. > > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/e5dec858-641f-4f69-a566-628ba9b49b43n%40googlegroups.com.
[dspace-tech] Dspace 7 documentation
Hello, I am new in Dspace. I have installed Dspace docker image on manjaro linux but didn't manage to login. Is there any documentation or video, from where I can get how to start working with Dspace? Thank you in advance. -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/c52ba201-8fab-47eb-be59-5ecca917dfe2n%40googlegroups.com.
Re: [dspace-tech] Re: Issue with review group assignment (DSpace7.1.1)
Hi Mark, thanks for analyzing this. Do you want me to derive an issue on GitHub for this topic? Thanks Robert Mark H. Wood schrieb am Mittwoch, 19. Januar 2022 um 15:04:46 UTC+1: > An incomplete analysis: > > The cause of the failure is that the DSpace Context being used for > curation has no user. The session, so far as curation is concerned, > is anonymous and has no permission to manipulate the object. > > Curator.curationContext() will manufacture a Context for curation if > none exists, but it creates it with no user. Somewhere in > workflow-attached curation we should be fetching that Context and > giving it a user, probably the one which owns the interactive Context. > > -- > Mark H. Wood > Lead Technology Analyst > > University Library > Indiana University - Purdue University Indianapolis > 755 W. Michigan Street > Indianapolis, IN 46202 > 317-274-0749 <(317)%20274-0749> > www.ulib.iupui.edu > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/01dfd748-40ea-4d08-8a1d-adcc63509539n%40googlegroups.com.
[dspace-tech] DSpace7.1.1 - disallowing HTML uploads
Hello again, Recently I've been trying to disable upload of certain file types. However I have not yet found the right spot where to do the same. The background is that I'd like to make sure HTML files cannot be uploaded, since any contained Javascript will fire directly when (pre)viewing the attachment, opening up all kind of risks for the responsible reviewer. Maybe someone can point me in the right direction how this is best to be handled. In the end I may just be missing the correct term to find the right place in the DSpace docs. Thanks in advance Robert -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/1aea85af-aa9d-4f7f-a291-e028e30dab39n%40googlegroups.com.
