=====Third Party Contributions===== ====osCommerce Interface==== Alan Jones - has contributed his work that allows webERP to be interfaced to osCommerce. Updated September 2005 to work with webERP 3.01 database - it should be good for 3.03 since the major changes for lower casing and tax were all completed in 3.01 - many thanks Alan Updated January 2009 by Geraint Jones. A few changes : * All settings are now in conf.php * The scripts are much more general (ie almost all hardcoded stuff has gone) * The scripts now work with WebERP v3.09 * The scripts now properly handle multiline orders * Freight is fixed * All the SQL is now safe (it is now getting escaped) Anyway i really hope these scripts help someone other than me. To get them running you need to edit conf.php $mysql_host='localhost'; < Set this to your MySQL server $mysql_user='root'; < Set this to the user for that server $mysql_pass=''; < Set this to their password $osc_db_name=''; < Set this to the name of the MySQL DB used by your osCommerce install $weberp_db_name=''; < Set this to the name of the MySQL DB used by your WebERP COMPANY $notify_email=''; < This is where you set the email address that things get sent to $shop_domain=''; < This is purely asthetic and just makes the email say which domain they are for You will also need to run the following SQL in your WebERP Company's DB : "create table osc_order_sync (last_synced_order int);" and you will be away to go - i have it running once a min from my crontab Feel free to let me know if you use it. ~& [[http://www.weberp.org/uploads/ScreenShotUploads/osCommerceSync_1.-1.tgz Download osCommerce Sync Code]] ~& OR [[http://sparx.net.nz/osCommerceSync_1.01.tgz Download osCommerce Sync Code]] ====Zen-Cart Interface==== Phil Daintree has created an interface that allows orders created in Zen-Cart to be imported together with customer details created in Zen-Cart. The application also has facilities to import Zen-Cart items into webERP and manage the mapping of Zen-Cart items to webERP item codes. This application does carry with it a small license cost.[[http://www.logicworks.co.nz Logic Works Web-site]] ====Spanish Translation of Manuals==== Marcos Garcia Trejo - has translated [[http://www.weberp.org/3rdPartyStuff/es_Manual-Pedidos.PDF Danie Brinks Order entry manual]]. He has also made a start on [[http://www.weberp.org/3rdPartyStuff/ManualSystemConventions.html Manual System Conventions]] and [[http://www.weberp.org/3rdPartyStuff/ManualSpecialUtilities.html Manual Special Utilities]] - thanks Marcos Daniel J. Loayza M. has also translated a portion of the Manual and is available for download below: [[http://www.weberp.org/wikidocs/images/guna_de_incio_rbpido_de_weberp_en_espasol.pdf guna_de_incio_rbpido_de_weberp_en_espasol.pdf]] ====German Translation of Manuals==== A German translation of the Manual has been made on this wiki!! Thanks Harald Ringehahn [[Inhaltsverzeichnis German Manual]] ====Chinese Translation of the Order Entry Manual==== Sing Major contributed his translation of Danie Brink's Order Entry Manual [[http://www.weberp.org/3rdPartyStuff/WebERPChineseOEManual.pdf Download Chinese Order Entry Manual]] ====Starting From A New Empty Database==== Instructions for StartingAFreshSystem from an empty database Contributed by Danie Brink ====Foreign exchange calculator==== A module that can be integrated with webERP to display an AJAX foreign exchange calculator in the footer. GPL'd - FREE. Link here: http://combatwombat.7doves.com/2009/03/13/new-project-forex ====synPOS Connector==== synPOS is an open source POS software written in Java. It can run standalone or connect to an ERP/eCommerce application. webERP connector is available at the projects website: http://sourceforge.net/projects/synpos Note: not updated since 2006. Not currently functional. ====Microsoft Access Helper/Reporting Application==== Hindra J has developed a cool reporting application that makes use of an ODBC driver for mysql - downloadable from www.mysql.com - this allows Access to "attach" the webERP tables that can then be used for reporting - this is an excellent way to import data as well - as described in the manual - but is a security risk and should not be made available to all. [[http://hindraj.wikispaces.com/WebERPHelpers Screen shots of Hindra's application]] ====Allow Print Price Lists to print only items in stock==== Adds a selection dialog to PDFPriceList.php to choose to display "In Stock Items Only". [[PDFPriceListInStock]] ====Improved GUI for Journal Entry==== (involves Ajax) Changes the GUI for the journal entry page to - find and autosuggest journal names - add credit and debit sections (-1 x value entered) http://moxx.in/downloads/GLJournal.zip [[support@moxx.in Write to us if files are not available]] ====Joomla Shopping Cart Integration==== [[http://www.joomlamo.com/joomlamo/cartweberp.html Joomla Mo CARTwebERP download]] **Other Joomla GUI interfaces to webERP for**: - Inventory Pricing and change reorder levels - Sales Order Importing - Customer/Branch updates - Display A/R Aging by Sales Person - SugarCRM integration - Salesman Dashboard - Cell Phone Application - Enter quotes to webERP and email them from your cell phone! [[mo@joomlamo.com If you add new webERP functionality using Joomla you can update either without migrating customized source code!]] [[http://www.youtube.com/watch?v=XoJIsPVAEZ0 YouTube video for installing webERP on a hosted account]]