File content conversion for reading entire file contents into one string

[santhosh_sontha2]

Hi Experts,

I have one  file which I want to read it through sender file adapter into one variable. Can you help me with the file content converstion paramters for this?

Below is the file contents for which I want to read in one XML string:

-----BEGIN PGP MESSAGE-----
Version: BCPG v1.46

hQEMAyVCl+p4gjQDAQgA2nFQrrpxRbXP/mI7X6FHxaRyWYz7GUrthDF6i6wZ+niM
Bo1jWhJcHdQov0PDkfUFXnJwNOUj0AsGFxdo5CGHxk7BH35DopxDb6MjAW5yeGZF
SjozQGbIBnpYpU1qkEmMG4ANeaglbVKjwDgaN44FdCg2GL9y9PgjdXvRm5RdTx++
non48yEcYEWxXQLIFkB3Vdr1jMyjXLU0O8bFinOPZ/kOnY9J4HwizN6KBUo1ohuj
tXLooyWSvhYigQOVsrPADSIoQqnrmmcxzkmPG/ICodGuoZtAxYLxToI7vEg4O/nA
3YsQQ07k2nyPhDwK7BxrsdBhgQxK/HRAqCVtOQ56MtLDugEjWafEs3mArVazaWUY
+UT2f6PbfM88PIJa8IbiFQdGurQLFWKTkGAIDAC5BdysXbE6YhJmEmjwWr+AvWoN
ZIqQGbJECUFId3pmqSQT4q5jF88l9h8H7JrnLgoEsMyWhjhsl80Z8G9846tzznjW
SNaoK44T0FDtm+MZYnufNoxuVLgCm+ICUWe/wIXYZGW4DDPLSr+5aH9qOwdKRU3w
8wv3UtFx195Y/1wyj6GNZbTSf0eLaW2sPAjQJbcmtnb4YT1TnjbHcUWHzzxjN8Ry
8zk/KsQ5i1prhH87bMlk6Mpf3JPrsrxBRELFhkO2ZFNMeI28njfxDm4+muvI368S
Oey1LTQWSKPGK9Snnoyxa7Ig5O115DEdtjzhkcCLQJcZ7MzAqQahdvtEvAs9KSgV
Hqa1rLtGrWwTdVCdJzzUGQnTBsA32i8v07O5S1xJpQmPlGWM2b+eL4XKrL7JC4AB
4Fclccj62JZASXIi5Fmo4vh2I3rqIY7gWE8DEDQt5aT/75J96jiiWundUCozEaV/
WiXzOBrPjQe8TPeX7k7ODWUrETuSB1P6ltiAaANsS0flDSsbQiG5uZhKQ1fJCi72
YXHQXzbM0KrKgfZoy0pYlhCIVR+IxxQgwQL59ZyEHkzjRsrf0kGdk6m10A7IBrbr
ORG3gtGG2bkY0wwynO8obUAHogZECEp8twgiEFRYIPHCgTU+iqc1wLaF7Kf5VwmM
O6y6osZhXRsCJtmaVA4quZ3B53uGuWB9XdzudRAxfyUuNT7nj9a5EqqddUYSSylt
E5/rkXU6xr2U7eO3kHGCo9+r/oJpClLZu98izInYEVJfbCr5TAQUUDUI7HYU05kC
r9cMb/GwgUq4BTPY2khc6OytmmoOH6WPSWMWHSoGk7NTAoML8DpFePU4PaV/ltxr
bK9Ql+dbzPFi+7YYF2fomwtUiUDSh47m7x/Bphle+M2mvRaKQ1xPlheGAmx9aco5
iaLf+mYzI5CQv7CtlkF5+mFvTs5ycociLRVFEnz+LpS3ztjPZa5iZXl0iXS3/E0e
d9pDdIshrqchjKzll6zMquUEmFPlkrcmqT+gDS2e+B+tM/HLAN64OhkkYGlCvqZv
VBlTFMqxeiigHBMPujSQdB7xsc3Gj8oc1bYNAsaoJC2kA343WM0t2W1D8PxoEf4I
5tetI/cEu62liOnYipBA7H/sstfJaoUbGctgzuIRpeje6vpGGhpy8u1k8W7Pcawd
jye76pNo3syUdPt3r99C6NLeexBiJY2kSn+Ce0aHFfVHKHMSgkL4ytSxtH7HvZV5
CUF/mD2k0ogylQorDqASpV9XyJYUnu3I2HMcCd99a3c/gcaXxh6PcoRlWMiRpW/R
tEIfikeVsN0tOw5zozPcx8eR9v6xufxrMw8G4A17lJ8mgX8TAS+lEigzVfDEL84o
v/A9jy9QrQz/5xWdwP1mvZnYbPGcsBztjONKmbcl6VIpnG9/lFMIZrE6JBjuq2bR
FsQRazTo5TMpdE8SUkEU0/hopwvhAQEg1fjgnQ==
=OgTr
-----END PGP MESSAGE-----

[iaki_vila · Accepted solution]

Hi Santhosh,

You have this option with a a java mapping Read Input Text File as a Single Field. - Process Integration - SCN Wiki

Regards.

[santhosh_sontha2 · Accepted solution]

Dear Vila,

Thanks for the reply.

Java mapping is the only option for this? Can't we do this through file content convertion?

Below is the xml structure should look like after FCC:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:mt_readPGPfile xmlns:ns0="http://dummy.com">

   <PGPRecordSet>

      <PGPRecord>

         <PGPString>-----BEGIN PGP MESSAGE----- Version: BCPG v1.46  hQEMAyVCl+p4gjQDAQgA2nFQrrpxRbXP/mI7X6FHxaRyWYz7GUrthDF6i6wZ+niM Bo1jWhJcHdQov0PDkfUFXnJwNOUj0AsGFxdo5CGHxk7BH35DopxDb6MjAW5yeGZF SjozQGbIBnpYpU1qkEmMG4ANeaglbVKjwDgaN44FdCg2GL9y9PgjdXvRm5RdTx++ non48yEcYEWxXQLIFkB3Vdr1jMyjXLU0O8bFinOPZ/kOnY9J4HwizN6KBUo1ohuj tXLooyWSvhYigQOVsrPADSIoQqnrmmcxzkmPG/ICodGuoZtAxYLxToI7vEg4O/nA 3YsQQ07k2nyPhDwK7BxrsdBhgQxK/HRAqCVtOQ56MtLDugEjWafEs3mArVazaWUY +UT2f6PbfM88PIJa8IbiFQdGurQLFWKTkGAIDAC5BdysXbE6YhJmEmjwWr+AvWoN ZIqQGbJECUFId3pmqSQT4q5jF88l9h8H7JrnLgoEsMyWhjhsl80Z8G9846tzznjW SNaoK44T0FDtm+MZYnufNoxuVLgCm+ICUWe/wIXYZGW4DDPLSr+5aH9qOwdKRU3w 8wv3UtFx195Y/1wyj6GNZbTSf0eLaW2sPAjQJbcmtnb4YT1TnjbHcUWHzzxjN8Ry 8zk/KsQ5i1prhH87bMlk6Mpf3JPrsrxBRELFhkO2ZFNMeI28njfxDm4+muvI368S Oey1LTQWSKPGK9Snnoyxa7Ig5O115DEdtjzhkcCLQJcZ7MzAqQahdvtEvAs9KSgV Hqa1rLtGrWwTdVCdJzzUGQnTBsA32i8v07O5S1xJpQmPlGWM2b+eL4XKrL7JC4AB 4Fclccj62JZASXIi5Fmo4vh2I3rqIY7gWE8DEDQt5aT/75J96jiiWundUCozEaV/ WiXzOBrPjQe8TPeX7k7ODWUrETuSB1P6ltiAaANsS0flDSsbQiG5uZhKQ1fJCi72 YXHQXzbM0KrKgfZoy0pYlhCIVR+IxxQgwQL59ZyEHkzjRsrf0kGdk6m10A7IBrbr ORG3gtGG2bkY0wwynO8obUAHogZECEp8twgiEFRYIPHCgTU+iqc1wLaF7Kf5VwmM O6y6osZhXRsCJtmaVA4quZ3B53uGuWB9XdzudRAxfyUuNT7nj9a5EqqddUYSSylt E5/rkXU6xr2U7eO3kHGCo9+r/oJpClLZu98izInYEVJfbCr5TAQUUDUI7HYU05kC r9cMb/GwgUq4BTPY2khc6OytmmoOH6WPSWMWHSoGk7NTAoML8DpFePU4PaV/ltxr bK9Ql+dbzPFi+7YYF2fomwtUiUDSh47m7x/Bphle+M2mvRaKQ1xPlheGAmx9aco5 iaLf+mYzI5CQv7CtlkF5+mFvTs5ycociLRVFEnz+LpS3ztjPZa5iZXl0iXS3/E0e d9pDdIshrqchjKzll6zMquUEmFPlkrcmqT+gDS2e+B+tM/HLAN64OhkkYGlCvqZv VBlTFMqxeiigHBMPujSQdB7xsc3Gj8oc1bYNAsaoJC2kA343WM0t2W1D8PxoEf4I 5tetI/cEu62liOnYipBA7H/sstfJaoUbGctgzuIRpeje6vpGGhpy8u1k8W7Pcawd jye76pNo3syUdPt3r99C6NLeexBiJY2kSn+Ce0aHFfVHKHMSgkL4ytSxtH7HvZV5 CUF/mD2k0ogylQorDqASpV9XyJYUnu3I2HMcCd99a3c/gcaXxh6PcoRlWMiRpW/R tEIfikeVsN0tOw5zozPcx8eR9v6xufxrMw8G4A17lJ8mgX8TAS+lEigzVfDEL84o v/A9jy9QrQz/5xWdwP1mvZnYbPGcsBztjONKmbcl6VIpnG9/lFMIZrE6JBjuq2bR FsQRazTo5TMpdE8SUkEU0/hopwvhAQEg1fjgnQ== =OgTr -----END PGP MESSAGE-----</PGPString>

      </PGPRecord>

   </PGPRecordSet>

</ns0:mt_readPGPfile>

Regards,

Santhosh

[azharshaikh]

Hi Santhosh,

I believe this can be achieved using FCC + Graphical Mapping feature. Please check below link:

Regards,

Azhar

[santhosh_sontha2]

Hi Azhar,

For this first I need to convert entire file contents into xml through FCC. My question is how to convert entire file contents into a xml as below sample:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:mt_readPGPfile xmlns:ns0="http://dummy.com">

   <PGPRecordSet>

      <PGPRecord>

         <PGPString>-----BEGIN PGP MESSAGE----- Version: BCPG v1.46  hQEMAyVCl+p4gjQDAQgA2nFQrrpxRbXP/mI7X6FHxaRyWYz7GUrthDF6i6wZ+niM Bo1jWhJcHdQov0PDkfUFXnJwNOUj0AsGFxdo5CGHxk7BH35DopxDb6MjAW5yeGZF SjozQGbIBnpYpU1qkEmMG4ANeaglbVKjwDgaN44FdCg2GL9y9PgjdXvRm5RdTx++ non48yEcYEWxXQLIFkB3Vdr1jMyjXLU0O8bFinOPZ/kOnY9J4HwizN6KBUo1ohuj tXLooyWSvhYigQOVsrPADSIoQqnrmmcxzkmPG/ICodGuoZtAxYLxToI7vEg4O/nA 3YsQQ07k2nyPhDwK7BxrsdBhgQxK/HRAqCVtOQ56MtLDugEjWafEs3mArVazaWUY +UT2f6PbfM88PIJa8IbiFQdGurQLFWKTkGAIDAC5BdysXbE6YhJmEmjwWr+AvWoN ZIqQGbJECUFId3pmqSQT4q5jF88l9h8H7JrnLgoEsMyWhjhsl80Z8G9846tzznjW SNaoK44T0FDtm+MZYnufNoxuVLgCm+ICUWe/wIXYZGW4DDPLSr+5aH9qOwdKRU3w 8wv3UtFx195Y/1wyj6GNZbTSf0eLaW2sPAjQJbcmtnb4YT1TnjbHcUWHzzxjN8Ry 8zk/KsQ5i1prhH87bMlk6Mpf3JPrsrxBRELFhkO2ZFNMeI28njfxDm4+muvI368S Oey1LTQWSKPGK9Snnoyxa7Ig5O115DEdtjzhkcCLQJcZ7MzAqQahdvtEvAs9KSgV Hqa1rLtGrWwTdVCdJzzUGQnTBsA32i8v07O5S1xJpQmPlGWM2b+eL4XKrL7JC4AB 4Fclccj62JZASXIi5Fmo4vh2I3rqIY7gWE8DEDQt5aT/75J96jiiWundUCozEaV/ WiXzOBrPjQe8TPeX7k7ODWUrETuSB1P6ltiAaANsS0flDSsbQiG5uZhKQ1fJCi72 YXHQXzbM0KrKgfZoy0pYlhCIVR+IxxQgwQL59ZyEHkzjRsrf0kGdk6m10A7IBrbr ORG3gtGG2bkY0wwynO8obUAHogZECEp8twgiEFRYIPHCgTU+iqc1wLaF7Kf5VwmM O6y6osZhXRsCJtmaVA4quZ3B53uGuWB9XdzudRAxfyUuNT7nj9a5EqqddUYSSylt E5/rkXU6xr2U7eO3kHGCo9+r/oJpClLZu98izInYEVJfbCr5TAQUUDUI7HYU05kC r9cMb/GwgUq4BTPY2khc6OytmmoOH6WPSWMWHSoGk7NTAoML8DpFePU4PaV/ltxr bK9Ql+dbzPFi+7YYF2fomwtUiUDSh47m7x/Bphle+M2mvRaKQ1xPlheGAmx9aco5 iaLf+mYzI5CQv7CtlkF5+mFvTs5ycociLRVFEnz+LpS3ztjPZa5iZXl0iXS3/E0e d9pDdIshrqchjKzll6zMquUEmFPlkrcmqT+gDS2e+B+tM/HLAN64OhkkYGlCvqZv VBlTFMqxeiigHBMPujSQdB7xsc3Gj8oc1bYNAsaoJC2kA343WM0t2W1D8PxoEf4I 5tetI/cEu62liOnYipBA7H/sstfJaoUbGctgzuIRpeje6vpGGhpy8u1k8W7Pcawd jye76pNo3syUdPt3r99C6NLeexBiJY2kSn+Ce0aHFfVHKHMSgkL4ytSxtH7HvZV5 CUF/mD2k0ogylQorDqASpV9XyJYUnu3I2HMcCd99a3c/gcaXxh6PcoRlWMiRpW/R tEIfikeVsN0tOw5zozPcx8eR9v6xufxrMw8G4A17lJ8mgX8TAS+lEigzVfDEL84o v/A9jy9QrQz/5xWdwP1mvZnYbPGcsBztjONKmbcl6VIpnG9/lFMIZrE6JBjuq2bR FsQRazTo5TMpdE8SUkEU0/hopwvhAQEg1fjgnQ== =OgTr -----END PGP MESSAGE-----</PGPString>

      </PGPRecord>

   </PGPRecordSet>

</ns0:mt_readPGPfile>

[azharshaikh]

Hi Santhosh,

It can be done with FCC. Please check the following link:

Regards,

Azhar