Skip to Content
Former Member
May 07, 2008 at 02:08 PM

Import Multilingual Text Blocks from Excel - SP06 HF02


Has anyone tried to import multilingual data from Excel via Data Manager since an upgrade to SP06? I have setup my Excel sheet per the MDM Data Manager Reference Guide (even used Export To > Excel to ensure correct column headings).

When I select my Excel file in DM, after Import From > Excel, working in the Text Blocks table, I see the error message: “Import file must include columns corresponding to the text block value of the current language and one or more additional languages. Import will now exit."

I have tried the following column headers in my Excel file:

Text Block  <English [US]> | Text Block <Italian [IT]> | Text Block <Spanish [ES]>
Text Block | Text Block <Italian [IT]> | Text Block <Spanish [ES]>

DM recognizes the heading of the second listing, "Text Block", but only for the language I am logged into DM with.

For additional reference, please see Section MULTILINGUAL EXPORT AND IMPORT, pages 585-586.

Thanks in advance for any help anyone can provide.