Jun 1, 2010
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.
View 6 Replies
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.