Click here to Skip to main content
15,912,400 members
Home / Discussions / C#
   

C#

 
GeneralRe: two use-cases that do not (surprise) cause a compiler error in VS 2010 Pro Pin
Shameel22-Aug-11 4:52
professionalShameel22-Aug-11 4:52 
AnswerRe: two use-cases that do not (surprise) cause a compiler error in VS 2010 Pro Pin
Shameel22-Aug-11 4:27
professionalShameel22-Aug-11 4:27 
Questionwindow services in VS2008 [modified] Pin
Aisha sharma21-Aug-11 21:12
Aisha sharma21-Aug-11 21:12 
AnswerRe: window services in VS2008 Pin
Richard MacCutchan21-Aug-11 21:38
mveRichard MacCutchan21-Aug-11 21:38 
AnswerRe: window services in VS2008 Pin
Paul E Davies21-Aug-11 22:07
Paul E Davies21-Aug-11 22:07 
GeneralRe: window services in VS2008 Pin
Aisha sharma22-Aug-11 0:29
Aisha sharma22-Aug-11 0:29 
GeneralRe: window services in VS2008 [modified] Pin
Paul E Davies22-Aug-11 2:56
Paul E Davies22-Aug-11 2:56 
QuestionXML to Excel parsing Pin
yoni.kess21-Aug-11 4:15
yoni.kess21-Aug-11 4:15 
Hi All,
First of all I would like to thank you for the support. I am new in coding and need assistance in getting a specific xml content to an excel spreadsheet or to a datagridview.

the XML file is not a standard one (i think and below is a sample).
what i need from this xml file is the following data:

the name (Towers xxx] of the alert and the gps points (dont need the utm)

this is the xml
[code]
XML
<?xml version="1.0" encoding="UTF-16"?>
<layer>
    <name>
        SF Zones
    </name>
    <alert_area_object>
        <creation_time>
            1303889594
        </creation_time>
        <name>
            Tower 1
        </name>
        <description>
            Fence Alert
        </description>
        <event_types num="1">
            <event_type>
                11111
            </event_type>
        </event_types>
        <event_severity>
            2
        </event_severity>
        <event_override_flag>
            false
        </event_override_flag>
        <identities num="0"/>
        <categories num="0"/>
        <groups num="0"/>
        <target_appear_in_area>
            true
        </target_appear_in_area>
        <target_enter_area>
            true
        </target_enter_area>
        <target_leave_area>
            true
        </target_leave_area>
        <from_hour>
            0
        </from_hour>
        <from_minute>
            0
        </from_minute>
        <to_hour>
            23
        </to_hour>
        <to_minute>
            59
        </to_minute>
        <from_speed>
            0
        </from_speed>
        <to_speed>
            98.8889
        </to_speed>
        <weighting>
            <weight>
                <type>
                    2
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    204
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    205
                </type>
                <value>
                    99
                </value>
            </weight>
        </weighting>
        <visual_feedback>
            true
        </visual_feedback>
        <sound_repeats>
            -1
        </sound_repeats>
        <wave_file>
            C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
        </wave_file>
        <utm_zone>
            40
        </utm_zone>
        <shape type="ClosedPolygon">
            <num_of_alloc_points>
                22
            </num_of_alloc_points>
            <num_of_points>
                5
            </num_of_points>
            <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
            <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
            <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
            <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
            <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
        </shape>
    </alert_area_object>
    <alert_area_object>
        <creation_time>
            1303890003
        </creation_time>
        <name>
            Towers 1 to 4
        </name>
        <description>
            Fence Alert
        </description>
        <event_types num="1">
            <event_type>
                11111
            </event_type>
        </event_types>
        <event_severity>
            2
        </event_severity>
        <event_override_flag>
            false
        </event_override_flag>
        <identities num="0"/>
        <categories num="0"/>
        <groups num="0"/>
        <target_appear_in_area>
            true
        </target_appear_in_area>
        <target_enter_area>
            true
        </target_enter_area>
        <target_leave_area>
            true
        </target_leave_area>
        <from_hour>
            0
        </from_hour>
        <from_minute>
            0
        </from_minute>
        <to_hour>
            23
        </to_hour>
        <to_minute>
            59
        </to_minute>
        <from_speed>
            0
        </from_speed>
        <to_speed>
            98.8889
        </to_speed>
        <weighting>
            <weight>
                <type>
                    2
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    204
                </type>
                <value>
                    99
                </value>
            </weight>
            <weight>
                <type>
                    205
                </type>
                <value>
                    99
                </value>
            </weight>
        </weighting>
        <visual_feedback>
            true
        </visual_feedback>
        <sound_repeats>
            -1
        </sound_repeats>
        <wave_file>
            C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
        </wave_file>
        <utm_zone>
            40
        </utm_zone>
        <shape type="ClosedPolygon">
            <num_of_alloc_points>
                22
            </num_of_alloc_points>
            <num_of_points>
                6
            </num_of_points>
            <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
            <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
            <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
            <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
            <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
            <utm_points x="132131" y="132131"/>
        </shape>
    </alert_area_object>
</layer>


[/code]

thanks again
AnswerRe: XML to Excel parsing Pin
Not Active21-Aug-11 6:47
mentorNot Active21-Aug-11 6:47 
GeneralRe: XML to Excel parsing [modified] Pin
yoni.kess23-Aug-11 9:31
yoni.kess23-Aug-11 9:31 
GeneralRe: XML to Excel parsing Pin
Not Active23-Aug-11 9:53
mentorNot Active23-Aug-11 9:53 
GeneralRe: XML to Excel parsing Pin
yoni.kess24-Aug-11 21:06
yoni.kess24-Aug-11 21:06 
QuestionPass object from an app to another Pin
mehrdadc4820-Aug-11 23:50
mehrdadc4820-Aug-11 23:50 
AnswerRe: Pass object from an app to another Pin
#realJSOP21-Aug-11 2:56
professional#realJSOP21-Aug-11 2:56 
AnswerRe: Pass object from an app to another [modified] Pin
Manfred Rudolf Bihy21-Aug-11 3:32
professionalManfred Rudolf Bihy21-Aug-11 3:32 
GeneralRe: Pass object from an app to another Pin
Keith Barrow21-Aug-11 9:23
professionalKeith Barrow21-Aug-11 9:23 
GeneralRe: Pass object from an app to another Pin
Manfred Rudolf Bihy21-Aug-11 20:50
professionalManfred Rudolf Bihy21-Aug-11 20:50 
SuggestionTIP: Autosetting properties in C# using DefaultValue attributes Pin
Itai Basel20-Aug-11 14:53
Itai Basel20-Aug-11 14:53 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
Mycroft Holmes20-Aug-11 16:48
professionalMycroft Holmes20-Aug-11 16:48 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
Itai Basel20-Aug-11 19:58
Itai Basel20-Aug-11 19:58 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
Itai Basel20-Aug-11 20:09
Itai Basel20-Aug-11 20:09 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
Mycroft Holmes20-Aug-11 22:35
professionalMycroft Holmes20-Aug-11 22:35 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
PIEBALDconsult20-Aug-11 19:57
mvePIEBALDconsult20-Aug-11 19:57 
GeneralRe: TIP: Autosetting properties in C# using DefaultValue attributes Pin
thatraja20-Aug-11 21:40
professionalthatraja20-Aug-11 21:40 
QuestionShowing Picture in Crystal Reports from Table Pin
M Riaz Bashir20-Aug-11 11:26
M Riaz Bashir20-Aug-11 11:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.