iDempiere en - User contributions [en]

Default behavior

2024-10-22T22:28:11Z

Kriegfrj: /* Open window */ Spelling update.

__FORCETOC__

= Window =
== Open window ==
* Sometimes when you open a window (From menu or favorite) it can open in either "new record" mode or "view old record" mode:

{|style="margin: 0 auto;"
| [[Image:Open_window_new_record.jpg|300px|left|alt:Open with new state]]
| [[Image:Open_window_view_old_record.jpg|300px|alt:left|Open with view state]]
|}

'''What is the logic for the mode in which the window will open?'''
<pre>
SELECT
COUNT(*)
FROM
C_Order
WHERE
((C_Order.IsSOTrx='Y')) AND
(Processed='N' OR Updated>SysDate-1) AND
C_Order.AD_Client_ID IN(0,11) AND
C_Order.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND
(C_Order.C_Order_ID IS NULL OR C_Order.C_Order_ID NOT IN (
SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )
)
</pre>

It's easy.
Before iDempiere opens the window, it will run the above count query.
When the count is 0, the window will open in the "new record" mode.
When count > 0, the window will open in "view old record" mode.

Logic of default query for document is simple: display unprocessed record or processed in preview day

* In some windows, you see the search panel when you open the window:
{|style="margin: 0 auto;"
| [[Image:Open_window_search_record.jpg|300px|left|alt:Open with search state]]
| [[Image:Open_window_search_record_setup.jpg|300px|left|alt:Open with search state setup]]
|}

Why? How do you make other windows have same behavior? What does it mean?
Just check "High Volume" in "Table and Column" window as per the above image.
This setting tells iDempiere that the table has a lot records, so it should open in search mode.

= Server =
== Auto switch to https when access to [server]/idempiereMonitor ==
Anytime, when you access to idempiereMonitor, server always use https protocol.

this feature setup by <transport-guarantee>CONFIDENTIAL</transport-guarantee> in web.xml in "org.adempiere.server"

just google if you want to more understand about it.

1. what's issue with this behavior

This default behavior just do well util you setup a proxy like haproxy with "SSL Termination" model and port of proxy difference port of application.

example:

<pre>
I setup haproxy listen at port 80 for http and 443 for https

I setup idempiere listen at port 8080 for http and 8443 for https

haproxy will process ssl, so connection from haproxy to idempiere always on http
</pre>

now, every time i access to [server_name]/idempiereMonitor it always redirect to [server_name]:8443/idempiereMonitor

by security, i just open port 443, so can't access to idempiereMonitor

2. how to resolve it?

setup proxy and web app do same https port, it also mean you have to setup haproxy on separate server.

if you setup idempiere run on port 443 you have to run idempiere with root right.

so i prefer to complete remove config "transport-guarantee", it's safe when I already idempiere behind https.

= TOOL =
== Create line from ==
On invoice window, when run "Create line from", value of "Payment Rule" update follow to "Payment Rule" of Order.

this change hide from end user, it's better to highlight this kind of fields get this kind of change.

[[Category: HowTo-Technical]]

Default behavior

2024-10-22T22:27:00Z

Kriegfrj: /* Open window */ Grammar tidy-up.

__FORCETOC__

= Window =
== Open window ==
* Sometimes when you open a window (From menu or favorite) it can open in either "new record" mode or "view old record" mode:

{|style="margin: 0 auto;"
| [[Image:Open_window_new_record.jpg|300px|left|alt:Open with new state]]
| [[Image:Open_window_view_old_record.jpg|300px|alt:left|Open with view state]]
|}

'''What is the logic for the mode in which the window will open?'''
<pre>
SELECT
COUNT(*)
FROM
C_Order
WHERE
((C_Order.IsSOTrx='Y')) AND
(Processed='N' OR Updated>SysDate-1) AND
C_Order.AD_Client_ID IN(0,11) AND
C_Order.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND
(C_Order.C_Order_ID IS NULL OR C_Order.C_Order_ID NOT IN (
SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )
)
</pre>

It's easy.
Before iDempiere opens the window, it will run the above count query.
When the count is 0, the window willl open in the "new record" mode.
When count > 0, the window will open in "view old record" mode.

Logic of default query for document is simple: display unprocessed record or processed in preview day

* In some windows, you see the search panel when you open the window:
{|style="margin: 0 auto;"
| [[Image:Open_window_search_record.jpg|300px|left|alt:Open with search state]]
| [[Image:Open_window_search_record_setup.jpg|300px|left|alt:Open with search state setup]]
|}

Why? How do you make other windows have same behavior? What does it mean?
Just check "High Volume" in "Table and Column" window as per the above image.
This setting tells iDempiere that the table has a lot records, so it should open in search mode.

= Server =
== Auto switch to https when access to [server]/idempiereMonitor ==
Anytime, when you access to idempiereMonitor, server always use https protocol.

this feature setup by <transport-guarantee>CONFIDENTIAL</transport-guarantee> in web.xml in "org.adempiere.server"

just google if you want to more understand about it.

1. what's issue with this behavior

This default behavior just do well util you setup a proxy like haproxy with "SSL Termination" model and port of proxy difference port of application.

example:

<pre>
I setup haproxy listen at port 80 for http and 443 for https

I setup idempiere listen at port 8080 for http and 8443 for https

haproxy will process ssl, so connection from haproxy to idempiere always on http
</pre>

now, every time i access to [server_name]/idempiereMonitor it always redirect to [server_name]:8443/idempiereMonitor

by security, i just open port 443, so can't access to idempiereMonitor

2. how to resolve it?

setup proxy and web app do same https port, it also mean you have to setup haproxy on separate server.

if you setup idempiere run on port 443 you have to run idempiere with root right.

so i prefer to complete remove config "transport-guarantee", it's safe when I already idempiere behind https.

= TOOL =
== Create line from ==
On invoice window, when run "Create line from", value of "Payment Rule" update follow to "Payment Rule" of Order.

this change hide from end user, it's better to highlight this kind of fields get this kind of change.

[[Category: HowTo-Technical]]

Installing from Installers

2018-04-17T02:41:33Z

Kriegfrj: /* Import the Database */ Made note about Oracle as well.

⇐
[[Installing_iDempiere|Table of Contents]] |
[[Downloading Installers]] |
Installing from Installers |
[[Running iDempiere from Installers]]
⇒


== Install Server ==

* Unzip the server installer you downloaded or created, for example:
cd $IDEMPIERE_HOME
unzip idempiereServer.gtk.linux.x86_64.zip
* Navigate to the idempiere-server folder, for example
cd $IDEMPIERE_HOME/idempiere.gtk.linux.x86_64/idempiere-server

=== Graphical ===

You can run:
sh setup.sh
or
sh setup-alt.sh

* You can fill the parameters as shown in the screenshot, or with your own preferred values, specially you must take care of the following:
** iDempiere Home: This is the repository folder
** Web Port / SSL: be careful to not use a port that is already used by another application, in linux ports below 1000 cannot be used by non-root users. For example port 8080 is used by Oracle-XE
** DB Already Exists: in common installation you must leave this flag unchecked as the database will be created later
** Database Name: here we fill with the name of the database you want to create
** DB Admin Password: must be filled with the postgres password you set up in the [[Install_Prerequisites#Assign_a_password_to_user_postgres|prerequisites]]
** Database User: this is a user to be created, it is recommended you keep it as the default adempiere
** Database Password: fill here with the password you want to assign to the database

[[Image:Screenshot-Adempiere_Server_Setup.png]]

And finally push the Save button, if something fails the Save button will be disabled and the failing option is marked in red, in order to re-enable the Save button you must push the Test button until all errors are gone.
The only '''valid error''' in red is in front of Database Password field when the database is still not created.

==== Differences for Oracle ====

On oracle some fields must be filled slightly different:
** Database Name: here you must fill the name of the oracle instance (usually xe or orcl)
** DB Admin Password: must be filled with the SYSTEM password you set when installing oracle
** Database User: in oracle you can define your preferred user here
** Database Password: fill here with the password you want to assign to the database

=== Console ===

sh console-setup.sh
or
sh console-setup-alt.sh

This is to be used when you don't have a graphical environment, in this case the parameters are shown in screen and you must fill them directly with the keyboard.

== Import the Database ==

This is the default way to import the database for oracle (11g or 12c) and postgresql 9.1 or higher:

After setting up the server (is a prerequisite) you can run:

cd utils
sh RUN_ImportIdempiere.sh

'''Note: In order for the above import script to work, you need to make sure that you have the <tt>jar</tt> and <tt>psql</tt> or Oracle executables on your path.'''

''This tutorial is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [http://globalqss.com GlobalQSS]. Feel free to improve directly or suggest using the Discussion tab.

[[Category:User Manual]]
[[Category:Installation|L]]
[[Category:Installation Installer]]
[[Category:Installation Linux]]
[[Category:Installation Windows]]
[[Category:Installation Server]]
[[Category:Installation Database]]

Installing from Installers

2018-04-17T02:40:58Z

Kriegfrj: /* Import the Database */ Fixed formatting to make it more noticable.

⇐
[[Installing_iDempiere|Table of Contents]] |
[[Downloading Installers]] |
Installing from Installers |
[[Running iDempiere from Installers]]
⇒


== Install Server ==

* Unzip the server installer you downloaded or created, for example:
cd $IDEMPIERE_HOME
unzip idempiereServer.gtk.linux.x86_64.zip
* Navigate to the idempiere-server folder, for example
cd $IDEMPIERE_HOME/idempiere.gtk.linux.x86_64/idempiere-server

=== Graphical ===

You can run:
sh setup.sh
or
sh setup-alt.sh

* You can fill the parameters as shown in the screenshot, or with your own preferred values, specially you must take care of the following:
** iDempiere Home: This is the repository folder
** Web Port / SSL: be careful to not use a port that is already used by another application, in linux ports below 1000 cannot be used by non-root users. For example port 8080 is used by Oracle-XE
** DB Already Exists: in common installation you must leave this flag unchecked as the database will be created later
** Database Name: here we fill with the name of the database you want to create
** DB Admin Password: must be filled with the postgres password you set up in the [[Install_Prerequisites#Assign_a_password_to_user_postgres|prerequisites]]
** Database User: this is a user to be created, it is recommended you keep it as the default adempiere
** Database Password: fill here with the password you want to assign to the database

[[Image:Screenshot-Adempiere_Server_Setup.png]]

And finally push the Save button, if something fails the Save button will be disabled and the failing option is marked in red, in order to re-enable the Save button you must push the Test button until all errors are gone.
The only '''valid error''' in red is in front of Database Password field when the database is still not created.

==== Differences for Oracle ====

On oracle some fields must be filled slightly different:
** Database Name: here you must fill the name of the oracle instance (usually xe or orcl)
** DB Admin Password: must be filled with the SYSTEM password you set when installing oracle
** Database User: in oracle you can define your preferred user here
** Database Password: fill here with the password you want to assign to the database

=== Console ===

sh console-setup.sh
or
sh console-setup-alt.sh

This is to be used when you don't have a graphical environment, in this case the parameters are shown in screen and you must fill them directly with the keyboard.

== Import the Database ==

This is the default way to import the database for oracle (11g or 12c) and postgresql 9.1 or higher:

After setting up the server (is a prerequisite) you can run:

cd utils
sh RUN_ImportIdempiere.sh

'''Note: In order for the above import script to work, you need to make sure that you have the <tt>jar</tt> and <tt>psql</tt> executables on your path.'''

''This tutorial is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [http://globalqss.com GlobalQSS]. Feel free to improve directly or suggest using the Discussion tab.

[[Category:User Manual]]
[[Category:Installation|L]]
[[Category:Installation Installer]]
[[Category:Installation Linux]]
[[Category:Installation Windows]]
[[Category:Installation Server]]
[[Category:Installation Database]]

Installing from Installers

2018-04-17T02:38:17Z

Kriegfrj: /* Import the Database */ Added a note about needing the executables on your shell path.

⇐
[[Installing_iDempiere|Table of Contents]] |
[[Downloading Installers]] |
Installing from Installers |
[[Running iDempiere from Installers]]
⇒


== Install Server ==

* Unzip the server installer you downloaded or created, for example:
cd $IDEMPIERE_HOME
unzip idempiereServer.gtk.linux.x86_64.zip
* Navigate to the idempiere-server folder, for example
cd $IDEMPIERE_HOME/idempiere.gtk.linux.x86_64/idempiere-server

=== Graphical ===

You can run:
sh setup.sh
or
sh setup-alt.sh

* You can fill the parameters as shown in the screenshot, or with your own preferred values, specially you must take care of the following:
** iDempiere Home: This is the repository folder
** Web Port / SSL: be careful to not use a port that is already used by another application, in linux ports below 1000 cannot be used by non-root users. For example port 8080 is used by Oracle-XE
** DB Already Exists: in common installation you must leave this flag unchecked as the database will be created later
** Database Name: here we fill with the name of the database you want to create
** DB Admin Password: must be filled with the postgres password you set up in the [[Install_Prerequisites#Assign_a_password_to_user_postgres|prerequisites]]
** Database User: this is a user to be created, it is recommended you keep it as the default adempiere
** Database Password: fill here with the password you want to assign to the database

[[Image:Screenshot-Adempiere_Server_Setup.png]]

And finally push the Save button, if something fails the Save button will be disabled and the failing option is marked in red, in order to re-enable the Save button you must push the Test button until all errors are gone.
The only '''valid error''' in red is in front of Database Password field when the database is still not created.

==== Differences for Oracle ====

On oracle some fields must be filled slightly different:
** Database Name: here you must fill the name of the oracle instance (usually xe or orcl)
** DB Admin Password: must be filled with the SYSTEM password you set when installing oracle
** Database User: in oracle you can define your preferred user here
** Database Password: fill here with the password you want to assign to the database

=== Console ===

sh console-setup.sh
or
sh console-setup-alt.sh

This is to be used when you don't have a graphical environment, in this case the parameters are shown in screen and you must fill them directly with the keyboard.

== Import the Database ==

This is the default way to import the database for oracle (11g or 12c) and postgresql 9.1 or higher:

After setting up the server (is a prerequisite) you can run:

cd utils
sh RUN_ImportIdempiere.sh

''Note'': In order for the above import script to work, you need to make sure that you have the <tt>jar</tt> and <tt>psql</tt> executables on your executable path.

''This tutorial is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [http://globalqss.com GlobalQSS]. Feel free to improve directly or suggest using the Discussion tab.

[[Category:User Manual]]
[[Category:Installation|L]]
[[Category:Installation Installer]]
[[Category:Installation Linux]]
[[Category:Installation Windows]]
[[Category:Installation Server]]
[[Category:Installation Database]]