Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='arey ooo samba' timestamp='1361914963' post='1303334291'] I am having XML content in a column which is stored in a dataset aa xml contetn lo parent tag ila untadi baa [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]<AA-Return returnVersion="2012v3.1" xmlns="http://www.example/efile" xmlns:irs="http://www.[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=2][background=rgb(234,237,244)]example[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]/efile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" [b]xsi:schemaLocation=" [/b][/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][b][background=rgb(234,237,244)]file:///efile/PIT_RETURNS/Sample1.xsd" [/background][/b][/size][/font][/color][/b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]>[/background][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]aa bold chesina content ni remove cheyali...transformer lo ela cheyachu baa[/background][/size][/font][/color] possible change ela undachu ante...aa red color lo unna part change avthaa untadii..for one xml to another xml [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]Sample1[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)].xsd" [/background][/size][/font][/color][/b] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]Example[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)].xsd" [/background][/size][/font][/color][/b] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)]Test[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234,237,244)].xsd" [/background][/size][/font][/color][/b] [/quote] nee requirement enti baa .....xsd tells u the structure of xml ....... obviously nee xml marinappudu u should define that xml as per new xsd
qwerty1204 Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='Silver_mani' timestamp='1361923298' post='1303334868'] nee requirement enti baa .....xsd tells u the structure of xml ....... obviously nee xml marinappudu u should define that xml as per new xsd [/quote] naaku vachey xml ..already as per the schema nee vasthundi... so I dont need to check for the wellformedness or validness all I have to do is to grad some contents from the XML which will always be the same for any incoming xml ikkada prob enti ante nenu chepina aa XSD location in the parent tag anedi is not a valid location anymore...so I have to skip that part whuile reading in the xml input stage...so that the stage wont point to the schema at all
Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='arey ooo samba' timestamp='1361983019' post='1303337821'] naaku vachey xml ..already as per the schema nee vasthundi... so I dont need to check for the wellformedness or validness all I have to do is to grad some contents from the XML which will always be the same for any incoming xml ikkada prob enti ante nenu chepina aa XSD location in the parent tag anedi is not a valid location anymore...so I have to skip that part whuile reading in the xml input stage...so that the stage wont point to the schema at all [/quote] baa oka question ..nee xml ela vastundi .... as a single sting (root ) ??
qwerty1204 Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='Silver_mani' timestamp='1361988140' post='1303338441'] baa oka question ..nee xml ela vastundi .... as a single sting (root ) ?? [/quote] dataset lo column ni LongVarchar ani define chesi reading the XML content baa
Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='arey ooo samba' timestamp='1361992205' post='1303339002'] dataset lo column ni LongVarchar ani define chesi reading the XML content baa [/quote] so column description lo [size=5][b]/[/b][/size] istunnav kada ?
qwerty1204 Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='Silver_mani' timestamp='1361992774' post='1303339085'] so column description lo [size=5][b]/[/b][/size] istunnav kada ? [/quote] avnu baa...
Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='arey ooo samba' timestamp='1361992856' post='1303339092'] avnu baa... [/quote] from xml input send the output link to xml transformer ...akkada xsd load chesko ...appudu neeku xml parse aipotundi ... remove that header and just read the columns what you want
qwerty1204 Posted February 27, 2013 Author Report Posted February 27, 2013 [quote name='Silver_mani' timestamp='1361993117' post='1303339117'] from xml input send the output link to xml transformer ...akkada xsd load chesko ...appudu neeku xml parse aipotundi ... remove that header and just read the columns what you want [/quote] ikkada prob enti ante...asalu XML Input stage loo incoming XML reading chesetapudu aa XSD location ni refer chestundi..since its not a valid location its throwing the error (i cant even give the valid location of XSD also, the reason being, we dont have the XSD is one reason and the other reason was the idea is to eliminate the XSD reference completely) wht I have to do is either remove that XSD attribute frm the parent tag or some how xml Input stage has to ignore that XSD attribute by itself.
Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='arey ooo samba' timestamp='1361993557' post='1303339170'] ikkada prob enti ante...asalu XML Input stage loo incoming XML reading chesetapudu aa XSD location ni refer chestundi..since its not a valid location its throwing the error (i cant even give the valid location of XSD also, the reason being, we dont have the XSD is one reason and the other reason was the idea is to eliminate the XSD reference completely) wht I have to do is either remove that XSD attribute frm the parent tag or some how xml Input stage has to ignore that XSD attribute by itself. [/quote] emo baa ...... nuvvu xml meta data data importer nunchi xsd import cheskuntunnava asalu ??
Silver_mani Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Kaarthikeya' timestamp='1361994598' post='1303339327'] Vendi_Diamond [/quote] vuncle ...emaipoinav ? aunty tho busy naa ??
ronitreddy Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Kaarthikeya' timestamp='1361994598' post='1303339327'] Vendi_Diamond [/quote]
deals2buy Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Silver_mani' timestamp='1361994737' post='1303339342'] vuncle ...emaipoinav ? aunty tho busy naa ?? [/quote] valentines day ki underground poyi monna weekend ey bayatiki vachina vuncle [quote name='Ronit' timestamp='1361994754' post='1303339344'] [/quote]u go dkc smiley esko neeku
ronitreddy Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Kaarthikeya' timestamp='1361994960' post='1303339367'] valentines day ki underground poyi monna weekend ey bayatiki vachina vuncle u go dkc smiley esko neeku [/quote] [img]http://www.desigifs.com/sites/default/files/ravitejapepe.gif?1290194480[/img]
deals2buy Posted February 27, 2013 Report Posted February 27, 2013 [quote name='Ronit' timestamp='1361995073' post='1303339387'] [img]http://www.desigifs.com/sites/default/files/ravitejapepe.gif?1290194480[/img] [/quote] peru maarchav enduku?
Recommended Posts