Skip navigation
Currently Being Moderated

Data from excel or xml into livecycle designer form

Mar 31, 2011 3:38 PM

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

 
Replies
  • Currently Being Moderated
    May 3, 2011 5:34 PM   in reply to CDesign2

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

     
    |
    Mark as:
  • Currently Being Moderated
    May 4, 2011 4:03 AM   in reply to CDesign2

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

     

    Regards--

    Chalukya.                                           

     

     

     
    |
    Mark as:
  • Currently Being Moderated
    May 12, 2011 12:28 AM   in reply to CDesign2

    Hi ,

     

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

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 1, 2011 12:57 PM   in reply to CDesign2

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 3, 2011 3:05 PM   in reply to CDesign2

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 3, 2012 4:16 PM   in reply to CDesign2

    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-workshe ets.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!

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points