Bruji

NOTE:
I think I solved my problem (discussed below): by going into the preferences | Fields tab and checking the appropriate check boxes so that the fields appear in the Add Edit Panel they then also become available in the drop down menu and view options panel. Not exactly intuitive but it does the job. I leave it to you to decide if this behavior is odd enough to be considered a bug.


I keep my book collection data in a Filemaker Pro database (primarily because Bookpedia doesn't support the kinds of reports and sorts that I like to generate). Nevertheless I have all the pedias and thought it would be nice to have some book data on my iPod Touch using Pocketpedia.

I created a tab-delimited file (exported from FMP) containing a subset of the FMP fields:

• AuthorsEditors
  FirstAuthorEditor
  Title
  SeriesSortCalc (used to do a particular kind of sort in FMP)
  Packaging (hardcover/trade paperback/paperback)
  GeneralClass (fiction/non-fiction)
  Category (e.g., novel, collection-authored, collection-edited, ...)
  Subcategory (e.g., science fiction, horror, humor, ...)
  SeriesTitle (e.g., Lord of the Rings)
  SeriesPart (1, 2, ...)
  SeriesLast (last book number in series, e.g., for a trilogy, 3)
  SmallDescription (e.g., F(ac) e, meaning fiction,authored collection, excellent condition)

In Bookpedia I used the first eight custom fields naming them as follows:

• C1 = All Authors/Editors
  C2 = Series Sort Value
  C3 = General Class
  C4 = Category
  C5 = Subcategory
  C6 = Series Part
  C7 = Series Last
  C8 = Small Description

I then imported the tab-delimited file into Bookpedia with the following mappings:

• AuthorsEditors --> All Authors/Editors
  FirstAuthorEditor --> Author
  Title --> Title
  SeriesSortCalc --> Series Sort Value
  Packaging --> Format
  GeneralClass --> General Class
  Category --> Category
  Subcategory --> Subcategory
  SeriesTitle --> Series
  SeriesPart --> Series Part
  SeriesLast --> Series Last
  SmallDescription --> Small Description

When trying to view the various fields in the column view the last four custom fields that I renamed (5 - 8, i.e., Subcategory, Series Part, Series Last and Small Description) are not available for choosing, neither in the drop down menu or in the view options panel (also note that the last two custom fields, custom 9 and custom 10 aren't available either). The data seems to be there as evidenced by its appearance in the Info panel.

Regards,
Gary Nunes