I have to create code to allow our end users to map import data to our
existing columns. I have not done this before - and thought others might
have good ideas on ways to do this so it is simple for an end user.
I was thinking simplest would be a grid with two columns. One locked is
our base fields. Second is a combobox of their import fields - when they
select one it is taken out of the choices - they basically would have to
click each one with the list getting shorter as they go.
I would love a visual way to do it - like dragging connections similar to a
table mapping in a database app, but I don't know any tools to do this? I
guess I could have a list, and allow a user to drag items from his list
onto our choices - but how could I show them linked?
The company has enough budget that if there is a tool that will do this in
a slick, simple GUI I would love to hear about it.
Thank you.