Document Generation from Database (Merge) Openoffice & MS-Word

Most everyone need to generate some document at some stage. You can generate your own document with the field names from the database and this document will then be saved to the database.
As soon as the Document is saved a number for it will be generated.

For instance your standard greeting might look like
With all your company logos and layout within the document.

A process then pick up these numbered templates and generated a Merge document that looks like
Dear Mr J Doe
and the rest of the document still stays intact.

These merged documents can then be saved as a new document to the database BLOB field. It is very robust and every field corresponds to the database field in the format DATATABLE.FIELDNAME as a merge field in the document.

We can easily help you with your document management and document merging.

Both MS-Word and Openoffice or Libreoffice documents can be merged.

You don’t have to save the resultant document to the database it can be emailed or saved to disk if you prefer, whatever other electronic purpose you require.

Top Excel Shortcuts

Here is a list of Excel shortcuts that are very useful.

F2 : Edit selected cell
F4 : Repeat last edit
F9 : Calculates all worksheets
F11 : New chart
ALT : Access the ribbon for formulas
ALT + = : Automatically SUM() selected
ALT + Enter : Start a new line in the same cell
ALT + o-c-a : Auto size columns
PG + UP/PG+DOWN : Go to next/previous worksheet
CTRL + ` : Display Formulas
CTRL + Backspace : Show active cell
CTRL + Shift + # : Change Date format with day, month and year.
CTRL + K : To insert Hyperlink.
CTRL+ Shift + $ : Applies the currency format to the selected cells.
CTRL + Shift + & : Applies border to cells
CTRL + B : Bold
CTRL + I : Italics
CTRL + U : Underline
CTRL + Shift + ~ : General style number
CTRL + Shift + $ : Currency style number
CTRL + Shift + % : Percentage style Number
CTRL + Shift + ^ : Scientific notation style
CTRL + Shift + # : Date style
CTRL + Shift + @ : Time Style
CTRL + Shift +! : Number Style
CTRL + F12 : Open
CTRL + Spacebar : Select the entire column
CTRL + [ : Select all cells directly referenced by formulas in the selection
CTRL + ; : Insert actual date in active cell
CTRL + : : Insert actual time in active cell
CTRL + A : Select All
CTRL + Shift + J : List Constants
CTRL + D : Copy equation down
CTRL + F : Find
CTRL + H : Find&Replace
CTRL + Right arrow : Move right
CTRL + Left arrow : Move left
CTRL + Up arrow : Move up
CTRL + Down arrow : Move down
CTRL + Enter : Same data in multiple cells
Shift + Spacebar : Select the entire row
Shift + F3 : Find Previous

Linux Media Player Howto

If you have an old PC converting it to Linux for a media player at home is great fun and I will let you know how I did mine. You can also watch Netflix or Showmax directly on your TV in Full HD.

  1. Get an old PC with preferably HDMI or DVI video out onboard.

DVI Port looks like:


If its DVI you would need  a converter adapter to convert from DVI Male to HDMI Female. Look Like: (Picture is wrong its a DVI female you would need DVI male)


The only issue is that it will not have sound and you would require a separate audio cable for that. Maybe Stereo  to RCA.

Look like:


Now all you need is to download a Linux CD try Mint from Linux Mint.

For ShowMax to work you would need to download and install Google Chrome. Not Chromium and not Firefox.  And you should download the Latest Ubuntu flavor  from : Chrome

Now for your own Media MP3’s and MP4’s you have I suggest following the Kodi TV Addons instructions.