fllogosm
 Main
 User's Guide
 Developer's Guide
 Admin's Guide
 FAQ
 License Info
 Feedback
 Import/Export

The nrio.utils.ImportExport class can be used to convert databases from foreign file formats to MaxBase native file format (.DAT) and viceversa.

As of today the following methods are implemented:

 o dbfToDat
        Converts a file from DBF to DAT.
 o
datToDbf
        Converts a file from DAT to DBF.
 o
csvToDat
        Converts a file from CSV (Character Separated Values) to DAT.
 o
datToCsv
        Converts a file from CSV (Character Separated Values) to DAT.
 o
qifToDat
        Converts a file from QIF (Quicken Interchange Format) to DAT.

boolean dbfToDat(String InputFile, String OutputFile, boolean bImportDeleted)

This method converts the DBF InputFile file into a DAT OutputFile file. The method returns true if the conversion has been succesful, false otherwise. Please note that after the conversion is finished, you will only have one indexed field -- feel free to change fields indexing as needed. One more note: if bImportDeleted is set to true, all of the records present in the DBF file will be imported, otherwise deleted records will be skipped.

boolean datToDbf(String InputFile, String OutputFile)

This method converts the DAT InputFile file into a DBF OutputFile file. The method returns true if the conversion has been succesful, false otherwise.

boolean csvToDat(String InFile, String OutFile, char SepChar)

This method converts the CSV InFile file into a DAT OutFile file. The method returns true if the conversion has been succesful, false otherwise.

boolean datToCsv(String InFile, String OutFile, char SepChar)

This method converts the CSV InFile file into a DAT OutFile file. The method returns true if the conversion has been succesful, false otherwise.

What is a CSV file? It is a file that holds a record for each line of which it is composed, with a special character acting as a separator between each field. Please note that after the conversion is finished, you will only have one indexed field -- feel free to change fields indexing as needed.

boolean qifToDat(String InFile, String OutFile)

This method converts the QIF InFile file into a DAT OutFile file. The method returns true if the conversion has been succesful, false otherwise.

As of today, the routine has been tested only on Asset Accounts ("Oth A" in QIF jargon) because I only had those for my tests. If you find problems with other types of QIF files, let me have a testcase with the failing example and I'll update the method.