#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    5

    Automatic xml import to mysql database


    I have a command like if run it to browser returns a report


    https://xml2.domain.com/tsim_xml/service/xmlgate?uname=user&upass=pass&plain=1&command=sbalance&started=2006-03-22&finished=2011-03-28&plain=1&onum=number

    I wanted to know if there is any way that a program will call this command save the report and import it to desired sql table



    xml report like at browser


    <records>

    <record>
    <added>2010-08-09 16:23:41</added>
    <type>card</type>
    <orderid>308</orderid>
    <uname>name</uname>
    <address>99.99.2.51</address>
    <command>sbalance</command>
    <inum>number</inum>
    <onum>number</onum>
    <balance>11.99 EUR</balance>
    <amount>+99.64 EUR</amount>
    </record>

    <record>
    <added>2010-08-09 16:23:41</added>
    <type>client</type>
    <orderid>308</orderid>
    <uname>asd</uname>
    <address>99.29.2.51</address>
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2009
    Posts
    225
    Rep Power
    11
    MySQL 5.5 - LOAD XML Syntax

    Command-line Data Import functionality is being developed to integrate into new dbForge Studio for MySQL.

    Currently, you can do it using GUI.

    http://www.devart.com/dbforge/mysql/...rt-import.html
    Devart Company,
    MySQL management tools
    http://www.devart.com/dbforge/mysql/
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0
    How to generate sql-code with "LOAD XML"? It need for using in external automatic scheduled php queries to database. The Import GUI doesn't create it.

IMN logo majestic logo threadwatch logo seochat tools logo