RocketTheme - TOPIC: XML Data import

Welcome Guest! Login

0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

Fred Dun...
Sr. Rocketeer
Posts: 136
Thanks: 0

XML Data import

Posted 13 years 4 months ago

Hello all,

I'm creating a site for a real estate company and I'm trying to import XML data from GreatSchools.org with their API Resources. Now I'm not the best of coders when it comes to creating something custom to be able to covert imported xml code to an article or module.

So I was wondering if anyone knows of a component that could grab XML code and I can just display it in a module. I thought I found a module before that I could put in a url and then their was a section that I could organize the data feed into a table but I can't remember what that module was call.

If there isn't such, what would be the easiest way to go about doing something like this? Thanks for any guidance

This is the XML Data that have.

<schools>
<school>
<gsId>536</gsId>
<name>Elsinboro Elementary School</name>
<type>public</type>
<gradeRange>K-8</gradeRange>
<enrollment>98</enrollment>
<gsRating>5</gsRating>
<city>Salem</city>
<state>NJ</state>
<districtId>144</districtId>
<district>Elsinboro Township School District</district>
<districtNCESId>3404680</districtNCESId>
<address>631 Salem-Fort Elfsborg Road, Salem, NJ 08079</address>
<phone>(856) 935-3817</phone>
<fax/>
<website/>
<ncesId>340468005032</ncesId>
<lat>39.5513</lat>
<lon>-75.5176</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/536-Elsinboro-Elementary-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=536&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=536&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/536
</schoolStatsLink>
</school>
<school>
<gsId>1802</gsId>
<name>John Fenwick Elementary School</name>
<type>public</type>
<gradeRange>PK-2</gradeRange>
<enrollment>386</enrollment>
<parentRating>4</parentRating>
<city>Salem</city>
<state>NJ</state>
<districtId>474</districtId>
<district>Salem City School District</district>
<districtNCESId>3414550</districtNCESId>
<address>183 Smith Street, Salem, NJ 08079</address>
<phone>(856) 935-4100</phone>
<fax/>
<website/>
<ncesId>341455005092</ncesId>
<lat>39.5671</lat>
<lon>-75.4685</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/1802-John-Fenwick-Elementary-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=1802&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=1802&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/1802
</schoolStatsLink>
</school>
<school>
<gsId>1025</gsId>
<name>Lower Alloways Creek Elementary School</name>
<type>public</type>
<gradeRange>PK-8</gradeRange>
<enrollment>223</enrollment>
<gsRating>6</gsRating>
<parentRating>5</parentRating>
<city>Salem</city>
<state>NJ</state>
<districtId>290</districtId>
<district>Lower Alloways Creek Township School District</district>
<districtNCESId>3409030</districtNCESId>
<address>67 Main St Canton, Salem, NJ 08079</address>
<phone>(856) 935-2707</phone>
<fax/>
<website/>
<ncesId>340903005034</ncesId>
<lat>39.470985</lat>
<lon>-75.41533</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/1025-Lower-Alloways-Creek-Elementary-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=1025&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=1025&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/1025
</schoolStatsLink>
</school>
<school>
<gsId>1094</gsId>
<name>Mannington Elementary School</name>
<type>public</type>
<gradeRange>PK-8</gradeRange>
<enrollment>172</enrollment>
<gsRating>5</gsRating>
<city>Salem</city>
<state>NJ</state>
<districtId>305</districtId>
<district>Mannington Township School District</district>
<districtNCESId>3409480</districtNCESId>
<address>495 Route 45, Salem, NJ 08079</address>
<phone>(856) 935-1078</phone>
<fax/>
<website/>
<ncesId>340948005036</ncesId>
<lat>39.60204</lat>
<lon>-75.42381</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/1094-Mannington-Elementary-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=1094&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=1094&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/1094
</schoolStatsLink>
</school>
<school>
<gsId>1801</gsId>
<name>Salem High School</name>
<type>public</type>
<gradeRange>9-12</gradeRange>
<enrollment>553</enrollment>
<gsRating>2</gsRating>
<parentRating>4</parentRating>
<city>Salem</city>
<state>NJ</state>
<districtId>474</districtId>
<district>Salem City School District</district>
<districtNCESId>3414550</districtNCESId>
<address>219 Walnut Street, Salem, NJ 08079</address>
<phone>(856) 935-3900</phone>
<fax/>
<website/>
<ncesId>341455005090</ncesId>
<lat>39.5619</lat>
<lon>-75.4714</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/1801-Salem-High-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=1801&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=1801&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/1801
</schoolStatsLink>
</school>
<school>
<gsId>1803</gsId>
<name>Salem Middle School</name>
<type>public</type>
<gradeRange>3-8</gradeRange>
<enrollment>467</enrollment>
<gsRating>1</gsRating>
<parentRating>2</parentRating>
<city>Salem</city>
<state>NJ</state>
<districtId>474</districtId>
<district>Salem City School District</district>
<districtNCESId>3414550</districtNCESId>
<address>51 New Market Street, Salem, NJ 08079</address>
<phone>(856) 935-2700</phone>
<fax/>
<website/>
<ncesId>341455005094</ncesId>
<lat>39.5702</lat>
<lon>-75.468</lon>
<overviewLink>
http://www.greatschools.org/new-jersey/salem/1803-Salem-Middle-School/?s_cid=gsapi
</overviewLink>
<ratingsLink>
http://www.greatschools.org/school/rating.page?state=NJ&id=1803&s_cid=gsapi
</ratingsLink>
<reviewsLink>
http://www.greatschools.org/school/parentReviews.page?state=NJ&id=1803&s_cid=gsapi
</reviewsLink>
<schoolStatsLink>
http://www.greatschools.org/modperl/achievement/NJ/1803
</schoolStatsLink>
</school>
</schools>

#756958

- Adamck
- Elite Rocketeer
- Posts: 546
- Thanks: 2
- Web Developer, IT Assistant, Graphics design, App Developer
Re: XML Data import

Posted 13 years 4 months ago
- What you need to do is read the XML file
  
  See www.w3schools.com/php/php_xml_simplexml.asp
  
  Then create a php array() of the results.
  Then run a foreach query on the query to fire the data to MySQL, if your query is set to create a new article (id should auto increment anyway), set a title and then the body you can make fancy within the query.
  
  Once the PHP is saved and tested, run it as a cron job every X hours/days/weeks etc...
  
  Should be relatively easy to do
  
  If their API allows JSON output then i would try and work with that, i find JSON easier to work with than XML.
- Kiss my RSS
#757291
- Who?
- Preeminent Rocketeer
- Posts: 25562
- Thanks: 613
- Joomla freelancer
Re: XML Data import

Posted 13 years 4 months ago
- You can use Jumi together with previous suggestion to build your own XML reader and parser:
  
  extensions.joomla.org/extensions/edition...code-in-content/1023
- Check my services at: Mihha-Vision
#758590

Time to create page: 0.056 seconds

XML Data import

XML Data import

Re: XML Data import

Re: XML Data import