Adlib Tools

Updated on 28 Dec 2018

Adlib Super Tools

An application that is used by different business units of the State Library NSW, and has allowed people to perform tasks that otherwise would not have been possible without the use of Adlib Super Tools. See the testimonials.

Convert XLSX to XML

This allows Excel Spreadsheets to be converted into Adlib specific XML that can then be used to load into Adlib to either update existing records or create new ones.

Viewing the conversion

As with most of my applications, I provide the ability for the user to either view or download the converted file. If you choose to view the existing XLSX file, a new column has been added to let you know of the status of converting that row to XML.

Viewing the errors

If there were errors in the conversion process, then when you either click to view the existing XLSX or click the new link that is on the UI for that file called errors.

  • Viewing the XLSX file will highlight the rows that have errors on them, and the status column will indicate what the issue is.
  • If you click errors, then the XLSX view is filtered to only show the error rows. The good news is that the row_id on this view actually corresponds to the actual row_id on the XLSX spreadsheet!

Convert XML to XLSX

This module allows XML exports from Adlib to be converted into XLSX. The conversion process has been designed so that the user shouldn’t have to do anything with the output because it comes out exactly how they want.

  • The specific fields they want
  • The order of the fields
  • Grouping of the fields (i.e. where 2 or more tags are related, group them together)

Viewing the conversion

I can either download or view the conversion, and notice that the last section of fields (Dimension Free & Dimension Free Phys Characteristics) have been grouped together.

Although the XML file may have many more fields, only those fields that you’ve requested actually get put into the Excel Spreadsheet, and in the specified order you want them.