<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Hi Joshua:</div><div><br></div><div>I don't have a solution for your technical question, but can suggest a work-around of sorts. You could ETL the organization (correct me if these are not organization records) and add the affiliations manually in the SWEET thereafter. It might be less trouble to do that, depending on the number of records, than to troubleshoot the ETL process.</div><div><br></div><div>If anyone else has experience with ETL and can provide a different tip or solution, please reply.</div><div><br></div><div>Regards,</div><div>Marc</div><div><br></div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> "Lease, Joshua" <<a href="mailto:jlease@hmc.psu.edu">jlease@hmc.psu.edu</a>><br><span style="font-weight:bold">Date: </span> Mon, 21 Jul 2014 16:06:39 -0400<br><span style="font-weight:bold">To: </span> "<a href="mailto:eagle-i-admins@open.med.harvard.edu">eagle-i-admins@open.med.harvard.edu</a>" <<a href="mailto:eagle-i-admins@open.med.harvard.edu">eagle-i-admins@open.med.harvard.edu</a>><br><span style="font-weight:bold">Subject: </span> [Eagle-i-admins] ETL Multiple Affiliations<br></div><div><br></div><div><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;"><div>Admins,</div><div><br></div><div>I am attempting to import data via the ETL, but cannot figure out how to import an item with multiple affiliations. Separating the affiliations via a semi-colon (like most fields with multiple entries) does not work. Has anyone figured this out already?</div><div><br></div><div>Thanks,</div><div> Joshua Lease</div><div><br></div><div><div><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><span style="font-size: 10.5pt;">*****E-Mail Confidentiality Notice*****<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><span style="font-size: 10.5pt;">This message (including any attachments) contains information intended for a specific individual(s) and purpose that may be privileged, confidential or
otherwise protected from disclosure pursuant to applicable law. Any inappropriate use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalty. If you have received this transmission in error, please
reply to the sender indicating this error and delete the transmission from your system immediately.</span></p></div><br></div></div></div></span></body></html>