How I can make it display a page with filters and exports?

hilas 20 Sep, 2011
hello all, sorry for my English, I'm from chile, but hey I need help in NEXT ..

as I can make a site that look for filters for example (from "X" date to "X" date / store name / code / team etc. ..) you can search for bone THROUGH a filter criteria (as in excel ) and once I show the list of what I want, I can export it to excel. please help!
GreyHead 21 Sep, 2011
Hi Hilas,

You can do this with ChronoConnectivity (on Joomla! 1.5 and ChronoForms v3) or with the DB Multi Record Loader action in ChronoForms v4 (there is a tutorial here on using the action).

Bob
hilas 21 Sep, 2011

Hi Hilas,


hi
You can do this with ChronoConnectivity (on Joomla! 1.5 and ChronoForms v3) or with the DB Multi Record Loader action in ChronoForms v4 (there is a tutorial here on using the action).

Bob




its work with Joomla 1.7 ? becouse im install the component but dont work
GreyHead 21 Sep, 2011
Hi Hilas,

ChronoConnectivity only works with Joomla! 1.5

Bob
hilas 21 Sep, 2011
hou God ..😟 i have to make a site complete again😟
hilas 21 Sep, 2011
between trying and trying to look I think I'm getting (I do not program well but something I'm trying.) but hey my question is .. NEXT

through filters to remove the mysql data, with the possibility to enter from that date until date need to show me the data did what NEXT ..

create another form in which events in the form put (in onload) I put "Show HTML" and put under the "Multi Record DB Loader" (to think I'm right here?) the matter in the configuration of Record Multi Loader DB need to put the "id" of what I get (right?) therefore I have to put the "DB Field" .. This .. I put? and as I do? I need help!
GreyHead 22 Sep, 2011
Hi Hilas,

Please get the Tutorial for the DB Multi-Record Loader - it's either on the Tutorials tab above or in the Downloads area. It has much more detail than I can type here.

Bob
hilas 22 Sep, 2011
yeah i get it but i dont undertand plz can u help me via chat ? plz ?
hilas 22 Sep, 2011
plzzz help mee !!😟 my boss its angry with me this its my only wayy !!😟
GreyHead 22 Sep, 2011
Hi Hilas,

Sorry about your boss . . .

If you ask a simple question I'll try to answer. I can't write your code for you or teach you to program.

I read your last post here with NEXT in it twice and I have no idea what the question is :-(

Bob
hilas 22 Sep, 2011

Hi Hilas,

Sorry about your boss . . .

If you ask a simple question I'll try to answer. I can't write your code for you or teach you to program.

I read your last post here with NEXT in it twice and I have no idea what the question is :-(

Bob




hi Bob !

yes yes .. obviously I'll explain .. look ..

I have (and already in use) a forum that is stored in the database is NEXT

field 1 (date) (the person Can input a date with "datetime box")

Field2 (name) its a simple text box

Field 3 (Choose) to select box with 2 option ..

now this is working and to press "submit" is stored in the db


now what do .. neceisto is another form but you can search for this information .. for example ..

I look for data: from the date September 2, 2011 until September 31, 2011, it shows all fields saved from the September 2, 2011 until September 31, 2011 and have the option to export (csv mode) the filtered

I need to now please help! if you need any information or can teach me how.
GreyHead 22 Sep, 2011
Hi Hilas,

Create a form with two date fields for the Start and End dates. Make sure that the date formats match the format you have used in your database table.

Use the DB Multi Record Loader and build the MySQL WHERE clause in the WHERE box to filter the dates you need.

The CSV export is a similar - you can use the CSV Export action on my site to build it.

Bob
hilas 22 Sep, 2011
Ok bob here it is ..

i do this ok ..

-- create the 2 dates box .. (ok)
-- install the action of export csv (ok, installed)

-- "Use the DB Multi Record Loader and build the MySQL WHERE clause in the WHERE box to filter the dates you need. "
ok, this part I have the problem, I need to make the form automatically do that part, I mean that from the page the user can set the start date and end date to search and press "submit" throw the csv to export , meustre obiamente the csv will be depending on the criteria that the user put in the dates .. from "x" date to "x" date



PD: i can send you a few wines from chile =D .. we have the best wine of the world =D really i can =D
GreyHead 22 Sep, 2011
Hi Hilas,

What are the names of the columns in the database table where you are saving the data?

What are the names of the date inputs in your new form?

Bob
hilas 23 Sep, 2011
The name of the Table is: qgl1c_chronoforms_data_gastosportienda
The name of the columns od datatime (in db): input_datatime_0

need something more ? i can give you all you need
GreyHead 23 Sep, 2011
Hi hilas,

What are the names of the date inputs in your new form?



Bob
hilas 23 Sep, 2011
you mean the "search date input" ? its this ..

Date 1 (from): dateone
Date 2 (to): datetwo

thats its the "field name" right ?
hilas 23 Sep, 2011
Its good ?
hilas 26 Sep, 2011
Bob ?
This topic is locked and no more replies can be posted.