Acrobat pdf form and Excel XML

P

Pete Cherry

Hello everyone,

I have written a spreadsheet for some data and a chart to display that data.
The data is over a two week period for shifts worked, sick leave days and
overtime shifts.

This is for administration staff to process.

The next step was I wrote a pdf form in Lifestyle designer. The form has a
layout for a two week period, the dates and columns for the information to
be put in by the supervisor. Then there is a button on it for the supervisor
to email the XML data to admin staff.

The spreadsheet and pdf form work well. It is a problem I have with the XML
data.

Once the original form was written, I has problems importing the data into
Excel. It created it's own map and layout for the data. I then tried to
write an XSD file. That worked initially.

The form will be filled out over a two week period, sometimes information
added twice a day. We do not have Acrobat writer on the workstations, only
reader. Some of the people who will put in the information have troubel
turning on a computer, let alone using excel. The easiest way for them is to
double click the pdf form on their desktop, fill in the form then press the
e-mail button. This process does most of the woirk for them.

Now the problem I have is after writing an XSD, the new schema does not
allow information to be mapped and appended, it will only allow new data to
be overwritten.
This then is a hassle as the form must be filled in completely before being
e-mailed, not a good option.

Any advice in whch way to go?
Thanks in advance,
Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top