Hi ,
I am having problem exporting name fields for derived types using salesforce query api call
for one of the projects..everything else works fine..
so I tried to check this bug with the jitterbit salesforce pack from the forum and its the
same results ...so here are the details
I am using the sample jitterpack for salesforce downloaded from the forum
http://www.jitterbit.com/PhpBB/viewtopic.php?f=6&t=66
and running it on on Jitterbit Client 3.0.0.70 Community & Jitterbit Server 3.0.0.64 Community Edition
It runs fine
1) It creates a Account "New Account...." in salesforce
2) Queries the Account back by name "like query."
3) Deletes the Account back
Now, the problem comes in step 2 , seems like the old bug in jitterbit
http://sourceforge.net/tracker/index.php?func=detail&aid=1871544&group_id=155858&atid=797458
is again opened up
a) the acccount's name field( or any other entity's name field) is not getting
transformed( I have attached the debug logs).
The name comes fines from salesforce API + The mapping is simple ( no scripts)
b) I have made sure that I am mapping the derived type "Account"'s name property properly from the
query response.
Any help will be greatly appreciated.
Attachments
1) Jitterpack
2) Jitterpack target files o/p s ( they are plain text file)
3) debug logs
below is the query made from api with response.
Select Id,Name,Type,RecordTypeId,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Fax,Website,Industry,AnnualRevenue,NumberOfEmployees,Description,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastActivityDate from Account where Account.Name like 'New Account%'
Response from api
<?xml version="1.0" encoding="UTF-8" standalone="no" ?><jb_ws:root xmlns:jb_ws="http://www.jitterbit.com/XsdFromWsdl"><jb_ws:transaction xmlns:ens="urn:sobject.enterprise.soap.sforce.com" xmlns:fns="urn:fault.enterprise.soap.sforce.com" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tns="urn:enterprise.soap.sforce.com" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><response xmlns="http://www.jitterbit.com/XsdFromWsdl" xmlns:prefix1="urn:enterprise.soap.sforce.com" xmlns:sf="urn:sobject.enterprise.soap.sforce.com" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><jb_ws:body><queryResponse xmlns="urn:enterprise.soap.sforce.com"><result><done>true</done><queryLocator xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><records xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="sf:Account"><sf:Id xmlns:sf="urn:sobject.enterprise.soap.sforce.com">0018000000h25sPAAQ</sf:Id><sf:AnnualRevenue xmlns:sf="urn:sobject.enterprise.soap.sforce.com">150000.0</sf:AnnualRevenue><sf:BillingCity xmlns:sf="urn:sobject.enterprise.soap.sforce.com">My City</sf:BillingCity><sf:BillingCountry xmlns:sf="urn:sobject.enterprise.soap.sforce.com">My Country</sf:BillingCountry><sf:BillingPostalCode xmlns:sf="urn:sobject.enterprise.soap.sforce.com">MyZIP</sf:BillingPostalCode><sf:BillingState xmlns:sf="urn:sobject.enterprise.soap.sforce.com">WA</sf:BillingState><sf:BillingStreet xmlns:sf="urn:sobject.enterprise.soap.sforce.com">MyStreet</sf:BillingStreet><sf:CreatedById xmlns:sf="urn:sobject.enterprise.soap.sforce.com">00580000002UveSAAS</sf:CreatedById><sf:CreatedDate xmlns:sf="urn:sobject.enterprise.soap.sforce.com">2010-04-16T07:54:05.000Z</sf:CreatedDate><sf:Industry xmlns:sf="urn:sobject.enterprise.soap.sforce.com">Software</sf:Industry><sf:LastModifiedById xmlns:sf="urn:sobject.enterprise.soap.sforce.com">00580000002UveSAAS</sf:LastModifiedById><sf:LastModifiedDate xmlns:sf="urn:sobject.enterprise.soap.sforce.com">2010-04-16T07:54:05.000Z</sf:LastModifiedDate><sf:Name xmlns:sf="urn:sobject.enterprise.soap.sforce.com">New Account 2010-04-16 13:23:46</sf:Name><sf:OwnerId xmlns:sf="urn:sobject.enterprise.soap.sforce.com">00580000002UveSAAS</sf:OwnerId><sf:RecordTypeId xmlns:sf="urn:sobject.enterprise.soap.sforce.com">01280000000U9uvAAC</sf:RecordTypeId><sf:SystemModstamp xmlns:sf="urn:sobject.enterprise.soap.sforce.com">2010-04-16T07:54:05.000Z</sf:SystemModstamp><sf:Website xmlns:sf="urn:sobject.enterprise.soap.sforce.com">www.jitterbit.com</sf:Website></records><size>1</size></result></queryResponse></jb_ws:body></response><request xmlns="http://www.jitterbit.com/XsdFromWsdl" xmlns:ens="urn:sobject.enterprise.soap.sforce.com" xmlns:fns="urn:fault.enterprise.soap.sforce.com" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tns="urn:enterprise.soap.sforce.com" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><jb_ws:header><tns1:SessionHeader xmlns:tns1="urn:enterprise.soap.sforce.com">
<tns1:sessionId xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">00D80000000dGQ8!ARcAQB_uUTZzKA1BRYRgsNY5W_4qb.alr3pSOyShqQQYcd.mSRf7ERREnrIy7RUlydrQnZ5HqtzcknXuuD5eu50NhAO78FIF</tns1:sessionId>
</tns1:SessionHeader><tns1:QueryOptions xmlns:tns1="urn:enterprise.soap.sforce.com"/></jb_ws:header><jb_ws:body><tns1:query xmlns:tns1="urn:enterprise.soap.sforce.com">
<tns1:queryString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">Select Id,Name,Type,RecordTypeId,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Fax,Website,Industry,AnnualRevenue,NumberOfEmployees,Description,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastActivityDate from Account where Account.Name like 'New Account%' </tns1:queryString>
</tns1:query></jb_ws:body></request></jb_ws:transaction></jb_ws:root>
jitterbit response after transformation ( see the second field name disappears)
accountnumber,name,.....
0018000000h25sPAAQ,"",MyStreet,My City,WA,MyZIP,My Country,"","","","","","","",NA,""
see debug attachment for more details
PS: I can not add a attachment larger than 256 k so let me know how can i send you the rest of the files..
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
jitterpack
Last edit: Anonymous 2014-03-15
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
jitterbit xform targets - output
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
jitterbit debug logs
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
ok I could upload rest of the files
Last edit: Anonymous 2017-01-10
Hi
I am new to the community so not sure how long will it take for this bug to be assigned or worked upon..if anybody can please pass on thier initial comments about this problem that we are facing , it will be great help
Thanks a lot