2 files in 1 communication channel

[Former Member]

Hello,

I transfer file from FTP to info cubes.

The process work correctly and with out problem.

Now I try to add 2 files with same structure from same folder to same info cubes.

I try to use with same communication channel to transfer this 2 files.

I looking for advise to this problem.

Regards

Elad

[Former Member · Accepted solution]

Hi Elad,

you can (have to) use a "multi-mapping" to merge the messages. So you have to use BPM.

Look in your SAPBASIS SWC in IR. There are samples to merge files/messages.

Regards Mario

Message was edited by: Mario Müller

[Former Member]

I follow the blog, but it does not work for my case.

I have to send the xml with its corresponding pdf

For example titi.xml with titi.pdf

What do I have to write in the File Name or file Name mask?

I tried with '.*\.', '%var1%'

I don´t know the name of the files, but I know there will be one file .xml and another .pdf, with the same file name.

Thanks

[Former Member]

Hi Elad,

read this SAP HELP, I think it can help you

http://help.sap.com/saphelp_nw2004s/helpdata/en/0f/80243b4a66ae0ce10000000a11402f/frameset.htm

Mickael

[Former Member]

Hi Elad,

Here's the solution than you want:

In your sender CC, make parameters like that:

1. Filename = <A_text_will_be_NOT_used>

2. Choose option "Advanced Selection for SourceFile", a table appears

3. Create two lines, fill them like that:

    Line 1: Directory = your_directory
            File Name Mask = aa*.text
    Line 2: Directory = your_directory
            File Name Mask = bb*.text

If you have a "xx*.text" file, then it will be NOT processed.

Note: If your are patient, I will create Weblog this evening with some pictures...

Mickael

<i>>> Because of SDN, pictures will be available in only one week (time needed to become a Webloger!)</i>

Message was edited by: Mickael Huchet

[Former Member]

Hello,

Thank you very much for your answer.

I try to implement this solution without succeed.

I not found your Weblog about this situation.

I thank if you send me more explanation.

Regards

Elad

[Former Member]

Hi Elad,

It's normal... before to be able to post my first weblog, I must be approved by SDN then they will verify my weblog. it will take a litle time...

my draft version is ready. I'm currently writing it on SDN.

send me an email and I will send it to you. Others people will wait that I finish my weblog.

Mickael

Message was edited by: Mickael Huchet

[former_member187587]

Hi Elad,

I'm not sure if I understand your ptroblem exactly

but it looks like you try to send in eacg configuration secnario different filenames to the same reciever.

If there is no meaning for the Reciever interface to be used (FTP file ->BW folder)then you can configure a single comm. channel that will include all the file types matching your scneario needs.

If you use content covertion and use specific functions in your BW system then you might need to configure a new comm. channel for every file you need according to the configuration scneario.

to which company you belong?

Nimrod

[Former Member]

Hello Nimrod,

I work in Netafim,

I try to add 2 files from FTP to same info cube in the BW.

Elad

[Former Member]

Hi,

here's my weblog. I hope it's what you search to do.

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter

Mickael

[Former Member]

Thank you all,

I try to explain and to bring more information about the problem.

To first info Cube I send the file xx*.txt

To second info cube I end file yy*.txt

And for third info cube I try to add the files aa.txt and bb.txt

Regards

Elad

[bhavesh_kantilal]

Elad,

Is this what you are looking at

Pick up 2 files from 2 folders ( xx.txt amnd yy.txt ) and then combine this into a single file?

If yes, you need a BPM .

Just take a look at this link,

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/08/16163ff8519a06e10000000a114084/content.htm">Collecting Multiple Messages from One Interface</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/0e/56373f7853494fe10000000a114084/content.htm">Collecting Multiple Messages from Multiple Interface</a>

Regards,

Bhavesh

[Former Member]

Hello,

The problem in my case is in the third part:

"I try to add the files aa.txt and bb.txt to same info" cube.

Elad

[bhavesh_kantilal]

Elad,

Can you describe the steps you have done?

In youcase you will need a BPM.

1 . Fork with 2 branches

2. Each Branch will have a Receive Step for XX and YY respectively.

3. Next, after the fork, you will have a transformation step where you will do a N:1 mapping. Combine the 2 files into a single file strucutre

4. Send step to send the combined File.

FOr step 3 , you have have a message mapping which will have the 2 source message type and you will combine them into a single file.

Regards,

Bhavesh

[Former Member]

Hello,

I try to separate between this 2 files with "," or with ";"

Elad

[Former Member]

Hi,

Try to use . in filename convention.It works.

thanks,

venu

[Former Member]

Hello,

I want to transfer aa.text and bb.text.

I don't want to transfer xx*.text file.

Elad

[bhavesh_kantilal]

Elad,

Can you please walk us through your entire requirement so that an accurate picture / solution can be arrived at.

Regards,

Bhavesh

[former_member91687]

Hi Elad,

You could use wild card characters. In your communication channel give *.filename or . if you want to pick any kind of file in File Name tab.

Regards,

Chandra

[bhavesh_kantilal]

Hi Elad,

Are you using the sender file adapter or the reciver file adapter?

In the sender file adapter, did you take a look at ,

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/3c/b4a6490a08cd41a8c91759c3d2f401/content.htm">Specifiying Additional Files</a>

This will help. Let us know if you need any further inputs.

Regards,

bhavesh