Tagged XML

Make CSV files do whatever you want, really fast

CommaThe following is a sponsored review of software that helps you work with large CSV files for data transfer and migration.

If you work in IT, you’ve probably had to deal with csv files at one time or another. The idea of a .csv file is, of course, that it is simply data separated by commas, with a carriage return indicating the end of a particular table entry and the beginning of the next. The site has a couple of versions of the CSV reader available for download, one written in Java and one in .NET. I went with the .NET version first, since it seemed to be a demo of the more full-featured downloadable version.

Ok, the first thing I figured out that wasn’t immediately obvious to me (although it does clearly say on the site that it’s a .NET class) was that I needed Visual Studio installed. Since my hard drive recently died, I don’t really have any of my old software on my computer, so I guess I now have the impetus needed to spend an hour watching Visual Studio re-install.

While I was waiting on the install, I perused the pages on the CSV Reader site to learn more about the product. What impressed me off the bat was how flexible the class seems to be–you can use it to parse records and insert them for web viewing, into an SQL database, etc. Also, the speed is impressive, as the site states “[r]ough benchmarks on a 2 Ghz processor, parsing common comma separated columns is 20 MB, or 390,000 rows with 5 columns each, almost 2,000,000 cells total, of data parsing per second.” Now, this might not be something everyone needs, but if you’ve ever used Excel to its breaking point (admittedly much higher in 2007 than in 2003) you’ll be glad you have the extra speed and ability to parse huge data files.

Also noted from the CSV Reader site is the fact that it removes the need to use Excel as an intermediary when working with .csv files. In fact, CSV Reader can work with .xls (Excel’s native format) and the ever-popular .xml format directly, alleviating the need for slower, GUI-heavy programs to do the heavy crunching work.

One of the things that I really liked about CSV Reader was the demo sample projects included with the demo, as well as the code samples available on the site itself. Also, the pricing is pretty good, starting at $150 (if you just need to use the class in-house to convert data) all the way up to royalty-free distribution rights along with the C# source code for a mere $750. Not bad pricing, considering that, once again, this is clearly targeted at DBAs and others with absolutely huge data streams that they need to deal with, not the home user with a knitting club membership database that needs to be moved from Excel to SQL.

sql, xls, csv, csv reader, xml, parse csv, parse xml, parse xls, .net, .net class, excel, csv files

WordPress blogging software administration on the Blackberry

The Blackberry: Sweet, juicy….Internet.

As PDAs and similar handheld devices continue to advance, it becomes more and more realistic to consider them in one’s site design, in order to reach the widest audience possible. Since I happen to have a Blackberry right now, I’ve been trying various sites in order to see what’s compatible and what fails miserably.

The usual suspects, such as Google and Gmail, performed flawlessly, as expected. The folks over at Google seem to a have a special little spot in their hearts for the mobile user, and their most popular offerings don’t disappoint in this regard.

Once I was sure that I’d maxed out my PDA’s capability to process client-side markup and scripting (you have to manually add JavaScript, Cascading Style Sheets (CSS), and XML support, otherwise you’re basically running Internet Explorer 4.0 on a teeny-tiny screen–a browsing experience that would make even the most desperate bsuite-hound run for the nearest Mennonite community), I headed over to this blog.

The front page loaded flawlessly, though it takes quite a while, and the Blackberry’s status bar indicates a laborious process of running scripts and proccessing CSS at what is, relatively, a snail’s pace. What surprised me the most was the appearance of a photo that went with one of the stories, nicely formatted and filling the screen. It’s easy to scroll through and read posts, click on related articles, and do pretty much anything else you’d want.

With the front page test complete, I tried logging in to the admin section. Navigating to /wp-admin yielded a standard userID/password dialog, and within 30 seconds, I was on the admin dashboard, free to click on any tab, change any options I wanted, and even post an article. As far as I can tell, WP works with the Blackberry, or rather, the Blackberry has no problems handling WordPress. It’s a far cry from the cell-phone internet I’m used to.

I plan to continue trying out sites to see where the Blackberry might get stuck. I’ll post if I find anything, and update this entry if I find any more significant sites or webapps that work.

UPDATE: I found a page with a really nice intro to CSS and web development on the Blackberry. Read about it here.