Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

pendragon-forms · Pendragon Forms

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 1074
  • Category: Databases
  • Founded: Jan 20, 1999
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

Advanced
Messages Help
Messages 2941 - 2971 of 3033   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Show Message Summaries Sort by Date ^  
#2941 From: Dave Hockman-Wert <dhwert@...>
Date: Thu Oct 27, 2011 8:52 pm
Subject: Re: Information Missing
dhwert
Send Email Send Email
 
Hello,

It is normal for the data to no longer be on the PDA once you have hotsynced
with the desktop PC.  The syncing process downloads the data from the PDA to
the PC.  However, you can change the settings for a form (within Form
Properties -> Data Persistence) so that the data remain on the PDA after
syncing, either indefinitely or for a specified number of days.


Sorry for the slow response, I was out all last week.

Dave




>________________________________
>From: Poloko Owen Rabai <rabaip@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Monday, October 17, 2011 6:14 AM
>Subject: [pendragon-forms] Information Missing
>
>
> 
>Hi All,
>
>I have developed a questionnaire in pendragon forms 5.1. Im Using
>Tungsten E2, The problem is after capturing data to the PDA, when i
>hotsync, i will find some of the data missing. I dont know what could
>be the cause or whether it is my PDA or what.
>
>Please Assist
>
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>
>
>

[Non-text portions of this message have been removed]

#2942 From: David Razorsek <davidrazorsek@...>
Date: Mon Oct 17, 2011 2:44 pm
Subject: Re: Information Missing
drazorsek
Send Email Send Email
 
To help we're going to need more information than "some data missing".  Is it
complete records, specific fields, are you using subforms, are the forms matched
to an external database, etc.

--Dave

#2943 From: Poloko Owen Rabai <rabaip@...>
Date: Mon Oct 31, 2011 7:16 pm
Subject: Re: Information Missing
sploxz
Send Email Send Email
 
Hi,
thank you for your response, but my question is " I hotsynced only to
find out that data on the PC and the PDA is missing"


On 10/27/11, Dave Hockman-Wert <dhwert@...> wrote:
> Hello,
>
> It is normal for the data to no longer be on the PDA once you have hotsynced
> with the desktop PC.  The syncing process downloads the data from the PDA to
> the PC.  However, you can change the settings for a form (within Form
> Properties -> Data Persistence) so that the data remain on the PDA after
> syncing, either indefinitely or for a specified number of days.
>
>
> Sorry for the slow response, I was out all last week.
>
> Dave
>
>
>
>
>>________________________________
>>From: Poloko Owen Rabai <rabaip@...>
>>To: pendragon-forms@yahoogroups.com
>>Sent: Monday, October 17, 2011 6:14 AM
>>Subject: [pendragon-forms] Information Missing
>>
>>
>>
>>Hi All,
>>
>>I have developed a questionnaire in pendragon forms 5.1. Im Using
>>Tungsten E2, The problem is after capturing data to the PDA, when i
>>hotsync, i will find some of the data missing. I dont know what could
>>be the cause or whether it is my PDA or what.
>>
>>Please Assist
>>
>>--
>>" A warrior doesn't give up what he loves... he finds the love in what he
>> does."
>>
>>
>>
>>
>
> [Non-text portions of this message have been removed]
>
>


--
" A warrior doesn't give up what he loves... he finds the love in what he does."

#2944 From: Dave Hockman-Wert <dhwert@...>
Date: Mon Oct 31, 2011 11:49 pm
Subject: Re: Information Missing
dhwert
Send Email Send Email
 
Okay, that was not clear from your first email.

As Dave Razorsek asked, what is missing?  Everything?  Just some of the
data?  Are the forms still there?


When you open the Forms32K database on the PC, do you see any data records in
the forms that you made?

Were there messages in your PDA hotsync log file indicating a problem?  There
often are, if the data don't "go through" to the PC.

Did you make your forms and upload them to the PDA from the same PC that you are
now syncing to?

The more you can explain what you did, starting at the beginning of the form
creation and upload process, the more we can be helpful.

Dave





>________________________________
>From: Poloko Owen Rabai <rabaip@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Monday, October 31, 2011 12:16 PM
>Subject: Re: [pendragon-forms] Information Missing
>
>
> 
>Hi,
>thank you for your response, but my question is " I hotsynced only to
>find out that data on the PC and the PDA is missing"
>
>On 10/27/11, Dave Hockman-Wert <dhwert@...> wrote:
>> Hello,
>>
>> It is normal for the data to no longer be on the PDA once you have hotsynced
>> with the desktop PC.  The syncing process downloads the data from the PDA to
>> the PC.  However, you can change the settings for a form (within Form
>> Properties -> Data Persistence) so that the data remain on the PDA after
>> syncing, either indefinitely or for a specified number of days.
>>
>>
>> Sorry for the slow response, I was out all last week.
>>
>> Dave
>>
>>
>>
>>
>>>________________________________
>>>From: Poloko Owen Rabai <rabaip@...>
>>>To: pendragon-forms@yahoogroups.com
>>>Sent: Monday, October 17, 2011 6:14 AM
>>>Subject: [pendragon-forms] Information Missing
>>>
>>>
>>>
>>>Hi All,
>>>
>>>I have developed a questionnaire in pendragon forms 5.1. Im Using
>>>Tungsten E2, The problem is after capturing data to the PDA, when i
>>>hotsync, i will find some of the data missing. I dont know what could
>>>be the cause or whether it is my PDA or what.
>>>
>>>Please Assist
>>>
>>>--
>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>> does."
>>>
>>>
>>>
>>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>
>
>

[Non-text portions of this message have been removed]

#2945 From: Poloko Owen Rabai <rabaip@...>
Date: Tue Nov 1, 2011 6:22 am
Subject: Re: Information Missing
sploxz
Send Email Send Email
 
Hello Everyone,

Okay let me explain this, I developed the forms from my PC then i
installed to the PC that is used for hotsyncing. Yes the forms in the
PDA are there, no message in the Log file. All have been fine but now
after hotsyncing i will find that some of the data have been uploaded
to the PC and some will not. When checking in the PDA, there will not
be there also.
For example,
If i have 10 records, 8 will be go and 2 will be missing both from the
PC and the PDA. No Messages in both PDA and PC hotsync log file
--
" A warrior doesn't give up what he loves... he finds the love in what he does."






On 11/1/11, Dave Hockman-Wert <dhwert@...> wrote:
> Okay, that was not clear from your first email.
>
> As Dave Razorsek asked, what is missing?  Everything?  Just some of the
> data?  Are the forms still there?
>
>
> When you open the Forms32K database on the PC, do you see any data records
> in the forms that you made?
>
> Were there messages in your PDA hotsync log file indicating a problem?
> There often are, if the data don't "go through" to the PC.
>
> Did you make your forms and upload them to the PDA from the same PC that you
> are now syncing to?
>
> The more you can explain what you did, starting at the beginning of the form
> creation and upload process, the more we can be helpful.
>
> Dave
>
>
>
>
>
>>________________________________
>>From: Poloko Owen Rabai <rabaip@...>
>>To: pendragon-forms@yahoogroups.com
>>Sent: Monday, October 31, 2011 12:16 PM
>>Subject: Re: [pendragon-forms] Information Missing
>>
>>
>>
>>Hi,
>>thank you for your response, but my question is " I hotsynced only to
>>find out that data on the PC and the PDA is missing"
>>
>>On 10/27/11, Dave Hockman-Wert <dhwert@...> wrote:
>>> Hello,
>>>
>>> It is normal for the data to no longer be on the PDA once you have
>>> hotsynced
>>> with the desktop PC.  The syncing process downloads the data from the PDA
>>> to
>>> the PC.  However, you can change the settings for a form (within Form
>>> Properties -> Data Persistence) so that the data remain on the PDA after
>>> syncing, either indefinitely or for a specified number of days.
>>>
>>>
>>> Sorry for the slow response, I was out all last week.
>>>
>>> Dave
>>>
>>>
>>>
>>>
>>>>________________________________
>>>>From: Poloko Owen Rabai <rabaip@...>
>>>>To: pendragon-forms@yahoogroups.com
>>>>Sent: Monday, October 17, 2011 6:14 AM
>>>>Subject: [pendragon-forms] Information Missing
>>>>
>>>>
>>>>
>>>>Hi All,
>>>>
>>>>I have developed a questionnaire in pendragon forms 5.1. Im Using
>>>>Tungsten E2, The problem is after capturing data to the PDA, when i
>>>>hotsync, i will find some of the data missing. I dont know what could
>>>>be the cause or whether it is my PDA or what.
>>>>
>>>>Please Assist
>>>>
>>>>--
>>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>>> does."
>>>>
>>>>
>>>>
>>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>
>>--
>>" A warrior doesn't give up what he loves... he finds the love in what he
>> does."
>>
>>
>>
>>
>
> [Non-text portions of this message have been removed]
>
>


--
" A warrior doesn't give up what he loves... he finds the love in what he does."

#2946 From: Dave Hockman-Wert <dhwert@...>
Date: Tue Nov 1, 2011 4:37 pm
Subject: Re: Information Missing
dhwert
Send Email Send Email
 
So you developed the forms on one PC and then imported the forms or somehow
moved the FORMS32K file to a different PC, which was the one you used to hotsync
to the PDA?  Is that correct?

If so, that might be an issue.  I've had problems in the past when I am making
the forms and/or hotsyncing from multiple PCs.

You say, "all have been fine".  For how long were things fine?  Can you
remember anything changing -- in your PC's setup, Windows Updates, changes in
antivirus software, anything -- around the time that things went from being
"fine" to being a problem?

It is very odd that some records download and some do not.  That makes me think
it could be a primary key issue, but if so, those usually lead to log messages
indicating that messages were not downloaded due to primary key issues.

Which version of the software are you running?

Dave




>________________________________
>From: Poloko Owen Rabai <rabaip@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Monday, October 31, 2011 11:22 PM
>Subject: Re: [pendragon-forms] Information Missing
>
>
> 
>Hello Everyone,
>
>Okay let me explain this, I developed the forms from my PC then i
>installed to the PC that is used for hotsyncing. Yes the forms in the
>PDA are there, no message in the Log file. All have been fine but now
>after hotsyncing i will find that some of the data have been uploaded
>to the PC and some will not. When checking in the PDA, there will not
>be there also.
>For example,
>If i have 10 records, 8 will be go and 2 will be missing both from the
>PC and the PDA. No Messages in both PDA and PC hotsync log file
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>On 11/1/11, Dave Hockman-Wert <dhwert@...> wrote:
>> Okay, that was not clear from your first email.
>>
>> As Dave Razorsek asked, what is missing?  Everything?  Just some of the
>> data?  Are the forms still there?
>>
>>
>> When you open the Forms32K database on the PC, do you see any data records
>> in the forms that you made?
>>
>> Were there messages in your PDA hotsync log file indicating a problem?
>> There often are, if the data don't "go through" to the PC.
>>
>> Did you make your forms and upload them to the PDA from the same PC that you
>> are now syncing to?
>>
>> The more you can explain what you did, starting at the beginning of the form
>> creation and upload process, the more we can be helpful.
>>
>> Dave
>>
>>
>>
>>
>>
>>>________________________________
>>>From: Poloko Owen Rabai <rabaip@...>
>>>To: pendragon-forms@yahoogroups.com
>>>Sent: Monday, October 31, 2011 12:16 PM
>>>Subject: Re: [pendragon-forms] Information Missing
>>>
>>>
>>>
>>>Hi,
>>>thank you for your response, but my question is " I hotsynced only to
>>>find out that data on the PC and the PDA is missing"
>>>
>>>On 10/27/11, Dave Hockman-Wert <dhwert@...> wrote:
>>>> Hello,
>>>>
>>>> It is normal for the data to no longer be on the PDA once you have
>>>> hotsynced
>>>> with the desktop PC.  The syncing process downloads the data from the PDA
>>>> to
>>>> the PC.  However, you can change the settings for a form (within Form
>>>> Properties -> Data Persistence) so that the data remain on the PDA after
>>>> syncing, either indefinitely or for a specified number of days.
>>>>
>>>>
>>>> Sorry for the slow response, I was out all last week.
>>>>
>>>> Dave
>>>>
>>>>
>>>>
>>>>
>>>>>________________________________
>>>>>From: Poloko Owen Rabai <rabaip@...>
>>>>>To: pendragon-forms@yahoogroups.com
>>>>>Sent: Monday, October 17, 2011 6:14 AM
>>>>>Subject: [pendragon-forms] Information Missing
>>>>>
>>>>>
>>>>>
>>>>>Hi All,
>>>>>
>>>>>I have developed a questionnaire in pendragon forms 5.1. Im Using
>>>>>Tungsten E2, The problem is after capturing data to the PDA, when i
>>>>>hotsync, i will find some of the data missing. I dont know what could
>>>>>be the cause or whether it is my PDA or what.
>>>>>
>>>>>Please Assist
>>>>>
>>>>>--
>>>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>>>> does."
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> [Non-text portions of this message have been removed]
>>>>
>>>>
>>>
>>>--
>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>> does."
>>>
>>>
>>>
>>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>
>
>

[Non-text portions of this message have been removed]

#2947 From: Penny Johnson <pjohnson@...>
Date: Tue Nov 1, 2011 6:06 pm
Subject: RE: Information Missing
roxrgr8_uxo
Send Email Send Email
 
Hi Poloko,

I was wondering if you are syncing to an external database you created or to the
pendragon database…I sync through the pendragon database to an external
database for proprietary reasons…and have found that if there is anything at
all conflicting in the external field mapping process that the info goes off
“into the wild blue yonder”.

Since some of your information arrives in the database and other information
does not…I was wondering if the missing information is contained within the
same form as the information that arrives properly…if so then are your field
names consistent within the form and the database? Have you changed any of the
field names in the database or in the pendragon form since the original form
creation?


     Penny L. Johnson
          Senior Geologist - Site Manager
       NAEVA Geophysics, Inc.
       P.O. Box 7325
       Charlottesville, VA 22906
       (434) 978-3187 (home office)
       (434) 806-9027 (work cell)
       (423) 341-4018 (personal cell)

From: pendragon-forms@yahoogroups.com [mailto:pendragon-forms@yahoogroups.com]
On Behalf Of Dave Hockman-Wert
Sent: Tuesday, November 01, 2011 11:38 AM
To: pendragon-forms@yahoogroups.com
Subject: Re: [pendragon-forms] Information Missing



So you developed the forms on one PC and then imported the forms or somehow
moved the FORMS32K file to a different PC, which was the one you used to hotsync
to the PDA?  Is that correct?

If so, that might be an issue.  I've had problems in the past when I am making
the forms and/or hotsyncing from multiple PCs.

You say, "all have been fine".  For how long were things fine?  Can you remember
anything changing -- in your PC's setup, Windows Updates, changes in antivirus
software, anything -- around the time that things went from being "fine" to
being a problem?

It is very odd that some records download and some do not.  That makes me think
it could be a primary key issue, but if so, those usually lead to log messages
indicating that messages were not downloaded due to primary key issues.

Which version of the software are you running?

Dave

>________________________________
>From: Poloko Owen Rabai <rabaip@...<mailto:rabaip%40gmail.com>>
>To: pendragon-forms@yahoogroups.com<mailto:pendragon-forms%40yahoogroups.com>
>Sent: Monday, October 31, 2011 11:22 PM
>Subject: Re: [pendragon-forms] Information Missing
>
>
>
>Hello Everyone,
>
>Okay let me explain this, I developed the forms from my PC then i
>installed to the PC that is used for hotsyncing. Yes the forms in the
>PDA are there, no message in the Log file. All have been fine but now
>after hotsyncing i will find that some of the data have been uploaded
>to the PC and some will not. When checking in the PDA, there will not
>be there also.
>For example,
>If i have 10 records, 8 will be go and 2 will be missing both from the
>PC and the PDA. No Messages in both PDA and PC hotsync log file
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>On 11/1/11, Dave Hockman-Wert <dhwert@...<mailto:dhwert%40yahoo.com>>
wrote:
>> Okay, that was not clear from your first email.
>>
>> As Dave Razorsek asked, what is missing? Everything? Just some of the
>> data? Are the forms still there?
>>
>>
>> When you open the Forms32K database on the PC, do you see any data records
>> in the forms that you made?
>>
>> Were there messages in your PDA hotsync log file indicating a problem?
>> There often are, if the data don't "go through" to the PC.
>>
>> Did you make your forms and upload them to the PDA from the same PC that you
>> are now syncing to?
>>
>> The more you can explain what you did, starting at the beginning of the form
>> creation and upload process, the more we can be helpful.
>>
>> Dave
>>
>>
>>
>>
>>
>>>________________________________
>>>From: Poloko Owen Rabai <rabaip@...<mailto:rabaip%40gmail.com>>
>>>To: pendragon-forms@yahoogroups.com<mailto:pendragon-forms%40yahoogroups.com>
>>>Sent: Monday, October 31, 2011 12:16 PM
>>>Subject: Re: [pendragon-forms] Information Missing
>>>
>>>
>>>
>>>Hi,
>>>thank you for your response, but my question is " I hotsynced only to
>>>find out that data on the PC and the PDA is missing"
>>>
>>>On 10/27/11, Dave Hockman-Wert <dhwert@...<mailto:dhwert%40yahoo.com>>
wrote:
>>>> Hello,
>>>>
>>>> It is normal for the data to no longer be on the PDA once you have
>>>> hotsynced
>>>> with the desktop PC. The syncing process downloads the data from the PDA
>>>> to
>>>> the PC. However, you can change the settings for a form (within Form
>>>> Properties -> Data Persistence) so that the data remain on the PDA after
>>>> syncing, either indefinitely or for a specified number of days.
>>>>
>>>>
>>>> Sorry for the slow response, I was out all last week.
>>>>
>>>> Dave
>>>>
>>>>
>>>>
>>>>
>>>>>________________________________
>>>>>From: Poloko Owen Rabai <rabaip@...<mailto:rabaip%40gmail.com>>
>>>>>To:
pendragon-forms@yahoogroups.com<mailto:pendragon-forms%40yahoogroups.com>
>>>>>Sent: Monday, October 17, 2011 6:14 AM
>>>>>Subject: [pendragon-forms] Information Missing
>>>>>
>>>>>
>>>>>
>>>>>Hi All,
>>>>>
>>>>>I have developed a questionnaire in pendragon forms 5.1. Im Using
>>>>>Tungsten E2, The problem is after capturing data to the PDA, when i
>>>>>hotsync, i will find some of the data missing. I dont know what could
>>>>>be the cause or whether it is my PDA or what.
>>>>>
>>>>>Please Assist
>>>>>
>>>>>--
>>>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>>>> does."
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> [Non-text portions of this message have been removed]
>>>>
>>>>
>>>
>>>--
>>>" A warrior doesn't give up what he loves... he finds the love in what he
>>> does."
>>>
>>>
>>>
>>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>
>--
>" A warrior doesn't give up what he loves... he finds the love in what he
does."
>
>
>
>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

#2948 From: "fuehri" <jensf@...>
Date: Tue Nov 8, 2011 9:50 am
Subject: Click into section field - Pendragon Forms VI
fuehri
Send Email Send Email
 
Hello all,

Im unable to use to "click into section field" feature in Pendragon Forms VI on
an iPhone / iPad. The "click-event" will not be triggered.
Does anyone has the same problem and a solution?

Regards
Jens

#2949 From: "p.c.boudreau@..." <p.c.boudreau@...>
Date: Tue Nov 8, 2011 2:06 pm
Subject: Re: Click into section field - Pendragon Forms VI
pcboudreau
Send Email Send Email
 
I also cannot make it work. I've had to change over to buttons instead.

Another change I've seen is that msgbox doesn't have yes/no answers anymore.
It's only OK/Cancel or OK.

Is there a listing of changes from 5.1 to VI? Very frustrating for me.

Phil



[Non-text portions of this message have been removed]

#2950 From: "manu" <mafersa@...>
Date: Tue Nov 8, 2011 5:48 pm
Subject: sync
mafersa@...
Send Email Send Email
 
Hi.
Im evaluating forms VI and apparently the web server is well configured as I
changed the provision.php with data.
The problem is when trying to distribute a form. I see in the log:
Connection: dtadmin - http://127.0.0.1:8080/formsvi/data.php
2011-11-08 18:46:07 Processing exception in form loop: Access violation at
address 005F5C1B in module 'Uploader.exe'. Read of address 00000060
When the IP I have in the pendragon transfer agent setup is the real one (127...
us the one the set for local hosting by default).
Is there something I should change so I can distribute forms?

Thanks to the group

M.Fernndez

[Non-text portions of this message have been removed]

#2951 From: "desautel@..." <desautel@...>
Date: Mon Nov 14, 2011 2:25 pm
Subject: New user cant sync data
desautel...
Send Email Send Email
 
I have created 4 forms in Pendragon VI for Ipod touch. I have an external Access
db. I have setup the link to the Access tables frozen and distributed the forms
to the handheld. I am using wifi for sync. Can see the forms on the device and
add records. But data does not sync in either direction. I get error message
indicating " Direct Connection to the server has failed." for each form. Dont
know what to fix.

John

#2953 From: "weeber.matt" <weeber.matt@...>
Date: Thu Dec 1, 2011 5:07 pm
Subject: Windows Mobile 6.5 (Classic)
weeber.matt
Send Email Send Email
 
I am testing a new handheld device that is running the OS listed above.  I have
Pendragon 5.1 loaded on the device and my forms appear to be running smoothly;
however, I noticed that the Windows Mobile user interface to exit a program
(typically an "X" in the lower right corner) was blocked out by the Pendragon
software.

Anyone else run into this or know of a solution?

#2954 From: "nifago" <nifago@...>
Date: Sun Dec 11, 2011 1:13 pm
Subject: Sychronisation problem
nifago
Send Email Send Email
 
Hello,
I have a problem with the synchronization (Pocket PC data to PC). One of my
tables refuse sychronosation (data
refused to move). After sychronosation, there are always data on Pocket PC.
Other thing, in Pocket PC, there is file nammed "form5.sdf" whitch contain my
survey data. I want to know if it is possible to open this file with an external
software such as "SDF Viewer" or other.
I try to open my database ("form5.sdf") with software "SDF Viewer" but a
password is required. I do not know which one.
BIG QUESTION : What can i do to open "form5.sdf" located in my Pocket PC
(\Programme files\forms5\form5.sdf)

Think you

#2955 From: "nifago" <nifago@...>
Date: Sun Dec 11, 2011 1:45 pm
Subject: Sychronosation
nifago
Send Email Send Email
 
Hello,
I have a problem with the synchronization (Pocket PC data to PC). One of my
tables refuse sychronosation (data
refused to move). After sychronosation, there are always data on Pocket PC.
Other thing, in Pocket PC, there is file nammed "form5.sdf" whitch contain my
survey data. I want to know if it is possible to open this file with an external
software such as "SDF Viewer" or other.
I try to open my database ("form5.sdf") with software "SDF Viewer" but a
password is required. I do not know which one.
BIG QUESTION : What can i do to open "form5.sdf" located in my Pocket PC
(\Programme files\forms5\form5.sdf)

Here, the content of synchronisation log file

======================================================================
10/12/11 05:29:01
Data communications successful.

Unexpected exception: System.InvalidOperationException: Q7 : String truncation:
max=1, len=2, value='18'.
 System.Data.SqlServerCe.SqlCeCommand.FillParameterDataBindings()
 System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText()
 System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand()
 System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
 Forms5.DataSynchronizer.InstallDesigns()
 Forms5.mainForm.BreakOutDesigns()
 Forms5.mainForm.Synchronize()

Location: record/System.String/Form ID 507840630/Record ID 26/Question ID 43
======================================================================

Think you

#2956 From: Dave Hockman-Wert <dhwert@...>
Date: Mon Dec 19, 2011 5:32 pm
Subject: Re: Sychronosation
dhwert
Send Email Send Email
 
There are a number of things that could be happening.  Here are my suggestions.

- Check the Advance Form Properties for the form/table that is not synchronizing
correctly to see whether the settings are different from your other forms.
- Think about whether you changed either the source form (on the PC) or the form
on the handheld since you first moved the form to the handheld.  If you did
(for example, updating the source form on the PC and deleting the original
version), this would be a problem, even if you made the newer form the same
name.
- Are you syncing to the same PC?  If not, this could be an issue.

Googling on the various error messages you got might also lead to a solution. 
That sometimes works for me.


As far as how to open the data file from the Pocket PC, I would suggest opening
it in a text file, if possible.

Good luck,
Dave



>________________________________
> From: nifago <nifago@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Sunday, December 11, 2011 5:45 AM
>Subject: [pendragon-forms] Sychronosation
>
>
> 
>Hello,
>I have a problem with the synchronization (Pocket PC data to PC). One of my
tables refuse sychronosation (data
>refused to move). After sychronosation, there are always data on Pocket PC.
>Other thing, in Pocket PC, there is file nammed "form5.sdf" whitch contain my
survey data. I want to know if it is possible to open this file with an external
software such as "SDF Viewer" or other.
>I try to open my database ("form5.sdf") with software "SDF Viewer" but a
password is required. I do not know which one.
>BIG QUESTION : What can i do to open "form5.sdf" located in my Pocket PC
(\Programme files\forms5\form5.sdf)
>
>Here, the content of synchronisation log file
>
>======================================================================
>10/12/11 05:29:01
>Data communications successful.
>
>Unexpected exception: System.InvalidOperationException: Q7 : String truncation:
max=1, len=2, value='18'.
>à System.Data.SqlServerCe.SqlCeCommand.FillParameterDataBindings()
>à System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText()
>à System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand()
>à System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
>à Forms5.DataSynchronizer.InstallDesigns()
>à Forms5.mainForm.BreakOutDesigns()
>à Forms5.mainForm.Synchronize()
>
>Location: record/System.String/Form ID 507840630/Record ID 26/Question ID 43
>======================================================================
>
>Think you
>
>
>
>
>

[Non-text portions of this message have been removed]

#2957 From: "Dave Laansma" <dlaansma@...>
Date: Tue Dec 20, 2011 3:33 pm
Subject: Re: Sychronosation
dlaansma@...
Send Email Send Email
 
This is interesting information.



Sincerely,

David Laansma





[Non-text portions of this message have been removed]

#2958 From: "joralemonshelly" <joralemonshelly@...>
Date: Tue Dec 27, 2011 7:41 pm
Subject: upload audio file
joralemonshelly
Send Email Send Email
 
Hello,

Is there a way to create a field in a Pendragon form for uploading an audio
file? Any help would be appreciated. Thanks.

#2959 From: "athenakuma" <erin.mead@...>
Date: Wed Mar 14, 2012 4:48 pm
Subject: Forms 5.1 Synchronization with Server when there's no internet
athenakuma
Send Email Send Email
 
I'm working on a project in which we will collect some data in rural areas using
a pocket PC with Pendragon Forms 5.1. We are planning to have one network server
in our main office and the data collectors will have laptops set up as network
clients. Internet access is not reliable or non-existent in some of the rural
areas where the data collectors will be.

I'm wondering what will happen if they sync the pocket PC to their laptop (the
network client) when there is no internet? Will the data be saved on their
laptops, then sent automatically to the network server when they have internet?
Or will synchronization fail, and they'll have to wait until they have internet
access to sync their pocket PCs? Thanks for the info!

#2960 From: "clp7991" <Carolyn.Pfeifer@...>
Date: Wed Mar 14, 2012 5:04 pm
Subject: Upgraded to Windows 7, Office 10 and Forms Manager won't display properly
clp7991
Send Email Send Email
 
Hello all, this is my first time posting. I have a new computer and we upgraded
to windows 7 professional, office 10 and reloaded forms VI. everything seemed
well until I opened the pendragon forms manager. The display is all off. I can
only see some of the tabs, I can't see "script" for example. The text in the
display is shoved all over to the right and there is extra white space/border
around everything.

At first I thought it was because I created my forms using Access 2007. I can't
edit my exiting forms and I can't create any new ones. Any suggestions?

Thank you

#2961 From: ilungalouis@...
Date: Wed Mar 14, 2012 7:02 pm
Subject: Re: Upgraded to Windows 7, Office 10 and Forms Manager won't display properly
louisilungak
Send Email Send Email
 
Can you make a copy of your forms and try to work with the copy.
Envoy par  BlackBerry
Louis ILUNGA K.

-----Original Message-----
From: "clp7991" <Carolyn.Pfeifer@...>
Sender: pendragon-forms@yahoogroups.com
Date: Wed, 14 Mar 2012 17:04:10
To: <pendragon-forms@yahoogroups.com>
Reply-To: pendragon-forms@yahoogroups.com
Subject: [pendragon-forms] Upgraded to Windows 7, Office 10 and Forms Manager
won't display properly

Hello all, this is my first time posting. I have a new computer and we upgraded
to windows 7 professional, office 10 and reloaded forms VI. everything seemed
well until I opened the pendragon forms manager. The display is all off. I can
only see some of the tabs, I can't see "script" for example. The text in the
display is shoved all over to the right and there is extra white space/border
around everything.

At first I thought it was because I created my forms using Access 2007. I can't
edit my exiting forms and I can't create any new ones. Any suggestions?

Thank you




[Non-text portions of this message have been removed]

#2962 From: Dave Hockman-Wert <dhwert@...>
Date: Thu Mar 15, 2012 3:13 pm
Subject: Re: Upgraded to Windows 7, Office 10 and Forms Manager won't display properly
dhwert
Send Email Send Email
 
This is such a technical question related to compatibility between the OS and
the software that the software manufacturer should really be the one to address
it.  So if you haven't already, I'd recommend writing to Pendragon's support
email address.  They're usually fairly responsive.


Please let us know what you learn.

Thanks,
Dave




>________________________________
> From: clp7991 <Carolyn.Pfeifer@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Wednesday, March 14, 2012 10:04 AM
>Subject: [pendragon-forms] Upgraded to Windows 7, Office 10 and Forms Manager
won't display properly
>
>
> 
>Hello all, this is my first time posting. I have a new computer and we upgraded
to windows 7 professional, office 10 and reloaded forms VI. everything seemed
well until I opened the pendragon forms manager. The display is all off. I can
only see some of the tabs, I can't see "script" for example. The text in the
display is shoved all over to the right and there is extra white space/border
around everything.
>
>At first I thought it was because I created my forms using Access 2007. I can't
edit my exiting forms and I can't create any new ones. Any suggestions?
>
>Thank you
>
>
>
>
>

[Non-text portions of this message have been removed]

#2963 From: Dave Hockman-Wert <dhwert@...>
Date: Thu Mar 15, 2012 3:19 pm
Subject: Re: Forms 5.1 Synchronization with Server when there's no internet
dhwert
Send Email Send Email
 
It seems like it should work this way (the way you describe), but as I always
tell my field crews, test, test, TEST (before you go into the field).

So, just disconnect one of the laptops from the network while you're still in or
near the office, enter some fake test data in one of your forms on the pocket
PC, attempt to sync to the laptop, and see whether it downloaded the data.  If
so, then reconnect the laptop to the network and see if the test data gets added
to the main network server.  (If you are not the main manager of the server,
you should probably work with that person to make sure they clean off the fake
test data after you run the test.)

There's really no substitution for doing a test run of the process on your own
system.  You can expect or hope that it will work the way it describes the
process on PF's website, or you can hear someone else's story of success (or
failure), but none of those will ensure that it works on *your* system.  Test
it out.

Even better, test it out a few different ways, trying to replicate what a
Pendragon-inexperienced field crew member might do during the downloading
process (i.e., a slightly different method than prescribed), to see where it
might break down.


Dave




>________________________________
> From: athenakuma <erin.mead@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Wednesday, March 14, 2012 9:48 AM
>Subject: [pendragon-forms] Forms 5.1 Synchronization with Server when there's
no internet
>
>
> 
>I'm working on a project in which we will collect some data in rural areas
using a pocket PC with Pendragon Forms 5.1. We are planning to have one network
server in our main office and the data collectors will have laptops set up as
network clients. Internet access is not reliable or non-existent in some of the
rural areas where the data collectors will be.
>
>I'm wondering what will happen if they sync the pocket PC to their laptop (the
network client) when there is no internet? Will the data be saved on their
laptops, then sent automatically to the network server when they have internet?
Or will synchronization fail, and they'll have to wait until they have internet
access to sync their pocket PCs? Thanks for the info!
>
>
>
>
>

[Non-text portions of this message have been removed]

#2964 From: "circular.stream" <ecuadorlex@...>
Date: Sun Apr 29, 2012 6:58 pm
Subject: Using the same Reference Form for more than one field?
circular.stream
Send Email Send Email
 
I would like to be able to use the same Reference Form (a list of plant species)
in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order for the
rest of the data on the reference form to auto-fill the next fields on the form
(Family, growth form, etc).  I need the Form Fields to be same as the Reference
Form, however I can't have the same Field twice. Does this make sense? How do I
work around that?

#2965 From: Dave Hockman-Wert <dhwert@...>
Date: Mon Apr 30, 2012 5:20 pm
Subject: Re: Using the same Reference Form for more than one field?
dhwert
Send Email Send Email
 
Hello,

This solution is a little redundant, but I'm not sure of a better approach. 
Couldn't you make separate reference forms for each plant# field where you want
to Lookup to Reference Form, and that way you could use different field names
for each reference form (as you have to do for each plant# anyway)?  For
example, Family1, Growth form1, etc.  Family2, Growth form2, etc., Family3,
Growth form3, etc.  The reference forms would have the same data in each, but
different field names.

Dave






>________________________________
> From: circular.stream <ecuadorlex@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Sunday, April 29, 2012 11:58 AM
>Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
>
>
> 
>I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc).  I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
>
>
>
>
>

[Non-text portions of this message have been removed]

#2966 From: "circular.stream" <ecuadorlex@...>
Date: Tue May 1, 2012 2:04 pm
Subject: Re: Using the same Reference Form for more than one field?
circular.stream
Send Email Send Email
 
Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.

--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>
> Hello,
>
> This solution is a little redundant, but I'm not sure of a better approach. 
Couldn't you make separate reference forms for each plant# field where you want
to Lookup to Reference Form, and that way you could use different field names
for each reference form (as you have to do for each plant# anyway)?  For
example, Family1, Growth form1, etc.  Family2, Growth form2, etc., Family3,
Growth form3, etc.  The reference forms would have the same data in each, but
different field names.
>
> Dave
>
>
>
>
>
>
> >________________________________
> > From: circular.stream <ecuadorlex@...>
> >To: pendragon-forms@yahoogroups.com
> >Sent: Sunday, April 29, 2012 11:58 AM
> >Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
> >
> >
> > 
> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc).  I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
> >
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>

#2967 From: Dave Hockman-Wert <dhwert@...>
Date: Wed May 2, 2012 12:37 am
Subject: Re: Re: Using the same Reference Form for more than one field?
dhwert
Send Email Send Email
 
That's not really a problem.  Just update one form, delete the others, then
copy the updated form as many times as you need to, renaming to the original
reference form names (of the forms you just deleted).

Another thing to consider is whether you have your database set up as
efficiently and as "normalized" as you could.  It sounds as if you may not. 
Rather than have multiple plant entries per record, you should probablyset up
your table so that each record has one plant entry.  If you think you need
multiple plant entries per record, because the plants reference something else,
then you should do this by the relationships you create among tables, not try to
lump it all in one table.  If you send me more information about your table
structure off-list, I'd be happy to take a look at it to see if I have any
suggestions for how you could reorganize your tables.


Dave




>________________________________
> From: circular.stream <ecuadorlex@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Tuesday, May 1, 2012 7:04 AM
>Subject: [pendragon-forms] Re: Using the same Reference Form for more than one
field?
>
>
> 
>Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.
>
>--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>>
>> Hello,
>>
>> This solution is a little redundant, but I'm not sure of a better
approach.  Couldn't you make separate reference forms for each plant# field
where you want to Lookup to Reference Form, and that way you could use different
field names for each reference form (as you have to do for each plant#
anyway)?  For example, Family1, Growth form1, etc.  Family2, Growth form2,
etc., Family3, Growth form3, etc.  The reference forms would have the same
data in each, but different field names.
>>
>> Dave
>>
>>
>>
>>
>>
>>
>> >________________________________
>> > From: circular.stream <ecuadorlex@...>
>> >To: pendragon-forms@yahoogroups.com
>> >Sent: Sunday, April 29, 2012 11:58 AM
>> >Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
>> >
>> >
>> > 
>> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc).  I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
>> >
>> >
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
>

[Non-text portions of this message have been removed]

#2968 From: "Pamela Zimmerman" <pzimmer@...>
Date: Wed May 2, 2012 2:32 pm
Subject: RE: Re: Using the same Reference Form for more than one field?
skeinbabe
Send Email Send Email
 
I almost always use a separate database for my lookup tables (with add edit
forms for users also in this DB), and then link the Pendragon form(s) to them as
needed.  Then I can use the same table in various forms, but yet have only one
table to maintain.  If you need a subset of your table data you can add some
flags to the reference table and parse that out as needed.



Pam





From: pendragon-forms@yahoogroups.com [mailto:pendragon-forms@yahoogroups.com]
On Behalf Of Dave Hockman-Wert
Sent: Tuesday, May 01, 2012 7:37 PM
To: pendragon-forms@yahoogroups.com
Subject: Re: [pendragon-forms] Re: Using the same Reference Form for more than
one field?





That's not really a problem.  Just update one form, delete the others, then copy
the updated form as many times as you need to, renaming to the original
reference form names (of the forms you just deleted).

Another thing to consider is whether you have your database set up as
efficiently and as "normalized" as you could.  It sounds as if you may not. 
Rather than have multiple plant entries per record, you should probablyset up
your table so that each record has one plant entry.  If you think you need
multiple plant entries per record, because the plants reference something else,
then you should do this by the relationships you create among tables, not try to
lump it all in one table.  If you send me more information about your table
structure off-list, I'd be happy to take a look at it to see if I have any
suggestions for how you could reorganize your tables.

Dave

>________________________________
> From: circular.stream <ecuadorlex@... <mailto:ecuadorlex%40yahoo.com> >
>To: pendragon-forms@yahoogroups.com <mailto:pendragon-forms%40yahoogroups.com>
>Sent: Tuesday, May 1, 2012 7:04 AM
>Subject: [pendragon-forms] Re: Using the same Reference Form for more than one
field?
>
>
>
>Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.
>
>--- In pendragon-forms@yahoogroups.com
<mailto:pendragon-forms%40yahoogroups.com> , Dave Hockman-Wert <dhwert@...>
wrote:
>>
>> Hello,
>>
>> This solution is a little redundant, but I'm not sure of a better approach.Â
Couldn't you make separate reference forms for each plant# field where you want
to Lookup to Reference Form, and that way you could use different field names
for each reference form (as you have to do for each plant# anyway)?  For
example, Family1, Growth form1, etc.  Family2, Growth form2, etc., Family3,
Growth form3, etc.  The reference forms would have the same data in each, but
different field names.
>>
>> Dave
>>
>>
>>
>>
>>
>>
>> >________________________________
>> > From: circular.stream <ecuadorlex@...>
>> >To: pendragon-forms@yahoogroups.com
<mailto:pendragon-forms%40yahoogroups.com>
>> >Sent: Sunday, April 29, 2012 11:58 AM
>> >Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
>> >
>> >
>> >Â
>> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3. But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc). I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
>> >
>> >
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

#2969 From: "circular.stream" <ecuadorlex@...>
Date: Wed May 2, 2012 6:28 pm
Subject: Re: Using the same Reference Form for more than one field?
circular.stream
Send Email Send Email
 
What I have is a point intercept plant survey.There are 200 intercept points
along a line. Each intercept point is a new record.
Here's how I would like the form to work:
1. Line Number (1-200)
2. Top Canopy (Species list lookup to Reference Form)
3. Lower Canopy 1 (Species list lookup to same REference FOrm)
4. Lower Canopy 2 (Species list lookup to same Reference Form)
5. Lower Canopy 3 (Species list lookup to same Reference FOrm)
6. Soil surface (lookup list)  BUT if the user chooses "Basal plant" then the
form jumps to:
7. Basal (Species list lookup to same Reference Form).

Each Species list lookup includes hidden auto-fill fields for Growth Form,
Forage Value, and Plant Family.

Finally, Pendragon Support suggested I rename the fields to the names on the
REference Form using a Select: function, for example,
Select:
$[TopCanopy] = $[Species]
$[TopGrowth] = $[Growth Form]
$[TopForage Value] = $[Forage Value]
$[TopFamily] = $[Family]

and this would repeated at the next lookup but with
Select:
$[Lower Canopy 1] = $[Species] etc....

This script did not test out OK. The error message said that the fields were not
yet defined.

Any suggestions you have would be welcomed. Thanks for looking at this!


--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>
> That's not really a problem.  Just update one form, delete the others, then
copy the updated form as many times as you need to, renaming to the original
reference form names (of the forms you just deleted).
>
> Another thing to consider is whether you have your database set up as
efficiently and as "normalized" as you could.  It sounds as if you may not. 
Rather than have multiple plant entries per record, you should probablyset up
your table so that each record has one plant entry.  If you think you need
multiple plant entries per record, because the plants reference something else,
then you should do this by the relationships you create among tables, not try to
lump it all in one table.  If you send me more information about your table
structure off-list, I'd be happy to take a look at it to see if I have any
suggestions for how you could reorganize your tables.
>
>
> Dave
>
>
>
>
> >________________________________
> > From: circular.stream <ecuadorlex@...>
> >To: pendragon-forms@yahoogroups.com
> >Sent: Tuesday, May 1, 2012 7:04 AM
> >Subject: [pendragon-forms] Re: Using the same Reference Form for more than
one field?
> >
> >
> > 
> >Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.
> >
> >--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@> wrote:
> >>
> >> Hello,
> >>
> >> This solution is a little redundant, but I'm not sure of a better
approach.  Couldn't you make separate reference forms for each plant# field
where you want to Lookup to Reference Form, and that way you could use different
field names for each reference form (as you have to do for each plant#
anyway)?  For example, Family1, Growth form1, etc.  Family2, Growth form2,
etc., Family3, Growth form3, etc.  The reference forms would have the same
data in each, but different field names.
> >>
> >> Dave
> >>
> >>
> >>
> >>
> >>
> >>
> >> >________________________________
> >> > From: circular.stream <ecuadorlex@>
> >> >To: pendragon-forms@yahoogroups.com
> >> >Sent: Sunday, April 29, 2012 11:58 AM
> >> >Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
> >> >
> >> >
> >> > 
> >> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc).  I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>

#2970 From: "circular.stream" <ecuadorlex@...>
Date: Wed May 2, 2012 6:30 pm
Subject: Re: Using the same Reference Form for more than one field?
circular.stream
Send Email Send Email
 
Thanks Pam.  I'm looking to use the same reference form in different fields of
the same main form.  Not in different forms.  Having one table to maintain is
definitely the goal!

--- In pendragon-forms@yahoogroups.com, "Pamela Zimmerman" <pzimmer@...> wrote:
>
>
>
> I almost always use a separate database for my lookup tables (with add edit
forms for users also in this DB), and then link the Pendragon form(s) to them as
needed.  Then I can use the same table in various forms, but yet have only one
table to maintain.  If you need a subset of your table data you can add some
flags to the reference table and parse that out as needed.
>
>
>
> Pam
>
>
>
>
>
> From: pendragon-forms@yahoogroups.com [mailto:pendragon-forms@yahoogroups.com]
On Behalf Of Dave Hockman-Wert
> Sent: Tuesday, May 01, 2012 7:37 PM
> To: pendragon-forms@yahoogroups.com
> Subject: Re: [pendragon-forms] Re: Using the same Reference Form for more than
one field?
>
>
>
>
>
> That's not really a problem.  Just update one form, delete the others, then
copy the updated form as many times as you need to, renaming to the original
reference form names (of the forms you just deleted).
>
> Another thing to consider is whether you have your database set up as
efficiently and as "normalized" as you could.  It sounds as if you may not. 
Rather than have multiple plant entries per record, you should probablyset up
your table so that each record has one plant entry.  If you think you need
multiple plant entries per record, because the plants reference something else,
then you should do this by the relationships you create among tables, not try to
lump it all in one table.  If you send me more information about your table
structure off-list, I'd be happy to take a look at it to see if I have any
suggestions for how you could reorganize your tables.
>
> Dave
>
> >________________________________
> > From: circular.stream <ecuadorlex@... <mailto:ecuadorlex%40yahoo.com> >
> >To: pendragon-forms@yahoogroups.com
<mailto:pendragon-forms%40yahoogroups.com>
> >Sent: Tuesday, May 1, 2012 7:04 AM
> >Subject: [pendragon-forms] Re: Using the same Reference Form for more than
one field?
> >
> >
> >
> >Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.
> >
> >--- In pendragon-forms@yahoogroups.com
<mailto:pendragon-forms%40yahoogroups.com> , Dave Hockman-Wert <dhwert@> wrote:
> >>
> >> Hello,
> >>
> >> This solution is a little redundant, but I'm not sure of a better
approach.  Couldn't you make separate reference forms for each plant# field
where you want to Lookup to Reference Form, and that way you could use different
field names for each reference form (as you have to do for each plant#
anyway)?  For example, Family1, Growth form1, etc.  Family2, Growth form2,
etc., Family3, Growth form3, etc.  The reference forms would have the same
data in each, but different field names.
> >>
> >> Dave
> >>
> >>
> >>
> >>
> >>
> >>
> >> >________________________________
> >> > From: circular.stream <ecuadorlex@>
> >> >To: pendragon-forms@yahoogroups.com
<mailto:pendragon-forms%40yahoogroups.com>
> >> >Sent: Sunday, April 29, 2012 11:58 AM
> >> >Subject: [pendragon-forms] Using the same Reference Form for more than one
field?
> >> >
> >> >
> >> >Â
> >> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3. But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc). I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

#2971 From: Dave Hockman-Wert <dhwert@...>
Date: Wed May 2, 2012 8:05 pm
Subject: Re: Re: Using the same Reference Form for more than one field?
dhwert
Send Email Send Email
 
Thanks for the explanation.  I figured you must need to identify multiple
plants in a given location or some such.


The suggestion by the PF folks makes sense.  It seems like it should work in
theory.  But for it to work, you will need to make sure that the field names
you use are in the "Field Label" section of the Script tab.  That's where
scripts are looking for field names.  So even if you used those names for the
Field Name or Column Name, you will probably need to add it to the Field Label
as well.

The one question I have is whether scripts can work across forms.  They may,
but I don't think I have done this before.  It seems like it might be a
problem.  However, if the PF folks suggested it, I guess it should work.


An alternative approach would be to work with a more relational, normalized
database approach.  If you only want to maintain and lookup one
reference table, then give each plant a unique ID in the reference form, and in
your form below where you need to include multiple plants in
separate fields, simply reference that ID in each field (Top Canopy, Lower
Canopy 1, etc.), and do not actually include -- hidden or otherwise -- the
redundant data fields that are
already in the other form.  If you set up relationships in your database (or
even if you don't, actually), the ID field
will be the only link you need to make queries that can pull in the information
from those other fields when you actually need to run a query or report.


If you're hiding those extra fields anyway, then they're apparently not needed
for the data collection itself, but only back in the office.  In which case,
let the database do the work of linking the tables.  No need for the redundant
data.

Good luck,
Dave



>________________________________
> From: circular.stream <ecuadorlex@...>
>To: pendragon-forms@yahoogroups.com
>Sent: Wednesday, May 2, 2012 11:28 AM
>Subject: [pendragon-forms] Re: Using the same Reference Form for more than one
field?
>
>
> 
>What I have is a point intercept plant survey.There are 200 intercept points
along a line. Each intercept point is a new record.
>Here's how I would like the form to work:
>1. Line Number (1-200)
>2. Top Canopy (Species list lookup to Reference Form)
>3. Lower Canopy 1 (Species list lookup to same REference FOrm)
>4. Lower Canopy 2 (Species list lookup to same Reference Form)
>5. Lower Canopy 3 (Species list lookup to same Reference FOrm)
>6. Soil surface (lookup list)  BUT if the user chooses "Basal plant" then the
form jumps to:
>7. Basal (Species list lookup to same Reference Form).
>
>Each Species list lookup includes hidden auto-fill fields for Growth Form,
Forage Value, and Plant Family.
>
>Finally, Pendragon Support suggested I rename the fields to the names on the
REference Form using a Select: function, for example,
>Select:
>$[TopCanopy] = $[Species]
>$[TopGrowth] = $[Growth Form]
>$[TopForage Value] = $[Forage Value]
>$[TopFamily] = $[Family]
>
>and this would repeated at the next lookup but with
>Select:
>$[Lower Canopy 1] = $[Species] etc....
>
>This script did not test out OK. The error message said that the fields were
not yet defined.
>
>Any suggestions you have would be welcomed. Thanks for looking at this!
>
>--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>>
>> That's not really a problem.  Just update one form, delete the others,
then copy the updated form as many times as you need to, renaming to the
original reference form names (of the forms you just deleted).
>>
>> Another thing to consider is whether you have your database set up as
efficiently and as "normalized" as you could.  It sounds as if you may
not.  Rather than have multiple plant entries per record, you should
probablyset up your table so that each record has one plant entry.  If you
think you need multiple plant entries per record, because the plants reference
something else, then you should do this by the relationships you create among
tables, not try to lump it all in one table.  If you send me more information
about your table structure off-list, I'd be happy to take a look at it to see if
I have any suggestions for how you could reorganize your tables.
>>
>>
>> Dave
>>
>>
>>
>>
>> >________________________________
>> > From: circular.stream <ecuadorlex@...>
>> >To: pendragon-forms@yahoogroups.com
>> >Sent: Tuesday, May 1, 2012 7:04 AM
>> >Subject: [pendragon-forms] Re: Using the same Reference Form for more than
one field?
>> >
>> >
>> > 
>> >Thanks for your reply. I considered that, but as we encounter new species we
will be adding them to the reference form, and I don't want to add them to all
the new reference forms.
>> >
>> >--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@> wrote:
>> >>
>> >> Hello,
>> >>
>> >> This solution is a little redundant, but I'm not sure of a better
approach.  Couldn't you make separate reference forms for each plant#
field where you want to Lookup to Reference Form, and that way you could use
different field names for each reference form (as you have to do for each plant#
anyway)?  For example, Family1, Growth form1, etc.  Family2,
Growth form2, etc., Family3, Growth form3, etc.  The reference forms
would have the same data in each, but different field names.
>> >>
>> >> Dave
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> >________________________________
>> >> > From: circular.stream <ecuadorlex@>
>> >> >To: pendragon-forms@yahoogroups.com
>> >> >Sent: Sunday, April 29, 2012 11:58 AM
>> >> >Subject: [pendragon-forms] Using the same Reference Form for more than
one field?
>> >> >
>> >> >
>> >> > 
>> >> >I would like to be able to use the same Reference Form (a list of plant
species) in different fields. i.e. Plant #1, Plant #2, Plant #3.  But in order
for the rest of the data on the reference form to auto-fill the next fields on
the form (Family, growth form, etc).  I need the Form Fields to be same as the
Reference Form, however I can't have the same Field twice. Does this make sense?
How do I work around that?
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >> [Non-text portions of this message have been removed]
>> >>
>> >
>> >
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
>

[Non-text portions of this message have been removed]

Messages 2941 - 2971 of 3033   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help