Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do populate adobe livecycle drop down list,

Posted on 2013-01-11
6
Medium Priority
?
1,409 Views
Last Modified: 2013-02-07
From a data file, like excel,  I'd like to populate a livecycle drop down list with a field,  and then different data pop into a text object.

Datafile

Building1,  Address1
Building2, Address2
Building3, Address3

In drop downlist, I'd like to list the buildings.   ONce one is selected, I'd like the corresponding address in the datafile to populate a text object on the same page.     Thanks.
0
Comment
Question by:rjablonk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 38769936
Do you want to do this once (when you design the form), or does the data need to come from a database every time  the user opens the form?
0
 

Author Comment

by:rjablonk
ID: 38770176
For now just need to load the table once but it would be good to know both ways
0
 
LVL 17

Expert Comment

by:Dushan De Silva
ID: 38773018
You can use simply use array, building as key and address as value.

[Building1] ->  'Address1',
[Building2] ->  'Address2',
[Building3] ->  'Address3',
0
Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

 

Author Comment

by:rjablonk
ID: 38773196
Thanks. Can you write sample code line or 2 demonstrating that?   Thx
0
 
LVL 17

Accepted Solution

by:
Dushan De Silva earned 2000 total points
ID: 38773264
Following will explain CSV to array. (Or else let me know exact data format)
http://stackoverflow.com/questions/1293147/javascript-code-to-parse-csv-data

Following will show how to show Array on Drop down list on PDF using Adobe Livecycle.
http://forums.adobe.com/message/4362597
0
 

Author Comment

by:rjablonk
ID: 38866418
Dushan911,

Thanks for your post,  the manual array works great.   I am a little confused on how to create the array from the CSV.

AFter copying the csvtoarray function into my livecycle, I ran the following command from the same page:

var worksite = new Array(CSVToArray( "c:\worksite.csv", "," ));

with the hope that the 5 X 5 csv file would create a similar array in adobe.  Is there an example of using the CSV to Array in LiveCycle that you could show me?
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show, step by step, how to integrate R code into a R Sweave document
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question