Misc

Simple Windows Print Accounting using Event Viewer data

This post continues where my previous post titled Export events including Event Properties from Windows Event Viewer left off. The data I’m going to work with was exported using eventquery.vbs and saved in a CSV-file, comma separated file and it is presented in the form shown below. “Information”,”10″,”12.05.2009 13:24:48″,”Print”,”Servername”,”None”,”AD\username”,”Document 232, filename.pdf owned by username was […]

Read More
Linux

Import csv data to mysql

This is a short note about how to import comma separated data, CSV, from a file into a mysql database from a shell. Log in to your mysql database and choose the database you are going to import into. Type in the following in the mysql console to import from the CSV file load data […]

Read More
Linux

MDB tools to export (migrate) from mdb (Microsoft Access format) to mySQL

This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin. To export a given table from a mdb-file, we type: mdb-export db.mdb customers >> customers.csv In my case, since I got some danish characters, […]

Read More