Hi Support

Okay, silly question time (from someone who knows nothing about .NET!)

How and where do I install a .NET library so that VC picks it up? I have the cook XML-RPC library (CookComputing.XmlRpc.CF.dll & CookComputing.XmlRpcV2.dll - I have placed them in the VisualCron Program Files folder. Do I need to do anything to register them?

Cheers

Andy

You can place it anywhere. You use the Assembly Execute Task to execute. But the question is what you want to do?

---

Hi Henrik

I am trying to 'experiment' with some .NET Code to access OpenERP via XML-RPC and return data back to VC. I can achieve this via Python script but the generic scripting feature means I have to create and maintain a library of script files where my preference is to keep everything internal to VC.

I'm pretty much just experimenting as I don't know anything about .NET :-)

Cheers

Andy

I think this require some work and programming. Using the VisualCron API is the only way to send messages to VisualCron. It is also the best method of retrieving data in an easily interpreted format.

I think, what you want (which you may have requested in the feature requests), is a direct web service interface to VisualCron. It is probably best to keep that request but then explain further what information you want out and in from VisualCron.

---

Hi Henrik

I did add this to feature requests but I realise you are very busy and need to find a work-around as soon as possible as we are rolling this solution out at the customer just now.

It is very difficult to specify particular information required as OpenERP is such a huge solution built around an Object Relationship Model. But in summary:

OpenERP provides the resource planning functionality for the customer (Contact management, Sales, Stock Control, Manufacturing Processes, Project Management etc). VC is performing the workflow tasks (i.e. executing external processes in order to achieve a full Sales Process). As VC performs tasks, it needs to update OpenERP to say that task completed succesfully or unsuccesfully. Also, OpenERP needs to feed various parameters into VC so that VC knows what tasks to execute.

A 'feel' for the typical functionality i'm talking about is found here:

http://doc.openerp.com/v..._web_services/index.html 

Is there a way to execute PHP scripts within VC? Or even to provide support for IronPython (.NET)?

Cheers

Andy

You execute any script like php or python. Just important that you have the "engines" installed locally (if you want to execute locally). The other approach is using the HTTP Task to execute remotely.

I think it is about what interfaces OpenERP has. If you can get information out of OpenERP you could also probably called OpenERP functions from outside.

---

By taking a quick look at the page you gave it seems like they have a web service interface = XML-RPC. This means you can use the Web service Task from VC to connecto to your OpenERP server and retrieve/execute.

---

Hi Henrik

Okay - trying to connect now with web services but there doesn't seem to be any way to add the relevant connection string, for example, in Python, I need the following to connect via xml-rpc:

---

username = 'admin' #the user
pwd = 'maven' #the password of the user
dbname = 'andy1' #the database

# Get the uid
sock_common = xmlrpclib.ServerProxy ('http://localhost:8069/xmlrpc/common')
uid = sock_common.login(dbname, username, pwd)

#replace localhost with the address of the server
sock = xmlrpclib.ServerProxy('http://localhost:8069/xmlrpc/object')

---

How would I replicate that in a Web Service task - particularly the user/pwd and dbname?

Cheers

Andy

The information you describe should exist in a so called wsdl which is hopefully exposed by the application. If VisualCron is installed on the same server as OpenERP you should try using the Web service Task with the URL: http://localhost:8069/xmlrpc/common

Hopefully, all properties will be exposed then.

---

It seems like SOAP support (which is needed for VisualCron) is deprecated at the moment for some reason.

Support for the SOAP protocol is deprecated at the moment, but could maybe be revived if sufficient interest is found in the community.

---

Hi Henrik

Yes, I just read that, so SOAP is not an option - equally, WSDL as a separate entity outside of SOAP does not seem to be a preferred option - all references are for direct XML-RPC calls.

I can call xml-rpc via Python Scripts but it seems that as it is externalised, I can't return the values from the RPC 'Query' back in to VC.

Rapidly running out of options now :-(

Cheers

Andy