Integrated Resource Planning System IRPS

ERPNext Home Page

Frepple Integration

Barcode Scanning System

Autocount

SQL Account

For Frepple User

In order to utilise the full integration between ERPNext and Frepple, you will need a running instance of Frepple software. To install Frepple software in both Windows and Linux refer to this document.

For ERPNext User

1. Integrated Resource Planning System IRPS

1. Prerequisites:

   • Windows: Docker Desktop
   • Ubuntu: Docker Engine, Docker Compose
   • Mac: Docker Desktop

2. The installation of this release includes the following:

   • ERPNext Version 12
   • Metabase Integration
   • Telegram Integration
   • Enhanced Frepple Integration
   • Barcode Scanning System
   • Autocount
   • SQL Account

3. For Windows & MacOS user, start from Section 3.

4. For Ubuntu user, start from Section 4.

2. Pre-Setup: Windows/MacOS

1. The setup guide is tested to work on Windows 10, Ubuntu 18.04 and macOS Mojave 10.14.6

2. For Windows and MacOS, create a folder.

3. Open a Powershell terminal, navigate to the newly created folder.

4. Go to Section 5: Setup.

4. Pre-Setup: Ubuntu

1. Open a terminal.

2. Create a user called frappe. (You can give a name of your preference to replace frappe)

   • sudo adduser frappe

3. You may be promted to give a password for the newly created user frappe. Remember this password, you will need it for the next step.

4. Log into the user frappe

   • su - frappe

5. Create a folder called frappe_docker. Again, folder name is of your preference. Navigate into the new directory.

   • mkdir frappe_docker
   • cd frappe_docker

6. Go to Section 5: Setup.

5. Setup

1. Clone this repo.

   • git clone https://github.com/msf4-0/ERPNext_version-12_update-1.2.git

2. Navigate to the cloned folder.

   • cd ERPNext_version-12_update-1.2

3. In enx-example, you can change the variables that would be used in this installation process to your preference such as the following:

   • Server port to host ERPNext,ERPNEXT_SERVER_PORT. Default is 8000.
   • Database port,MARIADB_SERVER_PORT. Default is 3306.
   • Site name SITE_NAME. Default is custom-erpnext-nginx.

   Note:

   • You can leave these variables as it's provided if all the specified ports are not occupied.
   • Upon successful setup, you can access ERPNext via port number ERPNEXT_SERVER_PORT.
   • For Metabase Integration, you would need to connect to Mariadb via MARIADB_SERVER_PORT.

4. Copy environment variables from the env-example file into .env file using this command cp env-example .env.

5. Start all the docker containers by this command docker-compose -p <project_name> up -d.

   Note:

   • Replace <project_name> to your preference.
   • For example, docker-compose -p project1 up -d

6. Monitor the site creation progress by logging into the <project_name>-site-creator-1 container. To do this step, use this command docker logs <project_name>-site-creator-1 -f.

   Note:

   • Replace <project_name> to the same project name as in step 4.
   • For example, docker logs project1-site-creator-1 -f.
   • If you face no such container error, try with docker logs project1-site-creator_1 -f or docker logs project1_site-creator_1 -f.

7. After the <project_name>-site-creator-1 container display Scheduler is disabled, To update some of the files (currently updated; Sales Order, Sales Order Item and Delivery Stop), use this command:

   • docker cp <local_file_path> <container_name>-erpnext-python-1:<container_file_path>

This is some of the container file path for sales_order, and sales_order_item, delivery_stop.

- sales_order file: `docker cp <local_file_path>\sales_order.json <container_name>-erpnext-python-1:\home\frappe\frappe-bench\apps\erpnext\erpnext\selling\doctype\sales_order`

- sales_order_item file: `docker cp <local_file_path>\sales_order_item.json <container_name>-erpnext-python-1:\home\frappe\frappe bench\apps\erpnext\erpnext\selling\doctype\sales_order_item`

- delivery_stop file: `docker cp <local_file_path>\delivery_stop.json <container_name>-erpnext-python-1:\home\frappe\frappe-bench\apps\erpnext\erpnext\stock\doctype\delivery_stop`

- job_card file:`docker cp erpnext\manufacturing\doctype\job_card\job_card.json <project_name>-erpnext-python-1:\home\frappe\frappe-bench\apps\erpnext\erpnext\manufacturing\doctype\job_card`

Note: - Replace <project_name> to the same project name as in step 4. - Replace <local_file_path> to your local file's path - For example, docker cp erpnext\selling\doctype\sales_order\sales_order.json project1-erpnext-python-1:\home\frappe\frappe-bench\apps\erpnext\erpnext\selling\doctype\sales_order

8. Now get back to the root directory by running cd ... Now login to <project_name>-erpnext-python-1 container. Use docker exec -it --user root <project_name>-erpnext-python-1 /bin/bash to login into this container as a root user.

   Note:

   • Replace <project_name> to the same project name selected in step 4.
   • For example, docker exec -it --user root project1-erpnext-python-1 /bin/bash.
   • If you face no such container error, try with docker exec -it --user root project1-erpnext-python_1 /bin/bash or docker exec -it --user root project1_erpnext-python_1 /bin/bash.

9. Once you login in into <project_name>-erpnext-python-1 container, by default, you will be in the ~:/home/frappe/frappe-bench/sites directory. Navigate out to ~:/home/frappe/frappe-bench directory by typing cd ...

10. Now, apply the new changes in Frepple app by running this command bench --site <site_name> migrate.

    Note:

    • Replace <site_name> to the same name as specified in the .env file. Refer to step 3 and 4.
    • For example, bench --site custom-erpnext-nginx migrate

11. After the process Compiling Python files... is finished, you will be back in the ~:/home/frappe/frappe-bench directory. This means the bench migrate process is completed. Type exit to exit from <project_name>-erpnext-python-1 container.

12. Now, you can open any browser such as Google Chrome and access ERPNext via http://localhost:<ERPNext_Server_Port> or http://<Your_IP_address>:<ERPNext_Server_Port>.

    Note:

    • Type the selected ERPNext port number in <ERPNext_Server_Port> selected in step 4.
    • For example, http://localhost:8000 or http://127.0.0.1:8000.

13. Default credentials.

    • Username: Administrator
    • Password: admin

6. Stopping Docker Containers

1. To stop all the docker containers related to your <peoject-name> project:
   • Open a Powershell terminal, navigate to IRPS-Enhanced-Frepple-Integration folder.
   • Run docker-compose -p <project-name> stop.
   • For example, docker-compose -p project1 stop.

7. Starting Docker Containers

1. To start up all the docker containers related to your <peoject-name> project:
   • Open a Powershell terminal, navigate to IRPS-Enhanced-Frepple-Integration folder.
   • Run docker-compose -p <project-name> start.
   • For example, docker-compose -p project1 start.

8. Deleting Docker Containers

1. To remove all the docker containers related to your <peoject-name> project:
   • Open a Powershell terminal, navigate to IRPS-Enhanced-Frepple-Integration folder.
   • Run docker-compose -p <project-name> down or run docker-compose -p <project-name> down -v to remove the related Docker Volume.
   • For example, docker-compose -p project1 down -v

Update Custom App

1. Assumptions:
   1. You have a running instance of ERPNext in docker production container.
2. How to update custom app

Backup

1. Assumptions:
   1. You have a running instance of ERPNext in docker production container.
2. Alternatives:
   1. Online Backup (Automatic)
   2. Local Backup (Manual)
   3. Local Backup (Automatic)

Restore

1. Assumptions:
   1. You have your backup files on your pc (if you perform online backup, you can download the backup files onto your pc).
   2. You have a running instance of ERPNext in docker production container in which you want to restore with the backup files.
2. Restore

For Developer

• Reference: Customizing your own shrdc custom frappe docker

1. Introduction

• Fork this repo to build your own image with ERPNext and list of custom Frappe apps.
• Change nginx/Dockerfile and add required apps. Refer comments in the file.
• Change worker/Dockerfile and add required apps.

Example file uses following apps:

• Metabase Integration
• Telegram Integration
• Enhanced Frepple Integration
• Barcode Scanning System
• Autocount
• SQL Account

2. Build images

Execute from root of app repo.

For nginx:

# For version-12
docker build --build-arg=FRAPPE_BRANCH=version-12 --build-arg=GITHUB_OWNER=<github-username> -t custom-erpnext-nginx:v12 nginx

# Example:
docker build --build-arg=FRAPPE_BRANCH=version-12 --build-arg=GITHUB_OWNER=msf4-0 -t custom-erpnext-nginx:version-12 nginx

For worker:

# For version-12
docker build --build-arg=FRAPPE_BRANCH=version-12 --build-arg=GITHUB_OWNER=<github-username> -t custom-erpnext-worker:version-12 worker

# Example:
docker build --build-arg=FRAPPE_BRANCH=version-12 --build-arg=GITHUB_OWNER=msf4-0 -t custom-erpnext-worker:version-12 worker

3. Push images to Docker Hub

1. Tag the images bulilt from Step 2 with the format: docker tag <Image Name>:<Version> <Docker Hub Username>/<Image Name>:<Version>

For nginx:

docker tag custom-erpnext-nginx:version-12 shrdc/custom-erpnext-nginx:version-12

For worker:

docker tag custom-erpnext-worker:version-12 shrdc/custom-erpnext-worker:version-12

Reference: Steps to create a Docker Hub, and push images to it.

2. To push to Docker Hub, run docker push with the tagged name created before.

docker push shrdc/custom-erpnext-nginx:version-12
docker push shrdc/custom-erpnext-worker:version-12

3. Possible troubleshoot: When you face denied: requested access to the resource is denied when pushing images, run docker login and enter your credentials. Then push image again.

4. (Optional) Configure env-example

1. You may need to change the DOCKER_USERNAME in env-example to the username of the Docker Hub account in which you have pushed your images to.
2. Copy env-example into .env by running cp env-example .env.

5. Start up

1. The following commands should be executed on the ~/some/path/Integrated-Resource-Planning-System-IRPS directory
2. docker-compose -p <project_name> up -d
3. docker logs <project_name>_site-creator_1 -f
   1. If you got a no such container error, you may need to change to docker logs <project_name>-site-creator-1 -f
4. After the site_creator container exited, open a browser, you can access ERPNext on localhost:8000 or 127.0.0.1:8000.
5. You can push the changes back to this repo (or your own repo if you forked one from this repo).

License

This software is licensed under the GNU GPLv3 LICENSE © Selangor Human Resource Development Centre. 2021. All Rights Reserved.