So, to kick of with reply to JonC from CSV thread.
JonC wrote:As for SQL - I know nothing.
For sure you know more than you think. Everything we have been doing with CSV is to emulate the SQL data approach using tables, rows and columns (whether you realised that or not).
JonC wrote:All I was meaning was that the Verbot can read and write to a csv file somewhere.
Exactly. But what I realised was, that if an external programme was dealing with this connection, it could use SQL instead (or both). An SQL database, when the data is viewed looks just like Excel would dipslay a CSV file. But when beign manipulated, there is no need to be splitting strings, etc to get to one piece of data.
JonC wrote:The Verbot can read-write to a "csv-type" file, what I was suggesting was that we could use a console type program to "condition" the data for the Verbot from the data output of a third program.
The only Verbot commands to do external things are the Run command. Inherently this can run a number of programs on your PC (Notepad etc.) and we can now get an external program to "force" data into the Verbot (see http://www.verbots.com/forums/viewtopic.php?f=7&t=3202.
Thus in principle, if we can also supply the external program with data (equivalent of Verbot5.exe --input "blah blah") then the Verbot can interact with another program, both "forcing" it and being "forced" to, take note of the communication between the programs.
Thus (hypothetically), you could have the Verbot send a line to your console program saying (e.g.) "get me data on XXXX".
This goes to your "interface console" (resident on your website) which reads this data and then processes that info and makes the requisite web-page access requests to your SQL DB or whatever, gets the data back, conditions it for the Verbot and re-presents it in "csvtype" form, either outputting this to another web-page that the Verbot reads (we've already got that one working btw), or (and don't ask me how) forcing the Verbot to take note with the Verbot5.exe etc. command.
My reason for thinking this way is that it gets past the limitation of Verbot C# (we may not have access to all C# libraries) and even allows you to use a different language for the "interface" if you wish.
Right. That looks like it can work then. I've got the external programme receiving parameters put after the file name. All I need to do is get it to send back text to Verbot (which would be the data obtained).
One thing I should add. What I'm working on is a Windows app, not an online helper. So the idea is it would be a local program that perhaps is run directly from Verbot when data actions need to be done.
JonC wrote:Now, for Online Verbots, we would have the problem of "addressing" the server hosted program ... back to the problem above!
Might not be a problem if the local one works. What I've done so far is only looking at desktop Verbot player, not online. But if it works for desktop I try to make a web version to do the same thing.
JonC wrote:The difficult part, AFAIK is actually getting the Verbot to write to a Webpage - this is what has had me and Sylvain stumped for a while, but as I said, Bluespace may have got this to work now, but I haven't had time to check out his code yet.
Trust me, I'd be delighted if you could help out here, I'm just to busy to give it the time it needs right now!Feel free to take this one on.
What do you mean here? You mean the desktop player accessing a web page, or actually editing a web page?