Installer error: Check system date before you install

Make sure the dates on installer file's Properties are not later than system date
Use FPC (File Properties Changer) if necessary to modify those dates

Performing JOIN operation on two Excel list

Google keyword: join|merge excel sheet|table|list

No _satisfying_ free solution so far

One of the solution (digdb) can be found on FilesTube

BA: Security/permission related settings

Analysis Manager's "Manage Roles" seems has nothing to do with BA security.

Business Analytics Enterprise:
Add user to Security > Windows Security > Access rights
(still can't figure out the difference of permissions there)

To limit access to dimension to certain value:
Security > Roles
For example, to limit dimension Principal Code to "10" only:
* Principal Code = Allow
* Principal Code > Criteria = [click on Allow and select "10"]

File and folder management related

Create a File Expiration Task

File expiration tasks are used to automatically move all files that match certain criteria to a specified expiration directory, where an administrator can then back those files up and delete them.

Can we automate deletion process as well ?

...

If the server is configured to track timestamps for when files were last accessed, this will result in the file management task only being applied to files that have not been accessed for more than the specified number of days. If the server is not configured to track accessed times, this condition will be ineffective.

How to configure server to track timestamps ?

    fsutil disablelastaccess

Note: Enabling last access timestamps on the [Windows] filer may impact the filer's performance, due to the extra file write requirement per client access.

Configure Storage Sense Settings, including Locally available cloud content preferences · GitHub

Seems that only Server 2019 has Storage Sense :

.SYNOPSIS

Configures Storage Sense Settings, including locally availabel cloud content preferences for Windows 10 / Windows Server 2019

File can't be renamed, opened or deleted; its properties can't be viewed or unlocker'd either

--------------------------------------------------------------------------------------------
If you intend to delete the file anyway, try to delete it from DOS using 'del' command

Auto delete old files
--------------------
Google keyword:
auto|schedule delete|remove date|old file folder
windows auto search and delete old|unaccessed|unmodified file

How to: Auto Delete Old Files

Looks promising but dont try yet:
Cyber-D's Autodelete 2.15
http://cyber-d.blogspot.com/2005/10/cyber-ds-auto-delete-101.html

Configure BA Server as Registered, not Trial

Run BA_Targit\Autorun.exe from installation/setup files
Select 'Servers' menu
Click 'Configure Business Analytics Advanced'
Point to folder where finsql.exe along with FIN.flf exist

If someday ANTserver service won't start, just re-run above procedure.

Update for Symantec Endpoint Protection

Symantec Endpoint Protection / Symantec Antivirus Corporate Edition
www.symantec.com/business/security_response/definitions/download/detail.jsp?gid=savce

Related topic:
In Symantec/Norton AntiVirus, how do I check the version number of the program and the age of the virus pattern update?
http://kb.iu.edu/data/ahaj.html

Connection disruption: How to tell overloaded bandwidth from pointing problem

Both indicated by RTO but the difference is:
With overloaded bandwidth, RTO is preceded by increasing response time.

Toshiba laptop won't turned on

Symptom:
Power LED is On but display is blank, optical drive won't eject.

Solution:
Power it off first then hold Fn button while pressing Power button again.

Can I connect 2.5" laptop SATA HDD directly to desktop SATA connector?

Yes

For a faster data recovery I would suggest connecting your SATA hard drive directly to the SATA ports inside a PC computer. Fortunately, you can use same type of cables as you use for regular 3.5″ desktop hard drives.
(Source: How to recover data from failed laptop or notebook
www.datarecoverytutorial.com/recover-data-from-failed-laptop-notebook/)

SATA connectors on a laptop hard drive are similar to SATA connectors on a destkop hard drive. You can connect a SATA laptop hard drive to a desktop computer using same SATA cables.
(Source: Hard drive
www.laptopparts101.com/hard-drive/)

Configure non-domain Windows 2000 client for AU

Replace Windows\Inf\wuau.adm with the one from XP SP2

Open gpedit.msc
Expand Computer Configuration node
Right click on Administrative Template
Click Add/remove templates
Add wuau.adm
Configure Windows Update options

Run wuauclt /detectnow

Inspect WindowsUpdate.log
If there is any error, try the following step

Replace several EXE and DLL on Windows\System32 with the ones from XP SP2
(Windows 2000 client problems and WUS!
www.wsus.info/index.php?showtopic=4529)

Restart Automatic Updates service

Inspect WindowsUpdate.log again

Optional: create a windows startup script to automatically delete WindowsUpdate.log

Related
--------
How to Enable “Group Policy Editor” (gpedit.msc) in Windows 7 Home Premium, Home Basic and Starter Editions?

[How to] Force a Wsus client to check for updates [and not wait for the scheduled time to come]
run wuauclt /detectnow will trigger the notification of downloading,and not wait until its detection cycle.

Ink save printing with mCISS

Katalog Produk: Cartridge Epson T11/T20E/TX101/TX200/TX400 mCISS Fast Print (Tanpa Tabung & Selang)
http://indonetwork.co.id/oasisusb/1374860/cartridge-epson-t11t20etx101tx200tx400-mciss-fast-print.htm

According to Mr. Sandy, one black ink tank could be used for up to 100 pages of text.

Note:
Better buy printer somewhere else then buy mCISS here.

Another interesting product:
Head Cleaner
http://oasisusb.indonetwork.co.id/1340407/head-cleaner-pembersih-head-printer-inkjet-grace.htm

Split / combine file via command line

chunk.exe

download from www.oldskool.org/pc/chunk

Open/view CDR file wihout Corel Draw

Summarized from:
inkscape 0.46 + windows + uniconverter + cdr
www.inkscapeforum.com/viewtopic.php?f=5&t=935&start=0

Download Inkscape 0.46

Update Python folder under Inkscape folder with the one downloaded from:
https://bugs.launchpad.net/inkscape/+bug/197617/comments/8

Get the updated versions of uniconv-ext.py and cdr_input.inx from:
http://inkscape.svn.sourceforge.net/viewvc/*checkout*/inkscape/inkscape/trunk/share/extensions/uniconv-ext.py?revision=18471
http://inkscape.svn.sourceforge.net/viewvc/*checkout*/inkscape/inkscape/trunk/share/extensions/cdr_input.inx?revision=18463

Modify cdr_input.inx:
1)
change the line
dependency type="executable" location="path">uniconv
to
dependency type="executable" location="path">uniconv.cmd
2)
remove namespace declaration:
xmlns="http://www.inkscape.org/namespace/inkscape/extension"

Add these to system path:
C:\Program Files\Inkscape\python;C:\Program Files\Inkscape\python\Scripts
---

Self experience with .cdr containing barcodes (typed using barcode font):
In Corel, save file as .pdf
Open the .pdf with Inkscape

Fonts collection with preview of your own text

urbanfonts.com

Related
--------
Moving Fonts from one computer to another
We generally recommend that you do not put them in the windows folder...
Instead, put them somewhere else (like c:\fontlib or  a subfolder of it) and use bitstream font navigator (on the CorelDraw DVD) to manage them. It will automatically install any fonts that an existing CorelDraw file needs, for as long as CorelDraw has the corresponding file open

How to password protect PDF file for free

Alternative to zip the file and password it...

How to password protect your PDF documents for free?
http://reviewofweb.com/how-to/password-protect-pdf-documents-free/

Found in comment:
www.protectyourpdf.com/ProtectYourPDF/index.cfm

Recording with motion detection using webcam

How to use your PC and Webcam as a motion-detecting and recording security camera
www.simplehelp.net/2006/09/27/how-to-use-your-pc-and-webcam-as-a-motion-detecting-
and-recording-security-camera/

Dorgem installer:
http://sourceforge.net/projects/dorgem/files/Dorgem/dorgem210.exe/download

Related
---------
How to playback CCTV footage with motion detection
Google: motion detect on video playback

Photoshop alternatives

Google keyword: photoshop free alike|alternative

Quick jump list:
11 Free Adobe Photoshop Alternatives (Softwares)
www.hongkiat.com/blog/11-free-alternatives-softwares-to-adobe-photoshop/

www.gimphoto.com/

Free online file converter

www.zamzar.com/

- long process time (could be a day)
- no support for Chinese character

Tested:
PDF to Word --> OK

Open/view Office 2007 Word/Excel file without Office 2007

How to obtain the latest Microsoft Excel Viewer

How to view Word 2007 and Excel 2007 files by using Word Viewer 2003 and Excel Viewer 2003
http://support.microsoft.com/kb/925180

Important notes:
You cannot click Open on the File menu to open an Excel 2007 file in the Excel 2003 Viewer.

The Compatibility Pack enables you to open and view Word 2007 and Excel 2007 documents by using the Word Viewer 2003 and the Excel Viewer 2003.


How to open new file formats in earlier versions of Microsoft Office says:
Before you install the Office Compatibility Pack, make sure that your computer has all the necessary updates. To make sure that you are ready to install the Compatibility Pack, review the following information for your version of Office.

For Office 2003, Office 2003 SP3 must be installed

www.oooninja.com/2008/02/office-compatibility-pack-review.html says:
Don't let the name "Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 file format" fool you. You do not need Microsoft Office, so it works great with OpenOffice.org, Google Docs, Abiword, WordPerfect, and Microsoft Office 2003.

Integrating NOD32 with UBCD

Integrating the ESET On-Demand Scanner (v2.7) with UBCD and BartPE
http://kb.eset.com/esetkb/index?page=content&id=SOLN557

Important note from nod32.htm (part of nod32ubcd.zip):
Create "NOD32" folder in the "plugin>AntiVirus" directory of UBCD4Win installation. Copy files from this archive to NOD32 folder + add these files from an existing and updated installation of NOD32: nod32r.dll (not present in english version), nod32.exe, nod32.000,..., nod32.006. If you use english version of NOD32, comment this line in nod32.inf: nod32r.dll=a,,3 (i.e. add ";" character at the beginning of this line). Go to the plugin section in UBCD4Win main window and make sure that NOD32 plugin is enabled. Now you can run the compilation. NOD32 On-Demand Scanner will be integrated into UBCD4Win live CD.

Disable keyboard special button

Windows XP: Any way to disable "special" keyboard buttons?
http://forums.cnet.com/5208-6142_102-0.html?threadID=345174
(haven't try it yet)