Barcode Overview

Overview of Barcde

1D (Linear) Barcode Symbologies with specific characteristics

• Code 128
• 2 of 5 Standard
• 2 of 5 Interleaved
• 2 of 5 IATA
• 3 of 9 (Code 39)
• 3 of 9 Ext (ASCII)
• EAN8
• EAN8 P2
• EAN8 P5
• EAN13
• EAN13 P2
• EAN13 P5
• EAN 14
• EAN128 / GS1-128 (subset of Code 128)
• UPC Version A
• UPC Version E

https://www.tec-it.com/en/support/knowbase/barcode-overview/linear/Default.aspx

Barcode Generator

Start

http://www.barcodez.net/

http://online-barcode-generator.net/

 

Robot Process Automation

Robot Process Automation (RPA)

Robotic process automation (or RPA or RPAAI) is an emerging form of clerical process automation technology based on the notion of software robots or artificial intelligence (AI) workers.^[1]

In traditional workflow automation tools, a software developer produces a list of actions to automate a task and interface to the back-end system using internal application programming interfaces (APIs) or dedicated scripting language. In contrast, RPA systems develop the action list by watching the user perform that task in the application’s graphical user interface (GUI), and then perform the automation by repeating those tasks directly in the GUI. This can lower the barrier to use of automation in products that might not otherwise feature APIs for this purpose.

https://en.wikipedia.org/wiki/Robotic_process_automation

 

Blue Prism

https://www.blueprism.com/

Setup Android Studio

Introduction

• Download and install Android Studio 3.0.1
• Android Studio – Code Editor, Rich Emulator, Develop for all Android devices, Performance Profilers Developer
• Workflow Basics Setup your workspace
• Write your app (Code writing, UI design, create resources for different device types)
• Build and Run (Build a debuggable APK package that run on emulator or and Android-powered device) Debug, profile, and test (performance profiling tool to optimize app performance)
• Publish your app

Modules

• Android app module – app’s source code, resource files and app level setting
• Library module – reusable code for different app module
• Google cloud module – Google cloud backend code – develop the backend to provide cloud services the app needs
• Modules- The module setting section lets you change configuration options for each of your project’s module
• An android library compiles into an Android Archive (AAR) file that you can use as a dependency for an Android app module.

DOS prompt command: net use

DOS Prompt Command

• map network path to local network drive

net use I: \\128.1.1.1\C$ /user:admin “password”

• disconnect local network drive

net use I: /delete

The above DOS command has same effect as the function provided in Window Explorer.

• Map Network Drive
• Disconnect

Install working environment in Windows 7 32 bit

1. Install VC 6
2. Edit sp598ent.stf to skip checking MDCA
3. Install VC6 SP5 (setupsp5.exe)
4. Install MQ 7.1
5. Set options in VC6 for adding include and directories for MQ
6. Modify Environment to include following: MQCCSID 950, MQCHLLIB C:\Ocp\Import, MQCHLTAB AMQCLCHL.TAB

Share DVD drive between PCs in same network

DVD drive used over the network

• make sure that enable sharing for DVD drive
• make sure that the sharing permission is for everyone to read

Computers in same network

• make sure that they are in same WORKGROUP
• make sure that the firewall is disable for file and printer sharing

References

• https://kb.wisc.edu/page.php?id=13067
• http://helpdeskgeek.com/networking/cannot-see-other-computers-on-network-in-my-network-places/

BitLocker To Go

The Feature “Turn On Bitlocker To Go” is available in Windows 7 Ultimate and Enterprise, Windows 8.1 Professional and above, and Windows 10 Professional above

Reference

http://www.techrepublic.com/blog/windows-and-office/secure-your-usb-drives-with-bitlocker-to-go-for-windows-7/

Moving Data between Workbooks

Const NUM_FARE_TYPE = 4
Dim SrcSheet(1 To 4) As String

Sub Initialize

SrcSheet(1) = “AduSR”
SrcSheet(2) = “ConSR”
SrcSheet(3) = “AduSR_1C”
SrcSheet(4) = “ConSR_1C”

End Sub
Sub Copy1a1b()
‘
‘ Copy1a1b Macro
‘

‘

Const NUM_SET = 2
Const SET1_SRC = 10
Const SET2_SRC = 51

Const SET1_DEST_ADUSR = 9
Const SET2_DEST_ADUSR = 77
Const SET1_NUM_STAT = 17
Const SET2_NUM_STAT = 6

Dim i, j, k, m As Integer
Dim SetSrc(1 To NUM_SET), SetDest(1 To NUM_SET), SetNumStat(1 To NUM_SET) As Integer

SetSrc(1) = SET1_SRC
SetSrc(2) = SET2_SRC

SetDest(1) = SET1_DEST_ADUSR
SetDest(2) = SET2_DEST_ADUSR

SetNumStat(1) = SET1_NUM_STAT
SetNumStat(2) = SET2_NUM_STAT

Initialize

‘ SHEET “1a. ISL + TKL: BEGIN
Windows(“2016 Worksheets.xlsx”).Activate
Sheets(“1a.ISL+TKL >”).Select

‘ To ISL: BEGIN
For k = 1 To NUM_FARE_TYPE
Windows(“2016_ (Test).xlsx”).Activate
Sheets(SrcSheet(k)).Select

For m = 1 To NUM_SET
j = SetDest(m) + k – 1
For i = 1 To SetNumStat(m)
Windows(“2016_(Test).xlsx”).Activate
Range(“G” & (SetSrc(m) + i – 1) & “:W” & (SetSrc(m) + i – 1)).Select
Selection.Copy
Windows(“2016 Worksheets.xlsx”).Activate
Range(“H” & j).Select
ActiveSheet.Paste
j = j + 4
Next i
Next m

Next k
‘ To ISL: END

‘ To TWL: BEGIN
For k = 1 To NUM_FARE_TYPE
Windows(“2016_(Test).xlsx”).Activate
Sheets(SrcSheet(k)).Select

For m = 1 To NUM_SET
j = SetDest(m) + k – 1
For i = 1 To SetNumStat(m)
Windows(“2016_(Test).xlsx”).Activate
Range(“X” & (SetSrc(m) + i – 1) & “:AK” & (SetSrc(m) + i – 1)).Select
Selection.Copy
Windows(“2016 Worksheets.xlsx”).Activate
Range(“Y” & j).Select
ActiveSheet.Paste
j = j + 4
Next i
Next m

Next k
‘ To TWL: END

==========================================================================
End Sub

 

useful software tool

1. Capture screen: Greenshot
2. File Transfer: FileZilla
3. MTTTY: Multi-threaded Terminal Sample (Win32)
4. usbview.exe
5. mysql-connector-odbc-5.3.4-win32.msi
6. PuTTY putty.exe
7. teraterm
8. winscp
9. HxD Hex Editor
10. Q-Dir_portable (Q-Dir.exe)
11. ruby185-21.exe
12. TrueCrypt
13. unix2dos.exe
14. Window Mobile Device Centre (for HHC)
15. VMware-player-6.0.4-2249910.exe
16. WinMerge
17. VirtualBox
18. Notepad++
19. tinytask
20. audacity

convert file from dos to unix – dos2unix

find . -name “*” -exec dos2unix {} \;