Posts Tagged “Comma Separated Values”

While playing around with pbnj or scanpbnj on Backtrack just a little bit ago I received an error when attempting to have scanpbnj output results to a CSV file. The error received is easily resolved by installing a single package on Backtrack. Below the error is described in more detail along with details about how to install the package that resolves the error message.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , ,

Comments No Comments »

This afternoon I was using PGAdmin and needed to export some data from a query I had run but realized I wasn’t even sure if PGAdmin had this capability. Typically I would export data using the PSQL command line but since I was already working in PGAdmin I wanted to try and figure out if the capability existed and if so how to do it. After some playing around I was able to figure out how to export PGAdmin data to a CSV (Comma Separated Value) format that would be Microsoft Excel friendly. Follow the directions below to export PGAdmin data to a .CSV file to open in MS Excel.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , ,

Comments 4 Comments »

A client of mine still has a computer running Microsoft Outlook Express and they wanted me to import the address book contacts into their Yahoo Mail account. At first I was a little worried that Yahoo Mail may no longer support the format of Outlook Express address book contacts but then I remembered that you can export contacts into a CSV (Comma Separated Values) file which means I could manipulate the data if it was not supported. Yahoo Mail says that it supports import from Outlook but it doesn’t specify Outlook Express. I assume the format between Outlook and Outlook Express must be similar because Yahoo Mail did import the exported contacts from Outlook Express. Below I describe how to export Outlook Express contacts and then import those contacts into Yahoo Mail. Follow the instructions below that are broken into two parts which include exporting the contacts using Outlook Express and then importing the contacts using the Yahoo Mail web interface.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , ,

Comments 19 Comments »

Outlook contacts not showing up in Skype has been a problem bugging me for a couple weeks but I have not had the time to look into it until tonight. I figured that it might be a bug or something with Skype since I recently upgraded however I was incorrect. For some reason when I turned on “Show Outlook Contacts” in Skype only two of my contacts were showing up. Luckily this was the case or it would have taken a lot longer to figure out.

The issue is that in my Skype setup (not sure if it is this way for all configurations) the numbers require a +1 to be in front of the area code. So for instance if you have a contact and the number is 502-123-1234 it will not show up in Skype unless you add a plus one for the number to show as +1502-123-1234. Below I describe a couple tips to convert all of your numbers a bit easier. There is probably a VB script out there that will do this easier but it  was much easier to convert all of your Outlook contact numbers as I discuss below than manually editing each one.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , ,

Comments 2 Comments »

Google’s Gmail has a handy little interface to import and export contacts in CSV format which will allow for easy synchronization between Outlook’s contacts and Gmail’s contacts without having to install some third party software. Most people will typically be making the switch to use more Outlook thus needing to import contacts into Gmail from Outlook so below the first set of instructions explains how to do so. The second set of instructions will explain how to export from Google in Outlook CSV format and then import back into Outlook. Both import functions provide a merge so duplicates can be kept to a minimum or really even zero duplicates.

First lets look at how to export Outlook contacts to a CSV file and then import that CSV file into Gmail.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , ,

Comments 2 Comments »