Import / Export with PostBooks?

Help
omfgppc
2007-11-05
2013-03-08
  • omfgppc
    omfgppc
    2007-11-05

    kkmfg Wrote at http://www.xtuple.org/phpBB2/viewtopic.php?t=495 :

    I've installed PostBooks 2.2.0 B3 in linux. I can use the program well enough but I'm evaluating it for potential use in a corporate setting. We've got years worth of data that we'd not like to lose or manually re-enter. As such, I find myself wanting to automatically import as much as possible. Unless I miss my mark there currently seems to be ZERO information on this subject.

    Is there no plan for getting data in and out of OpenMFG/PostBooks other than a direct dump or import using PostgreSQL? Having to figure it all out myself and import to postgresql would not be a lot of fun.

    Read more at: http://www.xtuple.org/phpBB2/viewtopic.php?t=495

     
    • omfgppc
      omfgppc
      2007-11-05

      jrogelstad Wrote:

      Of course you can connect to Postgres with any Postsql or ODBC driver of choice. However, bringing data directly into tables is not advised because if not done properly can easily "break" the system.

      To help make data importing safer and easier, however, we have recently begun an effort to create an embedded "Database API" which is a series of views that encapsulate all the business logic found in the UI. Version 2.2 of PostBooks will have the first pass at this, which includes views for Customer, Quote and Sales Order. The views work with any other method of choice that can connect to Postgres. If you had any interest in taking part in expanding the views to include Vendors, Items or other system documents, we would certainly love to discuss that with you!

      We will be publishing more information on the views soon, but you can read about the discussion that lead to their creation, and some explanation on how they currently work on the related forum at http://www.openmfg.org/?q=node/3917.

      There are tenative plans to include a GUI tool in v 3.0 which will make importing easier for non-technical users.

      Read more at: http://www.xtuple.org/phpBB2/viewtopic.php?t=495