I am struggling with a way to give our site manager a way to export the databases from Chronoforms as .csv files. When I try to display these databases using ChronoConnectivity, I get zero results in the Connections Manager. No databases are displayed.
On a similar note, when I use Menu Creator to create a shortcut to my database in Cronoforms, I get the message "Table Doesn't Exist" when selecting the new menu item.
It seems these two issues are related.
I can, however, choose the "Connected Table" in the Forms Manager and display my database.
I'm stuck at this point. I think that if I could get the Menu Creator working, I'd be okay. But I don't know where to begin.
For what it's worth, I cannot use Table Creator in ChronoForms either. I am on a MediaTemple DV server and I have read others have had a problem with that. I created my database manually. The database works, form data gets submitted, it's just the Menu Creator and ChronoConnectivity that doesn't work.
If you can shed any light on this, the help would be greatly appreciated.
Tim
On a similar note, when I use Menu Creator to create a shortcut to my database in Cronoforms, I get the message "Table Doesn't Exist" when selecting the new menu item.
It seems these two issues are related.
I can, however, choose the "Connected Table" in the Forms Manager and display my database.
I'm stuck at this point. I think that if I could get the Menu Creator working, I'd be okay. But I don't know where to begin.
For what it's worth, I cannot use Table Creator in ChronoForms either. I am on a MediaTemple DV server and I have read others have had a problem with that. I created my database manually. The database works, form data gets submitted, it's just the Menu Creator and ChronoConnectivity that doesn't work.
If you can shed any light on this, the help would be greatly appreciated.
Tim
Hi Tim,
To export as CSV files I would create a form that does just that. Have a drop down to select a table and then run some PHP to do the export - the code used in the ChronoForms admin covers most of what you need.
The table problesm sound really odd and I can only assume that there are some strange database rights set up by MediaTemple. I haven't checked the code but I'm as sure as I can be that the lists of database tables in ChronoForms and in ChronoConnectivity are practically identical and that both use the Joomla database interface. That makes it really hard to understand whay you would get one list displaying and not the other.
I suggest that you turn site Debug on temporarily; load the two pages and take copies of the debug reports - typically they are long lists of SQL queries. Search through these for the one's that are creating the table lists and then check those for differences and test them in PHPMyAdmin to see if there are any errors showing up.
Bob
PS Do check that there aren't any table names with spaces or dashes that have crept in, they might cause a problem.
To export as CSV files I would create a form that does just that. Have a drop down to select a table and then run some PHP to do the export - the code used in the ChronoForms admin covers most of what you need.
The table problesm sound really odd and I can only assume that there are some strange database rights set up by MediaTemple. I haven't checked the code but I'm as sure as I can be that the lists of database tables in ChronoForms and in ChronoConnectivity are practically identical and that both use the Joomla database interface. That makes it really hard to understand whay you would get one list displaying and not the other.
I suggest that you turn site Debug on temporarily; load the two pages and take copies of the debug reports - typically they are long lists of SQL queries. Search through these for the one's that are creating the table lists and then check those for differences and test them in PHPMyAdmin to see if there are any errors showing up.
Bob
PS Do check that there aren't any table names with spaces or dashes that have crept in, they might cause a problem.
Thank you for the reply, Bob. I have another question: Does ChronoConnectivity work only with the databases created by ChronoForms, or would it display all of my Joomla databases? I ask because I have a Joomla site on another host (not MediaTemple) and I test loaded ChronoConnectivity (without ChronoForms) to see if it would display databases there. It did not display anything.
"Have a drop down to select a table and then run some PHP to do the export" I'm afraid that you are presuming too much knowledge on my part. I am just dipping my toes into MySQL and PHP out of necessity. The programmer I work with doesn't like the idea of me using ChronoForms rather than having him custom-build a database component--so I've got no technical support on this issue. It's a shame because ChronoForms makes adding features very easy and will reduce our development and support cost.
Tim
"Have a drop down to select a table and then run some PHP to do the export" I'm afraid that you are presuming too much knowledge on my part. I am just dipping my toes into MySQL and PHP out of necessity. The programmer I work with doesn't like the idea of me using ChronoForms rather than having him custom-build a database component--so I've got no technical support on this issue. It's a shame because ChronoForms makes adding features very easy and will reduce our development and support cost.
Tim
Hi Tim,
ChronoConnectivity can normally see all of the tables in the current Joomla database (I've never known it not see all of them).
You can do CSV exports from the Admin area - is that not enough?
Bob
PS Sorry about the programmer.
ChronoConnectivity can normally see all of the tables in the current Joomla database (I've never known it not see all of them).
You can do CSV exports from the Admin area - is that not enough?
Bob
PS Sorry about the programmer.
I can do exports from the admin area. But unfortunately, the full-blown Chronoforms engine is too much to reveal to our clients who need to have something simple, where they cannot do any harm, and where they do not need to be trained.
At this point, the solution doesn't have to exist within Chronoforms. I just need to be able to display a MySQL table as a list, connected to a menu item, then have a way to perform a .csv export of that list.
The solution is out there, I'm sure--or maybe in here. It seems to me that this is what the chronoforms menu creator is supposed to do.
Tim
At this point, the solution doesn't have to exist within Chronoforms. I just need to be able to display a MySQL table as a list, connected to a menu item, then have a way to perform a .csv export of that list.
The solution is out there, I'm sure--or maybe in here. It seems to me that this is what the chronoforms menu creator is supposed to do.
Tim
This topic is locked and no more replies can be posted.
