Tuesday, June 04, 2013

fixed import spec

Our import process broke with the new national CSV file, now that they've started implementing the new member type. I quickly reviewed my VBA code and wondered if the import specification profile needed freshening. If we were lucky, that'd be all that was required.

After building a new specification, I saw that the importing started to work again.

But then I found new entries in the membership type column. These would not match up with our existing ones. So I cautioned Phil about not letting these types of records in, during the review process.

No comments: