Difference between revisions of "User:Trifonnt"
m (→EDI @ Adempiere - [http://www.adempiere.com/wiki/index.php/Sponsored_Development:_EDI_Import/Export Sponsored Development: EDI Import/Export]) |
|||
Line 109: | Line 109: | ||
* [http://martinfowler.com/articles/languageWorkbench.html Martin Fowler; Language Workbenches: The Killer-App for Domain Specific Languages?] | * [http://martinfowler.com/articles/languageWorkbench.html Martin Fowler; Language Workbenches: The Killer-App for Domain Specific Languages?] | ||
* [http://buildix.thoughtworks.com/ Continuous Integration, Source Control, a Wiki and a Bug-Tracker; by ThoughtWorks] | * [http://buildix.thoughtworks.com/ Continuous Integration, Source Control, a Wiki and a Bug-Tracker; by ThoughtWorks] | ||
+ | |||
+ | ==== Open Source articles ==== | ||
+ | * [http://itmanagement.earthweb.com/career/article.php/11067_3687096_1 Will Open Source Developers be Well Paid?] | ||
+ | * [http://www.riehle.org/computer-science/research/2007/computer-2007-article.html The Economic Motivation of Open Source Software: Stakeholder Perspectives] | ||
+ | |||
+ | ===== OSS Etiquette & Culture ===== | ||
+ | * [http://www.mozilla.org/community/etiquette.html Mozilla Forum Etiquette] | ||
+ | * [http://wiki.archlinux.org/index.php/Forum_Etiquette ArchLinux Forum Etiquette] | ||
+ | * [http://www.wikimatrix.org/forum/viewtopic.php?id=387 WikiMatrix Forum Etiquette] | ||
+ | * [http://www.lilbeginnings.com/forum/et/ Forum Etiquette & Rules] | ||
+ | |||
+ | ==== Books ==== | ||
+ | * [http://www.mergere.com/m2book_download.jsp Better Builds with Maven] | ||
==== Articles and posts from Martin Fowler ==== | ==== Articles and posts from Martin Fowler ==== | ||
Line 123: | Line 136: | ||
==== Comparison of Open Source ERP Systems ==== | ==== Comparison of Open Source ERP Systems ==== | ||
* [http://www.big.tuwien.ac.at/research/publications/diplomatheses/herzog.pdf A Comparison of Open Source ERP Systems] | * [http://www.big.tuwien.ac.at/research/publications/diplomatheses/herzog.pdf A Comparison of Open Source ERP Systems] | ||
+ | |||
+ | ==== Non IT Technology ==== | ||
+ | * [http://www.horizonfuelcell.com/store/rees.htm Technology of Future] | ||
+ | * [http://netinfo.bg/?tid=40&oid=1062999 Article In Bulgarian] | ||
+ | |||
=== Social networks === | === Social networks === | ||
Line 137: | Line 155: | ||
* [http://www.adempiere.com/wiki/index.php/ADempiere_Institute_%26_Center_of_Excellence ADempiere Institute & Center of Excellence] | * [http://www.adempiere.com/wiki/index.php/ADempiere_Institute_%26_Center_of_Excellence ADempiere Institute & Center of Excellence] | ||
* [https://sourceforge.net/forum/message.php?msg_id=4355888 Making Workflows more predictable] | * [https://sourceforge.net/forum/message.php?msg_id=4355888 Making Workflows more predictable] | ||
+ | * [http://svn.sourceforge.net/adempiere/?rev=2725&view=rev Revision: 2725; Grid Collapse & Horizontal Tab Improve] | ||
* [https://sourceforge.net/tracker/?func=detail&atid=879334&aid=1734897&group_id=176962 Feature Request] | * [https://sourceforge.net/tracker/?func=detail&atid=879334&aid=1734897&group_id=176962 Feature Request] | ||
Adempiere Brazil Localisation effort | Adempiere Brazil Localisation effort | ||
Line 145: | Line 164: | ||
Alvaro Montenegro (amontenegro) | Alvaro Montenegro (amontenegro) | ||
Mario Grigioni (mgrigioni) | Mario Grigioni (mgrigioni) | ||
+ | |||
+ | ==== VERY IMPORTANT ==== | ||
+ | * [http://sourceforge.net/forum/message.php?msg_id=4384940 Structure and idea of Commit Level] | ||
+ | |||
+ | ==== Incoming evenets ==== | ||
+ | Time: 15:00 GMT | ||
+ | Day: Tuesday June 26 | ||
+ | Venue: IRC channel #adempiere-team (on irc.freenode.net) | ||
+ | |||
+ | 1 - Centralized Application Dictionary Management | ||
+ | |||
+ | 2 - The second issue is that developer community is growing and commit committee can't cope with the review of all commits. | ||
+ | |||
+ | ==== 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] | ||
+ | * [https://sourceforge.net/forum/message.php?msg_id=4377879 1-Postcode lookup propsal by Michael Judd] | ||
+ | * [https://sourceforge.net/forum/message.php?msg_id=4377901 2-Postcode lookup propsal by Michael Judd] | ||
+ | * [https://sourceforge.net/forum/message.php?msg_id=4381779 Proposal from Teo] | ||
+ | |||
+ | ==== Developer hints ==== | ||
+ | class dbPort/org.compiere.process.DocActionTemplate shows a template for DocAction, i think that it must be updated. | ||
+ | |||
+ | * [http://www.youtube.com/watch?v=tRHyFODLlUE Video created by Tim; part 1] | ||
+ | * [http://www.youtube.com/watch?v=tRHyFODLlUE Video created by Tim; part 2] | ||
+ | |||
+ | ===== Migration - AD_Element ===== | ||
+ | <pre> | ||
+ | INSERT INTO AD_Element | ||
+ | (AD_Element_ID, AD_Client_ID, AD_Org_ID, IsActive, | ||
+ | Created, CreatedBy, | ||
+ | Cpdated, UpdatedBy, | ||
+ | ColumnName, EntityType, Name, | ||
+ | PrintName | ||
+ | ) | ||
+ | VALUES (500XX, 0, 0, 'Y', | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | '[ColumnNameHere]', 'D', '[NameHere]', | ||
+ | '[PrintNameHere]' | ||
+ | ); | ||
+ | COMMIT; | ||
+ | UPDATE AD_Sequence | ||
+ | SET CurrentNextSys = (SELECT MAX (AD_Element_ID) + 1 | ||
+ | FROM AD_Element | ||
+ | WHERE AD_Element_ID < 1000000) | ||
+ | WHERE NAME = 'AD_Element'; | ||
+ | </pre> | ||
+ | |||
+ | ===== Migration - AD_Column ===== | ||
+ | <pre> | ||
+ | INSERT INTO AD_Column | ||
+ | (AD_Column_ID, AD_Client_ID, AD_Org_ID, IsActive, | ||
+ | Created, | ||
+ | Updated, CreatedBy, | ||
+ | UpdatedBy, Name, Description, VERSION, | ||
+ | EntityType, ColumnName, AD_Table_ID, AD_Reference_ID, | ||
+ | FieldLength, IsKey, IsParent, IsMandatory, IsUpdateable, | ||
+ | IsIdentifier, SeqNo, IsTranslated, IsEncrypted, | ||
+ | isselectioncolumn, ad_element_id, callout, issyncdatabase, | ||
+ | isalwaysupdateable | ||
+ | ) | ||
+ | VALUES (502XX, 0, 0, 'Y', | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | 100, '[NameHere]', '[DescriptionHere]', 1, | ||
+ | 'D', '[ColumnNameHere]', AD_Table_IDHERE, AD_Reference_IDHere, | ||
+ | 1, 'N', 'N', 'Y', 'Y', | ||
+ | 'N', 0, 'N', 'N', | ||
+ | 'N', 50071, '[CalloutHere]', 'N', | ||
+ | 'N' | ||
+ | ); | ||
+ | COMMIT; | ||
+ | UPDATE ad_sequence | ||
+ | SET currentnextsys = (SELECT MAX (ad_column_id) + 1 | ||
+ | FROM ad_column | ||
+ | WHERE ad_column_id < 1000000) | ||
+ | WHERE NAME = 'AD_Column'; | ||
+ | </pre> | ||
+ | |||
+ | ===== Migration - AD_Field ===== | ||
+ | <pre> | ||
+ | INSERT INTO AD_Field | ||
+ | (ad_field_id, ad_client_id, ad_org_id, isactive, | ||
+ | created, createdby, | ||
+ | updated, updatedby, | ||
+ | NAME, description, iscentrallymaintained, seqno, ad_tab_id, | ||
+ | ad_column_id, isdisplayed, displaylength, isreadonly, | ||
+ | issameline, isheading, isfieldonly, isencrypted, entitytype | ||
+ | ) | ||
+ | VALUES (50184, 0, 0, 'Y', | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | 'Store Archive On File System', 'Store Archive On File System', 'Y', 250, 145, | ||
+ | 50214, 'Y', 1, 'N', | ||
+ | 'N', 'N', 'N', 'N', 'D' | ||
+ | ); | ||
+ | COMMIT; | ||
+ | UPDATE ad_sequence | ||
+ | SET currentnextsys = (SELECT MAX (ad_field_id) + 1 | ||
+ | FROM ad_field | ||
+ | WHERE ad_field_id < 1000000) | ||
+ | WHERE NAME = 'AD_Field'; | ||
+ | </pre> | ||
+ | |||
+ | ===== Migration - AD_Message ===== | ||
+ | <pre> | ||
+ | INSERT INTO AD_Message | ||
+ | (AD_Message_ID, AD_Client_ID, AD_Org_ID, IsActive, | ||
+ | Created, CreatedBy, | ||
+ | Updated, UpdatedBy, | ||
+ | Value, MsgText, MsgType | ||
+ | ) | ||
+ | VALUES (500XX, 0, 0, 'Y', | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, | ||
+ | '[VaueHere]','[MSG Text Here]','I' | ||
+ | ); | ||
+ | COMMIT; | ||
+ | UPDATE ad_sequence | ||
+ | SET currentnextsys = (SELECT MAX (ad_message_id) + 1 | ||
+ | FROM ad_message | ||
+ | WHERE ad_message_id < 1000000) | ||
+ | WHERE NAME = 'AD_Message'; | ||
+ | </pre> | ||
+ | |||
+ | ===== Migration - AD_Process_Para ===== | ||
+ | <pre> | ||
+ | INSERT INTO AD_Process_Para | ||
+ | (ad_process_para_id, AD_Client_ID, AD_Org_ID, IsActive, Created, | ||
+ | createdby, updated, updatedby, NAME, | ||
+ | description, | ||
+ | HELP, | ||
+ | ad_process_id, seqno, ad_reference_id, ad_reference_value_id, | ||
+ | ad_val_rule_id, columnname, iscentrallymaintained, fieldlength, | ||
+ | ismandatory, isrange, ad_element_id, entitytype | ||
+ | ) | ||
+ | VALUES (50019, 0, 0, 'Y', TO_DATE ('2007-03-03', 'YYYY-MM-DD'), | ||
+ | 100, TO_DATE ('2007-03-03', 'YYYY-MM-DD'), 100, 'Shipment Date', | ||
+ | 'Date printed on shipment', | ||
+ | 'The Shipment Date indicates the date printed on the shipment.', | ||
+ | 118, 15, 15, NULL, | ||
+ | NULL, 'MovementDate', 'N', 0, | ||
+ | 'Y', 'N', 1037, 'D' | ||
+ | ); | ||
+ | COMMIT; | ||
+ | UPDATE AD_SEQUENCE | ||
+ | SET currentnextsys = (SELECT MAX (ad_process_para_id) + 1 | ||
+ | FROM AD_PROCESS_PARA | ||
+ | WHERE ad_process_para_id < 1000000) | ||
+ | WHERE NAME = 'AD_Process_Para'; | ||
+ | </pre> | ||
+ | |||
+ | ==== License to use for new classes ==== | ||
+ | <pre> | ||
+ | /********************************************************************** | ||
+ | * This file is part of Adempiere ERP Bazaar * | ||
+ | * http://www.adempiere.org * | ||
+ | * * | ||
+ | * Copyright (C) Trifon Trifonov. * | ||
+ | * Copyright (C) Contributors * | ||
+ | * * | ||
+ | * This program is free software; you can redistribute it and/or * | ||
+ | * modify it under the terms of the GNU General Public License * | ||
+ | * as published by the Free Software Foundation; either version 2 * | ||
+ | * of the License, or (at your option) any later version. * | ||
+ | * * | ||
+ | * This program is distributed in the hope that it will be useful, * | ||
+ | * but WITHOUT ANY WARRANTY; without even the implied warranty of * | ||
+ | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * | ||
+ | * GNU General Public License for more details. * | ||
+ | * * | ||
+ | * You should have received a copy of the GNU General Public License * | ||
+ | * along with this program; if not, write to the Free Software * | ||
+ | * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * | ||
+ | * MA 02110-1301, USA. * | ||
+ | * * | ||
+ | * Contributors: * | ||
+ | * - Trifon Trifonov (trifonnt@users.sourceforge.net) * | ||
+ | * * | ||
+ | * Sponsors: * | ||
+ | * - Company (http://www.site.com) * | ||
+ | ***********************************************************************/ | ||
+ | </pre> | ||
+ | |||
+ | ==== Adempiere Export/Import Tools ==== | ||
+ | 2Pack can manage in the XML file the following items: | ||
+ | |||
+ | <table> | ||
+ | <tr><td>2Pack</td><td>ADCK</td></tr> | ||
+ | <tr><td>menu</td><td></td></tr> | ||
+ | <tr><td>window</td><td></td></tr> | ||
+ | <tr><td>tab</td><td></td></tr> | ||
+ | <tr><td>field</td><td></td></tr> | ||
+ | <tr><td>process</td><td></td></tr> | ||
+ | <tr><td>processpara</td><td></td></tr> | ||
+ | <tr><td>table</td><td></td></tr> | ||
+ | <tr><td>column</td><td></td></tr> | ||
+ | <tr><td>impformat</td><td></td></tr> | ||
+ | <tr><td>impformatrow</td><td></td></tr> | ||
+ | <tr><td>printformat</td><td></td></tr> | ||
+ | <tr><td>printformatitem</td><td></td></tr> | ||
+ | <tr><td>reference</td><td></td></tr> | ||
+ | <tr><td>referencelist</td><td></td></tr> | ||
+ | <tr><td>referencetable</td><td></td></tr> | ||
+ | <tr><td>reportview</td><td></td></tr> | ||
+ | <tr><td>reportviewcol</td><td></td></tr> | ||
+ | <tr><td>task</td><td></td></tr> | ||
+ | <tr><td>form</td><td></td></tr> | ||
+ | <tr><td>workbench</td><td></td></tr> | ||
+ | <tr><td>preference</td><td></td></tr> | ||
+ | <tr><td>role</td><td></td></tr> | ||
+ | <tr><td>userrole</td><td></td></tr> | ||
+ | <tr><td>orgrole</td><td></td></tr> | ||
+ | <tr><td>windowaccess</td><td></td></tr> | ||
+ | <tr><td>processaccess</td><td></td></tr> | ||
+ | <tr><td>formaccess</td><td></td></tr> | ||
+ | <tr><td>workflowaccess</td><td></td></tr> | ||
+ | <tr><td>taskaccess</td><td></td></tr> | ||
+ | </table> | ||
+ | |||
=== CRM systems === | === CRM systems === | ||
* [http://www.vtiger.com vTiger] | * [http://www.vtiger.com vTiger] | ||
+ | |||
+ | ==== Comparison of CRM systems ==== | ||
+ | * [http://www.pc101.com/showthread.php?t=3555 interesting post regarding different offers of CRM packages] | ||
+ | |||
+ | ==== Localized in Bulgarian ==== | ||
+ | * [http://dl.sugarforge.org/bgcrm/bgcrm/bg_bgdocuments/README_bg_bg.txt SugarCRM] | ||
+ | |||
=== Tina POS === | === Tina POS === | ||
Line 168: | Line 414: | ||
* [http://s3browse.com/explore/static.springframework.org Amazon S3Browse site] | * [http://s3browse.com/explore/static.springframework.org Amazon S3Browse site] | ||
* [http://blog.interface21.com/main/2007/04/25/uploading-to-amazon-s3-using-a-custom-ant-task/ Uploading to Amazon S3 using a custom ANT task] | * [http://blog.interface21.com/main/2007/04/25/uploading-to-amazon-s3-using-a-custom-ant-task/ Uploading to Amazon S3 using a custom ANT task] | ||
+ | * [http://www.liquibase.org/ Database Refactoring With LiquiBase; DBMS-independent library for tracking, managing and applying database changes; Similar to DDLUtils.] | ||
==== Autocompletion ==== | ==== Autocompletion ==== | ||
Line 178: | Line 425: | ||
==== Eclipse IDE and Application build on Eclipse ==== | ==== Eclipse IDE and Application build on Eclipse ==== | ||
* [http://wiki.eclipse.org/Using_Sourceforge_with_Mylyn Using Sourceforge.net with Mylyn] | * [http://wiki.eclipse.org/Using_Sourceforge_with_Mylyn Using Sourceforge.net with Mylyn] | ||
+ | |||
+ | ==== Script Languages ==== | ||
+ | * [http://www.beanshell.org/examples/actionhandler.html Neanshell, example how to invoke scriped ActionListener Interface] | ||
+ | * [http://www.cs.put.poznan.pl/dweiss/xml/projects/bsh-binding/index.xml?lang=en Dynamic BeanShell binding and ANT tasks] | ||
+ | * [http://www.javaworld.com/javaworld/jw-10-2003/jw-1003-beanshell.html Discover new dimensions of scripted Java] | ||
+ | |||
+ | ==== Java FTP Libraries and Articles ==== | ||
+ | * [http://www.javaworld.com/javaworld/jw-04-2003/jw-0404-ftp.html Java FTP client libraries reviewed] | ||
+ | * [http://www.javaworld.com/javaworld/jw-03-2006/jw-0306-ftp.html Update: Java FTP libraries benchmarked] | ||
+ | * [http://www.amoebacode.com/ftp/ amoebacode FTP Library] | ||
+ | |||
+ | ===== Commercial which support FTPS (FTP Over SSL)===== | ||
+ | * [http://www.example-code.com/java/javaftp.asp Chilkat] | ||
+ | * [http://www.jscape.com/articles/secure_ftp_using_java_ssl.html Secure FTP Factory] | ||
+ | * [http://www.enterprisedt.com/products/edtftpj/overview.html edtFTPj - LGPL for standard FTP.] |
Revision as of 06:58, 14 July 2007
|
Contents
- 1 About Me
- 2 Trifon's Paid Services
- 3 Adempiere trackers
- 4 Adempiere contributions
- 5 Adempiere commit schema
- 6 Interesting bugs/patches
- 7 My favourite readings
About Me
I started my own comapny last year providing Adempiere and Compiere consultancy and development. I like developing business systems. This makes me headache from tme to time, but also makes me very happy when i see system wokring.
As a member of ADempiere Council i like to review patches and SVN commits in order to be sure that code remains stable and system functional. I hope that you have found that i like to help in forums and provide guidance to ADempiere developers how to solve problems they find in their day by day work.
Trifon's Paid Services
Paid Adempiere support
- Need urgent advice for your Adempiere implementation or need to talk with experienced Adempiere developer - call now to get friendly help. Ask for Trifon.
- Price is 0.80 euro per minute
Use Skype Prime service to call now.
Paid EDI @ Adempiere support and training
- If you need training or support for EDI in Adempiere, please do not hesitate to contact me.
- Prices start from 30 Euro per hour.
Java Development
- Development of java applications.
- Please contact me for quotation.
Adempiere trackers
Submited by Trifon and Assigned to Trifon
Assigned to Trifon
Adempiere contributions
Functionality Contributions
EDI @ Adempiere - Sponsored Development: EDI Import/Export
Replication @ Adempiere - Sponsored Development: Replication
- Restrict form "Generate Invoices (manual)" to show only public records (hide locked records) BUG - 1713337
- Restrict form "Generate Shipments (manual)" to show only public records (hide locked records) BUG - 1713317
Planned Contributions and Tasks
Adempiere commit schema
Mentor/Commiter approach approved with 11/11 votes, according to this thread: https://sourceforge.net/forum/forum.php?thread_id=1765233&forum_id=611167
Initial team is:
Mentors:
- Heng Sin
- Teo
- Trifon - (Phib, Ashley )
- Victor
- Karsten
- Carlos
Mentored(Commiters):
- Redhuan
- Bahman
- Johannes
- Phib
- Ashley
- Fer_luck
- Tim (for 2pack)
- Robert Klein
Interesting bugs/patches
- 1721710 Changing BPartner in a completed document should be denied
- 1711594 Workflow is not taking account of "Access All Orgs"
- 1704785 VFile is not firing Vetoable Change
My favourite readings
Interesting
- Variable Costing/Direct Costing/Marginal Costing
- Martin Fowler; Language Workbenches: The Killer-App for Domain Specific Languages?
- Continuous Integration, Source Control, a Wiki and a Bug-Tracker; by ThoughtWorks
Open Source articles
- Will Open Source Developers be Well Paid?
- The Economic Motivation of Open Source Software: Stakeholder Perspectives
OSS Etiquette & Culture
- Mozilla Forum Etiquette
- ArchLinux Forum Etiquette
- WikiMatrix Forum Etiquette
- Forum Etiquette & Rules
Books
Articles and posts from Martin Fowler
Financial based
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=4366156 By: drhayderaziz
I think that Adempiere would get a lot of kudos if Adempiere went the XBRL route www.xbrl.org for financial reporting. For listed companies (and even for unlisted) XBRL will be the way to go especially for any international company that has to consolidate accounts from multiple legal entities in multiple countries in a standardised manner. This would be an essential component of an ERP system in the 2008-2009 time frame. If Adempiere would have its COA structured the XBRL way and have XBRL compliant financial statements at company/consolidated level it would be an AMAZING value proposition to so many organisations.
Comparison of Open Source ERP Systems
Non IT Technology
Social networks
- www.xing.com; Formerly know as openBC; Very strong in Europe
- www.linkedin.com; Emerging at the moment
Adempiere
- Adempiere Foundation
- ADempiere Motto Contest
- Qualification Round ADempiere Motto Contest
- WEB interface from Robert
- Accounting initiative
- Pictures from Adempiere Conference - Berlin 2007
- ADempiere Institute & Center of Excellence
- Making Workflows more predictable
- Revision: 2725; Grid Collapse & Horizontal Tab Improve
- Feature Request
Adempiere Brazil Localisation effort Peope that are cooperating with Adempiere LBR (LBR = Localization Brazil). Those are their names, followed by their sourceforge username.
Eduardo Montenegro (emontenegro) Alvaro Montenegro (amontenegro) Mario Grigioni (mgrigioni)
VERY IMPORTANT
Incoming evenets
Time: 15:00 GMT Day: Tuesday June 26 Venue: IRC channel #adempiere-team (on irc.freenode.net)
1 - Centralized Application Dictionary Management
2 - The second issue is that developer community is growing and commit committee can't cope with the review of all commits.
Postal Code Web Service
- 1741222 Webservice connector for address lookups
- 1-Postcode lookup propsal by Michael Judd
- 2-Postcode lookup propsal by Michael Judd
- Proposal from Teo
Developer hints
class dbPort/org.compiere.process.DocActionTemplate shows a template for DocAction, i think that it must be updated.
Migration - AD_Element
INSERT INTO AD_Element (AD_Element_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Cpdated, UpdatedBy, ColumnName, EntityType, Name, PrintName ) VALUES (500XX, 0, 0, 'Y', TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, '[ColumnNameHere]', 'D', '[NameHere]', '[PrintNameHere]' ); COMMIT; UPDATE AD_Sequence SET CurrentNextSys = (SELECT MAX (AD_Element_ID) + 1 FROM AD_Element WHERE AD_Element_ID < 1000000) WHERE NAME = 'AD_Element';
Migration - AD_Column
INSERT INTO AD_Column (AD_Column_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, Updated, CreatedBy, UpdatedBy, Name, Description, VERSION, EntityType, ColumnName, AD_Table_ID, AD_Reference_ID, FieldLength, IsKey, IsParent, IsMandatory, IsUpdateable, IsIdentifier, SeqNo, IsTranslated, IsEncrypted, isselectioncolumn, ad_element_id, callout, issyncdatabase, isalwaysupdateable ) VALUES (502XX, 0, 0, 'Y', TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, 100, '[NameHere]', '[DescriptionHere]', 1, 'D', '[ColumnNameHere]', AD_Table_IDHERE, AD_Reference_IDHere, 1, 'N', 'N', 'Y', 'Y', 'N', 0, 'N', 'N', 'N', 50071, '[CalloutHere]', 'N', 'N' ); COMMIT; UPDATE ad_sequence SET currentnextsys = (SELECT MAX (ad_column_id) + 1 FROM ad_column WHERE ad_column_id < 1000000) WHERE NAME = 'AD_Column';
Migration - AD_Field
INSERT INTO AD_Field (ad_field_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, NAME, description, iscentrallymaintained, seqno, ad_tab_id, ad_column_id, isdisplayed, displaylength, isreadonly, issameline, isheading, isfieldonly, isencrypted, entitytype ) VALUES (50184, 0, 0, 'Y', TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, 'Store Archive On File System', 'Store Archive On File System', 'Y', 250, 145, 50214, 'Y', 1, 'N', 'N', 'N', 'N', 'N', 'D' ); COMMIT; UPDATE ad_sequence SET currentnextsys = (SELECT MAX (ad_field_id) + 1 FROM ad_field WHERE ad_field_id < 1000000) WHERE NAME = 'AD_Field';
Migration - AD_Message
INSERT INTO AD_Message (AD_Message_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, MsgText, MsgType ) VALUES (500XX, 0, 0, 'Y', TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, TO_DATE ('02/26/2007 12:30:00', 'MM/DD/YYYY HH24:MI:SS'), 100, '[VaueHere]','[MSG Text Here]','I' ); COMMIT; UPDATE ad_sequence SET currentnextsys = (SELECT MAX (ad_message_id) + 1 FROM ad_message WHERE ad_message_id < 1000000) WHERE NAME = 'AD_Message';
Migration - AD_Process_Para
INSERT INTO AD_Process_Para (ad_process_para_id, AD_Client_ID, AD_Org_ID, IsActive, Created, createdby, updated, updatedby, NAME, description, HELP, ad_process_id, seqno, ad_reference_id, ad_reference_value_id, ad_val_rule_id, columnname, iscentrallymaintained, fieldlength, ismandatory, isrange, ad_element_id, entitytype ) VALUES (50019, 0, 0, 'Y', TO_DATE ('2007-03-03', 'YYYY-MM-DD'), 100, TO_DATE ('2007-03-03', 'YYYY-MM-DD'), 100, 'Shipment Date', 'Date printed on shipment', 'The Shipment Date indicates the date printed on the shipment.', 118, 15, 15, NULL, NULL, 'MovementDate', 'N', 0, 'Y', 'N', 1037, 'D' ); COMMIT; UPDATE AD_SEQUENCE SET currentnextsys = (SELECT MAX (ad_process_para_id) + 1 FROM AD_PROCESS_PARA WHERE ad_process_para_id < 1000000) WHERE NAME = 'AD_Process_Para';
License to use for new classes
/********************************************************************** * This file is part of Adempiere ERP Bazaar * * http://www.adempiere.org * * * * Copyright (C) Trifon Trifonov. * * Copyright (C) Contributors * * * * This program is free software; you can redistribute it and/or * * modify it under the terms of the GNU General Public License * * as published by the Free Software Foundation; either version 2 * * of the License, or (at your option) any later version. * * * * This program is distributed in the hope that it will be useful, * * but WITHOUT ANY WARRANTY; without even the implied warranty of * * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * * GNU General Public License for more details. * * * * You should have received a copy of the GNU General Public License * * along with this program; if not, write to the Free Software * * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * * MA 02110-1301, USA. * * * * Contributors: * * - Trifon Trifonov (trifonnt@users.sourceforge.net) * * * * Sponsors: * * - Company (http://www.site.com) * ***********************************************************************/
Adempiere Export/Import Tools
2Pack can manage in the XML file the following items:
2Pack | ADCK |
menu | |
window | |
tab | |
field | |
process | |
processpara | |
table | |
column | |
impformat | |
impformatrow | |
printformat | |
printformatitem | |
reference | |
referencelist | |
referencetable | |
reportview | |
reportviewcol | |
task | |
form | |
workbench | |
preference | |
role | |
userrole | |
orgrole | |
windowaccess | |
processaccess | |
formaccess | |
workflowaccess | |
taskaccess |
CRM systems
Comparison of CRM systems
Localized in Bulgarian
Tina POS
Compiere
My opinion is that this is very outdated information, but who knows...
HTML/CSS
- Dynamic Proxy
- Example Adempiere JPA persistance
- Configuring Inheritance for a JPA Entity; Explanation why Teo likes DiscriminatorColumn
- Hello world with standalone java persistance
- Java Performance Tuning
- Amazon S3Browse site
- Uploading to Amazon S3 using a custom ANT task
- Database Refactoring With LiquiBase; DBMS-independent library for tracking, managing and applying database changes; Similar to DDLUtils.
Autocompletion
Portal, JCR, ECM, Groupware
Eclipse IDE and Application build on Eclipse
Script Languages
- Neanshell, example how to invoke scriped ActionListener Interface
- Dynamic BeanShell binding and ANT tasks
- Discover new dimensions of scripted Java