Posts Tagged “CSV”

When working on a project where I was required to merge two sets of like data to make sure there were not any conflicts I needed a way to dump PostgreSQL database tables to Excel formatted .CSV files. Anyhow dumping Postgres tables to excel is easy to do by following the below directions.

Read the rest of this entry »

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

Comments No Comments »

The Interactive Ruby Shell, or IRB, doesn’t have a way to clear all variables that I am aware of besides quitting irb and then restarting irb however you can simulate this by invoking subirbs. Subirbs are jobs underneath the main irb session that will allow you to work within irb on different code at the same time without having to stop irb and restart it. So you can load certain gems from the main irb session and not be required to reload them for each subirb. Below are some examples of how subirbs or irb jobs are used.

Read the rest of this entry »

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

Comments No 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 »

If you want to export a subset of data (rather than the entire database or table) in CSV format:

Export subset of data with PgAdmin

  1. Click “Execute Arbitrary SQL queries” button
  2. Type query that will generate the subset of data
    • eg. select * from users where id >= 433 and id <= 436;
  3. Click “Execute query, write results to file” button (save file as temp.csv)

Import subset of data with psql (not supported in PgAdmin yet)

  1. copy vitals from '/temp.csv' DELIMITERS';' CSV;

The import feature will be available in PgAdmin soon.

References

A more thorough article:  Importing CSV Files to PostgreSQL Databases

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , ,

Comments No Comments »