Hi Max and Bob and why the hell not, everyone else🙂
Alrighty, 3 quick and direct questions if you'd be so kind to read:
- You set up a database, you set up a menu item, the end result is a table with records.
Question: How can you tweak what you see there? Meaning, it would be nice, dare I say Imperative, to have a table with a couple of columns of your choosing, say name and id from the user. I'm trying to make a subscriptions form and afterwards I just get a table with a long column of "records", I don't know what is what in there and so it is very hard to manage.
- After browsing the forums I found that this question was left hanging so I'll ask it again to see if there are any new developments. Any news on getting some sort of upload bar working when the user has huge files to upload? My form will receive 6 different files and each can go up to 2mbytes. It's a lost cause If I can't find a way to tell the user that it is uploading properly for it will take 5-10m with slow cons for it to go. Is there some low jack way of doing this, just showing some % number somewhere? What would one have to hack? (I believe this feature would have people flocking to chronos more than anything else)
- Attachments are receiving a timestamp to prevent same name files to mess with eachother. I ask if there is an option somewhere so that you can add a field of your choosing (more than one even) to the name. The point being that I'm trying to make a form that will ask for a document, let's say a drivers license. Everyone uploads a file named license.jpg, it gets timestamped and I get an entire directory with license.jpg files and have no idea to whom they belong. Can it be done? If not, would it be something worth adding to chronos?
I apologize if the post went a bit long, I jus wanted to make sure you understood me.
Thank you for reading and thanks again for this great component.
Mori
Alrighty, 3 quick and direct questions if you'd be so kind to read:
- You set up a database, you set up a menu item, the end result is a table with records.
Question: How can you tweak what you see there? Meaning, it would be nice, dare I say Imperative, to have a table with a couple of columns of your choosing, say name and id from the user. I'm trying to make a subscriptions form and afterwards I just get a table with a long column of "records", I don't know what is what in there and so it is very hard to manage.
- After browsing the forums I found that this question was left hanging so I'll ask it again to see if there are any new developments. Any news on getting some sort of upload bar working when the user has huge files to upload? My form will receive 6 different files and each can go up to 2mbytes. It's a lost cause If I can't find a way to tell the user that it is uploading properly for it will take 5-10m with slow cons for it to go. Is there some low jack way of doing this, just showing some % number somewhere? What would one have to hack? (I believe this feature would have people flocking to chronos more than anything else)
- Attachments are receiving a timestamp to prevent same name files to mess with eachother. I ask if there is an option somewhere so that you can add a field of your choosing (more than one even) to the name. The point being that I'm trying to make a form that will ask for a document, let's say a drivers license. Everyone uploads a file named license.jpg, it gets timestamped and I get an entire directory with license.jpg files and have no idea to whom they belong. Can it be done? If not, would it be something worth adding to chronos?
I apologize if the post went a bit long, I jus wanted to make sure you understood me.
Thank you for reading and thanks again for this great component.
Mori
Hi Mori,
Q1: You are right, ChronoForms doesn't have a very rich data viewer, it's not a part of the core functionality. Most people seem to use their forms to add to exisiting tables or do not record data at all. So it's probably OK as it is.
You do have some control from the DataViewer tab, that will let you specify columns for the viewers so you could show id and username if you like assuming that those are both columns in the table.
If you want something more sophisticated then there are three ways to go:
a) Use a database admin tool. EasySQL is a free Joomla extension that puts a simple MySQL tool in the Site Admin. You can use this to look at, edit and amend database tables. You do have to know what you are doing and it does have some shortcomings - but it is extremely useful. PhpMyAdmin or the MySQL Query Qrowser are two other stand-alone tools that also let you work with tables. I prefer the Query Browser which is a very nice tool but does require remote access to the database ahich not all ISPs allow.
b) Use ChronoConnectivity. This is ChronoForms sister extension designed for working with database tables. You have to hand-code most of the content but this isn't difficult and can be very effective. There's a snapshot below of a CC form that I'm working on now. The Filter box selects records, the Vue link shows the full record in a Smoothbox and the Edit link lets you edit the record.
c) Build an application. If your key aim is to work with the data then you can use the Joomla building blocks to build a little extension to let you work with and manage your data. Setting up a typical Joomla Admin table with sortable columns, filters and edit & delete icons isn't trivial but it's not that difficult either.
Q2: The Upload bar: I don't know. As far as I recall this was a problem with Mootools 1.1 and Flash 9 (or 10??) not particularly a ChronoForms issue. There have been a couple of workarounds posted here though.
Q3: Yes you can change this. There is Emmanuel's Image Management plugin which does this (but only manages one file per form) and there was a thread a couple of months ago where we talked at length about adding user names to image files and relocating them to other folders. See if you can hunt that down.
Bob
Q1: You are right, ChronoForms doesn't have a very rich data viewer, it's not a part of the core functionality. Most people seem to use their forms to add to exisiting tables or do not record data at all. So it's probably OK as it is.
You do have some control from the DataViewer tab, that will let you specify columns for the viewers so you could show id and username if you like assuming that those are both columns in the table.
If you want something more sophisticated then there are three ways to go:
a) Use a database admin tool. EasySQL is a free Joomla extension that puts a simple MySQL tool in the Site Admin. You can use this to look at, edit and amend database tables. You do have to know what you are doing and it does have some shortcomings - but it is extremely useful. PhpMyAdmin or the MySQL Query Qrowser are two other stand-alone tools that also let you work with tables. I prefer the Query Browser which is a very nice tool but does require remote access to the database ahich not all ISPs allow.
b) Use ChronoConnectivity. This is ChronoForms sister extension designed for working with database tables. You have to hand-code most of the content but this isn't difficult and can be very effective. There's a snapshot below of a CC form that I'm working on now. The Filter box selects records, the Vue link shows the full record in a Smoothbox and the Edit link lets you edit the record.
c) Build an application. If your key aim is to work with the data then you can use the Joomla building blocks to build a little extension to let you work with and manage your data. Setting up a typical Joomla Admin table with sortable columns, filters and edit & delete icons isn't trivial but it's not that difficult either.
Q2: The Upload bar: I don't know. As far as I recall this was a problem with Mootools 1.1 and Flash 9 (or 10??) not particularly a ChronoForms issue. There have been a couple of workarounds posted here though.
Q3: Yes you can change this. There is Emmanuel's Image Management plugin which does this (but only manages one file per form) and there was a thread a couple of months ago where we talked at length about adding user names to image files and relocating them to other folders. See if you can hunt that down.
Bob
Hi Mori,
Q1, you can use the Dataview fields to customize this by adding extra fields in the list page!
Cheers,
Max
Q1, you can use the Dataview fields to customize this by adding extra fields in the list page!
Cheers,
Max
I flatly refuse to be helped on a sunday. Go spend time with your loved ones instead you workaholics! =)
I on the other hand don't recognize days of the week, every day is the same, so off I go to do some extra browsing and to test your suggestions, will report back.
Thank you again good people.
Mori
I on the other hand don't recognize days of the week, every day is the same, so off I go to do some extra browsing and to test your suggestions, will report back.
Thank you again good people.
Mori
This topic is locked and no more replies can be posted.
