I need a utility that will allow me to take a source CSV or Excel file and select certain columns to be exported to a new CSV file.
This is similar to Outlook's import feature, where you drag/drop fields from the source CSV to Outlook.
Example of what I'm looking to do:
<img src="[url removed, login to view]">
My business need is this: I have a master database that has an import utility. the import utility requires that the data imported be formatted CSV a certain way, with certain fields in a certain order, etc.
The data I'm trying to import comes in dozens of different formats and the time it takes me to manually reformat the XLS or CSV file is astronomical. I need a utility that takes the source file, no matter what the format, CSV or Excel, and allows me to drag/drop the field names of the source to the field name of the destination file. Similar to what outlook does when you import another program's email:
<P><img src="[url removed, login to view]"><P>
<P>I want the destination file structure to be controlled via XML. I want you to create a very basic XML file that your program reads when importing. The data stored in the XML is the destination field names. The program should simply provide an option for selecting which XML file to use. One XML file may have 3 fields, one may have 300 fields. The data in the XML file is used so when your program reads the fields from the source file, there are fields to map to in the destination file.
The program is really quite simple: Just read the field names in the source file, read the field names in the XML file, allow the user an interface liek the one above so they can drag/drop the field names from the source to the destination, give them a place to designate where they want the file saved to, then allow them to create the new file. The new file is just the source file, sorted by the field names in the destination file. Not all fields in the source file will make it to the destination file.<P>
If you are confused, please be sure to ask questions. I'm really struggling with a way to communicate what I'm looking for and this is the best I've come up with so far.