Difference between revisions of "User:Racd"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
(My Notes)
(Tips for changing SQL Sevrver db compatibility using a sp command)
 
(32 intermediate revisions by 2 users not shown)
Line 8: Line 8:
  
 
==My Background==
 
==My Background==
*Place Of Bith: Parit Sulong, Batu Pahat, Johor, Malaysia
+
*Place Of Birth: Parit Sulong, Batu Pahat, Johor, Malaysia
 
*Date of Birth: 28 Jun 1981
 
*Date of Birth: 28 Jun 1981
  
Line 16: Line 16:
 
**Sekolah Menengah Teknik Batu Pahat (SMTBP) form 4 & form 5  
 
**Sekolah Menengah Teknik Batu Pahat (SMTBP) form 4 & form 5  
 
*Matriculation Program : Chermai College, Bahau, Negeri Sembilan
 
*Matriculation Program : Chermai College, Bahau, Negeri Sembilan
*Bachelor Science Hons(Information Technology): University Of Mara Technology
+
*Bachelor Science Hons(Information Technology): [http://www.uitm.edu.my/uitm/ University Of Mara Technology]
  
==My Notes==
+
==My Online Notes==
''How to migrate adempiere database to the latest version?''
+
====Overall About Adempiere====
''About language translation
+
 
 +
*1. What is Adempiere?
 +
**Adempiere is open source, fully integrated ERP, CRM, supply chain management and accounting software. ''[http://www.adempiere.com/wiki/index.php/Adempiere_Structure More about Adempiere..]''
 +
 
 +
 
 +
*2.''What is COA?''
 +
 
 +
 
 +
*3. How to install Adempiere?
 +
**The Installation steps of Adempiere can be summarized as below.
 +
***Install Java
 +
***Install Database
 +
***Install Adempiere
 +
***Setup Adempiere
 +
***Create Adempiere database
 +
***Server Setup
 +
**''For further explaination can be refer to''
 +
***''[http://www.adempiere.com/wiki/index.php/Installation_Steps Installation Steps]''
 +
***''[http://www.adempiere.com/wiki/index.php/ADempiere_Install_Linux%26PostgreSQL ADempiere_Install_Linux & PostgreSQL]''
 +
***''[http://www.adempiere.com/wiki/index.php/Adempiere_Install_WinXp Adempiere Install WinXp]''
 +
***''[http://www.adempiere.com/wiki/index.php/How_to_Install_ADempiere_on_P-Series_with_IBM_JAVA_%26_SLES_64bit How to Install ADempiere on P-Series with IBM JAVA & SLES 64bit]''
 +
***''[http://www.adempiere.com/wiki/index.php/How_to_install_Adempiere_with_Postgres_on_MacOSX_10.5 How to install Adempiere with Postgres on MacOSX 10.5]''
 +
 
 +
 
 +
 
 +
*4. How to create new Client?
 +
**After we have complete the installation, we need to do initial client setup in order to create new client in our Adempiere application. Adempiere default installation will only have one default client that is "Garden World" as a sample client. Read at the below links to learn more about [http://www.adempiere.com/wiki/index.php/ManPageX_InitialClientSetup#Contributions Initial Client Setup].
 +
 
 +
*''How to setup Master Data?''
 +
*''Adempiere Process Flow''
 +
 
 +
 
 +
====Customization====
 +
*[http://www.adempiere.com/wiki/index.php/Eclipse_Setup Eclipse Setup]
 +
*[[Creating New Window.]]
 +
*[http://www.adempiere.com/wiki/index.php/User:Ijam_duo/Tech%26Functional_Training Adempiere Functional and Techinacal Training Menu]
 +
*[http://www.adempiere.com/wiki/index.php?title=User:Racd/Malay_Translation Adempiere Bahasa Melayu Translation]
 +
*''How to migrate adempiere database to the latest version?''
 +
*''How to Compile Adempiere Source Code?''
 +
*''About Language Translation.''
  
 
==My Outstanding Project==
 
==My Outstanding Project==
''Adempiere Civil Works''
+
[[Image:CivilWorks.jpg|thumb|Under Construction]]
 +
===Adempiere Civil Works===
 +
Nearly three years ago i has been introduce with Compiere during i am working in one of IT company in Malaysia. From there i am falling love with compiere. One of my best work is customizing compiere to suit with Construction Business Flow. Now i am trying to put this construction module together with Adempiere. I am sure it will be my best contribution to Admepiere. To suit with construction business flow, me with help from a few friends, has successfully added some new modules.
 +
 
 +
*Project Budget
 +
*Bill Of Quantity
 +
*SubContractor Letter Of Award
 +
*SubContractor Progress Claim Record
 +
*Clinet Progress Claim Record
 +
 
 +
...download my documentation for more detail of my project here.
 +
http://adempiere.red1.org/racd/construction/construction.zip
 +
 
 +
or go to this link to know the whole story of this project
 +
http://www.adempiere.com/wiki/index.php/CivilWorks
 +
 
 +
 
 +
==Adempiere Implementation from my Perspective==
 +
 
 +
===''Implementation Process''===
 +
 +
*Requirement study
 +
Its will be great if the customer can provide the team with complete of their Business Process Flow. The customer must also give detail explanation on the business process in term of
 +
** Purchasing
 +
** Sales
 +
** Settlement of an open items
 +
** Customer invoice
 +
** Vendor invoice
 +
** Salary
 +
** Others bills etc: electricity, phone
 +
** Financial Report
 +
*** What type of report to produce by the system?
 +
*** What is the contents of the report?
 +
*** Sample of current financial report?
 +
** Chart of Account 
 +
*** Customer should also give the team with the actual COA to be used by the system.
 +
 +
 +
*Customer requirement and Adempiere module analysis
 +
Try to match the customer business process with the adempiere Module base on the requirement study. It will be great if less customization required during the implementation.
 +
 +
 +
*Installation and implementation 
 +
Installed adempiere and implement it base on the user requierement
 +
 +
 +
*Parallel Run
 +
Use adempiere that implemented and try to compare the end result with the actual result which use the normal process
 +
 +
 +
*Customization
 +
Customization on adempiere if required in order to fulfill user requirement.
 +
 
 +
==Other Stories Of My Life==
 +
====Tips for changing SQL Sevrver db compatibility using a sp command====
 +
 
 +
*''[http://blog.netnerds.net/2006/05/sql-65-compatability-in-sql-server-2005/ SQL: 6.5 Compatibility in SQL Server 2005]''
 +
**Reports the current compatibility level of 'MyDBName [ EXEC sp_dbcmptlevel 'MyDBName';GO ]
 +
**Changes it to SQL 2000 - 80 [ EXEC sp_dbcmptlevel 'MyDBName', '80';GO ]
 +
**Changes it to SQL 2005 - 90 [ EXEC sp_dbcmptlevel 'MyDBName', '90';GO ]
 +
 
 +
====How to backup and restore SQL Server 2000 database====
 +
*''[http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EHMAC SQL Server 2000 Backup and Restore]''

Latest revision as of 19:12, 7 May 2008

Name This user real name is : Mohd rasidi sareh
Sourceforge logo.png This user has a Sourceforge account.


My Background

  • Place Of Birth: Parit Sulong, Batu Pahat, Johor, Malaysia
  • Date of Birth: 28 Jun 1981

Study Background

  • Primary School: Sekolah Kebangsaan Parit Sulong
  • Secondary School: Sekolah Menengah Dato Sulaiman (SMDS) form 1 - form 3
    • Sekolah Menengah Teknik Batu Pahat (SMTBP) form 4 & form 5
  • Matriculation Program : Chermai College, Bahau, Negeri Sembilan
  • Bachelor Science Hons(Information Technology): University Of Mara Technology

My Online Notes

Overall About Adempiere

  • 1. What is Adempiere?
    • Adempiere is open source, fully integrated ERP, CRM, supply chain management and accounting software. More about Adempiere..


  • 2.What is COA?



  • 4. How to create new Client?
    • After we have complete the installation, we need to do initial client setup in order to create new client in our Adempiere application. Adempiere default installation will only have one default client that is "Garden World" as a sample client. Read at the below links to learn more about Initial Client Setup.
  • How to setup Master Data?
  • Adempiere Process Flow


Customization

My Outstanding Project

Under Construction

Adempiere Civil Works

Nearly three years ago i has been introduce with Compiere during i am working in one of IT company in Malaysia. From there i am falling love with compiere. One of my best work is customizing compiere to suit with Construction Business Flow. Now i am trying to put this construction module together with Adempiere. I am sure it will be my best contribution to Admepiere. To suit with construction business flow, me with help from a few friends, has successfully added some new modules.

  • Project Budget
  • Bill Of Quantity
  • SubContractor Letter Of Award
  • SubContractor Progress Claim Record
  • Clinet Progress Claim Record

...download my documentation for more detail of my project here. http://adempiere.red1.org/racd/construction/construction.zip

or go to this link to know the whole story of this project http://www.adempiere.com/wiki/index.php/CivilWorks


Adempiere Implementation from my Perspective

Implementation Process

  • Requirement study

Its will be great if the customer can provide the team with complete of their Business Process Flow. The customer must also give detail explanation on the business process in term of

    • Purchasing
    • Sales
    • Settlement of an open items
    • Customer invoice
    • Vendor invoice
    • Salary
    • Others bills etc: electricity, phone
    • Financial Report
      • What type of report to produce by the system?
      • What is the contents of the report?
      • Sample of current financial report?
    • Chart of Account
      • Customer should also give the team with the actual COA to be used by the system.


  • Customer requirement and Adempiere module analysis

Try to match the customer business process with the adempiere Module base on the requirement study. It will be great if less customization required during the implementation.


  • Installation and implementation

Installed adempiere and implement it base on the user requierement


  • Parallel Run

Use adempiere that implemented and try to compare the end result with the actual result which use the normal process


  • Customization

Customization on adempiere if required in order to fulfill user requirement.

Other Stories Of My Life

Tips for changing SQL Sevrver db compatibility using a sp command

  • SQL: 6.5 Compatibility in SQL Server 2005
    • Reports the current compatibility level of 'MyDBName [ EXEC sp_dbcmptlevel 'MyDBName';GO ]
    • Changes it to SQL 2000 - 80 [ EXEC sp_dbcmptlevel 'MyDBName', '80';GO ]
    • Changes it to SQL 2005 - 90 [ EXEC sp_dbcmptlevel 'MyDBName', '90';GO ]

How to backup and restore SQL Server 2000 database