Introduction
How to use command-line to export
Usage
- Be in the directory where the *.jar file is
$ ls -l sunriise-Build_20130216_50-app.jar
-rw-r--r-- 1 hle hle 19134996 2013-07-22 09:34 sunriise-Build_20130216_50-app.jar
- Get command line usage. The main class is com.le.sunriise.export.ExportToMdb
$ java -cp sunriise-Build_20130216_50-app.jar com.le.sunriise.export.ExportToMdb
Usage: java com.le.sunriise.export.ExportToMdb in.mny [password] out.mdb
- Specify input and output files. If your files are NOT in current directory, make sure to specify full path
- Jar file: sunriise-Build_20130216_50-app.jar
- Main class: com.le.sunriise.export.ExportToMdb
- Input file: ../src/test/data/mny/sunset01.mny
- Output file: /tmp/sunset02.mdb
$ java -cp sunriise-Build_20130216_50-app.jar com.le.sunriise.export.ExportToMdb ../src/test/data/mny/sunset01.mny /tmp/sunset02.mdb
0 [main] INFO com.le.sunriise.export.ExportToMdb.main(ExportToMdb.java:66) - srcFile=../src/test/data/mny/sunset01.mny
4 [main] INFO com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/home/hle/workspace/com.le.sunriise/target/../src/test/data/mny/sunset01.mny
125 [main] INFO com.le.sunriise.export.ExportToMdb.startCopyTables(ExportToMdb.java:128) - > Adding tables=83
132 [main] INFO com.le.sunriise.export.ExportToMdb.startCopyTable(ExportToMdb.java:136) - > startCopyTable, name=ACCT
654 [main] INFO com.le.sunriise.export.ExportToMdb.startAddingRows(ExportToMdb.java:213) - Adding rows=1 ...
956 [main] INFO com.le.sunriise.export.ExportToMdb.endAddingRows(ExportToMdb.java:218) - Added rows=1, ms=302
...
152505 [main] INFO com.le.sunriise.export.ExportToMdb.startAddingRows(ExportToMdb.java:213) - Adding rows=0 ...
152505 [main] INFO com.le.sunriise.export.ExportToMdb.endAddingRows(ExportToMdb.java:218) - Added rows=0, ms=0
152505 [main] INFO com.le.sunriise.export.ExportToMdb.endCopyTable(ExportToMdb.java:209) - < endCopyTable, name=XSYNCCHUNK
152506 [main] INFO com.le.sunriise.export.ExportToMdb.endCopyTables(ExportToMdb.java:132) - < Added tables=83
152506 [main] INFO com.le.sunriise.viewer.OpenedDb.close(OpenedDb.java:71) - Closing dbFile=../src/test/data/mny/sunset01.mny
152527 [main] INFO com.le.sunriise.export.ExportToMdb.main(ExportToMdb.java:71) - destFile=/tmp/sunset02.mdb
152527 [main] INFO com.le.sunriise.export.ExportToMdb.main(ExportToMdb.java:72) - < DONE
If you have a password-protected file, specify it as the second argument, then output fileName
Other main class
- com.le.sunriise.export.ExportToCsv: export to CSV
- com.le.sunriise.export.ExportToJSON: export to JSON