Anyone seen a control like this?
I allow my users to upload files to be imported into our database. These are usually csv or tab delimited files.
I have a few customers that can't grasp the fact that the columns for the import need to be in a particular order, so for those customers, I have to manually import their files.
I'd like to build a configuration screen for them to tell me what format their file is in so I can save the configuration and then import their files based on that configuration. That way, I won't have to manually import their files.
I'd like something that would allow them to move columns in a table or grid to match their specific configuration.
My import process requires this configuration:
- Part Number,Alt P/N# or NSN P/N#,Condition Code,Quantity,Description
But several customers have files that are in this format:
- Part Number, Description, Quantity, NSN, Condition, Alt-Number, Manuf
I discard any unused columns, such as Manuf. (for this customer, we don't use NSN, we use Alt-Number
for the Alt P/N# or NSN P/N#)
I want to present them with a grid showing only the headers. Then each column should have a right and/or left arrow on them. When the arrow is clicked, that would increase/decrease the index of the column in the grid and it would move positions in the grid.
Then I will take the column indexes and save them in a configuration for the customer's format to be remembered.
Can anyone help on this one?