Advanced Search

Search by Keyword
Search by User Name
   

Search Options

Find Posts from
Sort Results by
Jump to Result Number
Search in Categories

Search Results

Searched for: import data
14 Oct 2008 15:31

octavian
Re:Gateway: collect and send data to third website
Hello,

I'm glad to be of service. However, customer feedback is more important for us than a donation. Please check your email (dr.rahul@) for more details. Have a good day!
Category: RSForm!
26 Sep 2008 23:28

rayge
Re:Rsform Pro is DEAD SLOW!
Ok so HERES the deal. If anyone else has this issue about the admin list displaying slooowww.

I checked the table related to the submissions and... They are MISSING indexes!
IN phpmyadmin:

view structure of
jos_RSFORM_SUBMISSIONS
and add an index to FormId (not unique and NOT primary)
THEN

view structure of
jos_RSFORM_SUBMISSION_VALUES
and add an index to SubmissionId (not unique and NOT primary)
If you already have a lot of data it may take a while for it to do the indexing. I was...
Category: RSForm!
05 Sep 2008 16:51

haboyes
Re:How to record created date to database ?
You could try:
//<code>
jimport('joomla.utilities.date');
$jnow=new JDate();
$now=$jnow->toMySQL;
return $now;
//</code>

I have used this code as part of a 'checkout script' where I am using RSForm!Pro to prepare an update to an existing record. This code certainly works on the Script tab for RSForm!Pro. It the above script is used to create the Default value for a hidden field called \"created\" you could then map this to the relevant database field.
Category: RSForm!
28 Jul 2008 09:14

juergen.urban
User can use the form only 5 times a day - Script?
Have anybody an idea to make a restriction of 5 times a day access to the form. That means he can only send 5 times a day the form.
And on the next day he can send 5 times again.

dragonjc idea was: a hidden field with value:

<code>
$user = $RSadapter->user();
jimport('joomla.utilities.date');
$now = new JDate():
$db =& Jfactory::getDB0();
$db->setQuery(\"SELECT * FROM #__rsform_submissions WHERE DateSubmitted = '$now' AND UserId = '$user'\");
$data =...
Category: RSForm!
17 Jul 2008 06:52

dragonjc
Re:User can use the form only 5 times a day - Scri
Ok can you see in mysql database what's the value is for into the hide field ?
Just to know if the counter is write into ...

Another test : change the end please.
//<code>
$user = $RSadapter->user();
jimport('joomla.utilities.date');
$now = new JDate():
 
$db =& Jfactory::getDB0();
$db->setQuery(\"SELECT * FROM #__rsform_submissions WHERE DateSubmitted = '$now' AND UserId = '$user['id']'\"«»);
$data = $db->loadObjectList();
 
$numer = count($data);
if...
...
Category: RSForm!
16 Jul 2008 19:07

dragonjc
Re:User can use the form only 5 times a day - Scri
I have an other idea, but i don't know if it fonctionned , you are my tester :woohoo:
//<code>
$user = $RSadapter->user();
jimport('joomla.utilities.date');
$now = new JDate():
$db =& Jfactory::getDB0();
$db->setQuery(\"SELECT * FROM #__rsform_submissions WHERE DateSubmitted = '$now' AND UserId = '$user['id']'\"«»);
$data = $db->loadObjectList();
$numer = count($data);
if (count == 5) $This->setRedirect('index.php?option=' ....

It can fonctionned whithout...
Category: RSForm!
15 Jul 2008 13:39

dragonjc
Re:User can use the form only 5 times a day - Scri
You have wrong

First you have create your hide field : nice

Second you have to pre filled them into defaut value with
<code>
$user = $RSadapter->user();
jimport('joomla.utilities.date');
$now = new JDate():
$db =& Jfactory::getDB0();
$db->setQuery(\"SELECT * FROM #__rsform_submissions WHERE DateSubmitted = '$now' AND UserId = '$user['id']'\"«»);
$data = $db->loadObjectList();
$numer = count($data);
return $numer;
//</code>

Third you add into your...
Category: RSForm!
06 Jul 2008 02:14

dragonjc
Re:remembering and filling fields after logging i
craiz wrote:
Hi
the way we see it is that
1. user logs in
2. fills out the form and sends it
3. lets say that after a week he logs in again then he should see the form already filled out same way as he did a week ago
so he doesn't have to fill it again only change some fields if necessary

Ok it's what i understand and the solution is easy, i will write the answer here. Just wait. 1 day ^^. More 1 question, and important. Is it RS!Forms Pro ? because i can give you the answer only for them ......
Category: RSForm!
06 Jul 2008 00:35

adrian_m
Better than CSV: Really Cool HTML exports
Better than CSV: Really Cool HTML exports

In this thread I suggest a method of getting csv files to your PC from RS Forms on the web, using Eudora and Excel Macros. Well all that works BUT not if you want to use non-English characters. That's nearly everyone.

The problem is that plain text e-mails (and data exported in a .csv file from a MYSQL) database encode characters for languages such as Greek and Russian. Web pages display them all but it is a fact that when you import a CSV into...
Category: RSForm!
05 Jul 2008 18:21

adrian_m
Really cool CSV exports!
This works on RSForm Pro.

I needed a really cool .csv export, and I found the Joomla back-end one was not as slick as I wanted.

I have copies of the same form in different languages, so to get the data in spreadsheet format I had to go into Joomla Admin, find each form and export it manually.. too much hassle. I want an admin clerk to collect this data, not a Joomla expert!

So here is how to get just the data you need into an excel spreadsheet with FIVE clicks!

1. Format your administrator...
Category: RSForm!
03 Jul 2008 16:28

dragonjc
Re:Optional email?
Seperate them from the database is not the solution.

Maybe you should do this :
You operator who answer to phone, have just to write the admin adresse, or an adresse realesed for this service.

It's only advantage for you ...

- The operator, have a mail he can print and send on paper to your client, if it is necessary, if it is no, i erase the mail and we don't speak about that ^^.
- Your linke to the database is ok, and you can export your value with excel, for workk with them later.
- And...
Category: RSForm!
19 Jun 2008 20:04

marcel.hartwig
submission overview -> to wide
Hello,

the submission overview is to wide if many fields are in the form. The result ist, that i have to scroll horizontal in my Browser. Is it possible to show only the important data in the overview (such as submission number, submission date, edit, remove). And the place a \"view\"-button in the overview. If this button is clicked a new Page is opened with the submitted values. The values are listet vertically instead of horizontally then.

kind regards

Marcel Hartwig
Category: RSForm!
06 Jun 2008 11:00

dabat
Want to access the database
Hi

I have an ongoing survey for one of my customers. RSForm is really working out fine but instead of exporting the data and import in Excel I want to list the answers online through SQL. So- where are the data stored? What jos_ ?

/Daniel
Category: RSForm!
01 May 2008 13:35

dragonjc
[HELP] Create a module based on mod_forme_list
Hello everybody,

I'm french and don't speak very well english, so excuse me if you don't understant what i mean.

Usually I don't ask people, search alone and do it myself help but this time i have no choice. I managed a french first aid men association and we have to do a website with forms to do Administrative document and management of them (their is too much work and we do more paper than action, so with the website we hope have more easy to do the job).
And we have no money to buy a...
Category: RSForm!
07 Mar 2008 00:54

richiep
Re:Ability to edit entries from backend
It's very importent to improve the back-end and displaying features

One quick improvement would be to move the data select drop down on the view data main page to the left side.

The first form I created had 60 fields, when I go to the view data page it defaults to this form. If I want to look at another forms data I have to scroll 60 fields to the right.

More broadly it would be nice to have more control how the data is displays in the admin section.

Still very happy with the overall performance of RSform. Well worth the $10!
Category: RSForm!
Displaying 151 - 165 out of 171 results.