Importing completed

Posted on August 27, 2008. Filed under: Lessons Learned, importing data, milestone |

Whew.  Lessons learned:

  • Leave that friggin’ first checkbox UNCHECKED. damn.
  • Do things in the smallest possible increments so that you don’t invest a lot of time only to find out it’s not working.
  • If possible, do all the manipulation on your end before you import. e.g.: I had “M/F” for gender in my db but MS wants 1/2.  Instead of having to hand-code an import map, I just changed the data on my to make M=1 & F=2.  Much easier.
  • Test with very small batches of data.
  • Remember to delete the records before attempting to re-import them.

Make a Comment

Make a Comment: ( None so far )

You must be logged in to post a comment.

Liked it here?
Why not try sites on the blogroll...