import excel

[Former Member]

hi gurus,

i am trying to import excel file through import manager to vendor repository.

the schema of my repository is as follows

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><RepositorySchema Identity="35" MdsVersion="0,3,5,3,7,0,0,1,11"><Regions><Region co="US" code="USA" lang="eng" name="English [US]"/></Regions><LanguageInheritanceSpecifications><LanguageInheritance cutoff="1"><Language co="US" lang="eng" nativeName="English [US]" rgn="USA"/></LanguageInheritance></LanguageInheritanceSpecifications><Relationships enabled="1"/><Table code="Products" flags="0" id="1" lookup="1:2;" primaryDisplayField="2" type="Main"><Names><Name co="US" lang="eng" rgn="USA">Products</Name></Names><Field code="Name" id="2" multiLingual="1" params="50" type="Text" uniqueId="3"><Names><Name co="US" lang="eng" rgn="USA">Name</Name></Names></Field><Field code="Category" id="24" keywordWeight="0" params="5:0" type="Lookup [Taxonomy]" uniqueId="29"><Names><Name co="US" lang="eng" rgn="USA">Category</Name></Names></Field></Table><Table code="Masks" flags="0" id="4" lookup="1:22;" primaryDisplayField="22" type="Masks"><Names><Name co="US" lang="eng" rgn="USA">Masks</Name></Names><Field code="Name" id="22" multiLingual="1" params="50" type="Text" uniqueId="26"><Names><Name co="US" lang="eng" rgn="USA">Name</Name></Names></Field></Table><Table code="Categories" flags="0" id="5" lookup="1:23;" primaryDisplayField="23" type="Taxonomy"><Names><Name co="US" lang="eng" rgn="USA">Categories</Name></Names><Field code="Name" id="23" multiLingual="1" params="50" type="Text" uniqueId="28"><Names><Name co="US" lang="eng" rgn="USA">Name</Name></Names></Field></Table><Table code="Images" flags="0" id="6" primaryDisplayField="0" type="Image"><Names><Name co="US" lang="eng" rgn="USA">Images</Name></Names></Table><Table code="Copy_Blocks" flags="0" id="8" primaryDisplayField="0" type="Copy Block"><Names><Name co="US" lang="eng" rgn="USA">Copy Blocks</Name></Names></Table><Table code="PDFs" flags="0" id="10" primaryDisplayField="0" type="PDF"><Names><Name co="US" lang="eng" rgn="USA">PDFs</Name></Names></Table><Table code="Text_Blocks" flags="0" id="7" primaryDisplayField="0" type="Text Block"><Names><Name co="US" lang="eng" rgn="USA">Text Blocks</Name></Names></Table><Table code="Text_HTMLs" flags="0" id="9" primaryDisplayField="0" type="Text HTML"><Names><Name co="US" lang="eng" rgn="USA">Text HTMLs</Name></Names></Table><Table code="Workflows" flags="0" id="11" primaryDisplayField="0" type="Workflow"><Names><Name co="US" lang="eng" rgn="USA">Workflows</Name></Names></Table></RepositorySchema>

could you pls suggest me a sample XML data file to import the same...?

thanks in advance

regards

pavan

[Former Member]

Hi Pavan,

I think you're refering to an excel data file.

Just log on to the Data Manager and choose "File / Expot to / Excel" and do your custom configuration.

Then you'll get your repository fields (and data if existing already) in an excel format.

Hope this helped,

Andreas

[Former Member]

Hi pavan,

just create an excel file with columns as Name,Customer ID,Region,Country,etc.

and fill in the required values as row entries.

I will mail you the required document for Importing excel file.

Thanks and regards,

Sagar Sonje.