My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
Export_Command_Line  
Command-line to export
Updated Jul 22, 2013 by hle...@gmail.com

Introduction

How to use command-line to export

Usage

  1. Be in the directory where the *.jar file is
  2. $ 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
  3. Get command line usage. The main class is com.le.sunriise.export.ExportToMdb
  4. $ 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
  5. 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

Powered by Google Project Hosting