Hello Guys,
I am working on a Movie Platform and using XML file to upload/Publish Movies on to the platform. So for each Movie title I have to Edit and create an XML which is very time consuming and to be honest stupid. I want your help to suggest me a way how can I integrate this XML at the back of Excel Sheet and Index those fields which I have to change using Excel columns and can generate the XML file. I have data in excel sheet column wise. So each column serves as the data to be inserted on the platform. I need to make something so that I can I can run a script on excel data file and it generates all the XML files.
Please help me find a way as how to do it? So that I may be able to do it in future for all the platforms. Thanks in Advance
<?xml version="1.0" encoding="UTF-8"?>
<ADI xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="title" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="CarrierID" Value="96502"/>
<App_Data App="MOD" Name="CarrierID" Value="96501"/>
<App_Data App="MOD" Name="CarrierID" Value="96601"/>
<App_Data App="MOD" Name="CarrierID" Value="97101"/>
<App_Data App="MOD" Name="CarrierID" Value="96503"/>
<App_Data App="MOD" Name="CarrierID" Value="96402"/>
<App_Data App="MOD" Name="CarrierID" Value="96401"/>
<App_Data App="MOD" Name="CarrierID" Value="96802"/>
<App_Data App="MOD" Name="CarrierID" Value="97402"/>
<App_Data App="MOD" Name="CarrierID" Value="97303"/>
<App_Data App="MOD" Name="CarrierID" Value="97302"/>
<App_Data App="MOD" Name="CarrierID" Value="97301"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96502" Value="10"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96501" Value="9"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96601" Value="3"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="97101" Value="1"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96503" Value="11"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96402" Value="16"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96401" Value="15"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="96802" Value="13"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="97402" Value="8"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="97303" Value="7"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="97302" Value="5"/>
<App_Data App="MOD" Name="DestAreas" CarrierID="97301" Value="6"/>
<App_Data App="MOD" Name="Type" Value="title"/>
<App_Data App="MOD" Name="Title" Value="CHANGE" Language="en"/>
<App_Data App="MOD" Name="Summary_Medium" Value="CHANGE" Language="en"/>
<App_Data App="MOD" Name="Keyword" Value="CHANGE" Language="en"/>
<App_Data App="MOD" Name="Licensing_Window_Start" Value="2017-02-15"/>
<App_Data App="MOD" Name="Licensing_Window_End" Value="2019-02-15"/>
<App_Data App="MOD" Name="Suggested_Price" Value="00"/>
<App_Data App="MOD" Name="RentPeriod" Value="7999"/>
<App_Data App="MOD" Name="Rating" CarrierID="96502" Value="CHANGE"/>
<App_Data App="MOD" Name="Rating" CarrierID="96501" Value="CHANGE"/>
<App_Data App="MOD" Name="Rating" CarrierID="96601" Value="CHANGE"/>
<App_Data App="MOD" Name="Rating" CarrierID="97101" Value="CHANGE"/>
<App_Data App="MOD" Name="Category" CarrierID="96502" Value="CHANGE"/>
<App_Data App="MOD" Name="Category" CarrierID="96501" Value="CHANGE"/>
<App_Data App="MOD" Name="Category" CarrierID="96601" Value="CHANGE"/>
<App_Data App="MOD" Name="Category" CarrierID="97101" Value="CHANGE"/>
<App_Data App="MOD" Name="Category" CarrierID="97101" Value="CHANGE"/>
<App_Data App="MOD" Name="DistributionList" CarrierID="96502" Value="KW"/>
<App_Data App="MOD" Name="DistributionList" CarrierID="96501" Value="KW"/>
<App_Data App="MOD" Name="DistributionList" CarrierID="96601" Value="SA"/>
<App_Data App="MOD" Name="DistributionList" CarrierID="97101" Value="PK,KW,SA"/>
<App_Data App="MOD" Name="Suggested_Price" Value="00"/>
<App_Data App="MOD" Name="RentPeriod" Value="7999"/>
<App_Data App="MOD" Name="Year" Value="2011"/>
<App_Data App="MOD" Name="HighlyRecommended" Value="0"/>
<App_Data App="MOD" Name="Genre" Value="CHANGE" Language="en" />
<App_Data App="MOD" Name="Actors" Language="en" Value="CHANGE"/>
<App_Data App="MOD" Name="Actors" Language="ar" Value="CHANGE"/>
<App_Data App="MOD" Name="Director" Language="en" Value="CHANGE"/>
<App_Data App="MOD" Name="Director" Language="ar" Value="CHANGE"/>
</Metadata>
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="poster" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="Type" Value="poster"/>
<App_Data App="MOD" Name="PType" Value="1" Language="en"/>
</Metadata>
<Content Value="CHANGE"/>
</Asset>
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="poster" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="Type" Value="poster"/>
<App_Data App="MOD" Name="PType" Value="3" Language="en"/>
</Metadata>
<Content Value="CHANGE"/>
</Asset>
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="poster" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="Type" Value="poster"/>
<App_Data App="MOD" Name="PType" Value="4" Language="en"/>
</Metadata>
<Content Value="CHANGE"/>
</Asset>
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="poster" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="Type" Value="poster"/>
<App_Data App="MOD" Name="PType" Value="5" Language="en"/>
</Metadata>
<Content Value="CHANGE"/>
</Asset>
<Asset>
<Metadata>
<AMS Provider="000403" Asset_Class="movie" Asset_ID="CHANGE" Verb=""/>
<App_Data App="MOD" Name="Type" Value="movie"/>
<App_Data App="MOD" Name="Encryption" Value="N"/>
<App_Data App="MOD" Name="HDContent" Value="Y"/>
<App_Data App="MOD" Name="Domain" Value="WEBTV"/>
<App_Data App="MOD" Name="Analog_Output_Enable" Value="Y"/>
<App_Data App="MOD" Name="Encoder_Mode" Value="3"/>
</Metadata>
<Content Value="../encoded/CHANGE/index.m3u8"/>
</Asset>
</Asset>
</ADI>