SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert NSML format data in SQL table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rajkumar7
Starting Member

Malaysia
2 Posts

Posted - 02/23/2013 :  05:47:56  Show Profile  Reply with Quote
I got below NSML data which needed to be inserted into SQL table and able indexed based on Storyid.Need help.

<nsml version="-//AVID//DTD NSML 1.0//EN">
<head>
<meta words=182 rate=180>
<wgroup number=1></wgroup>
<formname>AWANISTORYFORM</formname>
<storyid>209ff5a0:000373b6:46fc4389</storyid>
</head>
<story>
<fields>
<f id=title>THAILAND MYANMAR</f>
<f id=v-format>VOGX</f>
<f id=var-2></f>
<f id=presenter></f>
<f id=v-graphics>PAINT/1PG</f>
<f id=mos-title></f>
<f id=awanivideoid></f>
<f id=event-status></f>
<f id=audio-time>60</f>
<f id=runs-time>0</f>
<f id=total-time>60</f>
<f id=mos-duration></f>
<f id=cume-time></f>
<f id=back-time></f>
<f id=awanieditor></f>
<f id=air-date>1190937640</f>
<f id=endorse-by></f>
<f id=create-by>kaamkha</f>
<f id=modify-by>director</f>
<f id=modify-date>1190937481</f>
<f id=modify-dev>172.17.212.139</f>
<f id=mos-active></f>
</fields>
<body>
<p><a idref=0><pi>(ANCHOR)</pi></p>
<p></p>
<p>ASEAN SUDAH MENGHABISKAN SUMBER KEUPAYAAN BAGI MEMBAWA DEMOKRASI KE MYANMAR.</p>
<p></p>
<p>PERDANA MENTERI THAILAND, SURAYUD CHULANONT YANG MENGHADIRI SIDANG PERTUBUHAN BANGSA BERSATU, P-B-B DI NEW YORK, AMERIKA SYARIKAT, MEMBERITAHU ASEAN MEMERLUKAN BANTUAN NEGARA SERANTAU LEBIH BESAR BAGI MENGEMBALIKAN PEMERINTAHAN DEMOKRATIK.</p>
<p><pi></pi></p>
<p><pi>VOGFX</pi></p>
<p></p>
<p>JELAS BELIAU, ASEAN TIDAK PERNAH MEMINGGIRKAN MYANMAR DAN SENTIASA BERUSAHA MEMULIHKAN DEMOKRASI.</p>
<p></p>
<p>ASEAN KINI MEMERLUKAN BANTUAN PEMIMPIN LAIN KHUSUSNYA NEGARA BESAR.</p>
<p></p>
<p>BELIAU BERUCAP PADA PERHIMPUNAN ASIA SOCIETY TURUT MENJELASKAN BAHAWA ASEAN BIMBANG MENGENAI TINDAKAN KERAS JUNTA TERHADAP PENUNJUK PERASAAN.</p>
<p></p>
<p>CHULANONT TURUT MENCADANGKAN INDIA DAN CHINA MEMAINKAN PERANAN UTAMA MENYELESAIKAN KRISIS MYANMAR.</p>
<p></p>
<p>CHINA SEBELUM INI TERBABIT DALAM RUNDINGAN MEMUJUK JUNTA BERDAMAI DENGAN KEM PRO-DEMOKRASI.</p>
<p></p>
<p>TETAPI PADA MASA YANG SAMA, MENOLAK CADANGAN MEMBAWA ISU MYANMAR KE MAJLIS KESELAMATAN P-B-B.</p>
</body>
<aeset>
<ae id=0>
<ap>]] S3.0 G 0 [[</ap>
<mc>
<ap>CG AS001 REAKSI NEGARA ASEAN</ap>
</mc>
</ae>
</aeset>
</story>

Newcomer in SQL

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 02/23/2013 :  09:34:46  Show Profile  Reply with Quote
SQL has capabilities to handle XML data. The sample you posted does not seem to be well-formed XML. If there are NSML to XML converters that you can use to convert the data to valid XML that you are aware of, then convert the NSML to XML and then SQL can be used to shred and/or query the XML.
Go to Top of Page

Rajkumar7
Starting Member

Malaysia
2 Posts

Posted - 02/25/2013 :  00:24:56  Show Profile  Reply with Quote
How to convert the NSML to XML,need help!

Newcomer in SQL
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000