Hi Massimiliano, To clarify, as best I can understand, I think the problem may be that **none of your Bitstreams (i.e. files) have a "dc.title" field** (this is the metadata field used to store the file name). This sounds like it's directly related to the earlier issue that I remember you asking about...that somehow all your "dc.title" field values were deleted or lost (and you had no backup to restore them from)
Because the Bitstreams are missing a "dc.title" field, the only way to restore the file names is to add back the "dc.title" field for each of your Bitstreams (files). In DSpace 6, there is **no way** to add a missing dc.title in the User interface because of a severe bug. In DSpace 6, if the "dc.title" was missing, then the file itself would not be visible in the User Interface. As of DSpace 7, this severe bug no longer exists. So, if you upgrade to DSpace 7, then all your files would reappear, but they'd all be named "Untitled". This would allow you to then edit each of the files and add a correct title back for each file. The only other way you could achieve this fix would be to add the "dc.title" fields at the database level. But, that would not be easy, as you'd need to craft a SQL statement which can insert a "dc.title" metadata value for each bitstream in the "bitstream" database table. The "dc.title" field MUST be attached to the "bitstream" and not to the "item". On the "item" the "dc.title" is the name or title of the Item (displayed at the top of the Item page). But, on the "bitstream" the "dc.title" is the name of the *file*. Hopefully this clarifies things. Tim On Friday, February 28, 2025 at 3:40:43 AM UTC-6 mcil...@unisa.it wrote: > Dear Tim, > According to you if I upgrade the system to dspace 7 then renaming the > files they will be visible again? > Thanks > Best regards > Massimiliano > > Il giorno venerdì 28 febbraio 2025 alle 10:28:09 UTC+1 Massimiliano > CILURZO ha scritto: > >> Dear Tim, >> >> The problem is that even if I restore the dc.title and so the name >> of the file then this file will be visibile on dspace? >> I have tried to put manually add dc.title to one of the item but the file >> isn't visible in the item view. >> So how dspace see that there is a file attached and display it in the >> item view? >> Thanks >> Best regards >> Massimiliano >> >> Il giorno giovedì 27 febbraio 2025 alle 21:49:54 UTC+1 DSpace Technical >> Support ha scritto: >> >>> In DSpace 6, all filenames are stored in the "dc.title" field that is >>> associated to the file. This should be findable in the database. The >>> files are stored in the "bitstream" table, and the metadata values are >>> stored in the "metadatavalue" table. In DSpace 6, the only way that I can >>> think of to restore these file names would be to add them at the database >>> level via the link between the "metadatavalue" table to the "dspaceobject" >>> table to the "bitstream" table as shown in the database diagram on this >>> page: https://wiki.lyrasis.org/display/DSDOC6x/Storage+Layer >>> >>> However, that would not be easy to achieve, and I don't have an example >>> query unfortunately (as I don't have a DSpace 6 site around anymore as that >>> version is unsupported). >>> >>> If you upgraded to DSpace 7, you could modify these file names more >>> easily from the User Interface, as any unnamed files would simply appear as >>> "Untitled" in the User Interface. But, that feature did not exist in >>> DSpace 6 unfortunately. >>> >>> Tim >>> >>> -- 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 visit https://groups.google.com/d/msgid/dspace-tech/ef15ff9f-b3a8-43a6-99dc-df9f3f5ecaean%40googlegroups.com.
