XML help reqired

[Guy]

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.

[DaveT]

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?

[Guy]

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

Thanks
Guy

[DaveT]

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.

[Guy]

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