How to install IDS

0. Setup Frappe (https://frappeframework.com/docs/user/en/installation)
1. bench init ids --frappe-branch version-13
2. cd ids
3. bench new-site ids --db-name ids --db-type postgres
4. bench use ids
5. bench start
6. bench get-app [email protected]:SAMBPLG/ids.git
7. rm -rf apps/samb/*
8. cd apps/samb
9. rm -rf .git
10. rm -rf .github
11. rm .gitignore
12. git clone [email protected]:SAMBPLG/ids.git .
13. bench get-app [email protected]:SAMBPLG/sambcoro.git
14. bench install-app samb
15. bench migrate
16. Download db postgress
DB Restore:
https://sambid-my.sharepoint.com/:u:/g/personal/zulfafalah_samb_co_id/EShSgjMH1zdBmPgEF0z6aPwBiTIw8-19Q564e3vCY4zJnA?e=1tXjmj

17. cp 20230915_111320-ids-database.sql.gz /home/foldername/ids
18. bench restore 20230915_111320-ids-database.sql.gz --db-root-username postgres --db-root-password root
18. move to /apps/samb git pull origin development
19. bench migrate
when you have an error psycopg2.errors.DatatypeMismatch: column "item_length" cannot be cast automatically to type numeric HINT: You might need to specify "USING item_length::numeric(21,9)".

20. connect to your postgress with dbeaver / pgadmin
21. set the connection with
Host : localhost
Database : ids
Port : 5432
User Name : postgres
Password : x!@#$

22. open editor
ALTER TABLE "tabItem" DROP COLUMN item_length
ALTER TABLE "tabItem" DROP COLUMN item_width
ALTER TABLE "tabItem" DROP COLUMN item_height
23. load your http://localhost:8001/app
24. Finish setup