0

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>
1
Contributor
1
Reply
7
Views
5 Months
Discussion Span
Last Post by usmanabb
0

Where ever I have mentioned "CHANGE" in the code. That field needs to be changed and to be inserted from Excel.

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.