We played with a bit. We inherited hundreds of mapping documents in our own crazy custom format. We imported the mapping data as extended attributes on the columns and then wrote another script to generate the maps from that data. That gave us a lot more control over how the mappings were generated and allowed us to compensate for some issues with the data in the spreadsheets. It ended up being faster than trying to modify the format of all the spreadsheets into something more acceptable. Unless your mapping documents are pretty clean that may end up being easier in the long run.
Not yet. I was curious if there is any excel structure, which is acceptable for standard Excel import extension. I can of course write my own import script, but using standard import wizard (now it can even create external shortcuts in the model when necessary) would be much simpler than custom import.
It is similar situation to excel structure for importing indexes (including indexcolumns). The excel structure (acceptable for excel imoprt wizard) for that is not very intuitive so you just NEED TO KNOW the requirements for the excel structure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.