XML Parsing with classic asp

Web, Mobile & Software Dev Web Development Posted 3 years ago

Fixed Price

Budget: $20
Delivery by December 14, 2012

Start Date

December 8, 2012


I have 2 xml files.

xml1 is a list of employees on duty
xml2 is a list of all employees

I have a working classic asp script that parses the xml1 and pulls out the managers names and the hours they work...

Set xmlObj = Server.CreateObject("MSXML2.FreeThreadedDOMDocument")
xmlObj.async = False
xmlObj.setProperty "ServerHTTPRequest", True
If xmlObj.parseError.errorCode <> 0 Then
response.write "ERROR"
End If
Set xmlList = xmlObj.getElementsByTagName("Shift")
Set xmlObj = Nothing
x = 1
For Each xmlItem In xmlList
EmployeeName = xmlItem.childNodes(1).text
Schedule = xmlItem.childNodes(2).text
StartTime = xmlItem.childNodes(3).text
EndTime = xmlItem.childNodes(4).text

       If Trim(Schedule) = "Manager" Then
                                <div class="item clearfix">
                                    <div class="info">
                                        <a href="#" class="name"><%=EmployeeName%></a>                                
                                        <span><%=StartTime%> - <%=EndTime%></span>
                                        <div class="controls">                    
                                            <a href="#" class="icon-pencil"></a>
                                            <a href="#" class="icon-envelope"></a>                                         
                                            <a href="#" class="icon-remove"></a>
<% End If %>

That part works great. What I need is to store those managers in an array. Then loop thru the array and go thru xml2 and get <Email> and  <Cellphone> for each of the managers.

Should be a straight forward task for a seasoned XML writer. I will have a follow-up job after this regarding figuring out which of the managers for the day is actually on duty at any given time.

Please only apply if you have read and understand the task requirements. I need it done quickly and don't want to spend a lot of time discussing it. If you understand XML and classic ASP...it should be an easy task.

XML2 is attached. Here is XML1:

<?xml version="1.0" encoding="utf-8"?>
<Restaurant xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.schedulefly.com/api/">
  <Name>The Lime</Name>
      <Date>Saturday - 12/8/2012</Date>
          <EmployeeName>Jordan Warshavsky</EmployeeName>
          <EmployeeName>James Trevino</EmployeeName>
          <Note>WEEKEND SERVICE</Note>
          <EmployeeName>Sarah Monson</EmployeeName>
          <Note>WEEKEND FRONT BAR</Note>
          <EmployeeName>Kevin Richardson</EmployeeName>
          <Note>MANAGER 2</Note>
          <EmployeeName>Ben Archer</EmployeeName>

Skills: asp-classic

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

About the Client

(4.95) 90 reviews

United States
Tampa 10:38 AM

125 Jobs Posted
82% Hire Rate, 1 Open Job

Over $10,000 Total Spent
105 Hires, 4 Active

$13.19/hr Avg Hourly Rate Paid
697 Hours

Member Since Jun 15, 2009