DBase How To

  • How it works, general notions:

*The screen displays 2 areas:
-the List panel (on the left)
-the Item data panel (on the right)

*Data is organized around [Libraries], [Items] and [Fields].
Supported [Field] types are:
-Text (single line)
-Text Area
-Image
-Date
-Check Box
-List (single selection)
-Multi-List (multi-selection) DBase31
-[Item] reference (with hyperlink)
(more to come...)

*Use Search popup (top-left icon) to retrieve data among all [Libraries]. DBase31

*Use "List Options" popup (bottom-middle icon in the List area) to configure:
-List view
-Sort options
-Search options DBase31

*Use "Options" popup (bottom-right wheel icon) to access advanced functionalities:
-Backup/Restore
-Export CSV
-Import CSV DBase31
-Language selection DBase31


  • How to edit or add a new [Field]:
-select (or create) a [Library]
-select (or create) an [Item]
-click "Edit" button (top right zone)
-click "Fields" button (top right zone)
=> the list of [Fields] is displayed in the [List] panel.

Click "+" button to create a new [Field]

Click a [Field] name to edit (edit name, options)


  • How to delete an [Item]:
-select an [Item]
-click "Edit" button (top right zone)
-click "Delete" button (top right zone), and click again to confirm.



  • How to configure a [Field] of type "List":
-select (or create) an [Item]
-click "Edit" button (top right zone)
-click "Fields" button (top right zone)
-click a [Field] of type "List" to edit
=> the [Field] edit popup is displayed.

On the right part use button "+" and "-" to add or remove "List" items.

To rename an item, select it, and change its name in the text input area. Use keyboard "Enter" key to save.


  • How to backup data:
-open "Options" panel (bottom right icon)
-select category "System"
-click "Backup" to create a backup file
-click "Restore" to restore data from the backup file.

Note: only 1 backup file is managed by DBase. Creating a new backup file will replace the previous one.


  • How to export CSV data:
Each [Library] can be exported individually in a CSV file.
-first line contains [Fields] names.
-images data are exported in a specific directory next to the CSV file, which contains relative path as field value.

Note: on iPad to retrieve the exported files, use iTunes and browse to DBase specific files. Then select directory "NextGen31" directory and click "Save as...": this will save all exported data to your computer (to the selected directory).


  • How to import CSV data :   DBase31
See Import CSV data for details.

9 comments:

  1. I don't see any option to import csv files.
    the only options I see are system files, display and export csv. how do I import a database from the free version?

    ReplyDelete
    Replies
    1. Hello Richard,
      in popup "Options" (bottom right gear icon), several categories are available in the drop down list. "Import DBase" is the last one, you have to scroll the list down.
      "Import CSV" is available in DBase31 (not in the free version).

      Delete
    2. This comment has been removed by the author.

      Delete
  2. i think you should add an sql dump option.

    ReplyDelete
  3. Hi,

    I try export csv file to my computer via iTunes. When I click "Save as..." in ITunes it starts to save, but after a while I get notification like this: Items "NextGen31" could not be copied, because there was an error. The required folder can not be found.
    DBase " How to..." dosen't tell where in my computer exported file must be saved. I'm using ipad2 and my computer is PC using win7 home premium.

    cheers
    JJO

    What or where is that required folder?

    ReplyDelete
    Replies
    1. Hello JJO,
      here is the detailed process that works for me:

      When your're in iTunes, with your iPad2 connected to your PC, select your device in the list on the left.
      Then, click on "Apps" in the menu bar (between infos and Music), and scroll down to see the "Files sharing" part.
      Here select Apps "DBase", and select the directory "NextGen31" on the right part in "Documents". This will open the file browser, where you can select the path where you want to save the "NextGen31" directory.

      If you encounter an error, please send me a screenshot to help resolving the problem. Thank you.

      Delete
  4. I created a library called finance, then opened up library to enter name of account, but i do not see the name of account. What i see is item #1. I dont see an option to fix this. I have tried creating field name title then giving it a value of list. What am i not doing?

    ReplyDelete
    Replies
    1. Hello Laureen,
      "item #X" is the default name given to newly created items. To change it, open the item, and edit the "title" field value.
      The field "title" is displayed in the list by default, but you can change it to any other field you have created.
      I'm not sure that answers your question, don't hesitate to contact me back if you have other questions.

      Delete
  5. Hello JC,
    I use dBase III + under DOS. DBF files have! Can I use these DBF files on iphone?
    Pierre

    ReplyDelete