Quote:
Originally Posted by Janrith
When you select Load Data, the tool appears to cache the data in memory and use that cache rather than re-reading the worksheet to build the rwexport file.
This means, if you subsequently update your source file (XLSX confirmed, probably the CSV will work the same), you need to select Load Data in order to refresh this cache or your updates won't make it to the rwexport file.
This is actually a good thing, since changing your column definition out from under your project definition could have alignment issues, depending on how the columns are being read from the file.
Haven't tested whether this cache is cleared when selecting a new structure definition. If the cache is maintained, it might be another argument for a New Project... option.
I'll test caching of CSV data and what happens when the structure is changed tomorrow... it's getting late.
Later.
-=Janrith
|
Hi,
Yes, when you select "Load Data" then it is read into memory and the file can be changed without changing the loaded data.
When you load a saved project, both the data file and the structure file are read from disk again - so any changes you've made in the CSV or XLSX file will be read in at that point.
The storage of the loaded data and the loaded structure are totally separate, so you can load a new structure file and use the already loaded data with that new file, or vice versa.