Announcement

Collapse
No announcement yet.

XML help reqired

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    XML help reqired

    Can anyone help please? I am trying to show live stock on my site, my supplier has sent me the following info and I haven't got a clue what do to do with it. Can anyone advise please?

    "We've not used Actinic v7 and so have no experience of using it to collect live XML feeds. We offer an XML service using http://intouch.computer2000.com/xml/...009&prodid=156 where prodid is our part-code. If Actinic can parse the response, then you're in business."

    (Don't worry the customer id is for demo.)

    Thank you :-)

    Guy.

    #2
    Actinic can't natively handle this but there are ways using .NET that are particularly good for XML handling. You can read the data from a url or from a file. What you would be looking to do is build a statement that says:

    for each product in YourCatalogue:
    Update Products SET nStockOnHand = <YOURSTOCKFIGURE> WHERE ProductReference = <YOURPRODUCTREFERENCE>.

    Something could be built that could grab the details of each product and run an insert, then you'd just upload Actinic. Interested?
    http://www.johnsons-seeds.com - Actinic plugins, remote add to cart and custom CMS
    http://www.dtbrownseeds.co.uk - More seeds and plants....
    http://www.mr-fothergills.co.uk - Well it used to be Actinic...

    Comment


      #3
      Hi Dave
      Sure am interested...tell me more :-)

      Thanks
      Guy

      Comment


        #4
        Hi Guy

        Please see the attached files for starters.

        It assumes you run a .NET enabled PC with IIS 5 or above - I suggest WebMatrix for testig asp.net pages it is very good.

        With that script I was able to parse the file you provided, saved to the desktop, and update the relevant access field for Product ref 156.

        If you had multiple items in one file you'd need a different routine that would loop through each record and do the insert - not actually much more complex at all. Contact me through www.johnsons-seeds.com/about/contact.html and I'll help out further.

        Best of luck.

        Dave.
        Attached Files
        http://www.johnsons-seeds.com - Actinic plugins, remote add to cart and custom CMS
        http://www.dtbrownseeds.co.uk - More seeds and plants....
        http://www.mr-fothergills.co.uk - Well it used to be Actinic...

        Comment


          #5
          You are a star! Thank you so much.
          Really appreciate it.

          Comment

          Working...
          X