Bulk Edit (module for Omeka S)
New versions of this module and support for Omeka S version 3.0 and above are available on GitLab, which seems to respect users and privacy better than the previous repository.
Current processes are:
- Replace value of a property (directly or via regex)
- Remove the literal value of a property
- Prepend or append a string to a value of a property
- Set or remove language of a property
- Order values by language (in particular for the title)
- Displace values from a property to another one
- Set visibility of a property public or private
- Update the media html via item or media
- Update the media type (mime-type) of a media
- Remove all trailing white spaces
- Convert a value to another data type
- Modify language codes
- Remove duplicate values
Furthermore, values are automatically trimmed and deduplicated when a resource is saved.
Uncompress files and rename plugin folder
See general end user documentation for Installing a module and follow the config instructions.
The tool is available via the standard bulk process in Admin > Items, Admin > Item Sets, and Admin > Media. Simply select specific resources or all, then click Go, then select and config the process to do.
To improve search of resources, you can use module Advanced Search Plus, that allows to search by creation date, modification date, or by visibility.
The job is launched directly when specific resources are selected, and in the background when all resources are selected.
Trim property values
Remove leading and trailing whitespaces preventively on any resource creation or update, or curatively via the batch edit, so values will be easier to find and to compare exactly (fix #1258). Note that the curative trimming uses a regex when possible (with mysql ≥ 8.0.4 or mariadb ≥ 10.0.5). There is no difference in most of the cases, except when there are multiple whitespace mixed (space, tabulation, new line, end of line, etc.).
Specify data type of linked resources
In some cases, in particular when using resource templates with data type "resource", linked resources are saved in the database with the generic data type "resource", not with the specific "resourc:item", "resource:media, etc. This process is needed to clarify output of the facets with module Search, lists from the module Reference, and in some other places.
Sometime, an empty language for a value is an empty string. This option makes it null.
Modify language codes
This options allows to replace all "fr" or "fre" by "fra", or any other language code, or into an empty code. It can be limited to specific properties.
Deduplicate property values
Remove exact duplicated values on any new or updated resource preventively. Note: preventive deduplication is case sensitive, but curative deduplication is case insensitive (it uses a direct query and the Omeka database is case insensitive by default).
Replace value of a property directly or via regex
Fill fields "Replace" and "By", specify the type of replacement (simple, html or regex), then select the properties to update.
The mode "html" means that the original string will be checked as raw string and
as html encoded string too. For example, string
café will be checked with
café). Be careful when simple characters are mixed with
entities, it may be difficult to replace all strings. The replacement string is
used unchanged, so it is recommended to use entities for it too.
Remove the literal value of a property
Simply check the box "Remove string", then select the properties to update. The string will be removed, but it can be prepended or appended with another string. In that case, the value is kept, else it is removed.
Prepend or append a string
Fill fields "Prepend" and/or "Append" and select the properties to update.
Set or remove language of a property
Select the properties to set or remove language. Note: all values of the selected properties are updated, so be aware of existing languages when they are multiple.
Order values by language
Sometime, we need that the title and the description to be displayed to be in one language, but the value in this language is not always the first in the metadata. This is important for the title and the description, that are displayed in many places.
So just write the language in the order you want for the properties you want. Values with other languages or without language will be kept after.
Set or unset visibility of a property
Select the properties to set or unset visibility.
Displace values from a property to another one
Select the source properties and the destination property, then process edit. Some filters (datatype, language, string, visibility) allows to move only selected values.
Explode a value into multiple values
This tool is useful for an import of a csv file, where the checkbox for "multivalue" was missed. Select the properties and the separator, that may have multiple character.
Merge two values as uri
Select the properties and their values will be merged two by two. This tool can only be used when the number of values is even. When a value has already the datatype "uri" with a label, it is not changed and all values of the property are skipped to avoid merge issues. When two uris follow each other, the property is skipped too. At least one value should be an url. When the label and the values are different urls, the property is skipped. It’s recommended to check order of values first.
Select the source datatype and the new datatype. Only some datatype are managed currently .
Update media html from item or media
Select the items or medias and update media html, then update it like an item value.
Update media types (mime-types)
Select the items or medias and set the existing and the new media type. They
should be standard ones, like
Use it at your own risk.
It’s always recommended to backup your files and your databases and to check your archives regularly so you can roll back if needed.
See online issues on the module issues page.
This software is governed by the CeCILL license under French law and abiding by the rules of distribution of free software. You can use, modify and/ or redistribute the software under the terms of the CeCILL license as circulated by CEA, CNRS and INRIA at the following URL "http://www.cecill.info".
As a counterpart to the access to the source code and rights to copy, modify and redistribute granted by the license, users are provided only with a limited warranty and the software’s author, the holder of the economic rights, and the successive licensors have only limited liability.
In this respect, the user’s attention is drawn to the risks associated with loading, using, modifying and/or developing or reproducing the software by the user in light of its specific status of free software, that may mean that it is complicated to manipulate, and that also therefore means that it is reserved for developers and experienced professionals having in-depth computer knowledge. Users are therefore encouraged to load and test the software’s suitability as regards their requirements in conditions enabling the security of their systems and/or data to be ensured and, more generally, to use and operate it in the same conditions as regards security.
The fact that you are presently reading this means that you have had knowledge of the CeCILL license and that you accept its terms.
- Copyright Daniel Berthereau, 2018-2021 (see Daniel-KM)