Don,
Your approach is interesting. In our case, the system we are getting data from is an in-house mobile application that I know will not change naming conventions for the duration of this project, so I am comfortable with the workaround for the short term. The in-house application is being phased out though, so I like your idea of having a converter application in Quick Base that can be updated when the new version comes out. I have previously used a Python script to normalize our data but did not want to have to go through a separate program to get our data into Quick Base among other challenges. I had not considered having a separate app do the normalizing, and will definitely give that a try for our next project. It seems like a much cleaner way to make a lot of the data processing happen that the user never needs to see.
Thanks for the suggestion!
------------------------------
Oana Toma
------------------------------