2 Replies Latest reply: Sep 4, 2014 1:13 PM by Frolnocx RSS

    Import Data help

    Frolnocx Community Member

      I'm working on a document that I need to import data from a spreadsheet. I'm getting hung up on something that seems so simple and I can't find any information on the subject. I'm creating a .pdf that someone will need to import data into from excel. I'm testing this out and the .txt file has multiple rows that need to be input. With the import you can only import one row at a time. I'm fine with that but how do I tell my form fields to accept different rows?

       

      Example: I have column A, B and C. Each column has 15 rows. So my document needs these rows to populate as well. I can only imagine I'm doing something wrong here but I've named the form fields A 1, A 2, A 3 and so on and so forth. They are different values so I can't name them the same.

       

      Any advice or direction to a solution would be grateful. Thanks you.

        • 1. Re: Import Data help
          George_Johnson CommunityMVP

          Are you importing the form data manually or with JavaScript? Do you want one row in the table in the form to correspond to one row in the data file? Will your users be using Acrobat or just Reader?

          • 2. Re: Import Data help
            Frolnocx Community Member

            Okay so my boss will be using this and he is on Acrobat Pro XI. It will be manually as I don't know JavaScript

             

            And what I'm looking for is 1 column of data with multiple rows.Screen Shot 2014-09-04 at 3.06.28 PM.png

             

            Here is a screen cap of the excel document. This is just a sample I'm using to test. My boss will be working with a file close to this one. So what I'm referring to would be column B, for example, has different values in rows 2-6. In the final .pdf I need all of those values to fill separate form fields. That's what I'm getting hung up on.

             

            Hopefully this is enough info. Let me know if I need to provide more information. Thanks.