Re: How to create a test data application based on Excel spreadsheet information like this?
Michael Wallman wrote:
Yes I expect the users to add more columns possibly in future.
For example they might add CountryID, and CountryName fields.
But I have made them aware that the list of these countries would have to be added to another sheet in the Excel spreadsheet AND the script would have to be modified to load that new sheet.
This the users are willing to do as a per-requisite for generating test data.
It's not just about loading the new sheets.
You would either need to create a quite complex script and use a defined syntax in your Fields sheet (using more columns / keywords) instead of just a textual representation of your value creation logic or manually create the new logic for new sheets in the script (which might not be doable by your users).
Even if you tend to go for the first option, you would need to prepare a complete set of possible value creation rules now, or you need to adapt again and again the script to changing user requirements.
After all, maybe QV is just not the right tool for doing that, have you considered also using something more specialized in creating sample data?