Creating a Project by Importing a CSV File in Obi

You can import the structure from a CSV file or a delimited text file when you are creating a publication using Obi. This feature makes the process of structure creation very simple. Any spreadsheet software, such as Microsoft Excel, can be used for this purpose. Obi accepts data in three columns:

  1. Section level: This indicates the level/depth of the section. It should be an integer; for example, 1, 2, 3 for the section at first, second, and third levels respectively. The upper limit for the section level is 6.
  2. Section name: The name of the section should be an alphanumeric string; for example, “Micro Economics”, “Inflation”, “Exercise 1.1”, etc.
  3. Number of pages: This indicates the number of pages the section spans. It should be an integer; for example, 3, 2, 5, etc.

Create a spreadsheet listing the entire structure of the book, and save it in the CSV or delimited text file format. The table below shows how data should be entered.

Section LevelSection Name No. of pages
1Micro Economics3
2Demand and Supply1
3Responsible Factors2
3The demand and supply curve2

Now, create a new project by importing this file in Obi as follows.

  1. Click File->New Project from Import on the menu or press Ctrl+Shift+N. An Open dialog pops up that lets you browse the file from which the structure should be imported.
  2. Select the CSV file or the delimited text file and click Open. A dialog box opens as shown in the figure below:

    Figure: Create a new project from Import

  3. Enter the following details in the dialog:
  4. FieldField TypeDescription
    TitleEdit BoxEnter the title of the book.
    IDEdit BoxEnter a unique identifier for the book. This identifier should be compliant with the scheme of assigned identifiers to a book in your organization. You can leave this field with the default value provided, if you are not sure. ID is stored in the metadata and can be changed any time.
    GenerateButtonRandomly generates an identifier for your project and fills in the ID field.
    LocationEdit BoxEnter the location where you want to store your project. You can also browse for a location by Clicking the Select button.
    SelectButtonOpens a dialog box to select a directory for your project. If the selected location is not empty, Obi will suggest one. Click Yes to accept or click No to ignore.
  5. Click on the OK button. Obi will display a dialog box to select the audio settings for the project.
  6. Enter appropriate values and click on the OK button.

A new project opens in the work area of Obi and the TOC view shows the sections and subsections Imported from the CSV or delimited text file.

Obi will do the following with the data from the imported file.

  • From each row, a section will be created at the level specified in the first column, and it will bear the name entered in the second column.
  • Thereafter, Obi will create the number of blank page phrases in the section as specified in the third column. It will also specify the page number for each page phrase, which will be one more than the previous phrase and the pages will be categorized as “page-normal”.

For example, if the row says “2,Inflation,3” and the last page number in the previous section was “23”, Obi will do the following:

  • The section “Inflation” will be created at level “2”.
  • 3 page phrases will be created with the page numbers “24”, “25”, and “26”.

See also

DAISYpedia Categories: 

This page was last edited by VLuceno on Saturday, April 25, 2015 19:28
Text is available under the terms of the DAISY Consortium Intellectual Property Policy, Licensing, and Working Group Process.