Difference between revisions of "User:Trifonnt/MyReadings2"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
(Created page with '=== Postal Code Web Service === * [http://sourceforge.net/tracker/index.php?func=detail&aid=1741222&group_id=176962&atid=879335 1741222 Webservice connector for address lookups] …')
 
Line 56: Line 56:
 
=== Posterita WEB POS ===
 
=== Posterita WEB POS ===
 
* [http://docs.google.com/View?docid=df58v8ht_139cnmm22dn Posterita Installation Guide]
 
* [http://docs.google.com/View?docid=df58v8ht_139cnmm22dn Posterita Installation Guide]
 +
 +
= CRM systems =
 +
* [http://xrms.sourceforge.net/pagebuilder.php?s1=18 XRMS]
 +
** [http://gleez.com/articles/it-systems/xrms-vs-sugarcrm XRMS vs. SugarCRM]
 +
 +
* [http://www.vtiger.com vTiger]
 +
** [http://www.crm-now.de/ online]
 +
** [http://www.vtigerserver.com/ online]
 +
** [http://forums.vtiger.com/viewtopic.php?p=60435#60435 Asterisk, Vtiger Integration]
 +
 +
* [http://www.sugarcrm.com SugarCRM]
 +
** [http://www.beanizer.org/site/index.php/en/Articles/SugarCRM-and-Asterisk-integration-in-Java-First-steps.html SugarCRM and Asterisk integration in Java - First steps]
 +
** [http://www.beanizer.org/site/index.php/en/Articles/SugarCRM-and-Asterisk-integration-in-Java-II.html Opening a customer SugarCRM page in the browser on incoming calls]
 +
 +
* [http://civicrm.org/ CiviCRM]Oriented towards advocacy, non-profit and non-governmental groups.
 +
* [http://www.freecrm.com Free CRM; provides free and paid subsription]
 +
* [http://crm.zoho.com/crm Zoho CRM] Free for up to 3 users
 +
 +
* [http://www.opencrx.org/ OpenCRX]
 +
** [http://yucrm.opencrx.com.cn/crm/ new GUI based on OpenCRX]
 +
 +
* [http://www.codeproject.com/useritems/Excel_Leads_into_MS_CRM.asp Import Leads from Excel via Email into Microsoft CRM] Interesting. Adempiere has the same two phase approach. Temporary table and after that process which import into real table.
 +
 +
 +
 +
== Comparison of CRM systems ==
 +
* [http://www.pc101.com/showthread.php?t=3555 interesting post regarding different offers of CRM packages]
 +
* [http://www.rdurl.com/article/hotspotnews/2009-01-21/1943.html CRM Heaven or CRM Hell? Seven Options Reviewed From the Trenches]
 +
 +
== Localized in Bulgarian ==
 +
* [http://dl.sugarforge.org/bgcrm/bgcrm/bg_bgdocuments/README_bg_bg.txt SugarCRM]
 +
 +
== On Demand prising ==
 +
* [http://www.kineoopensource.com/index.php/sugar/on-demand/ SugarCRM on demand]
 +
 +
 +
== Interesting news/Forum post regarding CRM systems ==
 +
* [http://www.sugarcrm.com/forums/showthread.php?p=81242#post81242 SOAP Performance Issue Loading Accounts] Strange advice "database to database conversion"! But for CRM system probably it is OK!
 +
* [http://www.sugarcrm.com/forums/showthread.php?p=80835#post80835 SugarCRM for blind man's (disabled people)] Very interesting requirements!
 +
* [http://www.dimdim.com/ DimDim]
 +
** [http://freefr.dl.sourceforge.net/sourceforge/dimdim/Dimdim_Opensource_Meeting_Server_v3.5_Integration_Guide.pdf Dimdim API Documentation]
 +
** [http://sourceforge.net/forum/forum.php?forum_id=728923 Dimdim Sugar CRM Integration Pack Release]
 +
** [http://sourceforge.net/forum/message.php?msg_id=5004767 How to change Port number of DimDim Server? - sf.net post]
 +
<pre>
 +
- vi /usr/local/dimdim/Mediaserver/mods/lighttpd.conf and leave port 80 not 81
 +
 +
then
 +
 +
vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB-IN
 +
F/classes/resources/dimdim.properties
 +
 +
dimdim.ServerAddress=SERVER_ADDRESS
 +
dimdim.serverPortNumber=81
 +
dimdim.dmsServerAddress=SERVER_ADDRESS:81
 +
dimdim.dmsServerInternalAddress=localhost:81
 +
 +
then
 +
- vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB
 +
-INF/classes/resources/streaming.properties
 +
 +
and modifiy port from 80 to 81
 +
 +
streaming_server.2.rtmp_url=http://SERVER_ADDRESS:81/screenshare/
 +
streaming_server.2.rtmpt_url=http://SERVER_ADDRESS:81/screenshare/
 +
streaming_server.2.max_number_of_streams=-1
 +
streaming_server.2.supported_stream_types=DTP
 +
 +
locate server.xml and modify port on 81
 +
 +
restart dimdim and go to http://SERVER_ADDRESS:81/dimdim
 +
* NOTE if made this cherrypy dont give error for / at final...
 +
 +
Control port 443 and 1935
 +
The dimdim start well
 +
 +
</pre>
 +
 +
 +
* [http://www.sugarcrm.com/forums/showthread.php?p=83961#post83961 SugarCRM osCommerce Integration] It is very strange for me too see how developers make integration at DB level. It looks that for CRM system it is completely OK.
 +
* [http://www.qinvoicing.com/ www.qinvoicing.com]Exports data from QInvoice itno OsCommerce.
 +
* [http://wiki.apexdevnet.com/index.php/Apex_Email_Services Apex Email Services] www.salesforce.com
 +
* [http://www.sugarcrm.com/wiki/index.php?title=Model-View-Controller_(MVC) SugarCRM Model-View-Controller implementation]
 +
* [http://www.packtpub.com/article/developing-a-simple-workflow-within-sugarcrm Developing a Simple Workflow within SugarCRM]
 +
 +
= Wiki =
 +
 +
== XWiki ==
 +
* [http://www.xwiki.org/xwiki/bin/view/Main/WebHome XWiki site]
 +
* [http://www.theserverside.com/tt/articles/article.tss?l=XWiki XWiki: A Platform for Collaborative Platform Apps]
 +
 +
 +
= GIS - Geographic Information System =
 +
* [http://easygis.org EasyGIS]
 +
 +
 +
= Monitoring Applications/Systems =
 +
* [http://www.groundworkopensource.com GroundWork Monitor]
 +
 +
== Log Analyzer ==
 +
* [http://awstats.sourceforge.net/ awstats.sourceforge.net]AWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically.
 +
 +
= CAD/CAM =
 +
* [http://sourceforge.net/projects/sweethome3d Sweet Home 3D]Open Source, Java based.
 +
 +
= Android =
 +
* [http://sipdroid.org/ SIPdroid]
 +
* [http://www.cyanogenmod.com www.cyanogenmod.com]
 +
* [http://www.linux-mag.com/cache/7667/1.html Automating Android with Ant]
 +
 +
= MFG/MRP - Manufacturing =
 +
 +
== Articles ==
 +
* [http://www.webandmacros.net/MRP-definition.htm Definition of MRP - Material Requirement Planning]
 +
* [http://people.brunel.ac.uk/~mastjjb/jeb/or/mrp.html Materials requirements planning (MRP)]
 +
* [http://wiki.openbravo.com/wiki/User_Manual_2.3/Production_Management OpenBravo - User Manual: Production Management]
 +
* [http://wiki.openbravo.com/wiki/Functional_Documentation/ProductionManagement OpenBravo - Functional Documenation: Production Management]
 +
 +
== Manufacturing Terminology ==
 +
* [https://sourceforge.net/forum/message.php?msg_id=5711565 sf.net post]
 +
 +
=== Queue time ===
 +
* [http://www.businessdictionary.com/definition/queue-time.html Source]
 +
Amount of time a person, signal, or thing spends before being attended
 +
to, or before value adding work is performed to or on it. In many factories
 +
queue time constitutes about 90 percent of the total lead time. It is a subset
 +
of cycle time.
 +
 +
=== Queuing time ===
 +
* [http://dictionary.bnet.com/index.php?d=queuing+time Source]
 +
The time between the arrival of material at a workstation and the start of work on it
 +
 +
=== Cycle time ===
 +
* [http://www.businessdictionary.com/definition/cycle-time.html Source]
 +
Period required to complete one cycle of an operation; or to complete
 +
a function, job, or task from start to finish. Cycle time is used in differentiating
 +
total duration of a process from its run time.
 +
 +
=== Waiting time ===
 +
* [http://www.businessdictionary.com/definition/waiting-time.html Source]
 +
Period at job for which an employee is paid but is unable to work
 +
due to factors beyond his or her control. Also called allowed time, downtime,
 +
or idle time.
 +
 +
= ERP Systems =
 +
* [http://www.baanusers.co.uk/docs/total_cost_of_erp_ownership.pd.pdf Average price of ERP] Good article. Shows TCO.
 +
 +
* TinyERP/OpenERP
 +
** [http://tinyerp.org/wiki/index.php/DevelopperBook/TechSpecArchProgram TinyERP design]
 +
** [http://odoo.com/index.php?option=com_quickfaq&view=quickfaq&Itemid=7 Odoo]OpenERP on Demand
 +
** [http://code.google.com/p/ooor/ OOOR - OpenObject on Rails]
 +
** [http://www.bluwiki.com/go/OpenERP_POS OpenERP POS]
 +
 +
* [http://sourceforge.net/projects/postbooks PostBook] Server part build with Postgre SQL procedures.
 +
** Good points[https://sourceforge.net/forum/message.php?msg_id=4777809]:
 +
*** - Amazing categories in master data setup - accounting and so on.
 +
*** - Very user-friendly forms
 +
 +
** Weak points:
 +
*** - PostBooks has not workflow (or i could not find it) and ERP system without workflow is meaningless.
 +
*** - Only desktop application
 +
*** - Technical weakness are DB Stored procedures.
 +
 +
* [http://www.dolibarr.org Dolibarr ERP/CRM]Build on Apache, Mysql, PHP.
 +
* [http://www.openbluelab.org OpenBlueLab] Model Driven Design
 +
* [http://www.openjades.com/ OpenJades]
 +
* [http://sourceforge.net/projects/gardenia/ Gardenia]Source code is older than binary release.
 +
* [http://seekingalpha.com/article/48112-sap-bets-the-future-on-business-by-design SAP Bets the Future on Business By Design]Quite expensive solution - min 25 user x 125 / month = 3125 / month x 12 = 37 500 USD year.
 +
* [http://www.salmon.ca/pricing.htm Price comparison]
 +
 +
== Small ERP/POS/MFG/WMS/Billing systems ==
 +
* [http://code.google.com/p/acacia-business-ace/ acacia-business-ace]Acacia Business Ace is ERP+CRM like system.
 +
* [http://redview.org redview.org]
 +
* [https://brownsocks.dev.java.net/ BrownSocks double-entry accounting library] DEAD.
 +
* [https://leunam.dev.java.net/ leunam.dev.java.net]
 +
* [http://sourceforge.net/projects/jledger/ jledger]Java Business Accounting API
 +
** [http://myrinix.com/jledger/doku.php jLedger documentation]
 +
* [http://timshadel.com/2005/03/03/zdot-podcast-accounting-patterns-in-java/ Zdot Podcast: Accounting Patterns in Java]
 +
* [http://www.opensubsystems.org OpenSubsystems]
 +
* [http://sourceforge.net/projects/blax/ Blax] Java-Swing application for optimized POS-Management and inventory management.
 +
* [http://jmoney.sourceforge.net/wiki/index.php/Change_notifications Change notifications in JMoney] JMoney RCP is a personal finance (accounting) manager written in Java. It is built using the Eclipse RCP and can be extended using plug-ins.
 +
* [https://sourceforge.net/projects/storemgr/ StoreMgr] intended to be a cross-platform open-source point of sale system for small businesses.
 +
* [http://www.2d-financialportal.com/2d_randr/orderportal/home Financial Portal]
 +
* [http://www.ebineutrino.org/ EBI Neutrino R1]
 +
* [http://sourceforge.net/projects/o2store/ o2Store]Warehouse and Point Of Sale (POS) Managment System
 +
* [http://sourceforge.net/projects/jchemicalmms/ J Chemical Mixing Manufacturing System]
 +
* [http://sourceforge.net/projects/strangebrew/ StrangeBrew] Brewing software written in Java.
 +
* [http://sourceforge.net/projects/playbilling/ PlayBilling] Webbased billing system for internet cafe and wireless hotspot.
 +
* [http://sourceforge.net/projects/incident-db/ Quality Complaint Management System]Automotive Quality complaint Management to record Customer incident.
 +
* [http://sourceforge.net/projects/rapla/ Rapla]Multi-user resource and event management system.
 +
* [https://sourceforge.net/projects/asdn ASDN]"Agile Supply Demand Networks" is software for analyzing and developing logistics networks.
 +
* [http://www.linuxcanada.com/pos.shtml POS by Linux Canada] Looks like nice POS.
 +
* [http://www.simpleinvoices.org www.simpleinvoices.org] PHP based
 +
* [http://sourceforge.net/projects/dolibarr www.dolibarr.org] PHP based
 +
* [http://www.softrak.com www.softrak.com] Paid.
 +
* [http://www.comarch.de www.comarch.de] Paid.
 +
* [http://www.billfaster.com www.billfaster.com] Proprietary.
 +
* [http://www.jbilling.com www.jbilling.com] Open Source
 +
* [http://www.sitig.com PostERP] Windows only. Works with Postgres.
 +
* [http://www.scalable-systems-ug.com www.scalable-systems-ug.com] Online Accounting application.
 +
* [http://www.clearcost.com.au www.clearcost.com.au] Budgeting and Reforecasting
 +
* [http://www.creloaded-manager.com Store Manager for CRE Loaded] Paid
 +
 +
== Bulgarian ==
 +
* [http://www.aloeco.com www.aloeco.com]Enterprise One
 +
 +
 +
== ERP Requirements ==
 +
Features that a composite of UK government bodies classified as Mandatory, Highly Desirable and nice-to-have in financial systems.  Chapter 9 sets out their requirements on fixed assets. List they came up seems to have general application.
 +
* [http://www.cio.gov.uk/documents/pdf/sharedservices/technology/D1401.pdf Core Accounting Systems Specification. Core Statement of Requirements]
 +
 +
* Historic Data
 +
** [http://tinyerp.org/wiki/index.php/Main/GermanNeedsEn TinyERP Historic Data]

Revision as of 06:13, 20 July 2010

Postal Code Web Service


INCOTERMS


Pricing

Interesting Proposal/Requiremnts

Web Service

1. Products - When entering a new product, call an UPC/EAN webservice (http://www.gepir.org/) that validates a product UPC/EAN and populates the item description and trade info (size, weight, etc).

2. Business Partners - When entering a new Business Partner, call a Company Registrar to validate (and populate) company registration / vat numbers and registered address, directors, etc.

3. Credit Checking - When entering a new Business Partner, call a webservice to perform a credit vetting / check after which the report can be populated into a credit check table or attached to the record.


Double UOM


Expectations from Adempreie

* It must be stable. I'm running my business and other's businesses on it and it must not stop working at any time.
* When I upgraded to the 3.52a release the invoices stopped printing due to a bug. To get the invoice printing to work Adempiere must be patched. This shouldn't happen in releases.
* User friendly - If the system isn't user friendly it's harder to convince people to work in it.
* Secure - I posted previously a message about Adempiere being easy to break into and that it can't be on an untrusted network. It's OK to have an insecure application as long as everybody knows it's insecure. For business critical data the implementors must know how to secure Adempiere.

I'm working on the user friendliness part (the Account Editor was the first step) and when I have time I'd like to work on the security part.

One example on how user friendliness can be improved is to increase the searchability
in accounts (you can't zoom to documents from accounts-view today) and make
a really simple form for creating manual general ledger entries. Manual general
ledger entries today are far too much work than what a normal accountant is
used to in other systems.

Posterita WEB POS

CRM systems


Comparison of CRM systems

Localized in Bulgarian

On Demand prising


Interesting news/Forum post regarding CRM systems

 - vi /usr/local/dimdim/Mediaserver/mods/lighttpd.conf and leave port 80 not 81

then

vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB-IN
F/classes/resources/dimdim.properties

dimdim.ServerAddress=SERVER_ADDRESS
dimdim.serverPortNumber=81
dimdim.dmsServerAddress=SERVER_ADDRESS:81
dimdim.dmsServerInternalAddress=localhost:81

then
 - vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB
-INF/classes/resources/streaming.properties

and modifiy port from 80 to 81

streaming_server.2.rtmp_url=http://SERVER_ADDRESS:81/screenshare/
streaming_server.2.rtmpt_url=http://SERVER_ADDRESS:81/screenshare/
streaming_server.2.max_number_of_streams=-1
streaming_server.2.supported_stream_types=DTP

locate server.xml and modify port on 81

restart dimdim and go to http://SERVER_ADDRESS:81/dimdim
* NOTE if made this cherrypy dont give error for / at final...

Control port 443 and 1935
The dimdim start well


Wiki

XWiki


GIS - Geographic Information System


Monitoring Applications/Systems

Log Analyzer

  • awstats.sourceforge.netAWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically.

CAD/CAM

Android

MFG/MRP - Manufacturing

Articles

Manufacturing Terminology

Queue time

Amount of time a person, signal, or thing spends before being attended to, or before value adding work is performed to or on it. In many factories queue time constitutes about 90 percent of the total lead time. It is a subset of cycle time.

Queuing time

The time between the arrival of material at a workstation and the start of work on it

Cycle time

Period required to complete one cycle of an operation; or to complete a function, job, or task from start to finish. Cycle time is used in differentiating total duration of a process from its run time.

Waiting time

Period at job for which an employee is paid but is unable to work due to factors beyond his or her control. Also called allowed time, downtime, or idle time.

ERP Systems

  • PostBook Server part build with Postgre SQL procedures.
    • Good points[1]:
      • - Amazing categories in master data setup - accounting and so on.
      • - Very user-friendly forms
    • Weak points:
      • - PostBooks has not workflow (or i could not find it) and ERP system without workflow is meaningless.
      • - Only desktop application
      • - Technical weakness are DB Stored procedures.

Small ERP/POS/MFG/WMS/Billing systems

Bulgarian


ERP Requirements

Features that a composite of UK government bodies classified as Mandatory, Highly Desirable and nice-to-have in financial systems. Chapter 9 sets out their requirements on fixed assets. List they came up seems to have general application.