To convert field values with date value but with text type in a spreadsheet.

Choose data > Text to columns..

Choose the delimiter for example “/” and it will generate 3 columns.

Can reformat the date with =A3&-A2&-A1 (YYYY-MM-DD)

Usually I used to use Google Calendar to set an event and reminder to the event. But there are features that are unnecessary that make things a bit complicated.

I found a simpler reminder application that is much easier to set up and just serve the purpose (to send an email reminder for an event)

Check it out –>  remindr.me

In an organization, there are information that are important enough to be documented. As a reference for all the members in the future.

I’ve tried several wiki applications and most of them are not friendly enough. So I decided to move to wordpress as a wiki alternative. To sort content by “category”, to have “page” as static information and “post” for other findings and on-going updates.

With the search function, it is very helpful to find any information within the ‘wiki’.

Template

• MyWiki
  • create a page and set template for the page follow “Wiki Template”
  • then set the page created as “static page” in Appearance > Customize

Plugins used

• manage user access –  user access manager
• file upload
• file view (esp attachment like image and pdf)

Settings

• disable comment features
  • Settings > Discussion > Untick “Allow comments on new articles”
• set permalink
  • Settings > Permalinks > Choose “Post Name”

If you want to set certain period of time to do something online or want to remind you after xx minutes, you can easily use the google timer.

Go to google.com and type “timer 10 seconds” or “timer 10 minutes”. Try it out.

Filezilla keeps all passwords in plain text file.

You can view the files in the path below (for windows)

Windows XP/2K:
“C:\Documents and Settings\username\Application Data\FileZilla”

Windows Vista/Windows 7:
“C:\Users\username\AppData\Roaming\FileZilla\”

Linux: “/home/username/.filezilla/”

This is how the recentservers.xml that keep the recent connection looks like

<!--?xml version="1.0" encoding="UTF-8" standalone="yes" ?-->
 
 
 
            yourhost.com
            21
            0
            0
            your_username
            your_password
            1
            0
            MODE_DEFAULT
            0
            Auto
            0

To secure your password,

1. Never save any password to your hosting. At most you can only save the username.

2. Clear the private data everytime before close the Filezilla application

Choose Edit > Clear private data..

Choose the first 2 options and click OK

Everytime I sit to do proposal, I come to face this question on what a system can do?

1. Automate the process
2. Shorten the process
3. Centralized the data
4. Data is at all time up-to-date
5. Can generate more useful information