View Single Post
Janrith
Member
 
Join Date: Mar 2019
Location: Pacific Northwest, USA
Posts: 57

Old March 22nd, 2019, 10:23 PM
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
Janrith is offline   #512 Reply With Quote