Share008資訊科技公司

我是資深的電腦資訊從業員,曾於 Motorola 及 Philips 等跨國大型公司管理層工作十多年,具各類ERP資源管理系統及其它應用系統經驗,如QAD之MFG/PRO、SAP、Ufida(用友)、Kingdee(金蝶)、Microsoft's Dynamic、Wonderware's In-Track (SFC)、Webplan (SCM)、Hyperion (business intelligence)、Informatics (Data Warehouse)...等等。另外,我精於廠房車間之電腦資訊運作,擁有 CISSP 及 ITIL 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為 au8788@gmail.com

「ERP資源管理系統」已是現今廠房管理必不可少的工具,提高它的效能,絕對能改善公司之盈利,請多多留意。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

提供香港股票價位歷史數據

我想很多人會對"香港股票價位的歷史數據"有興趣,我已下載成Microsoft Access database version 2000 的文檔,資料由2008/1/1至2009/12/2,zip壓縮後也有11M,若索取請留你的PM我 。

祝願各瀏覽者股壇威威!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2014年5月31日

Release of http://infotechmanagefactory.com/ web site

The first release version of web site http://infotechmanagefactory.com/ is completed. The main purpose of this web site is to provide useful information to those IT factory guys in order to improve the quality of IT operation management under factory or manufacturing field. Now, it contains about 40 IT management articles. You are welcome to provide any comment for further improve this web site.

2014年5月28日

IT人在工廠日記 - 招聘易 (2014/05/24)

最近,我部門在香港的一位IT supervisor辭職,所以要招聘新人,IT manager/IT supervisor 的廣告一出,便收到很多回覆回顧所收回的應徵信,大部份是網絡人員,平均叫價是3至3.5萬,但是考慮沒有工廠經驗的人;約二十名中有一名是有工廠經驗的,可是最悲的是有工廠經驗的IT人,叫價只是2.5至3萬,太令人失望,工資比前二、三年沒有增長。最終我在一星期內,便招聘到一名二十年經驗的IT人擔IT supervisor職位,起薪為2.8萬,不知是我公司好彩,還是現時香港的廠房IT人不值錢唉!可以理解的,香港的工廠北移,大陸工廠的員工本地化,大陸工廠的人工開支上升而影響營利倒退...如此種種原因引至今天的情況,希望香港的廠房IT人能轉運,在一、兩年後,有多些有前途和高薪的職位出現吧。

註:
若是網絡的IT、web/mobile的程式員、跟Project的IT人、或從事Banking/Finance的IT人,現時仍然很吃香的,不用擔心工作。

2014年5月23日

Remove program from register

After you run a program uninstallation, you can use the following to delete from register.

To run its uninstaller, you can also
Go to the folder where the program is installed.
Locate its uninstaller usually named as unins000.exe or uninstall.exe
Double click on its uninstaller and follow it to uninstall the program.
Please know that both of Windows Add/ Remove Programs and its build-in uninstaller can only uninstall the main executable files of the program, but not all program files and components. Some invalid files may be left in system registry and folders. To completely remove DriverMax, you need to get rid of those remnants, otherwise, it will slow down your PC and block you installing other incompatible programs.
To thoroughly delete its files, please follow the steps:
Run Registry Editor
Find and delete all registry entries of the program in HKEY_CURRENT_USER\Software, HKEY_LOCAL_MACHINE\SOFTWARE and HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Run\eg ui
Find and delete all files of the program in system folders C:\Program Files\, C:\Document and Settings\All Users\Application Data\ and C:\Documents and Settings\%USER%\Application Data\.

廠房資訊科技管理網站 web site for Info Tech of Factory

近日,本人新建了一個網站,網址為 http://infotechmanagefactory.com,主要是分享廠房的資訊科技管理資料。近十多年來,廠房的資訊科技介是沒有大進步,有些公司為了省錢,反而倒退,例如不用window domain,改用Lunix來節省開支,現實就是這樣了。本人在廠房環境中工作了二十多年,收集了不少有用文件,有些舊資料現時仍然合用,所以特別設置些網站來分享此等資料,希望能幫到各位,改善廠房的資訊管理。

2014年5月16日

Email Block by CBL

Problem: CBL Block
IP Address xxx.xxx.xxx.xx is listed in the CBL. It appears to be infected with a spam sending trojan, proxy or some other form of botnet.
It was last detected at 2014-05-13 21:00 GMT (+/- 30 minutes), approximately 3 hours, 30 minutes ago.
It has been relisted following a previous removal at 2014-05-12 01:48 GMT (1 days, 22 hours, 13 minutes ago)
This IP is infected (or NATting for a computer that is infected) with the cutwail spambot. In other words, it's participating in a botnet.

Solution:  How to find BOTs in a LAN

1.      On Windows, use this in a dos command window:
DOS 下跑 :   netstat 5
This will give you a list of all network connections your machine has open, much like *NIX netstat above every 5 seconds until you stop it. You're looking for very much the same sort of things as *NIX netstat above. You'll probably see Microsoft, Yahoo and other familiar names - they're normal (from your browser, IM etc). "Akamai" perhaps won't be familiar, but it's normal too. Lots of port 25 connections is the usual sign of infection.

2.      Port Scanners using Nmap tool
Detailed description of how to use nmap is well beyond the scope of this paper. For our purposes, the following command will do most of what you want and be non-destructive - won't do any damage:
nmap -A [machine or network specification]

2014年5月15日

金蝶ERP系統的應收總表錯誤

若怀疑金蝶ERP系統的應收總表錯誤,對不上應收明細,道致期间的Balance出现了问题。请尝试用以下方法是否可以解决:
打开 应收款汇总表 ,然后 同时按键盘上的 SHIFTER ,这时候会出现余额重算的窗口,对这个客户和相应的期间进行重算,或可以解决问题

唉!金蝶系統仍存在這些低級錯誤,太令人失望。




How can I set up Microsoft IIS as an ESET update Mirror server?

Source: http://kb.eset.com/esetkb/index?page=content&id=SOLN2270

Solution

To use Microsoft Internet Information Services (IIS) as an ESET update mirror server, click your server operating system and follow the step-by-step instructions:

Microsoft Windows Server 2008R2, Small Business Server 2011
  1. Open the ESET Remote Administrator Console (ERAC) by clicking Start All Programs ESET ESET Remote Administrator Console ESET Remote Administrator Console.

  2. Click Tools Server Options Updates. Deselect the Provide update files via internal HTTP server option. Click OK.
     
  3. Open Services by clicking Start All Programs Administrative Tools Services.
     
  4. Locate the Internet Information Services (IIS) Manager service, right-click it and select Stop.

  5. Open IIS Manager by clicking Start All Programs Administrative Tools Internet Information Services (IIS) Manager.

  6. Click the + next to your server name, right-click Sites and select Add Web Site from the context menu to open the Add Web Site Window.
Figure 1-1
Click the image to view larger in a new window

  1. Type a name for the website into the Site name field (for example, ESET mirror).

  2. Click the browse (...) button, navigate to the mirror folder by following the path below (default location for the Mirror folder) and click Open.

    • Server 2008R2: C:\Documents and Settings\All Users\Application Data\ESET\ESET Remote Administrator\Server\Mirror
       
    • Small Business Server 2011: C:\Documents and Settings\All Users\Application Data\ESET\ESET Remote Administrator\Server\Mirror
       
  3. Leave the Enter the IP address to use for this Web site field at its default setting: (All Unassigned). Type 2221 in the TCP port this Web site should use field (default is 80). Leave the Host header for this Web site field empty. Click OK.
Figure 1-2

  1. ESET Mirror should now be listed under Web Sites in the IIS Manager menu tree. Select it and then double-click MIME Types.
     
  2. In the MIME Types window, click Add. In Add MIME Type window, type * in the File name extension field and then enter application/octet-stream in the MIME type field and click OK..

Figure 1-3
Clck the image to view larger in a new window

  1. Close IIS Manager. Open a web browser and type the URL below (where servername is replaced with your actual server name). If there are no errors, your web browser will display a text file with update information.

    • http://servername:2221/update.ver
       
  2. Test the newly configured mirror server by directing an ESET client workstation (running ESET Smart Security or ESET NOD32 Antivirus) to update from http://servername:2221 and check its connection.
Back to top




Microsoft Windows Server 2003

  1. Open the ESET Remote Administrator Console (ERAC) by clicking Start All Programs ESET ESET Remote Administrator Console ESET Remote Administrator Console.

  2. Click Tools Server Options Updates. Deselect the check box next to Provide update files via internal HTTP server and click OK.

  3. Open IIS Manager by clicking Start All Programs Administrative Tools Internet Information Services (IIS) Manager.

  4. Click the + next to your server name, right-click Web sites and select New Web site from the context menu. Click Next in the first screen of the Web Site Creation Wizard to begin.

    the menu tree is on the left and Web Sites is under the server name

    Figure 1-4

  5. Type a name for the website in the Description field (for example, ESET mirror) and Click Next.

  6. Leave the Enter the IP address to use for this Web site field at its default setting (All Unassigned). Type 2221 in the TCP port this Web site should use field (default is 80). Leave the Host header for this Web site field empty. Click Next.

    the fields are listed in order

    Figure 1-5

  7. Click the Browse button and browse to the mirror folder by following the path below (default location for the Mirror folder). Click Open, select the Allow anonymous access to this Web site option and click Next.

    • C:\Documents and Settings\All Users\Application Data\ESET\ESET Remote Administrator\Server\Mirror
       
  8. Select the check box next to Read in the list of access permissions. Click Next and then Finish to complete and exit the Web Site Creation Wizard.

  9. ESET Mirror should now be listed under Web Sites in the IIS Manager menu tree, with the contents of the mirror folder displayed in the primary window. Right-click ESET Mirror from the menu tree and select Properties from the context menu.
    the menu tree is on the left and ESET mirror is under the Web Sites category

    Figure 1-6
  10. In the Web Site tab, check that the TCP port field is set to 2221 and the SSL port field is blank.

  11. Click the HTTP Headers tab and then click MIME Types.
     
  12. In the MIME Types window, click New. In the MIME Type window, type * in the Extension field and then enter application/octet-stream in the MIME type field. Click OK in each window.

    the second Mime Type window pops up after clicking new

    Figure 1-7

  13. Click the Documents tab and deselect the check box next to Enable default content page. Click OK to return to IIS Manager.

  14. Close IIS Manager. Open a web browser and type the URL below (where servername is replaced with the actual server name). If there are no errors, your web browser will display a text file with update information.

    • http://servername:2221/update.ver

  15. Test the newly configured mirror server by directing an ESET client workstation (running ESET Smart Security or ESET NOD32 Antivirus) to update from http://servername:2221 and check its connection.

2014年5月2日

How to Transfer Your Wordpress Blog From One Host to Another Host

Before you start with WordPress Hosting:
  • If you are a new HostGator customer or if you are upgrading your HostGator plan, you may be eligible for our free content transfer service.
  • If you are moving from a host where you used cPanel, you can perform a full backup and our Migrations department may be able to help you restore it. This will spare you from completing the steps below.
The standard way to transfer wordpress is to use its export and import function under wordpress admin tools. Otherwise, you can use the following alternative method.

Step 1: Backup Your WordPress Database Using phpMyAdmin

Before transferring your WordPress blog, it is recommended that you make a backup of your database using phpMyAdmin. Once you have successfully logged into phpMyAdmin:
  1. Click on the name of the database which contains your WordPress blog.
  2. Click Export in the top navigation menu.
  3. Select the Quick option listed under the Export Method section.
  4. Leave the selection in the format section as SQL .
  5. Click Go.
  6. Once completed, there will be a prompt to save the file. Simply click on Save as File; this will download a file named wordpress.sql to your desktop.
You have then successfully backed up your database. If you don’t have phpMyAdmin installed on your hosting account, you can use mySQLDump from a SSH terminal.

Step 2: Download/Upload All WordPress Files Using FTP

You will need to download ALL your files from your old host and upload them to your new host. This includes files from your themes folder and plugins folder. Make sure you also download any folders which were referenced outside of your blog's folder.
For example, if you are using a separate folder called images, located outside of the blog's folder, the images must be copied and uploaded to the new hosting location; otherwise, the site will contain a lot of broken links to images within the blog post.
Filezilla is the recommended FTP client. By default, Filezilla does not display the .htaccess file, for security reasons.
To ensure that your .htaccess file is included in the download, you must click on View and then select Show Hidden Files. If you neglect to upload your .htaccess file, your permalinks will not work.
Note: You should not update to a newer version of WordPress at this time as your database may not sync correctly. Complete the WordPress migration before you consider upgrading the version.

Step 3: Create a New WordPress Database and Edit wp-config.php

Create a New Database

To create a new MySQL database:
  1. From your control panel, click the MySQL Databases icon.
  2. Create a new database with a name appropriate for your blog.
  3. Create a database username and password.
  4. Assign the new user to the new database and grant All Privileges.
For additional help creating a MySQL database, please see:

Editing the wp-config.php File

After creating a new database, you will need to edit the wp-config.php file, which is the WordPress configuration file. This specific configuration file reads directly from a database of your choosing.
To update the WordPress configuration file:
  1. From your control panel, click the File Manager icon.
  2. Navigate to the document root for the domain for which you are updating the WordPress.
  3. Locate the file named wp-config (its normally in the group of files near the bottom).
  4. Click to open the file, and locate the following lines so that they can be updated with the correct information:
    /** The name of the database for WordPress */
    define('DB_NAME', 'cpuser_dbname');

    /** MySQL database username */
    define('DB_USER', 'cpuser_uname');

    /** MySQL database password */
    define('DB_PASSWORD', '******');

    /** MySQL hostname */
    define('DB_HOST', 'localhost');
    • If you did not edit the file on the server via the File Manager with your new database settings, upload it to the root of your blog folder.
The configuration file is now set up with the new database; however, it does not contain any database tables. In order to correct this, you will need to import the information into the database.

Step 4: Importing WordPress to the New Database

You can use either phpMyAdmin or BigDump to import your database. BigDump is the preferred option if you have a large database (10mbs or more). There is a step-by-step guide on how to use BigDump on its website.
Once you have logged into phpMyAdmin:
  1. Click the name of the Database to which you wish to import the information.
  2. Click the Import tab at the top of the page.
  3. In the File to Import section, select the SQL based file from your computer that you wish to import.
  4. Use Partial Import if you intend to skip a set number of code rows.
  5. The Format and Format Specific Options sections can be left to their default values.
  6. Click Go to initiate the import.
Note: Importing via phpMyAdmin is less strenuous on the browser compared to the SQL option (BigDump) since the query may take a long time and can sometimes crash your browser.

HostGator » Free Domain Name Transfer Form

HostGator will transfer the primary domain name (.com, .net, .org) associated with a new client's account upon signup at no charge. Please make sure you have completed the following process before submitting this domain transfer form. 

Please understand that it's not necessary to transfer a domain name with us to host your web site with HostGator. It is possible to leave your domain registered elsewhere, but point it to us using our nameservers. A majority of our clients decide to transfer their domain registrations to HostGator for the better support. Also, if the domain is new, you must wait 60 days until submitting this form, as brand new domains can't be transferred. If you still wish to transfer the registration to us, please follow these guidelines: 

1. Make sure the WhoIs information is up-to-date.
2. Make sure you have access to the email address stated in the WhoIs Information.
3. Update name servers to the HostGator name servers prior to initiating transfer.
4. Unlock the domain.
5. Retrieve the EPP Authorization key from your current registrar. 
6. Fill out the HostGator domain transfer form.
7. Please ensure that the domain is at least 60 days old.
8. This process can take up to 7 days, so please allow plenty of time for your previous registrar to approve the transfer.

Any domain transferred to HostGator is automatically renewed for an additional year for free! 
*Please note that a small fee may be required for certain TLDs with higher pricing structures (Example: CO.UK, .CA, .DE, .MOBI, etc) 


Easy to maintain your domain through HostGator. Consider to order domain from HostGator...

Update wordpress domain address after site/domain transfer

WordPress Home Fix

If the links in your blog show the wrong domain, redirect to another site or if they are missing images or styling, this is typically due to an improperly configured URL for your blog's domain name in your database.
To resolve the issue, you will need to update your domain in WordPress; this update will also be necessary to make your blog display and function properly with your temporary web address or secure web address.

Update WordPress Domain with Database Access

To update an improperly configured WordPress domain or to use a temporary URL or a secure web address for your WordPress domain via database, follow the steps below:
  1. Log into your cPanel.
  2. Check the wp-config.php file in the appropriate directory to get the WordPress database name.
    1. In the Files section, click the File Manager icon.
    2. Select the wp-config.php file in the base directory for your blog.
    3. Right-click on the file and select View.
    4. Find the line:
      define('DB_NAME', 'username_wrdp1');
    5. Exit the File Manager and return to cPanel home.
  3. In the Databases section of cPanel, click on the phpMyAdmin icon.
  4. In the left menu, click on the database name.
  5. In the left menu, click on the wp_options table.
  6. In the option_name column, look for the siteurl and home variables.




  7. Change those variables to the correct address for your blog.
    1. Click Edit on the far left of the option name.
    2. On the next page, place the full URL for your site into the large text box in the option_value field.
    3. Click Go.
If you are using your temporary URL or shared SSL address to preview your blog on the HostGator servers, be sure to change the siteurl and home database values back to your normal domain if you want your blog to work with your regular domain name once your name servers (or DNS) have been switched over to HostGator.

Update WordPress Domain through WP-Admin

This method cannot be used if you cannot access the WP-Admin section of your WordPress installation.
WordPress allows users to update their domain name through the administrative access panel; however, this should be done with caution. This method is best for users who wish to update the domain prior to a directory change.
To change a WordPress domain through WP-Admin:
  1. Visit http://yourdomain.com/wp-admin/ and log in with your admin username and password. (Be sure to replace yourdomain.com with your working domain name.)
  2. In the left menu of the dashboard, click Settings.
  3. Under General Settings, in the WordPress address (URL) field, enter the new domain.
  4. In Site address (URL) field, enter the new domain again.
  5. Click Save Changes at the bottom of the page.

WP-Admin Lost Password

If you've lost or forgotten your WP-Admin username or password, navigate to the login page (http://yourdomain.com/wp-admin/ ) and click the Lost your passwordlink.

You will be prompted to enter your username or email address in order to receive an email with your username and a link to create a new password at the email address you entered when you created your blog.

Update WordPress Domain via File Manager or FTP

If you are unable to update your WordPress domain using the methods above, you can alternativley try the following:
  1. In cPanel, go to File Manager or connect via FTP.
  2. Navigate to your WordPress directory.
  3. Edit the wp-config.php file.
  4. Update (or add) the following lines to the code:
    define("WP_SITEURL","desired url address");
    define("WP_HOME","desired url address");
  5. Save the changes.