Greetings Integrator/AIE gurus,
I am looking to update People data from a file attached to an email (as only
option is to email reports).
My assumptions (please feel free to correct):
1. Atrium Integrator cannot update CTM:People entries.
2. AIE does not have an easy method to read from an attachment pool.
3. Three is a magic number.
4. Using AIE processing will be more efficient and robust, and quicker to
set up than writing custom import code.
Requirements:
1. Two columns will need to be transformed (Work Location - Site,
Functional Group - Organization, Department)
2. Customization is to be kept to a minimum (zero, if possible),
particularly on OOB elements.
My proposed process is:
1. Generate report, send as email attachment with a canned Email Engine
submit command in content.
2. Email to an AR mailbox set to process emails - Email engine submits to
custom 'PQ:HR:Import People' form, pushes file to attachment pool.
3. Workflow on form saves the attachment to a secure directory on the
server.
4. AIE job runs, picks up file from server directory, uses
targetsql|select ... functions to look up mapped values in 'PQ:Mapping' form
and 'Site Alias'.
Any experience people have had with this or ideas on other things to try would
be welcome.
Kelly Logan, Sr. Systems Administrator (Remedy, Planview), GMS
ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346
USA | 734.997.4777
kelly.lo...@proquest.commailto:kelly.lo...@proquest.com
www.proquest.com
ProQuest...Start here. 2010 InformationWeek 500 Top Innovator
P Please consider the environment before printing this email.
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the sender, and delete the
message from your computer.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
