Store the updated list of map items into csv (including the unmapped cases)
Have a person edit the csv to patch the gaps (i.e. map the unmapped items)
Back to step 1, so that with every reload the mapping list is more complete than the time before.
Problem I'm running into:
For some reason after the load (of a previously stored file), the first column name is prefixed with a set of special characters.
I've tried specifying the character set, but that can only be done on the Load not on the Store, and I can't seem to find info on the default codepage for the Store operation.
I know I'm fudging things by mixing csv and txt, but my options here appear very limited.
The two code lines pertinent to my question:
Store OwnerLookup into $(vSharePath)APPS\OwnerLookup .csv(txt);
LOAD * from $(vSharePath)APPS\OwnerLookup .csv (txt, delimiter is ',', embedded labels)
