Skip to main content

Publications Import

You will be able to do imports to create and update publications in bulk.

To know more about the general requirements and specifications, please, check it: Bulk Operations.

Example files:

Note:

  • The file must be a CSV (comma-separated values).
  • It is not necessary to add all the columns to perform an import, only the columns marked as required.

Columns details:

  • ISBN: required, is a unique identifier for the publication. It is usually used for the ISBN. It can contain an alpha-numeric characters, as well as dashes and underscores with 250 characters max.
  • Free: optional, in case the publication is free, it must contain 1. It must be a boolean: 0 or 1.
  • Free Until: optional, in case the publication is free up to a certain date It must contain the date in yyyy-mm-dd “year-month-day“ format (2019-04-28).
  • Require Login to Read: optional, in case the publication requires login when free, it must contain 1. It must be a boolean: 0 or 1.
  • Allow Preview: optional, in case the publication is previewable it must contain 1. It must be a boolean: 0 or 1.
  • Require Login for Preview: optional, in case the publication requires login when previewable it must contain 1. It must be a boolean: 0 or 1.
  • Name: required, is the name of the publication. It must contain with 200 characters max.
  • Description: optional, is the description of the publication. It must contain with 10000 characters max.
  • Private Material: optional, the private material of the publication. It can only be viewed by users with access to the publication. It must contain with 10000 characters max.
  • Publication Date: optional, if you need to specify a publication date or datetime. It must contain the date in "day-month-year" and if you want to add a time, then you need to add the value like this "hour:minute:second".
    Example:
    • If the value is only a date, the format is yyyy-mm-dd “year-month-day” (2019-04-28).
    • If the value is a datetime, the format is yyyy-mm-dd hh:mm:ss “year-month-day hours:minutes:seconds“ (2019-04-28 00:00:00).
    • If the field is empty, the default value is the current datetime.
  • File URL: required, the value depends on how is the operation:
    • Without FTP: is a URL from which to download the publication.
    • From FTP: is a PATH with the location of the publication inside a /files directory. This file must be PDF, or EPUB. Use the ISBN as the file name. The filename must be without spaces and without characters non-alphanumerics.
      Example: username_ftp/files/isbn_code.pdf (username/files/123abc.pdf). (a) (c)
      Valid extensions: PDF, EPUB or MP3.

      If the file is with a mp3 extension:
      You can add one or multiple track files for an Audiobook. If you want to add multiple tracks, you need to add this | character to separate between them. To do this, you need to follow this example format:
      - **One track**: `username_ftp/files/isbn_code.mp3` (username/files/123abc.mp3). [(a)](#notes) [(c)](#notes) <br/>
      - **Multiple tracks**: <br/>
      `username_ftp/files/isbn_code-1.mp3|username_ftp/files/isbn_code-2.mp3` <br/>
      (username/files/123abc-1.mp3|username/files/123abc-2.mp3).
      [(a)](#notes) [(c)](#notes) <br/>
  • Cover File URL: optional|recommended, the value depends on how is the operation:
  • Without FTP: a URL from which to download the publication cover.
  • From FTP: a PATH with the location of the publication cover inside a /files directory. This file must be JPG or PNG. Use the ISBN as the file name. The filename must be without spaces and without characters non-alphanumerics.
    Example: username_ftp/files/isbn_code.jpg (username/files/123abc.jpg). (a) (b) (c)
  • Type: required, is the type of file. It must be pdf, epub or audio. (c)
  • Lang: required, the language of the publication. It must be es or en. (c)
  • Retail Enabled: required, set this field to 1, if you want to offer the publication in the Marketplace under the retail license. If this field is 1, the prices field will be required and you must provide a price in USD.
  • Prices: optional, is a string with the format currency_id:amount. Supports multiple values ​​by separating them with the character |.
    • currency_id can be ARS, USD, EUR, MXN, COP, PEN or CLP.
    • amount is the value of the price, in float or integer format.
    • For example: If we want to set the price of a publication to 500 ARS, 300000 CLP and 9.99 USD: ARS:500|CLP:300000|USD:9.99
  • PPU Enabled: required, configures the publication to be offered in the "Publicala Marketplace" under the PPU (Pay Per Use) license. It must be 0 or 1.
  • PPU Prices: optional, but required IF ppu_enabled equals 1. Sets the PPU license price, and follows the same format as the prices field, but it only accepts prices in USD (for example: USD:40 to set the price to 40 american dollars).

Taxonomies columns:#

All taxonomies columns are optional. You will be able to add and use the standard taxonomies columns or/and add/create customizable taxonomies columns.

  • Standard taxonomies columns:

    • Keywords: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Category: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • BISAC: optional, setup up to four (4) Bisac categories for your publications. Multiple values must be separated by | (ex: JUV033160|ANT011000). Take into account that the first Bisac code you put on the field will be considered as the "main category" (in this example, JUV033160).
    • Collection: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Author: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Publisher: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Country: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Edition: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Narrator: optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.
    • Audience: optional, setup up to one (1) audience value for your publications. Allowed values are children, young-adults or adults
  • Customizable taxonomies columns:

    To add/create customizable taxonomies columns, all these columns must have this prefix: taxonomy_. After of this prefix, you need to add the taxonomy name.

    Examples: taxonomy_titles, taxonomy_city, taxonomy_genre, etc.

    Also, these are optional, supports multiple values ​​by separating them with the character |. Maximum of 250 characters.

Considerations#
  • (a): Upload the publications files to the SFTP, you'll be provided write access inside a /files directory.
  • (b): Supported publication cover files are JPG and PNG with a minimum resolution of 256x256 pixels.
  • (c): This field cannot be updated.