Cleanliness is next to…

This year has been all about migrating existing business objects to SharePoint 2010. Some of these projects required bulk processing and conversion into either SPFile or SPItem objects. While there are excellent third party tools like ShareGate that help people migrate existing content back and forth inside of SharePoint; it is not always an option in that one project you are spinning. This is a simple method I use to clean strings of illegal, and some bothersome, characters on the way into SharePoint from either file shares, Lotus Notes, old database, web … whatever the source, it’s a good idea to clean it up first.

Essentially just open your connection to your data source, iterate and store a list of objects with corresponding properties in a generic. For each string that serves as a file name or a title field you want to have a measure of control over, send the string to a method like this example cleanstring.txt and return it without problematic values.

Posted in sharepoint

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Activity

  • Weight Training
    On February 21, 2018 4:53 pm rode 0.00 mi. during 00:20:00 hours climbing 0.00 ft.
  • Afternoon Run
    On February 20, 2018 3:43 pm rode 3.56 mi. during 00:35:29 hours climbing 144.03 ft.
  • Workout
    On February 17, 2018 4:43 pm rode 0.00 mi. during 01:30:00 hours climbing 0.00 ft.
  • Afternoon Walk
    On February 15, 2018 4:59 pm rode 1.40 mi. during 00:30:00 hours climbing 0.00 ft.
  • Afternoon Run
    On February 14, 2018 1:32 pm rode 3.78 mi. during 00:40:07 hours climbing 168.64 ft.
  • Afternoon run
    On February 12, 2018 5:22 pm rode 3.20 mi. during 00:30:00 hours climbing 0.00 ft.