Saturday, January 13, 2018

New standard programs and settings for new computers checklist

  • Network account
  • Computer name
  • Add to domain
  • Power buttons/ power settings
  • ESET
  • MS Office
  • Disable MS OneDrive file collaboration
  • Adobe reader
  • Network Printer
  • Disable auto install of network printer 
  • google chrome   
  • Mozilla firefox
  • Map network drives
  • Transfer browser bookmarks
  • Transfer Stick Notes
copy mac address
Kaseya
netstat -rn
  • Syncback
  • Team Viewer
  • Create system restore point

Tuesday, August 4, 2015

LG G2 mini Unboxing (Photos)

The LG G2 mini was released in April 2014 and has a 1.2GHz quad core CPU, 4.7-in screen, 2440mAH battery and runs Android OS. For complete specs, click here.






Wednesday, February 4, 2015

Print (write) checks using MS Excel with this template

 Print (write) up to 10 personal checks per batch with this Ms Excel template.

Download template from this google docs link.

By J.Archer (Own work) [CC BY 3.0], via Wikimedia Commons

Reminders
Please enable macros when prompted.
Create custom paper size for your printer 8" x 3" or 8"x5" and name it "check"

Entering data
Enter data in 2nd sheet - check info.
Enter "date" and "amount numbers" only. Excel will convert amount in numbers to words automatically.
Enter payee name in 1st sheet if you'd like to select it in a dropdown option in second sheet

Printing
Print 3rd sheet - "checkprint"
Select page range of of checks you want to print check1 is page 1 etc.
Select paper "check"
Insert check right side first in printer

Editing
3rd sheet protected to avoid accidental moving of textboxes
To edit, right click checkprint sheet then unprotect.
You'll probably need to edit checkprint sheet since banks have different check layouts.
To edit output of "amount words" column in checkdetail sheet press Alt+F11 then edit code.

References:
Cheque printing without special software or Printer with Excel
MS Excel: Convert currency into words

Thursday, March 20, 2014

Commonly Used MARC21 Fields for cataloguing books in OpenBiblio

Material Type: Books

Description
Tag
Example
remarks
International Standard Book Number:
020$a


Classification number
050$a

Later to be copied as call# in openbib
Personal name:
100$a
Wells, H. G.
First author only
There is punctuation (usually a period) at the end of the field unless the name has an open date.
Main entry - Corporate name
110$a


Title
245$a
The DNA story :

Remainder of title:
245$b
a documentary history of gene cloning /

Statement of responsibility, etc.:
245$c
prepared by Margaret Peg Davis and John Hohmann. (two authors)
by Margaret Peg Davis … [et al.]. (for four or more authors).
by Margaret Peg Davis … [et al.] ; with contributions by John Hohmann … [et al.]. (for four or more authors with four or more contributors)


There is punctuation (usually a period) at the end of the field.
Edition statement:
250$a


Place of publication, distribution, etc.:
260$a


Name of publisher, distributor, etc.:
260$b


Date of publication, distribution, etc.:
260$c


Extent
300$a


Summary, etc. note
520$a


Topical term or geographic name as entry element:
650$a


Topical term or geographic name as entry element:
650$a


Topical term or geographic name as entry element:
650$a


Topical term or geographic name as entry element:
650$a


Topical term or geographic name as entry element:
650$a


Added entry--personal name
700$a
Wells, H. G.
Other authors
Added entry - Corporate name
710$a



References:
http://www.libraries.psu.edu/psul/cataloging/training/bpcr/choice.html#3a
http://www.loc.gov/marc/umb/um07to10.html
http://www.statemuseum.arizona.edu/library/cataloging_manual/createbibrec.shtml

Wednesday, March 12, 2014

How to setup automatic backup using SynvBackFree v6

How to share backup storage network folder in Ubuntu Server
  1. Add user account and assign password 
  2. Login to new account and create backup folder
  3. Open Samba > File > Add share
  4. Browse > select backup folder > Ok
  5. Check "Writable" and "Visible"
  6. Access tab > select " Only allow specific users" >select correct user/s 
  7. Click Ok. 
  8. The shared folder can now be accessed on a Windows network with username and password.
  9. More info
Assigning Drive letter to an External USB Hard Drive for backup storage
  1. Plug in external USB HD to be used as storage
  2. Open Disk Management
  3. Right Click on USB HD > Change Drive Letter and Paths
  4. Click Change > Assign the following drive letter > Select Any letter (preferably "R" to "Z") > OK
  5. Your USB HD has been assigned the new drive letter.

Setup Backup client
  1. Download and install SyncBackFree
  2. New >Enter Profile name > next > Mirror>next>Done/OK
  3. Select Source and destination (network folder) or External USB HD Drive
  4. Click Choose subdirectories and files > Check Desktop, Documents, Downloads, Music, Pictures, Videos, Etc. Uncheck everything you don’t need backed up.
  5. Click expert
  6. Decisions –Files > What to do if a file exists on the Destination but not on the source
  7. Set “Delete file from destination if it hasn’t been modified within the last __ Days” to 5.
  8. Log> Check Display Log after running a profile > Uncheck only when an error occurs
  9. Network> Type in network connection details for destination
  10. Click OK
  11. Add Schedule > Weekly > M-F
  12. Check “Run only when user is logged on” > OK






How to map network drive
Computer > Network > Right click network folder > Map network drive > Specify Drive letter >Finish


How to log-out from network folders in windows
Open cmd
Type in: net use * /delete /yes


Monday, February 24, 2014

How to turn off ESET Smart Security Pop-ups - Outbound /Inbound traffic

How to turn off persistent ESET Smart Security pop-ups - Outbound /Inbound traffic: "An application running on this computer is attempting to communicate with a remote computer. Do you wish to allow this communication?... Allow or Deny"


Open ESET window > setup > Personal Firewall > Switch to automatic filtering mode > enter password > done.

Reference: Wilders Security Forums - inbound/outbound traffic
ESET Smart Security Personal firewall behavior and user interaction (5.x)

Thursday, January 23, 2014

How to move photos from Bitnami gallery in windows to Gallery3 in Ubuntu Linux


How to migrate/change servers from Bitnami gallery in windows to Gallery3 in Ubuntu Linux

Windows -bitnami

  1. Copy var folder
  2. Access phpmyadmin
  3. Select bitnami_gallery database
  4. Select export tab
  5. Export method: custom
  6. Check Object creation options:  Add statements: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
  7. Go
  8. Download bitnami_gallery.sql file

Ubuntu

  1. Install gallery 3 in Ubuntu normally
  2. This would create the gallery3 database, create var folder etc.
  3. Import bitnami_gallery.sql file into gallery3 database
  4. Copy contents of var folder in the var folder in Ubuntu
  5. Edit database.php to match the newly created user, pass, database, etc.
  6. You can now see your old gallery in the gallery3 page in Ubuntu but the photos are blank.
  7. Right click on var folder > permissions tab
  8. Change File Access: Read and write; Group file acess: read-only. Others file access: read-only.
  9. Click apply permissions to enclosed files > close
  10. You should now be able to see your old photos
  11. Done


Some helpful links:
How to install xampp in ubuntu?
why cant i copy into /opt/lampp/htdocs ?
How to auto start XAMPP in Ubuntu?