Forums

After 90 days of trying with several people, we have failed to make a working complex ChronoForms query which works to read information from a MySQLi database. I can either make the 9 criteria search form without a ability to make the joins work to the between the 5 tables or I can get ChronoConnectivity to make all the joins work without having a search form at all.

We need someone who can make ChronoForms work & write the custom PHP code necessary.

Who can do this & at what cost?

Hi RLaurel,

Please post the project's info or a link to it if it was posted before, I can give you some hints of how to build tables joins in v5, this is so easy and will take no almost no time, but you will have to use v5 of course.

Regards,
Max

Pardon my ignorance!
I understand I need at least one of these. But which one?

Why would I need to install the ChronoEngine version 5 component?
Why would I need to install the ChonoEngine version 5 module?
Why would I need to install the ChonoEngine version 5 plugin?

We are migrating from Joomla! 1.5, (which works very well), to Joomla! 2.5 or Joomla! 3.x. We have been going through the agony of this conversion because we know we must!

I will be delighted to post the project specifics. I just need some assurance that this is not in a public forum or a private communication. It is not that there are any big secrets, it is just to access the search or administration of the website, is limited.

Thanks in advance,
Roger

Hi Roger,

That's a public forum, no info should be posted here, except general stuff.

I just need to know what you are trying to do with the tables joins, which tables are joined together and their names, I can then write a demo code for you, don't post any login details or links.

Regards,
Max

I have installed ChronoForms version 5 Component, Module & Plugin successfully.
I have enabled the ChronoForms version 5 Module & Plugin. I see the forms I have been working with in both CF & CC. As I said, I have been using both products in an attempts to get them to work with desired results.

I have never understood the difference between a component, module & plugin. The installation process, because it is an installation of 3 different code pieces, appears that I may not need all of them. But, I am too ignorant about it to understand.

No URLs, accounts or password/passphrases will be posted here.

I have this much working in CF, a 5 table join with a result set of the entire database. I am trying to write a search form with 9 input areas where a user may conduct a more targeted search. It is expected that a users may only put in 2 search criteria, but in as many as 9 inputs. But none returns the entire data set.

Perhaps I should PM you some of the failed efforts I have made.

I feel I am close because I get it work in limited ways. I seem to be missing some small feature.

What I am attempting is when invoked, I have a search form at the top half of the screen & a partial data output of a 3200+ row database in the lower half of the screen.

In one attempt in , I have ChronoConnectivity working with all joins. But there is no search form.
In another attempt, I have a ChronoForms produce a search form, but there is no data output what so ever, however the table column labels show. When I put in a value & search, the column titles disappear but still no data result.
In a third attempt, I have a ChronoForms produce a search form and data output, but the joins to the other 4 tables are not complete. Only the key values show. Again, I am unable to search any of the data. When I do input a search value & search then all data out put disappears from the screen. Yet I know the string to be there, for I witness it on screen before input it.
In the fourth has failed attempt I have an Access Denied problem. I think I was just mentally exhausted when this one failed & I had forgotten I was able to achieve in the other 3 attempts.

How can I deliver this so you can see?

I didn't say it above. The fourth attempt was a ChonoConnectivity attempt.

Hi Roger,

Apologies for the delay!

I suggest that you give it a try with the new v5, it should do what you need easily, if you have any questions then please send them to me, and if you can't get it to work then I can help you to get it done!

Regards,
Max

Of the 4 approaches I have tried above, which one has the most promise? I will try again in version 5, so I need to make the forms in that version or tweak the one which partially works.

Can Forms created in earlier versions be inported into this version?

You only need to search and list, so you will only use Connectivity, you will have to rebuild the connection because v5 is different, no need to uninstall v4, keep your work intact, v5 can work beside it.

The tutorials should make everything easy, but it doesn't explain how to make the search, this is explained in the connection settings area itself under the "searchable" box

Regards,
Max

1st. I like the new look of the CE fourms.
2nd. There is a broken link to the download for ChronoConnectivity on the home page. (404 error)
3rd. If it is thought that ChronoConnectivity holds the most promise for my issue, it is not available in version 5. CF is!
4th. I have installed CF Component ver. 5.0 RC4.1; Module V5 RC1.2 & Plugin ver. 5.0
5th. I have installed CC Component ver. 4.0 RC3.2
6th. If CC has the best chance, what should I do in CF v5?

I am confused!

Hi Roger,

Ofcourse cc has v5, here its:
http://www.chronoengine.com/downloads/chronoconnectivity.html

Please install it and check the ccv5 tutorials section under the FAQs page!

Regards,
Max

Thank you! I got CC version 5 & validated it.

1. The CE home page still has a broken link to CC download. (http://chronoengine.com/downloads/7-chronoconnectivity.html)
2. As the web page copy reads, if it were working, it would link to CC V4.0 RC3.2

I am hoping to backup my CC & CF forms made in V4.0, restore them individually to CC & CF V5.0 & remake the database connections.

I am hoping not to recreate each & every CC & CF form I have; just 'massage' them a little.

Am I thinking clearly?

Apparently not!

The back made of one CC form went to the downloads area specified by my browser.

The restoration from that download, produced a "Restore error" in CC V5.0.

Looks like I must recreate all the CC forms. I wonder if this process will work for CF forms?

Hi RLaurel,

Please use the DownLoads page to get the latest versions (I suspect that the Homepage link may have been broken when the site was upgraded to Joomla! 3).

I know that the Back-up + Restore route between CFv4 and CFv5 is experimental and doesn't work for all forms; I didn't know that there was any similar path for CC.

Bob

Hi,

For a list and search, you only need CC, no need for forms, you can also keep v4 and just install v5 with it to experiment, both can be installed on the same system at the same time, the tutorials should help you build a list using v5 quickly, after that you can post any questions here.

Regards,
Max

OK, I have a new member query form in CCv5. When I have more than one model, (there are 5 table joins I will need), I have a blank white page output. (Debug is set to "Yes")

When I have a CCv5 member query form with one model, I have an output on the screen of the column headings I will want & a SELECT statement with many AS assemblages where the model & column names have been combined. I realize this is where I am building my WHERE statements & for a single model, this WILL NOT work, but at least I have a screen output.

My Joomla! Database is running the InnoDB engine.

I have looked over the tutorials for CCv5 which are 4 in number, but they are all dealing with a single model. I want to use SQL LEFT JOINS to assemble all the information. There are 3300 rows in my biggest table with all of my members. The other tables are less than 50 rows in number & contain status, field of work, industry & committee membership. They are all recorded as foreign keys in the member table. They other tables provide human description to the codes in the member tables.

I had the list function working in CCv4, so there is something about making the JOINS work in CCv5. In CCv4 there was a JOIN rule. In CCv5 it appears similar to a high degree, but the blank page output has me wondering what it is about multiple models that produces a blank page output on Front View, View Connection.

BTW:
The Admin View, View Connection of the multiple model CCv5 Connection also produces a completely white page.

The Admin View, View Connection of the single model CCv5 Connection at produces the column titles.

OK, I have a part of a database listing working. As long as a single table is used, I get all the output of that table I need.

Adding the second model is when it breaks. I will ultimately need to add 4 additional models to make the LEFT JOINS in the 4 other tables.

I have looked at the CCv5 tutorials in the FAQ's but that only addresses a single table with no JOINS.

I can make it work in CCv4, so I can't be far off. I am trying to follow the notes I read below the input boxes for style & syntax, but I am getting nothing when I attempt anything more than reading a single table.

Ideas? Instructions? Examples?

Hi Roger,

Please post a screenshot for the first model config and the 2nd one's config, you just need to set the relation type to "hasOne" in most cases and configure the foreign key.

Regards,
Max

I don't see how a screenshot can be posted to this forum.

All subordinate models are set to "hasOne".

Model 1
Model Title: Members
Table Name: eu_members
Conditions: UPPER(STATUS)!='D' ("D" indicates deceased or deleted members)
Fields: first_name,last_name,home_phone,mobile_phone,email_address,industry_id,jobclass_id,status,committee,active_date
order: last_name,first_name
Group: (blank)

Model 2
Model Title: Industry
Table Name: eu_industries
Relationship: hasOne
Associated Model: Members
Associated Save: No
Associated Delete: No
Foriegn Key: Members.industry_id
Conditions: (blank)
Join Conditions: (blank)
Join type: LEFT
Fields: industry_id,industry_name
Order: (blank)
Group: (blank)
Primary Key: industry_id

Model 3
Model Title: jobclass
Table Name: eu_jobclass
Relationship: hasOne
Associated Model: Members
Associated Save: No
Associated Delete: No
Foriegn Key: Members.jobclass_id
Conditions: (blank)
Join Conditions: (blank)
Join type: LEFT
Fields: jobclass_id,jobclass_name
Order: (blank)
Group: (blank)
Primary Key: jobclass_id

Model 3
Model Title: Status
Table Name: eu_member_statuses
Relationship: hasOne
Associated Model: Members
Associated Save: No
Associated Delete: No
Foriegn Key: Members.status
Conditions: (blank)
Join Conditions: (blank)
Join type: LEFT
Fields: member_status,member_status_desc
Order: (blank)
Group: (blank)
Primary Key: member_status

Model 4
Model Title: Committee
Table Name: Committee
Relationship: hasOne
Associated Model: Members
Associated Save: No
Associated Delete: No
Foriegn Key: Members.committee
Conditions: (blank)
Join Conditions: (blank)
Join type: LEFT
Fields: committee.committee_name
Order: (blank)
Group: (blank)
Primary Key: committee


Ideas? Instructions? Examples?

Hi RLaurel,

You can upload/attach an image using the 'Choose File' button immediately under the Editor window.

Bob

Thanks Bob. I had been using the Quick Reply where pasting a screen shot or including a file is not possible. I it would help if they would mention what file extensions are allowed! :?

Here is my screen shots!
[attachment=0]model1.JPG[/attachment]
[attachment=1]model2upperhalfscreen.JPG[/attachment]
[attachment=2]model2lowerrhalfscreen.JPG[/attachment]

Ok, its really hard to debug the problem with all these models active, please take a copy of the connection and keep 2 models only, the main one and another one.

Also please remove any extras, like the order, fields and also the conditions, any of those may have problems which may affect the result of the joined select statement.

Then run a test, if the list is still not working then please enable the debug option under the list tab and add here the debug data shown under the list.

Regards,
Max

Thanks Max,
I have trimmed it down to one 2 models. The output should have only 2 columns, a member's first name & a status description taken from a join to a 2nd table. The join is made from a foreign key (representing a member's status), in the first table, to second table where the code is matched to a description of that status code.

This is the output I get with the debugger set to "Yes".

Thank you for taking a look!

[attachment=0]Modelwith1joindebugcode.JPG[/attachment]

Good, but what do you have the foreign key field or the join rule ? because its broken! please post 2 screenshots, 1 for the main model config, and another for the 2nd model config!

Regards,
Max

[attachment=0]model1.JPG[/attachment]
[attachment=1]model2upperhalfscreen.JPG[/attachment]
[attachment=2]model2lowerrhalfscreen.JPG[/attachment]
[attachment=3]CCdebugoutput.JPG[/attachment]

Ok, first, if you re going to add specific fields then you must add the primary keys because they are usually used in some operations.

2nd, since the first model "hasOne" 2nd model, then the foreign key should be a field in the 2nd model, without model id, if you want the relation to be based on some field in 1st model instead then please use "belongsTo" relation type, but also don't add the model id in the foreign key string.

Regards,
Max

Ok, I removed the model identifier from the foreign key field in the second model. I changed the relation in the second model to "belongsTo". It helped but it is still not producing a JOIN.

I now produce a list of first names from the table listed in Model 1 but there is no output from the join I am attempting to the status description of their member status in the Model 2.

Just for a test, I added an output field to the screen to see if I am getting the status code for a member from the members table (Model 1). I am getting information from Model 1 which I want to make the JOIN to another column in the data table in Model 2.

Need I input something in the Conditions or Join Conditions dialog?

Do you have any examples of dialog inputs of 2 models with a data JOIN?

Please copy and paste the new debugger data here so I can check how it works now ?

Here it is. The names list in the first model but the status description of membership is a blank column.

[attachment=0]CCv5 debug output.JPG[/attachment]

Sorry for the delay!

Does the field you need exist in the select query ? if not then please add it to the "fields" box, or simply clear that box so that all fields are loaded!

Regards,
Max

Clearing complete entry from the Field box in Model 1 got it to work.

I did not want the entire table to load, just the fields that were necessary. I guess the caption below the Fields box is deceiving. Now I need to get 3 other joins to work.

Then it is off to the search form, to permit operator criteria input to reduce the result set.

Hi Roger,

You can add the fields again but please make sure that any primary keys are added, also any fields used in the JOIN, and of course the fields you need!

Regards,
Max