En curso

CSV Merge/Mapping Utility

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]">

## Deliverables

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.

<P>

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.

<P>

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.

Habilidades: .NET, Programación en C, Programación en C#, Ingeniería, Microsoft, MySQL, PHP, Gestión de proyectos, Arquitectura de software, Verificación de software, Visual Basic, Windows Desktop

Ver más: what is data structure in programming, what is an interface in programming, use of data structure in programming, src program, src format file, reformat data, outlook programming, img wordpress, data structure programming questions, data structure in programming, custom formats in excel, custom excel programming, c map data structure, best c programming questions, utility mapping, need xml file programming, merge data, i have 300 names in excel, data merge, data mapping, csv to excel, come up with business name, astronomical, drag drop excel, map data excel files

Información del empleador:
( 22 comentarios ) Sioux Falls,

ID de proyecto: #3134566

Adjudicado a:

Ruturaaj

See private message.

$85 USD en 10 días
(221 comentarios)
6.6

19 los freelancers están ofertando un promedio de $121 para este trabajo.

smartprovw

See private message.

$148.75 USD en 10 días
(323 comentarios)
7.8
hwanghendra

See private message.

$106.25 USD en 10 días
(457 comentarios)
6.9
dvfabia

See private message.

$110.5 USD en 10 días
(278 comentarios)
6.3
daaaavevw

See private message.

$127.5 USD en 10 días
(72 comentarios)
6.3
meparashar

See private message.

$148.75 USD en 10 días
(83 comentarios)
5.7
suryavijayvw

See private message.

$126.65 USD en 10 días
(127 comentarios)
5.7
vw6868760vw

See private message.

$127.5 USD en 10 días
(53 comentarios)
5.6
MoonSoftware

See private message.

$127.5 USD en 10 días
(53 comentarios)
5.5
tudoralex

See private message.

$127.5 USD en 10 días
(32 comentarios)
5.3
jeromeanthony

See private message.

$148.75 USD en 10 días
(26 comentarios)
5.2
azrajobs

See private message.

$148.75 USD en 10 días
(56 comentarios)
5.2
enikos

See private message.

$85 USD en 10 días
(6 comentarios)
3.5
irfantasneem

See private message.

$148.75 USD en 10 días
(10 comentarios)
2.8
bipi

See private message.

$85 USD en 10 días
(12 comentarios)
2.5
isolutionslx

See private message.

$85 USD en 10 días
(5 comentarios)
2.0
vbguru1vw

See private message.

$148.75 USD en 10 días
(1 comentario)
1.1
mastersrac

See private message.

$85 USD en 10 días
(0 comentarios)
0.0
anonymous11205

See private message.

$127.5 USD en 10 días
(1 comentario)
0.0