Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1 Solution
Accepted Solutions
Hi Shong,
Sure with pleasure.
This is what i tried. This might look a bit confusing, but it is really not. Please reply to the post if you face any difficulty.
STEPS
1) Get the API for swift message parsing (WIFE)
Download the required APIs for parsing SWIFT message http://www.prowidesoftware.com/en/download.html
2) Configure External Routine in Talend using WIFE API
2.1) Create the Routine
2.2) Attach the WIFE API Library files to the Routine (Refer image-1)
2.3) Write the custom routine code by calling the API methods as per the requirement (Sample code below)
Sample custom routine code
-----------------------------------------------------------------------------------------------------------
public static Map<String, Object> fieldParser(String fin){
Map<String, Object> fieldMappings = new HashMap<String, Object>();
try {
SwiftMessage m = (new ConversionService()).getMessageFromFIN(fin);
Field32A f = new Field32A(m.getBlock4().getTagValue("32A"));
fieldMappings.put("Field32A", f.getComponent1());
fieldMappings.put("BlockCount", m.getBlockCount());
} catch (Exception e) {
e.printStackTrace();
}
return fieldMappings;
}
-----------------------------------------------------------------------------------------------------------
3) Create job (Refer Image-2)
3.1) Parse the SWIFT message file
3.2) Call the java routine code for parsing the messages
3.3) Perform the required mappings
3.4) Save the parsed attribute values to Database/File
Sample SWIFT Message
-----------------------------------------------------------------------------------------------------------
{1:F01BANKDEFMAXXX2039063581}{2
1031609050901BANKDEFXAXXX89549829458949811609N}{3:{108:00750532785315}}{4:
:20:007505327853
:23B:CRED
:32A:050902JPY3520000,
:33B:JPY3520000,
:50K:EUROXXXEI
:52A:FEBXXXM1
:53A:MHCXXXJT
:54A:FOOBICXX
:59:/13212312
RECEIVER NAME S.A
:70:FUTURES
:71A
HA
:71F:EUR12,00
:71F:EUR2,34
-}";
-----------------------------------------------------------------------------------------------------------
Sure with pleasure.
This is what i tried. This might look a bit confusing, but it is really not. Please reply to the post if you face any difficulty.
STEPS
1) Get the API for swift message parsing (WIFE)
Download the required APIs for parsing SWIFT message http://www.prowidesoftware.com/en/download.html
2) Configure External Routine in Talend using WIFE API
2.1) Create the Routine
2.2) Attach the WIFE API Library files to the Routine (Refer image-1)
2.3) Write the custom routine code by calling the API methods as per the requirement (Sample code below)
Sample custom routine code
-----------------------------------------------------------------------------------------------------------
public static Map<String, Object> fieldParser(String fin){
Map<String, Object> fieldMappings = new HashMap<String, Object>();
try {
SwiftMessage m = (new ConversionService()).getMessageFromFIN(fin);
Field32A f = new Field32A(m.getBlock4().getTagValue("32A"));
fieldMappings.put("Field32A", f.getComponent1());
fieldMappings.put("BlockCount", m.getBlockCount());
} catch (Exception e) {
e.printStackTrace();
}
return fieldMappings;
}
-----------------------------------------------------------------------------------------------------------
3) Create job (Refer Image-2)
3.1) Parse the SWIFT message file
3.2) Call the java routine code for parsing the messages
3.3) Perform the required mappings
3.4) Save the parsed attribute values to Database/File
Sample SWIFT Message
-----------------------------------------------------------------------------------------------------------
{1:F01BANKDEFMAXXX2039063581}{2
1031609050901BANKDEFXAXXX89549829458949811609N}{3:{108:00750532785315}}{4:
:20:007505327853
:23B:CRED
:32A:050902JPY3520000,
:33B:JPY3520000,
:50K:EUROXXXEI
:52A:FEBXXXM1
:53A:MHCXXXJT
:54A:FOOBICXX
:59:/13212312
RECEIVER NAME S.A
:70:FUTURES
:71A
HA
:71F:EUR12,00
:71F:EUR2,34
-}";
-----------------------------------------------------------------------------------------------------------
Hi Shong,
Sure with pleasure.
This is what i tried. This might look a bit confusing, but it is really not. Please reply to the post if you face any difficulty.
STEPS
1) Get the API for swift message parsing (WIFE)
Download the required APIs for parsing SWIFT message http://www.prowidesoftware.com/en/download.html
2) Configure External Routine in Talend using WIFE API
2.1) Create the Routine
2.2) Attach the WIFE API Library files to the Routine (Refer image-1)
2.3) Write the custom routine code by calling the API methods as per the requirement (Sample code below)
Sample custom routine code
-----------------------------------------------------------------------------------------------------------
public static Map<String, Object> fieldParser(String fin){
Map<String, Object> fieldMappings = new HashMap<String, Object>();
try {
SwiftMessage m = (new ConversionService()).getMessageFromFIN(fin);
Field32A f = new Field32A(m.getBlock4().getTagValue("32A"));
fieldMappings.put("Field32A", f.getComponent1());
fieldMappings.put("BlockCount", m.getBlockCount());
} catch (Exception e) {
e.printStackTrace();
}
return fieldMappings;
}
-----------------------------------------------------------------------------------------------------------
3) Create job (Refer Image-2)
3.1) Parse the SWIFT message file
3.2) Call the java routine code for parsing the messages
3.3) Perform the required mappings
3.4) Save the parsed attribute values to Database/File
Sample SWIFT Message
-----------------------------------------------------------------------------------------------------------
{1:F01BANKDEFMAXXX2039063581}{21031609050901BANKDEFXAXXX89549829458949811609N}{3:{108:00750532785315}}{4:
:20:007505327853
:23B:CRED
:32A:050902JPY3520000,
:33B:JPY3520000,
:50K:EUROXXXEI
:52A:FEBXXXM1
:53A:MHCXXXJT
:54A:FOOBICXX
:59:/13212312
RECEIVER NAME S.A
:70:FUTURES
:71AHA
:71F:EUR12,00
:71F:EUR2,34
-}";
-----------------------------------------------------------------------------------------------------------
Sure with pleasure.
This is what i tried. This might look a bit confusing, but it is really not. Please reply to the post if you face any difficulty.
STEPS
1) Get the API for swift message parsing (WIFE)
Download the required APIs for parsing SWIFT message http://www.prowidesoftware.com/en/download.html
2) Configure External Routine in Talend using WIFE API
2.1) Create the Routine
2.2) Attach the WIFE API Library files to the Routine (Refer image-1)
2.3) Write the custom routine code by calling the API methods as per the requirement (Sample code below)
Sample custom routine code
-----------------------------------------------------------------------------------------------------------
public static Map<String, Object> fieldParser(String fin){
Map<String, Object> fieldMappings = new HashMap<String, Object>();
try {
SwiftMessage m = (new ConversionService()).getMessageFromFIN(fin);
Field32A f = new Field32A(m.getBlock4().getTagValue("32A"));
fieldMappings.put("Field32A", f.getComponent1());
fieldMappings.put("BlockCount", m.getBlockCount());
} catch (Exception e) {
e.printStackTrace();
}
return fieldMappings;
}
-----------------------------------------------------------------------------------------------------------
3) Create job (Refer Image-2)
3.1) Parse the SWIFT message file
3.2) Call the java routine code for parsing the messages
3.3) Perform the required mappings
3.4) Save the parsed attribute values to Database/File
Sample SWIFT Message
-----------------------------------------------------------------------------------------------------------
{1:F01BANKDEFMAXXX2039063581}{2
1031609050901BANKDEFXAXXX89549829458949811609N}{3:{108:00750532785315}}{4:
:20:007505327853
:23B:CRED
:32A:050902JPY3520000,
:33B:JPY3520000,
:50K:EUROXXXEI
:52A:FEBXXXM1
:53A:MHCXXXJT
:54A:FOOBICXX
:59:/13212312
RECEIVER NAME S.A
:70:FUTURES
:71A
HA
:71F:EUR12,00
:71F:EUR2,34
-}";
-----------------------------------------------------------------------------------------------------------
