cancel
Showing results for 
Search instead for 
Did you mean: 

regarding syndicator

Former Member
0 Kudos

Hi,

I need small info regarding syndicator.

I need to syndicate records in to Excel file.but in destination properties if you select file type "Flat" then I am not able to select target structure.is there any way to output records as Excel file.

thanks in Advance.

Regards,

Ravi.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ravi,

The output can be one of the two types i) Flat and ii) XML. I have workaround to get the output in Excel file. Follow these steps:

i) Keep the syndication file format to Flat.

ii) Select comma (,) as Item delimiter.

Now execute the Syndication and save the file with (csv) extension e.g. filename.csv . And you know CSV files can be opened in Excel.

Hopefully this will solve your problem.

Regards

Shahid Nadeem

Former Member
0 Kudos

Hi,

Thank you.

I have created my cutom repository and I have imported data from Excel file.

in syndicator, I have selected destination properties as Flat and target system as MDM. In MDM Console I can give only XML Schema files.

but I need to select my Flat file structure.

In syndicator I don't have target structure to map to destination fields.

How to get same structure in my syndicator to map fields.

is there any way?

Thanks,

Ravi

Former Member
0 Kudos

Hi ravi,

As per your requirement you have to create a target structure.

Follows these Steps:

I assume that you have opened Syndicator with Destination Properties as "Flat" and target system as "MDM"

Step1. Go to <b>Destination Items</b> tab in bottom pane. Right click in <b>Destination Items</b> window and select "<i>Add Destination Item</i>" from the Context menu.

Step2. Go to "<b>Properties</b>" window and fill the required details.

Similarly you can create other destination fields as per your requirement.

Step3. Go to "<b>Item Mapping</b>" tab in bottom pane and Map the source field to the required destination field.

Step4. After all the mapping is done you can "Execute Syndication" and a flat file will be syndicated.

Thanks and Regards,

<b>Sagar Sonje

Mark Helpful Answers</b>

Answers (1)

Answers (1)

former_member205403
Active Contributor
0 Kudos

HI Ravi ,

After performing steps as stated by sagar, after clicking execute button ,when syndicator asks you where to save the file then speciy the file location and save file as ".xls"(excel file extension).This will syndicate your data into excel file.

Hope this solves your problem.

Thanks,

shiv