Need help to Syndicate CSV file

[Former Member]

Hi All,

Need your help. Recently I have got a requirement where Web method team is requesting me to create a syndication map which can syndicate in CSV format (.csv files) as following:

_start meta data

AccountName,MDMID,MDMAccount,CustStatus,Country,PartyGroup,PartyRole,PartyType,PrimaryPhone,Street,City,CityPostCode,RgStateProvince

String,String,String,String,String,String,String,String,String,String,String,String,String

,,,,,,,,,,,,

_end meta data

Office Depot,234887,10092,Active,MX,Partner,Retailer,OSS,?,Juan Salvador Agraz,,,

MAUBREY BUREAUTIQUE,135563,48821,Active,FR,Partner,Reseller,Copier Dealer (BSD),?,4 RUE PAUL HENRI SPAAK,Ste Savine,?,?

....ETC (As viewed in text pad)

They needed meta data header...etc

If they wanted Comma delimiter I could have done that and then renamed file using windows batch jobs from *.TXT to *.CSV however since they need meta data headers too so I am not sure if this can be done, If anyone had ever faced similar issue please do help me?

Thanks and regards,

Atif

[Former Member · Accepted solution]

Hi Atif,

You can syndicate data from MDM system in comma delimited text only and PI team can take care of adding Header data and other formatting. You can do these changes/enrichment in PI system easily. you need to tell your requirement to PI team.

Than you can create syndication map to send data to PI system in agreed format.

PI team will pick the file from FTP folders and enrich it with Header details and send it to destination system. This should resolve your issue. Otherwise it will not be possible to add header details in MDM syndicator itself.

Thanks and Regards,

Ankush Bhardwaj