# Import XML in mysql

**URL:** <https://www.ruby-forum.com/t/import-xml-in-mysql/127590>\
**Category:** Rails\
**Created:** [January 30, 2008, 4:25pm UTC](https://www.ruby-forum.com/t/import-xml-in-mysql/127590 "2008-01-30T16:25:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [January 30, 2008, 4:25pm UTC](https://www.ruby-forum.com/t/import-xml-in-mysql/127590/1 "2008-01-30T16:25:48Z")

</div>

Hi,

I am using scrubyt for scraping a webpage. The output is xml:

Example:  
  
  
\<item\_name\>Canon Vertical Battery Grip BG-E3 For EOS Digital Rebel  
XT\</item\_name\>  
$179.00  
  
  
\<item\_name\>Canon Vertical Battery Grip BG-E4 For EOS  
5D\</item\_name\>  
$249.00  
  
  
\<item\_name\>Canon CB-2LW Battery Charger For Canon NB2L Lithium  
Battery\</item\_name\>  
$69.00

Question:

Is there a way to import this output in a mysql-database?

Grtz…remco

---

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [January 30, 2008, 5:35pm UTC](https://www.ruby-forum.com/t/import-xml-in-mysql/127590/2 "2008-01-30T17:35:48Z")

</div>

i don’t know if there’s a direct way, but with hpricot it would be a  
thing of 15 minutes to write something like that

[http://code.whytheluckystiff.net/hpricot/](http://code.whytheluckystiff.net/hpricot/)