8 Replies Latest reply: Aug 3, 2012 4:16 PM by Lisa McClure RSS

    Data from excel or xml into livecycle designer form

    CDesign2 Community Member

      Hi

       

      I have an excel spreadsheet set up to calculate average, count, max and min of some data that will be regularly altered.

       

      I would like to connect the spreadsheet cells to my form sop that this calculated data is imported into my form (created in Livecycle Designer).

       

      I have looked at numerous pages explaining connecting to databases but don't seem to be able to translate this information to relate to excel.  Could someone please help me connect these single cell pieces of data from Excel spreadsheet to my form.

       

      Thanks

       

      Hi again

       

      I am now looking at eporting the data as an xml file from excel in an attempt to make this work.  It seems to me that this should/could be possible but is just out of my grasp.  When I think I find the answer it does not hold enough detail for me to follow through with making it work

       

      Can anyone steer me in the right direction.

       

      Thanks again

       

      Message was edited by: CDesign2

        • 1. Re: Data from excel or xml into livecycle designer form
          ReeseTurner Community Member

          Did you ever get assistance with this?  I need to perform a similar function.

          • 2. Re: Data from excel or xml into livecycle designer form
            CDesign2 Community Member

            No I have not had any responses but am still keen to find an answer

            • 3. Re: Data from excel or xml into livecycle designer form
              chalukya Community Member

              Are you able to bind the XML data with your Form ?    

               

              Regards--

              Chalukya.                                           

               

               

              • 4. Re: Data from excel or xml into livecycle designer form
                CoolSun_Sunil Community Member

                Hi ,

                 

                      In order to connect a LiveCycleForm to xls Sheet (or any other database) it needs the Reader Extension Credential .

                • 5. Re: Data from excel or xml into livecycle designer form
                  Mike-Davies Community Member

                  If you designed the original form (from which the xml/excel data was created) as pdf, it is straight forward as if reintegrating data back into the form.  I suspect that may not be the case in your situation.  However, try to save the excel/xml document as a pdf document.  Then using adobe reader or professional, open this document and Adobe will load the elements.  You may want to you use Adobe LiveCycle to edit or create a form and preview at the same time until you are satisfied. In that case open the saved pdf form in liveCycle.  Hope this helps.

                  • 6. Re: Data from excel or xml into livecycle designer form
                    CDesign2 Community Member

                    Thanks for responding Mike-Davies!

                     

                    I am trying to use DATA from say excel and use it to populate a form.  The

                    excel form would be updated and then hopefully so would the relevant areas

                    of the form, which would do other things with the data.  I am not sure

                    that what you have suggest will accomplish that....but maybe I am missing

                    your point

                    • 7. Re: Data from excel or xml into livecycle designer form
                      Mike-Davies Community Member

                      Hi CDesign2,

                       

                       

                      If I understood you correctly, you are either trying to

                      1. View your xml data in Adobe LiveCycle form to redit the form???
                      2. View your xml data in Adobe acrobat pro
                      3. Or wishing to collate updated(new) data into adobe (lifecycle) tracker and view the data set

                       

                      I suspect points 2, 3 may be the case.

                       

                      My experience with migrating excel data back to adobe is this.

                      If you created the original form with adobe, you have the option of distributing the form (file/form distribution..)

                      to recipients list (could include form creator).

                      This allows adobe to generate a distribution and form response file and therefore able to track returned forms either as pdf (preferably) or excel/xml converted back to pdf after saving it.

                       

                      For Point 2 above,assuming your original data set were created using an adobe form you previously saved, open your original form in acrobat pro, go to menu/forms/manage form data/import data (usually as xml). It automatically repopulates the form.

                       

                      OR

                       

                      To view returned forms as a set, go to menu/forms/compile returned forms and this will bring up a window that

                      requires you

                      -to browse and locate your response file (essentially defining the index form),which is opened into the top row

                      -then find and add each new completed form into a list in the second row.

                      You then click ok and all returned forms are opened in a tracker window...

                       

                      I just realised I am talking about liveCycle ES version8 and this forum refers to pre ES!

                       

                      I am not sure if this helps but I hope it answers some of your questions.

                      • 8. Re: Data from excel or xml into livecycle designer form
                        Lisa McClure Community Member

                        I'm working on this same thing today, and we are getting it to work.  First make sure that you define a data range for your Excel spreadsheet information.   Next, follow the instructions at:  http://www.ehow.com/how_12175930_connect-adobe-livecycle-excel-worksheets.html   After building the connection string in Step 3, be sure to select the Table radio option and select your data range from the dropdown list.   Hope this help!