Bug with multiple fields with the same label

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Set up a custom field on Lead with Label="Phone" and API Name = Phone__c
2. When I run a query on Leads, I get the correct headers displayed in the 
worksheet, but the query fails with a messagebox citing a duplicate field 
on Phone__c.
3.

What is the expected output? What do you see instead? I expect the query 
to succeed. It fails as above.

What version of the product are you using? On what operating system?
Connector V9.1 running versus SFDC EE instance. Win Vista 32. Excel 2003 
SP3.

Please provide any additional information below.
I have looked at the source code and written some workaround code 
(attached). It is not that pretty, but I don't know the code well. I think 
that there will be a more elegant solution. The error results from the 
code in sfFieldLabelToName_slow always picking up the first of the 2 
identical labels.

Regards 
James

Original issue reported on code.google.com by jwil...@orcon.net.nz on 27 May 2010 at 2:19

Attachments:

• [s_force Module.txt](https://storage.googleapis.com/google-code-attachments/excel-connector/issue-4/comment-0/s_force Module.txt)

[GoogleCodeExporter]

Forgot to mention: The bug still affects the Excel Connector if the Salesforce 
Connector Options setting "Use API Names" is not selected. ie, in order for the 
above fix to work, you must check the "Use API Names" checkbox.

Original comment by jwil...@orcon.net.nz on 29 May 2010 at 3:39

[GoogleCodeExporter]

It would be really good to get the source code for the PE version as I use this 
all 
the time and it suffers from the same problem. Thx

Original comment by jwil...@orcon.net.nz on 29 May 2010 at 4:21

[GoogleCodeExporter]

Original comment by vneh...@gmail.com on 24 Nov 2010 at 7:45

• Changed state: Accepted

[GoogleCodeExporter]

One of my customers experienced a potentially related issue today. When running 
a query against Account, he noted that one of his custom fields was showing 
twice in the list of fields. This field was of type text(60) and is set as 
"required" at field level. I checked to see if there was a renamed standard 
field (No), or a deleted field with the same name (No). Nothing appears unusual 
about this field.

The workaround for this related issue is:
 - Run a query to get the header rows (with multiple copies of some fields)
 - Excel Connector fails to run the query and displays the name of the offending duplicate column(s)
 - Manually delete one of the redundant column(s)
 - Click on cell $A$1 again and re-run the query using the “Query Table Data” menu command 

Now runs fine.

Original comment by ja...@sqwarepeg.com on 29 Nov 2010 at 7:35

[GoogleCodeExporter]

Due to recent changes made by Google Apps, my account details have changed. 
Please use the Sqwarepeg details as per Comment 4.

Original comment by ja...@sqwarepeg.com on 29 Nov 2010 at 8:28

[GoogleCodeExporter]

I am running into an issue related to this bug.  For account and contact, we 
have a custom field also named "Account ID" and "Contact ID", which are 
identical to the SFDC default ID field (the 18-digit SFDC ID).  So when I run 
query, the connector pulls the data from the custom field, not the SFDC field 
which is really what I needed.  I am not a developer unfortunately and do not 
know where in the code I can fix this.  Any tips?

Original comment by jo9...@gmail.com on 27 Dec 2010 at 6:44

[GoogleCodeExporter]

Re: Issue 4 in excel-connector: Bug with multiple fields with the same
label

Hi

If you are not a developer, and all you need is the ID of these records,
then I would suggest that you use a workaround. Here are 2 options:

1)       Change the label of the custom fields temporarily. Eg, change from
�Contact ID� to �Contact ID2�, then run your Excel query and if this is the
same issue, then the labels won�t get confused. After you have completed
your queries, change the labels back again.

2)       Create 2 more custom fields on Accts and Contacts. Make these
fields formula fields that mirror the ID field. Then get the ID from your
new custom fields.

Original comment by ja...@sqwarepeg.com on 12 Jan 2011 at 7:59

[GoogleCodeExporter]

I've updated the connector to version 1603, it fixes a duplicate API name field 
bug, check it out

Original comment by vneh...@gmail.com on 14 Jul 2011 at 6:20

• Changed state: Fixed