I'm having the following conundrum with a bulk update of Metadata. But first, some background...
I have a library of about 2000 letters that currently live on a shared drive. We're migrating those to SharePoint so we can track changes and make them available as read-only reference documents for our CSRs. Each letter on the shared drive has a header paragraph that was manually added before it was stored. The header looks like this:
Service Guide - WI Description: Explains payment and billing options Reference Number: 1298 Replaces brochure: N/A Special Conditions: N/A States Applicable: WI & MI How Generated: This document is for viewing purposes only When Generated: Consultant can mail through XXXX Owner: Sxxxx Xxxxx Last change date: Sept. 21, 2010
I've created a delimited text file containing all the data values (extracted by choosing a substring of 'stuff after the colon' when the line startsWith), but now, I'm getting data mismatches when I try to paste that data into SharePoint's datasheet view of my library.
For instance, I've got a StatesApplicable column defined as two checkboxes, WI and MI, and the ability to check one or both. Pasting the string "WI", "MI" or "MI; WI" results in a mismatch--I suspect that in a battle between String vs. SP checkbox, SP wins.
Any suggestions about a good way to go about importing these data values?