Software development, photography, jokes, ....


Sites by me

 
tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelkussens voor verstandelijk gehandicapten
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen naam@vos.net emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen
Professionele opvang bij Gastouderbureau
Kind-Zijn
Salarisadministratie en belastingadvies bij
De Zaak Loont
Zutphense Bomenstichting

Hosting Favorites

 
ANU Internet Services
XelMedia .internet Services
register.com

Blogroll

 
Bomenstichting
LassoSoft
MacFreak
Quality that computes
The Economy of Motion
Wheel 2.0
IntrAktv



Website Hosting bij Xel Media


Marc's Place


 

ICS Viewer 2.9 #icsviewer #ical #calendar #viewer #xojo #event #planning #planned #timeline

icon
The ical/ics calendar file viewer ICS Viewer is updated to version 2.9.

What is new:
- New: Added an 'Export' feature, which exports to a .csv file.
- New: Added automatic save/restore of column checkboxes and decimal separator.
- New: Added column ATTENDEES.

What has changed:
- Moved LOCATION into its own column.
- No more rounding of hours. Hours are displayed with 2 decimals.
- Open and Save dialogs are now sheet windows on Mac OS X.
- When checking/unchecking columns or loading a new file, the chosen sort-column is now remembered.
View Comments
 

Install PHPMailer on MacOS X 10.11 El Capitan or higher

Installing PHPMailer on MacOS X 10.11.6 El Capitan or higher is not as straightforward as I thought because of the new MacOS X System Integrity Protection security where one is not allowed to install stuff in /usr anymore. I wrote down my steps on how I installed PHPMailer on my Macs on this page… .
View Comments
 

ICS Viewer 2.7

icon
The ical/ics calendar file viewer ICS Viewer is updated to version 2.7.

From / To dates selection fixed.
From / To dates would take the chosen date, but with the current time as as start or endpoint.
For example: 01-01-2016 09:10:34 to 13-12-2016 09:10:34
This would cause events on 01 jan 2016 earlier than 09:10 and events on 13 dec 2016 later then 09:10 not to show up.
From / To dates now use 00:00:00 as From time and 23:59:59 as To-time.

About-window at start
The About-window will not show itself automatically anymore when opening the app.
The about window would pop-up each time you start the application until you donated; only then it would not pop-up anymore.
Since this is a bit annoying, I moved the Paypal-button to the main window. When you donate, this button wil disappear.

New version-detection
As of v2.7, the app will check for a new new version and pop-up a notification dialog with a link.
View Comments
 

CSVviewer - Quicklook CSV files #utility #macos #linux #windows #csv #database

CSVviewer (formerly known as TABviewer) is a tool which shows the contents of text files, where data of each line is equally separated by either a semicolon, a comma or a tab-character.

You can download it here.
20160926-csvviewer
View Comments
 

ICS Viewer updated to 2.6

The ical/ics calendar file viewer ICS Viewer is updated to version 2.6.

CATEGORIES added as a new column.


 
View Comments
 

Apache vhost sort order on CentOS

I’ve written a page on how to control the order of Apache vhosts [on CentOS]. Just for reference.
 
View Comments
 

ICS Viewer updated to 2.4

The ical/ics calendar file viewer ICS Viewer is updated to version 2.4.

A multi-line SUMMARY, which I did know could exist, is now handled correctly.

Thanks to Phil Birch for pointing this out.

 
View Comments
 

ICS Viewer updated to 2.3

The ical/ics calendar file viewer ICS Viewer is updated to version 2.3.

DTEND with All-Day Events is now handled correctly: DTEND minus 1 day is actually the last day of the All-Day Event.

Thanks to Kevin Edwards for pointing this out.

 
View Comments
 

ICS Viewer updated to 2.2

The ical calendar file viewer ICS Viewer is updated to version 2.2.

A crash when no DTEND entry was present has been repaired. This seems to be possible with Google Calendar events.
 
View Comments
 

Cool Unix-Shell Prompt

At the shell-prompt in Terminal or some SSH session, copy/paste the following line:

export PS1="\n\u@\h \A \w $ "

and see the following nice shell-prompt:

shellprompt
You will have the following information always present:
  • Who you are
  • On which machine you are
  • The current system time
  • The current working directory cq. folder you are in
  • The $ as the separator
  • And a new line after a command
To have this prompt permanent, add the line mentioned above to the file /etc/profile

 
View Comments
 

Quickly transfer MySQL databases to a new server

Again I needed to transfer all data from one server to another. I knew I documented the transfer of MySQL databases somewhere (it's deep inside in the Replication-how-to) and decided to post them again here, so they're quicker to find.

One can transfer MySQL databases in various ways:
  1. Using mysqldump and zip + ftp
  2. Zip the database itself + ftp (you might need to repair the tables after unzipping)
  3. Use Navicat's Data Transfer module (not always good for tables with millions of records or blob data)
Personally, I prefer to use option 2, like below, in Terminal or an SSH session:

$ cd /var/mysql/ (or /var/lib/mysql/)
$ sudo zip -r ~/[database].zip [database]

Do this for each database that you want to copy. Then send all zip's per FTP to the new server.
Start an SSH session with the remote server and enter the following commands:

$ cd /var/mysql (or /var/lib/mysql/)
$ sudo unzip ~/[database].zip
$ sudo chown -R _mysql:admin [database]

For the above chown, check first with ls -l if _mysql:admin are the right owners. Then do this for each unzipped database.

Next, start Navicat and now you should see your databases in the connection of the new server. If not, you probably forgot to either do a Refresh Connection or the chown-command.

If you can access the tables and view data, good! If not, right click the table and choose Maintain->Repair Table->Quick or ->Extended and then try again.
 
View Comments
 

ProFTPD with MySQL backend

I know there are already many pages about ProFTPD and MySQL, but all info I needed was scattered over the Internet.
Therefore I collected all info I needed and put into one page: Setup ProFTPD and MySQL.
 
View Comments
 

ICS Viewer v2 is out. View and export .ics calendar files

Version 2 of ICS Viewer was released today. Someone reported a crash, which had to do with the order of VEVENT entries. This, among other things, has been fixed. Enjoy!

View Comments
 

Relocate SVN repositories with SmartSVN

Today I had to move our SVN repositories to a new server, because the old one (an Xserve G5) is being emptied and then either sold or thrown away. So if you're interested in an early 2005 Xserve G5, send me a note. Anyway, relocating a repository was easier than I thought. A bit of reading and googling revealed the steps I had to take and to help you, I wrote them all down, sort of collected steps-to-take, and posted them on this page.
View Comments
 

ICSviewer

iconA small program to convert a calendar-export (.ics-file) to table-format and calculate working hours, so you can copy and paste the results of your calendar entries into an invoice or a spreadsheet.
Download here.
View Comments
 

Using FTP in Lasso

I created a page about the various ways to use the FTP protocol with Lasso, from and to various systems. Find it here. I have been trying to get it work the last few days and now that it does, I wanted to share what you can do. Of course there are probably installations where it all works out-of-the-box, but this time not with me.
View Comments
 
See Older Posts...
© 1997- Marc Vos (and others) Contact Me