Hi,I have to upload a heap of documents into a document library - that has a number of custom columns. The documents are from an old web system that has tables with connecting data to each document (this data would go in the custom fields of the document library for each document). Does anyone know a good way of doing this? If this is not so straight forward could someone give me a link for migrating data to a Document Library in the Content Database from SQL Tables. Thanks.John.

Hi John,Definately not straightforward, given that you have connected metadata from another stream (i.e. SQL) related to your documents; and providing a link is pretty much impossible given that the script would somehow need to take into consideration how your SQL setup is, how your files are structured, how the links are managed etc.You most probably would have to code a web service to connect your SQL db and files location, and build an DLL to connect into Sharepoint (using the service as a conduit into SharePoint).If you want to go down the coding route you will need to see a raft of detail starting here:http://www.codeproject.com/KB/sharepoint/Exploring_Sharepoint.aspxhttp://msdn.microsoft.com/en-us/library/dd583131(office.11).aspxhttp://www.codeguru.com/Csharp/Csharp/cs_webservices/tutorials/article.php/c5477However, if you want to see one that might help you out, I would advise though that you take a look at a third party tool, for example:Quest File Migratorhttp://www.quest.com/file-migrator-for-sharepoint/or DocAve File System Migrator for Microsoft SharePointhttp://www.avepoint.com/file-system-to-sharepoint-migration-docave/Hope this helpsGeoff

I managed to do this quite easily - well 4 hours. I ensured the document library had the correct fields setup. I imported all the documents. I then went into Content Database for the site and found that mappings work as follows:-AllDocs -> AllLists -> AllUserData where AllUserData contains fields that I had added and it was just a case of migrating fields from database into the content fields. Formats were a bit strange for checklists but as long as you backup a copy and thoroughly test it it works fine. Ensuring of course it is the correct version you are updating, it is not deleted etc. A few other flags as well.

Up to you if you decide that Geoff's answer didn't help you towards getting the answer, but in order to signal that the thread has been answered, you should then mark your own post as an answer. I've done this for you. As the starter of a thread, it's not good practice to mark own posts rather than someone else's who put you on the way to a solution, but here it seems your answer is different so it's OK. (Moderator) FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.

Mike - I read on a post somewhere that you said you should not be recommending your own post as an answer.