The 401(k) program we switched to this year happens to have been a step backward as far as support for exporting transactions. In talking with Alan about it, he said he’d downloaded a program to convert the CSV they export into a QIF. In looking at the QIF format, I just decided to whip up something to do the conversion for me. This converts the export from MVP Plan Administrators to QIF and imports successfully into Quicken for Mac 2007.
#!/usr/bin/perl
#based on: http://en.wikipedia.org/wiki/QIF
open(INH, "< ". $ARGV[0]);
open(OUTH, ">". $ARGV[0]. ".qif");
print OUTH '!Account
NDavid\'s New 401k
TInvst
^
!Type:Invst
';
<INH>
while (<INH>) {
chop;
chop;
s/\$//g;
@vals = split /,/;
if ($vals[3] eq 'RECEIVABL') {
next;
}
print OUTH "D" . $vals[0] . "\n";
print OUTH "N" . $vals[5] . "\n";
print OUTH "Y" . $vals[4] . "\n";
print OUTH "T" . $vals[9] . "\n";
print OUTH "I" . $vals[8] . "\n";
print OUTH "Q" . $vals[7] . "\n";
print OUTH "M" . $vals[6] . "\n";
print OUTH "^\n";
}
close OUTH;
Known issues:
- You still need to go through and mark Dividend transactions as such.
- Doesn’t handle Sells very well, especially when these are to cover fund fees
Related posts
During the Marketplace Morning Report on 11/13, there was a segment covering Google’s recent release of software and a bounty surrounding Cell phones. During this segment, the use of the word “code” followed conventions that aren’t preferred in the Computer Science community–academic or commercial.
During the segment they refer to “based on a code that’s open”. When code is used in this context, it’s collective and should be used without an indefinite article. While, “based on code that’s open” would be correct.
Other appropriate uses:
1. code
2. source code
3. the source code
4. some source code (usually a part of a program)
5. line of code (a single line of a program)
6. a piece of code
The usage of “code” very much follows other words like “stuff” and “water”. “code” is a mass noun in the English language and thus cannot be preceded by numerals like “one code” (when the semantics refer to computer software). As a result, it’s not used with the indefinite article a or an.
Improper uses (in all below, you can simply remove the “a” or “an” for a proper usage):
I downloaded a code to solve that problem.
Google released a source-code to mobile manufacturers.
An open-source code would encourage developers.
All of the above reflects my opinion. My wife, however will often say things such as “I am trying to debug a code that I wrote a few months ago.” It also seems that in the non-CS/EE/CE fields of scientific research that this usage is quite common. One of the libraries she uses in building her programs (not codes) is FFTW has a statement on their home page
Our benchmarks, performed on on a variety of platforms, show that FFTW’s performance is typically superior to that of other publicly available FFT software, and is even competitive with vendor-tuned codes.
This too uses code as a count noun incorrectly.
Related posts
Recently I tried to use the Gallery Multiroot module/plugin to setup a new site based upon an existing Album in our gallery. Since we started sorting albums chronologically, we wanted to sort out the Dachshund photos separately. To do this, I used the Multiroot feature. Unfortunately, I couldn’t get this to work as I’m already using the Multisite plugin to host several Galleries off of my web server. The magic touch was to use the following file, the first line is key and had to be added to make things work in the Multisite configuration.
define('GALLERY_CONFIG_DIR', "/var/virtualwww/gallery.raschnet.com"); //I had to add this line
require('/usr/local/share/gallery2/embed.php');
$ret = GalleryEmbed::init(
array('embedUri' => '/',
'g2Uri' => 'http://gallery.raschnet.com/',
'apiVersion' => array(1, 2)
));
if ($ret) {
print '<body>' . $ret->getAsHtml() . '</body>';
return;
}
$gallery->setConfig('login', true);
$gallery->setConfig('defaultAlbumId', 28426);
$gallery->setConfig('breadcrumbRootId', 28426);
GalleryMain();
Now live: DRNA Gallery
Related posts