Time card template

[peddie]

Hi

I am a newbie to Infopath and not sure if I can achieve what I wish to
do.

1. I try to customize the out of the box time card template. I would
like to be able to enter the data onto the form which will be placed on
a sharepoint form library. I also want to submit data onto MS Access
Database too, is this doable?

2. I dont seem to be able to change the XML data source. I want to be
able to change the property of timecard to be repeating area but I dont
seem to be able to do so. How to work around this?

Many thanks in advance for any advice.

Thanks
Peddie

 

[Amanda Murphy]

Heya Peddie,

I haven't done much with that template but I can only assume it is like many
of the others. Have you installed the service packs (in particular SP1) for
InfoPath 2003 (assuming you are using that)? It makes changes to your data
source and external data connections much easier.

 

[Ben Walters]

Hey Peddie,
The templates that come with InfoPath will have their schemas locked by
default hence you can't edit the properties of the fields.

you have a couple of options here
1: Extract the files from the template and use the template .xml as a basis
to create a new form
2: make a copy of the template that comes with InfoPath, extrac the files
from the xsn and update the manifest .xsf to all full editing of the schema.

Option 1:
The templates InnfoPath are essentially cab files with different extension
hence you can actually change the extnsion of the template from .xsn to .cab
and extrac the files within, alternatly you can extract these files from
within the InfoPath designer
With the form in design mode, click on File>Extract files. This will extract
the files to the selected directory.
One of the files extracted should be a "Template.xml" this represents the
blank xml structure of the form.
From here you can design a new blank form then select Tools>Convert Main
datasource. and point to the extracted template .xml file to import the xml
strucutre.

Option 2:
In this option you will first need to extract the files to a directory (As
noted in option 1), once the files have been extracted right click on the
Manifest.xsf and select to edit in notepad.
do a search and look for the following line. <xsfroperty
name="editability" type="string"
you will notice one of the properties on this line is set to "none" change
this to "partial", save the changes and close the file then right click on
the manifest.xsf and select Design you shoul dnow find the entire schema is
editable.



Hope this helps
Cheers
Ben

 

[peddie]

Thanks Ben, I will try the option 2.

Hey Peddie,
The templates that come with InfoPath will have their schemas locked by
default hence you can't edit the properties of the fields.

you have a couple of options here
1: Extract the files from the template and use the template .xml as a basis
to create a new form
2: make a copy of the template that comes with InfoPath, extrac the files
from the xsn and update the manifest .xsf to all full editing of the schema.

Option 1:
The templates InnfoPath are essentially cab files with different extension
hence you can actually change the extnsion of the template from .xsn to .cab
and extrac the files within, alternatly you can extract these files from
within the InfoPath designer
With the form in design mode, click on File>Extract files. This will extract
the files to the selected directory.
One of the files extracted should be a "Template.xml" this represents the
blank xml structure of the form.
From here you can design a new blank form then select Tools>Convert Main
datasource. and point to the extracted template .xml file to import the xml
strucutre.

Option 2:
In this option you will first need to extract the files to a directory (As
noted in option 1), once the files have been extracted right click on the
Manifest.xsf and select to edit in notepad.
do a search and look for the following line. <xsfroperty
name="editability" type="string"
you will notice one of the properties on this line is set to "none" change
this to "partial", save the changes and close the file then right click on
the manifest.xsf and select Design you shoul dnow find the entire schema is
editable.



Hope this helps
Cheers
Ben

 

[peddie]

Hi again
I managed to make the change in the properties to make it repeatable.
Now I have copied the script.js from Time Card template to my new time
card template but the script.js doesnt seem to work.

I am not a programmer so I would be much appreciated if you could
advice me what to do please? I want the calculation from Time Card
template to work on my new template too.

Many thanks in advance