Java .Net to CSV "Converter of the Future" is here...


Written on Friday, June 08, 2007 by Gemini

CSV stands for Comma Separated Values. It is a list of comma delimited values, looks similar to an Microsoft Excel worksheet. It is a plain text file version of the Excel spreadsheet, but very small in size (as it does not contain unnecessary tags contained in Excel file). CSV files are used to transfer huge chunks of data (spreadhseet / database content) between applications / systems. It is a cost-effective way because of:

  • Its smaller size. Hence it puts less strain on system resources
  • Its relatively plain & simple structure. It makes the encryption / decryption quite easier.
When the content is huge (typically of the Enterprise Resource Planning / Customer Relationship Management / Business Intelligence systems), converting data to CSV might pose problems, as data might be lost during conversion. Also, if the conversion algorithm is not incorrect, then uploading the converted CSV file will give erroneous results. Typically developers use CSV files to convert data between different programming languages. For example, there is an (legacy) application written in Java, and now you are migrating to .Net technology. You have designed the front-end and the business logic in .Net. However, the database would more or less be the same. But the way Java & .Net communicate with the underlying database is different. So you have a problem here.

You have two options - either to start from scratch (and lose all the existing data), or to use DataStreams from CSVReader - an effective tool for converting data between Java & .Net using CSV format. CSVReader is a .Net component library using which developers can easily integrate data from various formats including CSV, Microsoft Excel, or even XML. This can be extremely helpful while porting your applications.

CSVReader claims to have extremely fast & stable conversion from a stream-based data format to practically any other text-delimited format (like CSV, XML). You can use seamlessly this tool in your C#, VB.Net, ASP.Net applications, or practically any application based on .Net technology. It even offers backward compatibility with older .Net versions. To prove that CSVReader is the fastest conversion tool, let's take a case where conversion time using ODBC tools is typically 25-30 seconds. For conversions using Jet tools, it takes around 10-15 seconds, and for CSVReader, it justs takes less than 5 seconds!!! Wow! now that's something. And I am sure the price at which it is offered is just perfect. Guys, go ahead and get this awesome tool for all your CSV conversion related needs.

It is an Advertisement. Product URL: DataStreams

If you enjoyed this post Subscribe to our feed