Apatar.com
|
Log In
Log In
close x
Login
Password
Remember me
Forgot Your Password?
Create Account
close x
First Name
Last Name
E-mail
Telephone
Message
Home
DataMaps
Downloads
Community
Documentation/Wiki
Report Bugs
Forums
Mailing Lists
ETL News
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Apatar Community Forums Forum Index
->
Help
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Font size
Tiny
Small
Normal
Large
Huge
Close Tags
[quote="Sergei"][quote="Anonymous"]Hi Sergei the combination of 3 values is unique. If i choose 1 value for join then there will be duplicates[/quote] Ok, then check if the field size is equal in each source. [quote="Anonymous"]i am trying to create both the account and its related contact at the same time from the csv[/quote] You mentioned that: [quote]The contact (CSV) - Transform - Salesforce (Account) : is working fine and is creating a new account [/quote] If so, then you need only to create contacts and associate them with created accounts. In this case to avoid duplicates in Account table you need to delete Transform node between CSV and SFDC account table, because you have already created accounts.[/quote]
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
All times are GMT
Jump to:
Select a forum
Apatar Open Source
----------------
Announcements
Installation and Upgrade
Help
General Discussion
Feature Requests
Downloads
Development
APPLICATION INTEGRATION AND CONNECTORS
----------------
New Connector Requests
Connectors Discussion
DataMaps
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Author</th> <th class="thCornerR">Message</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Feb 16, 2012 1:02 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody"></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Anonymous wrote:</b></span></td> </tr> <tr> <td class="quote">Hi Sergei <br /> <br />the combination of 3 values is unique. If i choose 1 value for join then there will be duplicates</td> </tr></table><span class="postbody"> <br /> <br />Ok, then check if the field size is equal in each source. <br /> <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Anonymous wrote:</b></span></td> </tr> <tr> <td class="quote">i am trying to create both the account and its related contact at the same time from the csv</td> </tr></table><span class="postbody"> <br /> <br />You mentioned that: <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Quote:</b></span></td> </tr> <tr> <td class="quote">The contact (CSV) - Transform - Salesforce (Account) : is working fine and is creating a new account </td> </tr></table><span class="postbody"> <br /> <br />If so, then you need only to create contacts and associate them with created accounts. In this case to avoid duplicates in Account table you need to delete Transform node between CSV and SFDC account table, because you have already created accounts.</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>Guest</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Feb 16, 2012 12:39 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi Sergei <br /> <br />the combination of 3 values is unique. If i choose 1 value for join then there will be duplicates <br /> <br />i am trying to create both the account and its related contact at the same time from the csv</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Wed Feb 15, 2012 3:17 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hello, <br /> <br />Why your Join on condition contains 3 values? It would be enough to choose 1 value with a unique ID that matches in both sources. Then try to just preview results on the Join node to check if there are any records. NOTE: if you have created new account you need to delete Transform node between CSV and SFDC account table.</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>kils</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Wed Feb 15, 2012 9:56 am<span class="gen"> </span> Post subject: Re: Salesforce contact creation from CSV</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi Sergei <br /> <br /> <br />Thank you for the reply. I am facing the same issue after converting all the "long text" values to "text" in transform <br /> <br /> <br /> <br /><img src="http://i41.tinypic.com/uu5xk.jpg" border="0" /> <br /> <br /> <br />The contact (CSV) - Transform - Salesforce (Account) : is working fine and is creating a new account <br /> <br /> <br /> <br />As assugested by you, i have added a transform between the CSV and the join and converted the value using "to string" <br /> <br /> <br /><img src="http://i43.tinypic.com/1r5ax2.jpg" border="0" /> <br /> <br /> <br />and in the "join on" i have mapped the csv values and account values <br /> <br /> <br /><img src="http://i40.tinypic.com/vhdz6u.jpg" border="0" /> <br /> <br /> <br />and in work i have mapped the value that are required to create the contact refreing the account id <br /> <br /> <br /><img src="http://i39.tinypic.com/oqgh6p.jpg" border="0" /> <br /> <br /> <br />Now when i click run the account is created but not the contact. can you Please see the error log and let me know what is the mistake i am doing <br />Thank you for the time <br /> <br /> <br /> <br /> <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Code:</b></span></td> </tr> <tr> <td class="code"> <br /> <br />********************************* <br />Start date Wed Feb 15 14:36:52 IST 2012 <br />Version Apatar_v1.12.23 <br />JRE Version 1.6.0_13 <br />JRE Vendor Sun Microsystems Inc. <br />Encoding Cp1252 <br />log4j.configuration = `file:/C:/Program%20Files/Apatar/log4j.properties` <br />Start Reading from Contact.csv <br />Row '' has incorrect length. <br />Start Reading from Account <br />java.sql.SQLSyntaxErrorException: Syntax error: Encountered "name" at line 1, column 202. <br /> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) <br /> at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) <br /> at com.apatar.core.DataBaseTools.executeSelect(DataBaseTools.java:1401) <br /> at com.apatar.join.JoinNode.Transform(JoinNode.java:224) <br /> at com.apatar.core.Runnable.execute(Runnable.java:272) <br /> at com.apatar.core.Runnable.execute(Runnable.java:250) <br /> at com.apatar.core.Runnable.execute(Runnable.java:244) <br /> at com.apatar.core.Runnable$Run.run(Runnable.java:118) <br />Caused by: java.sql.SQLException: Syntax error: Encountered "name" at line 1, column 202. <br /> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) <br /> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) <br /> ... 14 more <br />Caused by: ERROR 42X01: Syntax error: Encountered "name" at line 1, column 202. <br /> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) <br /> at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) <br /> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) <br /> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) <br /> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) <br /> ... 8 more <br />Start Reading from Contact <br /></td> </tr></table><span class="postbody"></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Tue Feb 14, 2012 9:40 am<span class="gen"> </span> Post subject: Re: Salesforce contact creation from CSV</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody"></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>kils wrote:</b></span></td> </tr> <tr> <td class="quote"> <br />The problem is when i have to create the related contact. <br /> <br />Salesforce(account) ----> <br /> ^>>Join----> Salesforce(contact) <br />CSV -> Transform - -^ <br /> <br /> <br />I have used the join with inner join condition between some account fields ... but i am not able to find the matching results based on the join. <br /> <br />appreciate any help in configuring the join correctly. If you guys have alternative suggestions or solutions please suggest</td> </tr></table><span class="postbody"> <br /> <br />After .CSV file you need to use Transform to convert long text field to text field using to string function. Then you map transform to Join and you will be able to find matching results. <br /> <br />SFDC (account) -> <br /> Join -> SFDC (contact) <br /> <br />CSV -> Transform ->^</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>kils</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Mon Feb 13, 2012 1:34 pm<span class="gen"> </span> Post subject: Salesforce contact creation from CSV</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi All, <br /> <br />I have a CSV file which contains both contact and account information within the same row. I have to create both the account and related contact from CSV file <br /> <br />I have created a data map for account creation and it is working good. <br /> <br />CSV (account fields) -> Transform -> Salesforce (Account object) <br /> <br />The problem is when i have to create the related contact. <br /> <br />Salesforce(account) ----> <br /> ^>>Join----> Salesforce(contact) <br />CSV -> Transform - -^ <br /> <br /> <br />I have used the join with inner join condition between some account fields ... but i am not able to find the matching results based on the join. <br /> <br />appreciate any help in configuring the join correctly. If you guys have alternative suggestions or solutions please suggest</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
Powered by
phpBB
© 2001, 2005 phpBB Group
Terms and Conditions
Privacy Policy
Contact Info
Comments and Suggestions
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in