[Eagle-i-admins] ETL Multiple Affiliations

[Ciriello, Marc]

Hi Joshua:

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.

If anyone else has experience with ETL and can provide a different tip or solution, please reply.

Regards,
Marc


From: "Lease, Joshua" <jlease at hmc.psu.edu<mailto:jlease at hmc.psu.edu>>
Date: Mon, 21 Jul 2014 16:06:39 -0400
To: "eagle-i-admins at open.med.harvard.edu<mailto:eagle-i-admins at open.med.harvard.edu>" <eagle-i-admins at open.med.harvard.edu<mailto:eagle-i-admins at open.med.harvard.edu>>
Subject: [Eagle-i-admins] ETL Multiple Affiliations

Admins,

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?

Thanks,
    Joshua Lease

*****E-Mail Confidentiality Notice*****
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://open.med.harvard.edu/pipermail/eagle-i-admins/attachments/20140722/c74a8da1/attachment-0001.html>