Some Fields Not Available? - AMOQ (Answered my own question)

Aug 28, 2009 at 4:20 PM

First of all, fantastic stuff, so glad this project is here!

I answered my own question just as I was about to post.  I’m still posting in the event someone else has the same question, as I did a search and didn’t see something similar to my problem

Using SQL 2005, and Sharepoint lists as my source...in the column mappings for my lists, I was noticing some fields are being ignored.  I first noticed a field named Index (wasn't my idea for a name) was not showing up as an available field, but then I saw it available in another Sharepoint list as available for mapping.  Same thing for a field named Description. 

Long story short, these fields are the primary or link field (what is the correct term for the field that has the dropdown menu?).  I started noticing the LinkTitleNoMenu field in the mapping and in a moment of genius decided to try that, and behold, what I’m sure everyone else knew already, I just discovered.

So hopefully someone else as equally a noob as I will find this helpful.

Coordinator
Sep 29, 2009 at 4:56 AM

Thank you! I'm glad you found it and got it to work.