csv – Pario TechnoBlob

Windows

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 […]

Windows

Exporting last name, first name and username from Active Directory using AdFind

AdFind is a Windows command line Active Directory query tool. It is a mixture of ldapsearch, search.vbs, ldp, dsquery, and dsget tools with a ton of other cool features thrown in for good measure. This post describes how I managed to export Last name (surname/sn) First name (givenName) Username (samaccountname) from a Active Directory and […]

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 […]

Scripting

Comma separated list of system processes

Run this command from a console window ps axo “%u,%U,%p,%a,%z”

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, […]