Friday, April 29, 2011

Able2Extract: Cannot select all/area properly

Cause:
This is fairly common with free PDF creation products that deviate from PDF specification. [This kind of PDF has a] “layer” [which] is occupied by some non-standard “junk” items.

Solution:
Change Edit > OCR Options to "Perform Image-based conversion"
Select all/area

Source:
E-mail corespondence with customer service

Recording a phone call (conversation)

Panasonic TDE 100/200

Requires a Panasonic Voice Processing System
(USER_MANUAL.pdf section 1.10.5)

Cannot be done with single line telephone
(USER_MANUAL.pdf p.157, notice icon on the upper right of the page)

Store SEARCHABLE long text

WaldoNavPad
www.mibuso.com/dlinfo.asp?FileID=335

Thursday, April 28, 2011

Shrink/truncate [log] file while restoring?

alias "Restoring only used space"

Basically...you can't...but...


Source:
How to restore a SQL Server database and shrink its files at the same time?
http://serverfault.com/questions/183588/how-to-restore-a-sql-server-database-and-shrink-its-files-at-the-same-time

Restore Database w/Large Transaction Log File
www.sqlmonster.com/Uwe/Forum.aspx/sql-server/18930/Restore-Database-w-Large-Transaction-Log-File

...there is alternative using commercial product...mounting your backup file:

redgate SQL Virtual Restore
www.red-gate.com/products/dba/sql-virtual-restore/
idera SQL virtual database
www.idera.com/Products/SQL-toolbox/SQL-virtual-database/
ApexSQL Restore

Related article(s)
Brad's Sure Guide to SQL Virtual Restore
www.simple-talk.com/sql/sql-tools/brads-sure-guide-to-sql-virtual-restore-/

...and yet another one (also commercial prod): restoring to compressed format:
The only difference from a regular restore operation is that we specify that we want the .mdf and .ldf files of the restored database to be compressed. This is achieved by restoring to .mdfx and .ldfx file formats.

www.red-gate.com/products/dba/sql-storage-compress/walkthrough

OpenOffice3: Cannot remove/clear Print Area marquee

Steps to duplicate the issue:
1. Select a range
2. Click Format > Print Ranges > Define
3. Click Page Preview ==> should be as expected
4. Close Preview
5. Format > Print Ranges > Remove
6. Notice that marquees still appear on the sheet
7. Click Page Preview ==> it is displayed as a print range still in effect

Solution:
Click File > Print
The Preview box should displayed full page as it should
Choose Cancel
Click Page Preview ==> should be correct by now

Sunday, April 24, 2011

Suku bunga simpanan(Indonesian)

Tabungan
--------
BTN
Batara
> 5.000.000 s/d 50.000.000 ==> 2.00%
Last update: 02/03/2011 14:01
http://202.147.255.27/Layanan/Suku-Bunga.aspx

BCA
Tahapan
>= Rp 10.000.000 - < Rp 100.000.000 ==> 1.75%
Berlaku Efektif: 01 April 2011
www.klikbca.com/individual/silver/ind/rates.html?s=2

Related info:
Bung Dana

Simulasi Perhitungan Bunga Tabungan dan Bunga Deposito
http://takealeak.wordpress.com/2008/09/24/simulasi-perhitungan-bunga-tabungan-dan-bunga-deposito/

Suku Bunga Deposito Rupiah
www.seputarforex.com/saham/suku_bunga_deposito_bank.php

Saturday, April 23, 2011

Calculate number of months elapsed

How to calculate the number of months between two dates in Excel
http://support.microsoft.com/kb/214134