Hello, I was not very present lately for the simple and good reason that I worked a lot on one compatible component only with RS! Forms pro.
This component is maybe more efficient than the mod-form-list and can display data with content of your choise into a private or public access (if you param them).

This component allows in back-end to define:

- The accesses to the users of your choice for every created contents.
- To define the options to see, to publish(edit), to delete(eliminate) results(profits)
- To bind(connect) several results(profits) RS! Form pro, between them (requires to conceive its form of a certain Way)
- To define the data visible for the sélectionés users previously
- to bind(connect) a table RS! Form Pro for display(posting) of the results(profits)
- to choose columns to post(show) in picture(board) of recapitulation
- to create with WYSWIG editor the contents of your choice to show the data you want
- to define the general information of the contents (published, title, description)
- to define a category for every created contents

This component allows in front end to define:
Level 1:
- Post(show) by category various created contents and published
- by clicking contents, of accèder at the level 2

Level 2:
- Post(show) (according to the parameter setting) a picture(board) of the wanted results(profits)
For every line of the picture(board), so activated:
- Option to see:
- display(visualization) of the results(profits) in a personalized document
- to print document
- pdf document

- Option to modify
- to edit the result selected for modifictation with the form RS! Forms Pro
and to protect
- Delete
- delete the selected result

The component is fonctionned very good on my localhost and with my data test. But i need more work on it to finalize them and need help of user to test and help me.

This message is for the RS!Joomla Team, I would be happy if you want help me to finalize the project with me.
it's make 3 weeks i work on it, and maybe it will take one more to verify them before testing them.

DOWNLOAD FILE AT DOWN AND INSTALL THEM AFTER UNISTALL OLD VERSION

The admin interface is a small complexe and i will try too explain it :
When you creat a new view display :

How to create a new categories ?
easy : write what you want into the input field

How to use an old categories ?
easy : select into the list and click onto \"valid my choice\"

What is the Field link ?
Exemple : you have 2 forms they result are this:Into the field link just insert the name of the field who link with another one
exemple : UserSubmissionId

Into the edit area for create content just insert
exemple : {UserSubmissionId:FullName:value}

The result of the display content from Forms 2 will be :
You have more one field too link ? easy, just seperate tour fieldname with a : | (without space)

How to create columns for create and array of value to select one ?
Just add columns title and colum name
With the result of the display content from Forms 2 we have define before :Will display this array :
How to create my own content ?
Esay, use the wyswig editor and just insert this code : {Nameoffield:value}. For have more easy you can add

into a drag and drop input the code.

How to create give access for specific user only ?
Choose the level of access (Everibody, Only register user, select list, Backend manager, Only administrator)

and if necessary, create your own list just select multiple user into the list of user.

How to made that user can see their own result or at over, see data from a specific user ?
Choose the level of access data (No one,Only their data, Select list, Their data and the select list, All data)

and if necessary, create your own list just select multiple guys.

You just want that an user see the data if the field have a special value ?
You can custom the request. exempleAdd a manual request : Yes
into input, just insert : AND jos_rsform_submission_values.FieldValue = 'Antoine'

The result will be :
Please RS!Forms Team, can you give your opinion on this component ? And can you help us to upgrade them. Thank.<br><br>Post edited by: dragonjc, at: 2008/08/06 17:09

I've been emailing Alex for the past couple of weeks on this very topic. They have plans to further develop this aspect of RSForm Pro. Thanks so much for taking the initiative to speed it along.

If you're looking for someone to beta test sign me up!

Thanks
Richiep

Hello dragonjc,

how can I test it?

Ok all i try make a package this day, and i will modify all after. I will give a link to a joomla the forge for download. Just wait a few hours ^^.

Soory for late, i have forgot the language package. I'm french ... And maybe you won't understand french. So i add a language file who you can customize.

If work permit I give you file this week end.<br><br>Post edited by: dragonjc, at: 2008/08/01 20:04

Bonjour dragonjc,

Comment le trouver ?,

Vu que vous parlez français j'en profite pour vous poser une question j'ai rsform pro et j'ai l'impression qu'il n'est pas compatible avec sh404SEF.

Quand j'utilise le mambo \" mosrsform\" dans un article la validation du formulaire ne fonctionne pas.
il me suffit de désactiver en passer RS forme dans l'option 'par composant \" de sh404SEF pour qu'il fonctionne mais l'URL Rewriting.

As tu une solution ?

merci de ton aide

Willy<br><br>Post edited by: meignen.willy, at: 2008/08/03 11:08

Hello,

Please try to write in english... so that more people who are facing this problem can read about the solution !

Thank you for your understanding!

REMOVE<br><br>Post edited by: dragonjc, at: 2008/08/06 17:09

FILE REPLACE SEE DOWN<br><br>Post edited by: dragonjc, at: 2008/08/05 21:06

thank you dragonjc for this file. It's a VERY good initiative.

I tried to install it but I have some errors:
1. Warning: current() [function.current]: Passed variable is not an array or object in .../www/prod/libraries/joomla/html/html/select.php on line 68
2. Warning: Invalid argument supplied for foreach() in .../www/prod/administrator/components/com_rsshowform/controller.php on line 125

Do you know how to resolve this problem ?
Fred

are you using joomla 1.5.5 and a rs form pro version ?
I have do 10 install before upload them ... and have no this error ...

the problem can be from define the table
I have try to use the #_ for jos so replace all #__rsform with jos_rsform (only for this function but for all tabvle from the request) and tell me if it fonctionned

pr the problem can came because you have no forms data So try to create one please.

UNINSTALL OLD FILE AND INSTAL NEW ONE<br><br>Post edited by: dragonjc, at: 2008/08/05 21:02

I am using joomla 1.5.4 and RSForm!Pro (updated)
Just a precision: This error is not during the install, but when I launch the component.

REMOVED<br><br>Post edited by: dragonjc, at: 2008/08/06 17:03

In fact my data in my database are prefixed by \"prod_\" and not \"jos_\".
I will try you solution, but can you tell me which file have to be modified ?

REMOVED<br><br>Post edited by: dragonjc, at: 2008/08/06 16:55

OK I will try it tomorrow and I will keep you inform.
Thanks for your help.
Fred

The new update is ok :
Correction :
- upgrade the language pack for admin list
- correct the bug who don't permit to see first row into drag and drop select list
- some bug of view int front end
- change all request to have possibility to use a database prefix different from 'jos'
- change procedure of field link => for display result linked, add now {name_of_one_field_link:name_of_the_field_to_display:value}<br><br>Post edited by: dragonjc, at: 2008/08/06 17:02

Hi dragonjc,
I just installed your new package, but I always have the same error:

Warning: current() [function.current]: Passed variable is not an array or object in .../www/prod/libraries/joomla/html/html/select.php on line 68

And:
Warning: Invalid argument supplied for foreach() in .../www/prod/administrator/components/com_rsshowform/controller.php on line 125

I send you my errors

Thanks for your contibution

I have test them in all computer i can and with all server i have download. I have not this error. I try to understand, but the explication for are this ones :

For the first it can apperaed then you have no categories cretead. SO it will be disapperead after first submission.

For two others errors, it's make a list from all field you have created with RS!Forms Pro. If you have no submission $data is null and foreach is invalid. SO question is have you some forms created and with field created and RS!forms pro installed with the same prefix table like other one ?<br><br>Post edited by: dragonjc, at: 2008/08/06 16:57

The new update is ok :
Last update :
- upgrade the language pack for admin list
- correct the bug who don't permit to see first row into drag and drop select list
- some bug of view int front end
- change all request to have possibility to use a database prefix different from 'jos'
- change procedure of field link => for display result linked, add now {name_of_one_field_link:name_of_the_field_to_display:value}
New update :
- add more test of security for empty and non empty variables who display some error of foreach when data are null
- add pathway on front end
- add print and pdf link on view content mod

UNINSTALL OLD VERSION AND INSTALL THE NEW PACKAGE<br><br>Post edited by: dragonjc, at: 2008/08/26 06:57

Are you working with Alex on this? Will this component officially be part of RSForm?

Thanks for your work.
Richiep

i have do all alone but i have send today a ticket to support to ask them help, it will be cool if it will became official.
i need some help for smal function. Like the upload files. It's the only component who can't fonctionned.
I work now on the send email when modify data and on option for user to have possibility to choose the order from data in array view.

have you test them ? what you think about it ?<br><br>Post edited by: dragonjc, at: 2008/08/06 22:26

Hello dragonjc,

a big compliment for this great work!!

I Installed the component and it works fine, but I cold not see
datas in frontend. In the detail view it works, but not in the list,
see attached file.

In backend it looks like this: {Belegnr:value}|{Liefertag:value} <br><br>Post edited by: juergen.urban, at: 2008/08/08 15:15

the file <br><br>Post edited by: juergen.urban, at: 2008/08/08 15:18

O Dear, I am so stupid, wrong syntax = wrong result.
All works fine!!!

But how can I realize to put the DateSubmitted in the list?<br><br>Post edited by: juergen.urban, at: 2008/08/08 16:08

2 possibility:laugh:
First the one i do for this time :
in my form i have add a hiden field with some script on process who display date of day.

Second :
Wait next update i will try to insert them in code as global variable

You can customize the display with the css file, just change value, color,... and you can display all fine. For editor, i Recommend the JCE Editor, it's work better than the standard joomla editor. And display is better on front, pdf and print, i find.

I have see that you have not the icon on front end, i will correct that. For next time.

Remember for next update :
- fix bug of icon
- fix globale variables like date submitted
- add script display and process field if i can ...

1 ask, should we update date of submitted when edit ? if yes i will add this too.<br><br>Post edited by: dragonjc, at: 2008/08/08 21:30

Next update is coming soon :
- it will correct a bug when use Internet Explorer (don(t submit the forms) I have found the reason, it's easy)
- will inculde global variable, like date of submitted

- i will try to add possibilty to user to order the field in array like they want
write here what you want more.

Hello dragonjc,

ordering will be great, do you think it is possible to integrate a search function in frontend?

i will try to insert search function too

The new update is ok :
Last update :
- upgrade the language pack for admin list
- correct the bug who don't permit to see first row into drag and drop select list
- some bug of view int front end
- change all request to have possibility to use a database prefix different from 'jos'
- change procedure of field link => for display result linked, add now {name_of_one_field_link:name_of_the_field_to_display:value}
- add more test of security for empty and non empty variables who display some error of foreach when data are null
- add pathway on front end
- add print and pdf link on view content mod

New update :
- add lot of CSS class to custom main and array a lot your front end private space
- add CSS class to param pdf and print link on display content
- add global variable into content like author informations, submission informations and user connected informations. exemple : {global:SubmittedDate:value} will display 2008-08-02 13:25:03 (date of submission)
- correct the IE bug who can't go next level after main before javascript search input id
already existing with search function.


UNINSTALL OLD VERSION AND INSTALL THE NEW PACKAGE WHO IS AT END OF THE POST

Post edited by: dragonjc, at: 2008/08/26 06:57<br><br>Post edited by: dragonjc, at: 2008/08/26 06:58

Hello dragonjc,

I have a problem with {global:SubmittedDate:value}, it don

There is no problem to do a search input. These quote problem at top, is something other. I have see that then you have the search input of joomla onto the page a same time my component, there is a bug, becaus there is an hiden input who have same id. So i have correct that only.
I will work for search into array for next version. In few days.

For SubmittedDate Arf sorry i have forget to add them into array, is only available into content, i will try to add it for tomorrow.

Thanks for your help.<br><br>Post edited by: dragonjc, at: 2008/08/14 06:57

hi dragonjc,

thanks for our effort to generate a component like this... !!

but i got a lproblem in handling your compo...

it

attached my screenshot

First : It's only for joomla 1.5 and rs form pro

ahoi,
thanks for your fast reply. but please tell me wich files u need...
all rsforms related tables in my mysql database or the install file which should come with rsformspro?
thanks, tom

export all table sql from rsform from your database and post them, i will try to insert them into my databse and see if it came from here.<br><br>Post edited by: dragonjc, at: 2008/08/14 15:01

ahh, i see... i

Here is the code who generate this droplist :Like you see, the function is very simply. It's like if their is no data in table : $data seems empty... are you sure your table is ok ? are you sure you have form ? are you sure works with a Pro version ? please copy here the sql from table yourprefix_rsform_forms.<br><br>Post edited by: dragonjc, at: 2008/08/14 16:15

thanks for your help !!
here is the sql file as .zip


i tried it tonight to resolve it but no chance !!
i re added the table into sql but no recent entry of existing forms will be added....

if you can find it out?

greetz, tom

I think i have found the reason why it isn't fonctionned.
You have not define a FormTitle to your form... (is blank on sql), the FormName is ok but the FormTitle is blank.

The list display the title of form and not the name of form. SO go to rsform manage form and give a title in generals informations. you will find it easly. I have not my pc, so i can test the solution only Monday, so if you can try.<br><br>Post edited by: dragonjc, at: 2008/08/16 09:30

but there is a formTitle in the sql called Problemformular_de.

i tried a second form even with the same bad result.
but it is written into the sql with the formname and formtilte...

i really get crazy on this !!

Yes there is a column FormTitle but is blank into the value. So give them a value and the problem will be disapperread, it's what i have do with your sql...
You have to give the name into rs forms management interface.

Hi dragonjc,

I have the same problem as Thomas.
I define a FormTitle to my form
I send you an export of my database.

Could you have a look a this issue ?
Thanks
Fred

Here is the file...

In zip format... (I am exhausted tonight )

Hello dragonjc,

please contact me - This e-mail address is being protected from spambots. You need JavaScript enabled to view it !

Ok nice we will make good work now ^^.

I have modifiy the source code to include search function and order.
The file is coming soon.
For this problem from RS!Forms list, i wil try something new, but all your sql base are fonctionned onto my localhost. Whitout any changement.

PS : Fred si tu as une adresse msn, contacte moi, plus facile je pense ^^.<br><br>Post edited by: dragonjc, at: 2008/08/20 20:43

dragonjc,

I am looking forward to trying your latest version.
Thanks for your reactivity.



PS in french: Tu peux me joindre par msn: This e-mail address is being protected from spambots. You need JavaScript enabled to view it . Par avance, merci.

With Fr

OK, I tried installing this and got the following to error messages. I tried through Joomla and RSForm.

* The file you selected is not valid.

* Error! Could not find an XML setup file in the package.

Are you working working with Alex on this? Or will this be a branch stand alone component?

Thanks
Richiep

Yes you have not laod the alst component but a file error ... So it can't functionned...

The component is only for rs form pro, and an update is coming soon to correct some bug, wait for them please it's came in fex days, maybe tommorow. I have work all the day on it
And yes i have ask Alex to help me.<br><br>Post edited by: dragonjc, at: 2008/08/25 20:43

The new update is ok :
Last update :
- upgrade the language pack for admin list
- correct the bug who don't permit to see first row into drag and drop select list
- some bug of view int front end
- change all request to have possibility to use a database prefix different from 'jos'
- change procedure of field link => for display result linked, add now {name_of_one_field_link:name_of_the_field_to_display:value}
- add more test of security for empty and non empty variables who display some error of foreach when data are null
- add pathway on front end
- add print and pdf link on view content mod
- add lot of CSS class to custom main and array a lot your front end private space
- add CSS class to param pdf and print link on display content
- add global variable into content like author informations, submission informations and user connected informations. exemple : {globalubmittedDate:value} will display 2008-08-02 13:25:03 (date of submission)
- correct the IE bug who can't go next level after main before javascript search input id
already existing with search function.

New update
- Correct the online (don't appeared on localhost) bug in admin who display some foreach error (because name of table should be write in Minus but RSform use table nam in MAJ)
- correct some bug of display with IE (grid and some list in admin)
- add the search functionnality (coose the column, and just write into the input file what you search)
- add the order functionnality (simply, just choose the column, and the order)
- add a small pagination system
- active the limit page in admin interface
- add more css option to customize better the display
- change system of creating the main array
- correct some bug into pathway display
- add languages files (English defaut and French) next update will synchronize it with admin user parameters

For add global variable into main array, just insert VarGlobal before :
exemple : VarGlobalDateSubmitted will display the date of submission.
Into VarGlobal You can display all column of #__rsform_submissions and all column from #__users

Hello dragonjc,

this looking great, but I can not see any data in frontend. I Ithink I have another Syntax mistake.

What means: Define the show data array : columns, columns title, edition, delete,... ? <br><br>Post edited by: juergen.urban, at: 2008/08/27 13:35

Hi Jurgen, it's very strange. I don't know why there is this problem.
Have you any data submit ?
Can you impr screen from all the paramters and send it to me ?
Have you msn ? if yes give me your adress i will help you, and have you the adress of the webdiste or is it in localhost ?

I just tryed to contact you over msn, in the attachement you can see the backend, more over msn!

We have found solution with J

That

Next update coming soon :
it will correct a bug who can't use parameters from show form more than 9 afor generate array
add functionnality for display some global information
add on title (numbers of row and nubers of new submission last 2 days)

Hi guys,
I have this component running to edit form results in the frontend for a number of forms. For some reason it won't save after editing the results - the table it's looking for: 'xxx.jos_rsform_submission_values' doesn't exist. And that's correct - the table in the database is all caps in the name. Changing the name in phpmyadmin works, however then the RSforms component doesn't find the table. Anyone have a quick fix?
thnx

First have you RS!Forms Pro, it's run only with pro version. For edit mod, i have add some functionnality, like script display, and script process, and mail too. I will search reason have you msn ? if it is give me your msn adress
Give me too your adress site if you don't work on localhost.
Else send me your msql database for all rsform tables.
Thanks.

Hi dragonjc, yes it's on RS!Forms Pro. I have MSN, I'll PM you the details. The site is on a test location at: www.meldingsformulier.nl , I'll PM you the codes to get in.

-- edit --

Ok, no PM on this site: my MSN is dennmans+at+yahoo.co.uk. Skype is dennmans, yahoo is dennmans

Dennis

Post edited by: dennmans, at: 2008/09/11 10:52<br><br>Post edited by: dennmans, at: 2008/09/11 10:52

ok, I solved it (not in a pretty way though!). What I did was to search for the rsform_submission_values line and replaced it for RSFORM_SUBMISSION_VALUE in all the component's files. I came across a bit of code that looked like it was supposed to be doing this in controller/adapter.php on line 42 so I left that. I'm not a whizz at this, if there's a nice solution I'm still interested.

Ok you replace the update in minus by MAj is it that, if it is, your right, that's the only one solution. It's came from the fact that RSJoomla have write all their table in MAJ, and on linux server ther is a difference between min and MAJ. On localhost all is ok. I have replace all other one as next update.

I have solved the problem with using an Joomla 1.5 API especially for update database.
It's functionned very good on localhost and on server host.
New functionnality for next update :
- Scriptdisplay
- Scriptprocess
- mail after update submission
- export table as CSV
- more functionnality to customize the display interface<br><br>Post edited by: dragonjc, at: 2008/09/11 20:23

Hi dragonjc,

I have just found this component and would like to take it in use.

I read that with this i can update the fields in a form and thats exactly what i need.
But also need sending of mail after update and notice you mention that this will be available in the
next update. So i would like to ask you when you approximate suppose that the next update will be available ?

I should have do it for last week, but my work take me lot of time. I try to do it for this week, or next one. I hope you are ok. But test the component before send them into a production site. All seem's ok but it can have, more, some bug.

Great! Looking forward to it!

Nice work

NEW UPDATE

Last update :
- upgrade the language pack for admin list
- correct the bug who don't permit to see first row into drag and drop select list
- some bug of view int front end
- change all request to have possibility to use a database prefix different from 'jos'
- change procedure of field link => for display result linked, add now {name_of_one_field_link:name_of_the_field_to_display:value}
- add more test of security for empty and non empty variables who display some error of foreach when data are null
- add pathway on front end
- add print and pdf link on view content mod
- add lot of CSS class to custom main and array a lot your front end private space
- add CSS class to param pdf and print link on display content
- add global variable into content like author informations, submission informations and user connected informations. exemple : {globalubmittedDate:value} will display 2008-08-02 13:25:03 (date of submission)
- correct the IE bug who can't go next level after main before javascript search input id
already existing with search function.
- Correct the online (don't appeared on localhost) bug in admin who display some foreach error (because name of table should be write in Minus but RSform use table nam in MAJ)
- correct some bug of display with IE (grid and some list in admin)
- add the search functionnality (coose the column, and just write into the input file what you search)
- add the order functionnality (simply, just choose the column, and the order)
- add a small pagination system
- active the limit page in admin interface
- add more css option to customize better the display
- change system of creating the main array
- correct some bug into pathway display
- add languages files (English defaut and French) next update will synchronize it with admin user parameters

New update
- change admin interface
- add export functionnality
- add and correct link between foms syustem
- add link to create new submission to RSForms Component formid
- add order and search functionnality
- correct a bug who don't save data after add some field into manage forms
- change syntax of global variable
- add possibility to cut DateSubmitted in hours and in date
- add scriptdisplay functionnality
- add scriptprocess functionnality
- add help on admin
- add more simple CSS function to customize display
- add width of row for array
- change defaut language for give admin to change text and insert icon for replace texte whith jst change this file.

UNINSTALL OLD VERSION, TABLE HAVE BEEN UPDATE TO <br><br>Post edited by: dragonjc, at: 2008/09/18 21:28

Hi dragonjc,

I have tried your new version, and it's very nice.
Thank you.
However I have seen an error in your installer:
In the rsshowform.xml you have to change \"\\" by \"/\"

For example, in your file: images\Corb.png have to be images/Corb.png
I made this change and now it's OK for the install.

An other detail for the next version, please rename in your package the file print.png to Print.png. My server is under UNIX and is not case sensitive.

You new interface is really more user friendly than before.

Fred

Salut dragonjc,
I've returned from holiday and thus to my work on the site I'm making. I noticed a possible bug: when I recall a form from the form list (using the 'edit' icon), it shows me all the information that was filled in except for what was filled in using a radio button or a checkbox.
How is your work coming along? Have you had time to work on this component more?

thanks in advance,

Dennis<br><br>Post edited by: dennmans, at: 2008/10/15 19:24

I seem to have found another bug:

When the 'show details' link is used, the result is returned as text, without html tags. So, if you try to display your results in a table, the contents show properly, but the table tags are removed.

Dennis

Ok first :
- if you read at bottom, the bug for Checkbox came from RS Forms Pro, not for my component.
They use /n for register their array data, but with some configuraytion of host, it doesn't functionned. And they don't know from where it's came.
So if you use my component. You click more on result checkbox and it will register it as nex register array who wan be use next time for edition. Correctly.

Second
I f you use the WYSWYG editor you will have no problem.
Give me a link. To see what's the problem or some screen please.

Have tou instal last version :
www.rsjoomla.com/index.php/RSform-How-To...rint-and-search.html

because this topic is too big i have created a new one for.<br><br>Post edited by: dragonjc, at: 2008/10/15 19:48

UP for new users. If you have problem, see here too if answer was not given before the new thread.
Thanks.

PS : This thread have the more Views score from forum section <br><br>Post edited by: dragonjc, at: 2008/10/22 21:46

Hi dragonjc,

You did a very, very good job. Thank

dragonjc,
Bravo pour ce \"component\", J'aurais besoin d'un peut d'aide, pouriez-vous m'envoyez un e-mail
via cette page wsc-ny.com/index.php/contact.html
Merci.
jp

Hello
I have similar project, and I download your component to test it.

Can I take contact with you ? how ? I dont find any mail in source code, but I dont read every single file ^^

And this forum dont have private messagerie...

I want to contact you, perhaps my job can add to your component and not only in my way.

Bye

niko

mail in case nk @@S@P@A@MM@ darkoline DOT com