How to convert Epoch timestamp to Datetime in Excel
=TEXT((G2/1000 + (“1/1/1970”-“1/1/1900″+1)*86400) / 86400,”DD/MM/YYYY HH:MM:SS”)
Reference:
https://stackoverflow.com/questions/48484020/convert-epoch-time-to-readable-time-in-excel
How to convert Hex number to Decimal Number in Excel
=HEX2DEC(XX)
Reference:
https://www.extendoffice.com/documents/excel/2168-excel-convert-hex-to-decimal.html
Pentaho Data Integration Community Edition 8.1.0.0-365 Spoon.bat not running on Windows 10 64 Bit
I downloaded Pentaho DI CE 8.1.0.0-365 and when I ran spoon.bat, nothing was happening.
I then ran spoon.Debug.bat to see what is happening. The following error was seen in SpoonDebug.txt
“C:\Program Files (x86)\Java\jdk1.8.0_181\bin\java.exe” “-Xms1024m” “-Xmx2048m” “-XX:MaxPermSize=256m” “-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2” “-Djava.library.path=libswt\win32” “-DKETTLE_HOME=” “-DKETTLE_REPOSITORY=” “-DKETTLE_USER=” “-DKETTLE_PASSWORD=” “-DKETTLE_PLUGIN_PACKAGES=” “-DKETTLE_LOG_SIZE_LIMIT=” “-DKETTLE_JNDI_ROOT=” -jar launcher\launcher.jar -lib ..\libswt\win32 /level:Debug
Error occurred during initialization of VM
Could not reserve enough space for 2097152KB object heap
Java HotSpot(TM) Client VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
I opened Spoon.bat and removed “-Xmx2048m” from this line below and saved.
if “%PENTAHO_DI_JAVA_OPTIONS%”==”” set PENTAHO_DI_JAVA_OPTIONS=”-Xms1024m” “-Xmx2048m” “-XX:MaxPermSize=256m”
Now Spoon.bat runs and opens up the IDE.
Code Snippets 