Imports all formats, including ONIX 2.1, MARC 21 und Excel/CSV
Accelerated import of data improves efficiency
Automatic data correction and error reports
Integration into any existing database system
NEWBOOKS Solutions is a permanent member of the Germany, Austria, Switzerland ONIX working group
Every day hundreds of thousands of new and forthcoming titles are exchanged using ONIX. As part of this process, it’s becoming increasingly important for players in the industry to accomplish two key goals: good quality data and the shortest possible processing time. Our ONIX 3.0 import system makes this possible – or in other words, it ensures that shorter processing times don’t negatively impact on quality.
As a permanent member of the Germany, Austria, Switzerland ONIX working group we’re operating right at the heart of the new standard. As a consequence, our system can import all of the fields in the current ONIX 3.0 standard, including DRM relevant information and ISTC classification. We use all of the new features to maximum effect - especially block updates, in which updates and amendments are converted into partial amendments to data records, thus reducing the amount of data that needs to be exchanged and further accelerating the import process. Data from the older ONIX 2.1 standard can also be imported if required.
Imports are runs as bulk operations with parallel processing. This allows for the system to scale according to actual demand and use mechanisms for load sharing. The system’s high speed also comes from using standardized technology. .NET Framework and SQL Server Integration Services (SSIS) are being constantly improved by developer Microsoft, ensuring that the system remains reliable and up to date with respect to future upgrades.
The fact that both data quality and speed are provided in equal measure is due to the automated improvement of data quality – a further key feature of our system. Clusters of characters, line breaks or incorrect codification of special characters and umlauts are all examples of typical formatting errors. The import system corrects these by automatically adjusting long texts and by normalizing characters. The improvement in data quality pays for itself because the quality of both display and readability are also immediately enhanced. The system also blocks the import of incorrect information by specifically ignoring correspondingly defined data fields.
Many publishers use internal conventions for data management which diverge from the ONIX standard. In order to prevent this leading to the transmission of incorrect data, the ONIX system corrects such exceptions using publisher filters, which can be easily adapted and updated using an intuitive graphic user interface. An additional benefit is that these changes can also be automatically applied to previously imported data records!
Broadly speaking our ONIX import system can be easily integrated into an existing database. During the process, the active database structure remains and only the previous import process is replaced by the ONIX import system.
Any number of data transformations during the export process
Data export according to best practice guidelines
Seamless integration into any existing IT landscape/database system
NEWBOOKS Solutions is a permanent member of the Germany, Austria, Switzerland ONIX working group.
Regardless of whether it’s a new title announcement, an update or a deletion, when partners in the book business exchange title information ONIX has become the definitive standard.
In the new ONIX 3.0 format, data relating to DRM, bundles, and supplementary marketing material can be easily integrated into the process. There’s one requirement, however: such data has to be transformed in compliance with the standard. That’s where our ONIX 3.0 export system comes in. It ensures that your data always fulfills the requirements.
As with all our solutions, it’s important that our ONIX export system precisely fits your requirements. The system can be quickly and easily implemented and is undoubtedly suited to publishers who are already using a database system. It’s also possible for us to install a dedicated ONIX 3.0 interface which will, for example, facilitate trouble-free data exchange with existing publisher software.
Our ONIX 3.0 export system converts existing data records to conform to the standard, and then validates and exports them. As part of the process, it uses the block updates newly introduced in ONIX 3.0, in which data fields relevant for new title announcements and updates are isolated by the system so that the size of the data record to be transmitted is considerably reduced. Individual adjustments to the export process are also possible, meaning that users can transform data according to their needs, e.g. if they wish to alter the convention for entering a date.
It’s precise because it’s innovative that our ONIX 3.0 export system has been built using tried and tested technological standards. During programming, we used T-SQL upgrades and consistently applied XML processing functions in Microsoft-SQL-Servers. As a result, the export process doesn‘t operate via a third party program but takes place within the database itself, thus increasing processing speed and saving time – time that can be more effectively invested in manual tasks than in data exports.
MARC21, MARCXML, MAB
Integrable via web service or upload of ISBN list
Additional proprietary formats on request
NEWBOOKS Solutions offers a converter that is capable to convert ONIX data to MARC21 and MARCXML. The converter is developed as a ‘standalone' program (.exe) which converts ONIX metadata from an input directory to the desired format upon execution and then stores them in an output directory. The system is equipped with a logging which holds infeasible conversions at field level. Thus, tags and composites can be identified, which can be recorded in the conversion later.
Based on an ISBN list, our Format Converter for library formats transfers publishers' title data automatically into your library’s desired format. Data supply is done either by eMail or via FTP. We also offer a web service that can further provide data for other services. Thus title queries are possible within an automated acquisition system or through invoice processing. Alternatively, the Converter can transmit the data to an FTP server. However, if no dedicated FTP server is available, the title data can also be saved on and provided from NEWBOOKS FTP on a long-term basis. MARC records can also be transferred to publishers or booksellers website for download by librarians.