Can I use Chrono for this (Add/edit/del - existing DB)

I've already used ChronoForms and Connectivity for another site and paid for licenses for both. The site worked well. It was essentially add/edit/delete and view of some client data.

I would like to use these tools for a second site with similar requirements but from my previous use I have a feeling I can't because:

1) The data I want to access is *NOT* in the Joomla databases, and cannot be moved there. It spans 5 databases and 100's of tables - I don't believe ChronoConnectivity can access tables not in the Joomla DB, not sure about Forms, I couldn't see how to select another DB in it either

2) I would rather not add new fields to these tables. They already have primary keys, and all the last updated and record status fields they need. ChronoForms added a lot of cf_id and ipaddress stuff that either duplicates (similar fields) or isn't needed. I put up with it for the new site, but don't think I can make these sort of changes to existing tables used by a large number of scripts and programs already

Are these statements true? Any way around them if they are? Or any other alternatives?

Hi Fashtas,

ChronoForms can access and read/write from any MySQL database that it can access. It doesn't have to be the Joomla! database, or the same DB server.

The 'extra' columns that ChronoForms adds are optional - the only requirement is that the table has an integer primary key (this is so that the Joomla! DB classes can be used to updates records).

Bob

Ok thank you for your reply! So it is only ChornoConectivity that doesn't support non-Joomla databases?

Sort of kills the view part :/ Their requirements are fairly complex here, including a table list screen with sub-table detail lists per item.
I noticed the front page with details on ChronoConectivity it mentions "Connect to any table in the Joomla Database (and soon to other databases too)."

I don't suppose we have any ideas when "soon" is?

Hi Fashtas,

I don't know what plans Max has fro ChronoConnectivity. Some of the functionality is included in ChronoForms v4 - that will connect to remote databases. Alternatively it wouldn't be too difficult to hack ChronoConnectivity to do the same. There are already hacked versions here that will support complex queries.

Bob