My DataBank Online Data Converter This online tool, courtesy of Digital Capture, can be used by advanced users to convert Comma Separated Values (*.csv) data to My DataBank Format (*.mdf) and vice versa. Any and all information pasted into this tool is processed locally on your machine/device and is not transmitted or stored across the internet. Convert CSV to MDF Copy and paste the CSV data into the CSV Data Container. Select the appropriate Table from the dropdown list (Categories or Items). Press on the >> button. Upon successful conversion, the results will appear in the MDF Data Container which can be imported into My DataBank. Note: All CSV values must be encapsulated with double quotes (") as a qualifier.  Also, Short Date (mm/dd/yyyy hh:nn am/pm) values within the CSV data are automatically converted to the numeric equivalent (number of milliseconds since the midnight of January 1, 1970) within the MDF format. Convert MDF to CSV Copy and paste the MDF data into the MDF Data Container. Press on the << button. Upon successful conversion, the results will appear in the CSV Data Container which can be used as data for a CSV text file and imported into external applications (e.g. MS Excel, MS Access). Note: All CSV values are encapsulated with double quotes (") as a qualifier.  Also, the numeric Date value (number of milliseconds since the midnight of January 1, 1970) within the MDF format are automatically converted to the Short Date (mm/dd/yyyy hh:nn am/pm) format within the CSV data.

CSV Data Container:		MDF Data Container:
Warnings/Errors: Assign unspecified categorytypeid to:  Tab Delimited:		Warnings/Errors: Table: Categories Items
Frequently Asked Questions What are the format specifications for Categories and Items? Visit the following link and scroll to the bottom under the Import/Export section: MDF Format Specifications How do I link Items to the correct Category? Each Item requires the column name categorytypeid. If you leave this value blank during CSV to MDF conversion, this tool will automatically assign -1 as the value, or if specified, the value you above in Assign unspecified categorytypeid to. A value of -1 is recognized by the My DataBank app and files these items under the "Uncategorized" category. However, you can also use a categorytypeid value from an existing Category to create the appropriate relationship link. This value can be found under the column name categorytypeid for Categories and is also identified as the "Unique Identifier" under the Category Setup screen in My DataBank. How do I append new Items or Categories into My DataBank? For Categories, omit the column name categorytypeid in your data before importing. For Items, omit the column name itemsid in your data before importing. I am encountering the error message 'Constraint Failed' after importing which is preventing my records from appearing in My DataBank.  How do I avoid this? There is a conflict with a value you are using against values that already exist in the database. The values for the column name categorytypeid must be a unique value for Categories; omit this column name and it's value before importing. For Items, the values for the column name itemsid must also be a unique value; omit this column name and it's value before importing. I am encountering the error message 'Unknown Column name...' upon attempting to convert my data into MDF format.  How do I avoid this? Make sure you are using the correct Table destination from the drop down list: Categories or Items. Otherwise, unknown columns are identified during conversion to prevent errors from being generated upon importing into My DataBank.  Note: Column names are all lowercase and case sensitive.
File Specifications: Section Seperator: | Line Seperator: ~ Field Seperator: ^ Category Table: db_categorytype The first row contains the header fields. field name data type required field description categorytypeid integer optional Unique Record Identifier Automatically assigned if not provided. name text required Category Title Title for the category notes text optional Category Notes Notes associated with category itemlistorder text required Item List Order Contains field name for sorting. The first item separated by a comma is the primary sort value, the proceeding is the secondary sort value. Use categorytypeid,categorytypeid for default (no space). itemlistshow text required Item List Show Contains secondary field name to display in the Items List screen. Use date1 for default. fieldorder text required Field Order Contains the Field Order that will appear in the Items List screen. This must contain the values from 1 - 20 separated by commas (no spaces). icon text required Icon Path Contains the path to the icon image associated with the category. External references can also be used using http:// priority integer required Priority Value Priority value which can be used for sorting. text1 text optional Text Field 1 Title Text Field Title for index 1. Up to 5 indexes supported. text1limit integer optional Text Field 1 Character Limit Text Field Character limiations for index 1. Up to 5 indexes supported (Currently not being used) int1 integer optional Integer Field 1 Title Integer Field Title for index 1. Up to 5 indexes supported intcurr1 boolean optional Integer Field 1 Currency Flag Integer Field Currency Flag for index 1. Up to 5 indexes supported date1 datetime optional Date Field 1 Date Field Title for index 1. Up to 5 indexes supported. bit1 boolean optional Bit Field 1 Bit Field Title for index 1. Up to 5 indexes supported. Appears as Checkbox in the Item Detail screen. Items Table: db_items The first row contains the header fields. field name data type required field description itemsid integer optional Unique Record Identifier Automatically assigned if not provided categorytypeid integer required Category to Items link Relationship link between Categories and Items name text optional Item Title Title for Item priority integer optional Priority Value (Currently not beind used) text1 text optional Text Field 1 Value Value for Text Field 1. Up to 5 indexes supported. int1 integer optional Integer Field 1 Value Value for Integer Field 1. Up to 5 indexes supported. date1 datetime optional Date Field 1 Value Value for Date Field 1. Up to 5 indexes supported. Includes storage for Time value. The date value must represent the number of milliseconds since the midnight of January 1, 1970 bit1 boolean optional Bit Field 1 Value Value for Bit Field 1. Up to 5 indexes supported.