ImHori HoriLiu

## test_mpxj_from_MS_Project2003_To_Excel_use_python.py
import jpype
import mpxj
import pandas as pd

#Ref FAQ for log4j2 in https://www.mpxj.org/faq/
jpype.startJVM("-Dlog4j2.loggerContextFactory=org.apache.logging.log4j.simple.SimpleLoggerContextFactory")

#Ref https://pypi.org/project/mpxj/
from net.sf.mpxj.reader import UniversalProjectReader
project = UniversalProjectReader().read('example.mpp')

## .gitignore
pkg/
src/
understand-bin-*.pkg.*
Understand-*.tgz
.SRCINFO

## gc_repack_prune
git remote prune origin && git repack && git prune-packed && git reflog expire --expire=1.month.ago && git gc --aggressive


croc command
croc relay --ports 443
croc --relay 192.168.205.99:443 sned "MAN.3_03. VMG-015-A5CO_WBS_20240311.mpp"

croc --relay 192.168.205.99:443

AD23=>setup private license server

## teams
https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZjdmMGNmMDEtNzQxMy00YmFmLWI1ZWItZWEyMWQzNTNmYjE5%40thread.v2/0?context=%7b%22Tid%22%3a%22d852d5cd-724c-4128-8812-ffa5db3f8507%22%2c%22Oid%22%3a%220ccd7b86-c8b0-49a9-b295-58fe05992423%22%7d

## AutoSAR SC3
https://www.youtube.com/watch?v=A9ssJ4YTeSA

https://blog.csdn.net/qq_25920091/article/details/107140898

https://support.vector.com/sys_attachment.do?sys_id=6af05b3e872ab8948816dd383cbb354a&sysparm_viewer_table=kb_knowledge&sysparm_viewer_id=7fd58be4876ef054b9f233770cbb3543

https://www.semanticscholar.org/paper/Freedom-from-Interference-for-AUTOSAR-based-ECUs%3A-a-Haworth-Jordan/f5ad014ef6d3d4088babcee769ca9d7c50366959

https://stackoverflow.com/questions/65558006/how-can-i-configure-mpumemory-protection-unit-for-an-os-task-in-vector-autosar


## Rebuild pymakr-vsc for pyboard REPL
# Must use administrator privileges in cmd.exe in below instructions.
# Goto https://chocolatey.org/install, find the "Install with cmd.exe"
(copy command text)
# Goto https://nodejs.org/en/download/package-manager/#windows
# Using Chocolatey to install node and npm:
cinst nodejs

# Do you want to run the script?([Y]es/[N]o/[P]rint):
Press "Y"
# Check version can be showed

## Build Micropython in Archlinux
Install gcc-arm-none-eabi-bin in Archlinux's AUR
sudo pip install pyusb --pre

git clone https://github.com/micropython/micropython.git
Merge & modify ./stmhal/boards/PYBV11/.* for PYB Nano Board

#Edit linux udev setting for stm32 bootloader dfu (USB PID/VID) driver as below, and set pyb.bootloader() by upy command:
https://gist.github.com/HoriLiu/afb0e6d8ddb0bbe372dc1de0bb118ad0

cd micropython

## Anaconda install in Debian
http://askubuntu.com/questions/505919/how-to-install-anaconda-on-ubuntu

python 2 anaconda install bash script:

# Go to home directory
cd ~

# You can change what anaconda version you want at
# https://repo.continuum.io/archive/
wget https://repo.continuum.io/archive/Anaconda2-4.2.0-Linux-x86_64.sh

## Install taiga.io
#Set proxy in ~/.gitconfig
[http]
  proxy=http://user:psw@proxyaddress:port
[https]
  proxy=https://user:psw@proxyaddress:port
#proxychains

sudo apt-get install libssl-dev libffi-dev
	import jpype
	import mpxj
	import pandas as pd

	#Ref FAQ for log4j2 in https://www.mpxj.org/faq/
	jpype.startJVM("-Dlog4j2.loggerContextFactory=org.apache.logging.log4j.simple.SimpleLoggerContextFactory")

	#Ref https://pypi.org/project/mpxj/
	from net.sf.mpxj.reader import UniversalProjectReader
	project = UniversalProjectReader().read('example.mpp')
	git remote prune origin && git repack && git prune-packed && git reflog expire --expire=1.month.ago && git gc --aggressive


	croc command
	croc relay --ports 443
	croc --relay 192.168.205.99:443 sned "MAN.3_03. VMG-015-A5CO_WBS_20240311.mpp"

	croc --relay 192.168.205.99:443

	AD23=>setup private license server
	https://www.youtube.com/watch?v=A9ssJ4YTeSA

	https://blog.csdn.net/qq_25920091/article/details/107140898

	https://support.vector.com/sys_attachment.do?sys_id=6af05b3e872ab8948816dd383cbb354a&sysparm_viewer_table=kb_knowledge&sysparm_viewer_id=7fd58be4876ef054b9f233770cbb3543

	https://www.semanticscholar.org/paper/Freedom-from-Interference-for-AUTOSAR-based-ECUs%3A-a-Haworth-Jordan/f5ad014ef6d3d4088babcee769ca9d7c50366959

	https://stackoverflow.com/questions/65558006/how-can-i-configure-mpumemory-protection-unit-for-an-os-task-in-vector-autosar
	# Must use administrator privileges in cmd.exe in below instructions.
	# Goto https://chocolatey.org/install, find the "Install with cmd.exe"
	(copy command text)
	# Goto https://nodejs.org/en/download/package-manager/#windows
	# Using Chocolatey to install node and npm:
	cinst nodejs

	# Do you want to run the script?([Y]es/[N]o/[P]rint):
	Press "Y"
	# Check version can be showed
	Install gcc-arm-none-eabi-bin in Archlinux's AUR
	sudo pip install pyusb --pre

	git clone https://github.com/micropython/micropython.git
	Merge & modify ./stmhal/boards/PYBV11/.* for PYB Nano Board

	#Edit linux udev setting for stm32 bootloader dfu (USB PID/VID) driver as below, and set pyb.bootloader() by upy command:
	https://gist.github.com/HoriLiu/afb0e6d8ddb0bbe372dc1de0bb118ad0

	cd micropython
	http://askubuntu.com/questions/505919/how-to-install-anaconda-on-ubuntu

	python 2 anaconda install bash script:

	# Go to home directory
	cd ~

	# You can change what anaconda version you want at
	# https://repo.continuum.io/archive/
	wget https://repo.continuum.io/archive/Anaconda2-4.2.0-Linux-x86_64.sh
	#Set proxy in ~/.gitconfig
	[http]
	proxy=http://user:psw@proxyaddress:port
	[https]
	proxy=https://user:psw@proxyaddress:port
	#proxychains

	sudo apt-get install libssl-dev libffi-dev