Loading multiple Contacts to a client in 1 transform
Can it be done? Is it done using arrays?
ie
$ID<party.customerperson>contacts[0]<contact.location>address
etc etc
then
$ID<party.customerperson>contacts[1]<contact.location>address
etc etc
for the postal address for example.
Side notes
1.
Remotely using kettle downsides ? Ie remotely loading data ie Kettle is not running on the localhost. I was running a transform from home last night which had a lookup in it....3minutes on the first lookup...I ended the trasform and just ran it locally...no issues.
2.
Anyone ever used kettle 4 to parse emails to create docs and drop in to the docloader to automatically add reports from external labs?.
Re: Loading multiple Contacts to a client in 1 transform
That should work.
You should also be able to do different contact types e.g.:
When you run kettle remotely, its got to send all of the database traffic over the network.
Lookups are cached to avoid too many database accesses. On the first access of a particular type (e.g. lookup.breed) all instances of that lookup will be fetched. I expect this is the delay you are seeing.
Also, when you run the transform for the first time, it has to access the database to load archetypes, so you will see a delay there as well.
With regards to the Kettle question - never tried it but Kettle 4.1 provides an "Email messages input" step which can fetch mails using either POP3 or IMAP protocols. Its not clear if it handles attachments though.
-Tim