I'm fairly new to biztalk, but have succeeded in processing xml files to
update our database server, send e-mails etc, but i now have a slightly more
complicated requirement and need to call on all the biztalk experts out ther
e.

I have a requirement to take in an xml file (easy), create a CSV file (easy)
and then for each record in the CSV file extract a jpg file associated with
the record in the csv file (from numerous directories) and then to 'zip' up
all of these files into a single file and ftp it to an address.  I want to,
if at all possible try and utilize the ftp adapters etc and not have to
engineer all the process (otherwise we might as well do it all and not bothe
r
with biztalk!).

Any suggestions pointers?

[ Post a follow-up to this message ]

There are no doubt lots of ways to do this, but I'd be tempted to:

1) have orchestration iterate through each record, passing the name of the
jpeg filespec to a .net component
2) when all iterations are completed, have the orchestration call a method
on the component that causes it to take the accumulated list of filespecs
and create a single zip file, placing it in a directory that is configured
as a File-Receive location
3) Have an FTP-send port tied directly to the file-receive location via a
filter.

There are no doubt more orchestration-centric solutions, but I don't know if
they would be any easier.

- Scott Colestock


"jamie" <jamie@discussions.microsoft.com> wrote in message
news:F1E51980-1F83-4074-8607-D04A0855A6E1@microsoft.com...
> I'm fairly new to biztalk, but have succeeded in processing xml files to
> update our database server, send e-mails etc, but i now have a slightly
> more
> complicated requirement and need to call on all the biztalk experts out
> there.
>
> I have a requirement to take in an xml file (easy), create a CSV file
> (easy)
> and then for each record in the CSV file extract a jpg file associated
> with
> the record in the csv file (from numerous directories) and then to 'zip'
> up
> all of these files into a single file and ftp it to an address.  I want
> to,
> if at all possible try and utilize the ftp adapters etc and not have to
> engineer all the process (otherwise we might as well do it all and not
> bother
> with biztalk!).
>
> Any suggestions pointers?
>

[ Post a follow-up to this message ]