The TitlePage file naming convention ensures your files are loaded successfully. By using the correct file extension, the TitlePage loader knows when a file is ready to be ingested. TitlePage uses EDItEUR's standard for FTP file naming.
Who this is for
This information is for:
- Technical staff maintaining scheduled feeds to TitlePage.
- Publishing staff who manually upload ONIX feeds to the TitlePage SFTP.
File extension format
A three-character file extension (for example filename.123) controls how the file is processed by TitlePage. Each character in the extension has a specific meaning.
Character 1 – file status
The first character signifies the status of the file. While a file is being transferred it should use the extension .XOT, where X indicates the transfer is still in progress.
Once the upload is complete, the status character must be changed to either C or Z so the loader knows the file is ready to be processed:
- C is used for unzipped files.
- Z is used for zipped files.
Character 2 – file format
The second character defines the format and may be one of two values:
- O representing an ONIX file.
- D representing a title deletion. This is a unique TitlePage variation indicating that the products contained within the file are to be deleted from the TitlePage catalogue.
Character 3 – transaction type
The third character defines the transaction type and must be T, which indicates a Title Status or Product Catalogue ONIX file.
The loader will only process the file after it has been named to one of these final extensions:
- For unzipped files: .COT or .CDT
- For zipped files: .ZOT or .ZDT
Files contained within zipped uploads
When uploading a zipped ONIX file using the .ZOT or .ZDT extension, the ONIX file contained inside the archive must also use a valid TitlePage ONIX extension. The unzipped file must be named with one of the following extensions:
- .COT
- .CDT
Files inside the archive that use .xml, .onix, .txt, or any other extension will not be processed and will generate a load error. The ONIX file must also be located at the root of the archive and not inside a folder.
File naming conventions
The file naming conventions for TitlePage publisher SFTP uploads are based on the EDItEUR FTP Filenaming Standard, as defined jointly with the Book Industry Study Group (US) and Book Industry Communication (UK). The standard requires the use of a unique filename followed by a three-character extension representing the status, format, and transaction type as outlined above.
Further FTP file naming information is available from EDItEUR.
Important notes
- We recommend zipping files because ONIX XML formatted files generally compress to approximately 20% of their original file size.
- The base filename must be unique and must not contain dots.
- Use only letters, numbers, underscores, or dashes in the base filename.
- Only uppercase file extension characters are recognised.
- Files should be uploaded using the temporary .XOT extension while transferring to indicate the file is not ready to load, and to avoid the possible loading of incomplete files.
- The format character must always be either O for a normal record or D for a deletion record.
- Files should be renamed to a final .COT or .ZOT extension once the upload is complete. They will not be processed until this occurs.
Further information
For further information please contact TitlePage support.