function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
fbastokfbastok 

fields access : some are missing

  Hi,

I try to use the Xcel connector to access fields in the Account tabs.
One of my custom field is not listed in step 2 of the wizard, so I can access it.
Data type for this field is Lookup(user). Is there any way I can access it ?

Thanks
Chester CheetahChester Cheetah

Hi,

I am having the same problem.  The nearest I can figure is that there is a bug in the Excel Connector that only seems to affect custom lookup fields on standard page layouts.  The WSDL shows the field to be available, but the descriptor is not showing the field in the list.  Have you had any luck figureing this out?

 

Chester

Harry JamesHarry James

This is a stab because I can not remember which version of the API supports which features.  When you logon, does the "Server URL" box end in ....Soap/c/6.0?  If it does,click the Advanced command button and change the 6.0 to 7.0

See if that helps.

 

fbastokfbastok
It works by changing it to 7.0.
Thanks a lot!
spinner65spinner65
Regarding the sforce Connector for PE:

I have been having the exact same problem in trying to access more than 2 Lookup fields. I have built several lookup fields onto both Standard & Custom objects, but with no success in viewing any of them in the picklist window.

Before I found your recommended solution, I was always logging in as per normal with the https://www.salesforce.com/services/Soap/c/6.0

but now with a change in seetings in Advanced to the API 7.0, I am always loggin in with  https://www.salesforce.com/services/Soap/c/7.0

It fixes this problem 100%!!
And now saves my client a ton of time vs. inserting over 5000+ records manually.

thank you.