Freeware Utility CSV2Code

[Overview] [Features] [Screenshots] [Example 1 (SQL)] [Example 2 (CSV)] [Installation] [Download] [Donation] [Other Freeware] [Home]

Overview

• The CSV input data must contain a header line with the field names.
• The code template contains field value placeholders, represented by field names enclosed by a special prefix/suffix, e.g. @@ID@@ as the field value placeholder for the field named ID. The code template can consist of one or more lines.
• The code template is applied to each record, thus for each record a "piece" of code (normally a single line) will be generated by replacing all field value placeholders by the actual field values of the record.

CSV2Code simplifies writing the code template, because it reads the CSV header beforehand and provides a context menu to insert field names and field value placeholders in several styles. In addition, the context menu has a special menu item to add all fields/field value placeholders with a single mouse click.

If you have any questions or comments, feel free to contact the author.

Features

• The CSV separator is selectable (TAB, semicolon, or comma).
• The CSV data can either be pasted into a memo field, or can be read from a file.
• The program analyzes the CSV data, i.e. checks if the separator is valid, reads the field names, and builds a context menu to insert field names and field value placeholders.
• When writing the code template, you can use the context menu.
• The code will be generated with options, e.g. replacing up to three text patterns or duplicating single quotes

• SQL statements
• HTML code
• XML code
• Programming language code (PHP, Java, C++, Pascal, …)
• CSV (allows reordering and/or suppressing columns and/or change CSV separator)
• Whatever you need and can imagine!

Screenshots

Example 1: SQL

The following tab-separated records are given:

Template used:
UPDATE tblEmployees SET Department_ID = @@Department_ID@@ WHERE ID = @@ID@@

Generated SQL code:
UPDATE tblEmployees SET Department_ID = 10 WHERE ID = 1
UPDATE tblEmployees SET Department_ID = 20 WHERE ID = 2
UPDATE tblEmployees SET Department_ID = 20 WHERE ID = 3

[Top]
 
 

Example 2: CSV reordering and suppressing columns

CSV records:
ID;LastName;FirstName;Comment;Department_ID;bgcolor
1;Maas;Christian;"developer of CSV2Code";10;#defdef
2;Doe;John;NULL;20;#abcabc
3;Smith;Jack;"Jack's the greatest";20;#defdef

To create a CSV file with only three columns (LastName, Comment, ID), we can use the following template (note that you could also change the separator):
@@LastName@@;@@Comment@@;@@ID@@

Generated CSV records:
Maas;developer of CSV2Code;1
Doe;NULL;2
Smith;Jack's the greatest;3

[Top]
 
 

Installation

CSV2Code is a 32 bit application and requires Windows 9x/NT/2000/XP/Vista/7/8. No special installation procedure is required, i.e. CSV2Code is a portable application. Simply create a directory (e.g. C:\CSV2Code or C:\PortableApps\CSV2Code) for CSV2Code and unzip all files of the archive into this directory.

No data will be written into the registry, no DLLs are copied to your hard disk. The user defined settings are stored in two files (INI and TPL) which are located in the same directory as the executable.

To uninstall CSV2Code, simply remove the complete folder.

[Top]
 
 

Download

• CSV2Code.exe  (the executable)
• README.TXT  (with additional information)
• CSV2Code.pdf  (Documentation)

The currrent version 1.02 contains a bugfix (in 1.01, an empty field at the end of a line wasn't properly handled - the value of the previous field was used).

Before downloading CSV2Code, you have to accept my license and disclaimer agreement.

Download CSV2Code release 1.02 here (532 KB ZIP archive).

Donation

CSV2Code is freeware. However, if you like this tool, want to appreciate my work, and/or support the development, I would be pleased to receive a donation from you via PayPal. The suggested amount to donate is US$ 15 or 10 EUR. However, any amount, higher or lower, is appreciated.
Click the button below to make a donation via PayPal in US$:		Click the button below to make a donation via PayPal in EUR:

[Top]