hello.
i new xml , new livecycle designer, have acclimated rather well.
here want do:
1) create pdf fill-in-form (including various fields...text, numeric, radio buttons, , formcalc functions)
2) create submit button emails xml file form administrator
3) use ms excel import xml files pre-mapped fields
basically, not have server database support, , best workaround (and functional) come with.
after mapping fields in excel, exported *.xsd , created new data connection within livecycle. then, linked schema fields bindings - corrected errors, , have tested form (form1). made submit button - that's good, too. when import xml excel - that's have problem, , it's not issue excel knowledge, rather how form generates xml output.
for example, have 25 fields outputted via xml. pdf form consists of 4 pages (8.5" x 11"). when created form , got end of page, "inserted new page" , went on merry way. when import xml, excel maps fields, however, not import info single row. have discovered since pdf form consists of 4 pages (each bound "sheet[*]"), xml output looks following:
example of xml output form:
...
<form1>
<sheet>
<submissionid xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>743</submissionid>
<reviewerid xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>234</reviewerid>
<date xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>24/01/2008</date>
</sheet>
<sheet>
<tag1>input</tag1>
<tag2>input</tag2>
</sheet>
</form1>
wherever there "<sheet>" tag (hence new page in pdf document), excel puts data on new row. fields within form1 imported , mapped correct field, importing single xml file occur on 4 rows (since pdf form on 4 sheets).
i bound each "page" "sheet[*]" because way knew how use formcalc calculations fields occur @ different places throughout document.
so, have tried clear possible, , suggestions/help how control xml output livecycle document. have taken xml output , changed in notepad remove instances of <sheet>/</sheet> except 1 that fixes "problem" , excel maps fields correctly , in single row.
i love on rather specific problem. guess it's basic issue experience help.
thank much!!
jim
i new xml , new livecycle designer, have acclimated rather well.
here want do:
1) create pdf fill-in-form (including various fields...text, numeric, radio buttons, , formcalc functions)
2) create submit button emails xml file form administrator
3) use ms excel import xml files pre-mapped fields
basically, not have server database support, , best workaround (and functional) come with.
after mapping fields in excel, exported *.xsd , created new data connection within livecycle. then, linked schema fields bindings - corrected errors, , have tested form (form1). made submit button - that's good, too. when import xml excel - that's have problem, , it's not issue excel knowledge, rather how form generates xml output.
for example, have 25 fields outputted via xml. pdf form consists of 4 pages (8.5" x 11"). when created form , got end of page, "inserted new page" , went on merry way. when import xml, excel maps fields, however, not import info single row. have discovered since pdf form consists of 4 pages (each bound "sheet[*]"), xml output looks following:
example of xml output form:
...
<form1>
<sheet>
<submissionid xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>743</submissionid>
<reviewerid xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>234</reviewerid>
<date xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
>24/01/2008</date>
</sheet>
<sheet>
<tag1>input</tag1>
<tag2>input</tag2>
</sheet>
</form1>
wherever there "<sheet>" tag (hence new page in pdf document), excel puts data on new row. fields within form1 imported , mapped correct field, importing single xml file occur on 4 rows (since pdf form on 4 sheets).
i bound each "page" "sheet[*]" because way knew how use formcalc calculations fields occur @ different places throughout document.
so, have tried clear possible, , suggestions/help how control xml output livecycle document. have taken xml output , changed in notepad remove instances of <sheet>/</sheet> except 1 that fixes "problem" , excel maps fields correctly , in single row.
i love on rather specific problem. guess it's basic issue experience help.
thank much!!
jim
it sounds there's no "sheet" element in xsd. don't bind page-level subforms data node. set binding "none".
More discussions in LiveCycle pre-ES (6.x and 7.x) discussions
adobe
Comments
Post a Comment