@@markelliot2994 ha. Yea I noticed. The video has stood the test of time. I’m not sure if that speaks higher of your video, or lower of Adobe since the issue your addressing is still present (and anything but intuitive). Regardless, this semi-ancient video got me out of a bind and I appreciate you sharing it.
@@TangleWireTube Again thank you for your kind words. I am sure it was created because someone from a class I taught asked about it. Also, I am sure I was just the mid-wife of the information, as I probably didn't figure it out on my own, so kudos to the original folks who helped me!
Exactly...thanking God I mean...I am just mid-wife of information...thankfully this still works I hope, it's been a long time. Glad I could help, heaven knows I learn something everyday...Have a great spring!
Hi Mark, It's me again. I have test all this and works nicely as expected. Ive got a question maybe u can help. I've created the form with several text fields. For example the form structure is as follows: - field 1 - filed 2 - field 3 - field 4 When I received the form and convert it to Excel, the field order/showing in Excel is all over the place - not like the form structure. - field 2 - field 1 - field 4 - field 3 My question is, how do you keep the order of the field just like the form structure after it have been converted to Excel? Field1- Field 4 instead of all over the place - 2,1,4,3 😕 Do u modify this in PDF or Excel? I know u can cut n paste in excel but no, I want it t be automatic. Hope u get my drift and thank u for the tut 😎
hmmm...something to try...can you change the field names to "F1" "F2" ect to see if Excel is being mislead in alphabetizing the order? Or maybe extra spaces in the naming of the 'fields'?
I think I know what was the problem. I have re-created the form - edit and re-arrange the fields in acrobat making sure all they are in the correct order as in PDF. Click send and Voila ! , all data come in the correct order in excel. 😁
Hello Mark, this is great! I tried it on a pdf and worked the first time, but after that I only get my form header and nothing else. I have been working on this and cant figure out how to get it to work, any suggestions? Does your original form need to be set up so that it shows a highlight in the area to be filled out? My form looks like black and white, no highlight in the area to be filled out. Any suggestion is appreciated!!
@@markelliot2994 been struggling with this for a few hours, lol, I'm determined! Now it seems to only be importing the name of the file and nothing else. I select 5 files to merge into the CVS, then when I look at the CVS file it only show the 5 filenames of the pdf and no data from the pdf
so it looks like this might be possible.. but i am wondering if i need to create the form in Adobe Indesign.. or can i use Acrobat Pro form creator? When i tested one of my scholarship application forms i made in acrobat, the fields did not quite merge correctly into columns
Greetings, I am only familiar with using InDesign, but here is a link I found to the Adobe Acrobat webpage talking about forms, hope it helps: acrobat.adobe.com/us/en/acrobat/how-to/create-fillable-pdf-forms-creator.html by the way there a plethora of Acrobat user groups on the web that can probably answer your questions. good luck!
What if you wanted to have an ongoing spreadsheet? To better explain, I have employee files coming in multiple times a day and want to keep a running list of employee transactions one one spreadsheet. Any suggestions would be greatly appreciated.
Morning Adam, Unfortunately I am Adobe InDesign guy not Excel.....with that said, these are two highly rated sites: Good Luck, Mark SuperUser.com is the appropriate site for general Microsoft Excel questions, including those dealing with built in Excel features, functions, and formulae. For help with automation in Excel using VBA, including User-Defined Functions, then StackOverflow.com is probably a better resource
Morning! I personally don't have a vidoe on making forms, however if your search RU-vid for Indesign Forms, you will find many videos. Here is one for example: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DtivEou8U1M.html If you have any questions just drop me a reply Good luck!
Faraz Shaikh 2 days ago (edited) Hi Mark, Thank you for your feedback and a good question. I would suggest you watch this part 03:55 which demos to combine multiple PDF's Once you have the data into Power Query then you may load it Excel and create PivotTable for more analysis. If you are still facing the issue feel free to write back.
Hey! Great tutorial. Is it possible to return user data into an email without getting the actual PDF file itself back from the user? You know, just a simple HTML text email with the embedded data?
I have an Image Field in the student enrollment form where the student uploads their photo. I tried this method, I get all the other text data but the image field is missing in the csv file. Any idea how to solve this problem? I really need the images. Thanks in Advance!
My initial thought is the Field name is not formatted correctly: @student_image If you are using Excel, and it prompts you with an error while writing the field name with a “@“ up front, it is because you need to set the Excel cell to text type. Write a " ' " in front of the field name (i.e., "'@field_name") and, when you exit the Excel cell, make sure that you don't see the " ' " you just typed. Jagdish, try this link he does an awesome job of explaining and bet you can find your error...try another data doc with just two students and get that to work could you email me a sample excel file with a sample photo? mark@easelsolutions.com indesignsecrets.com/troubleshooting-data-merge-errors.php Above is a great site problem solving also redokun.com/blog/data-merge-indesign
i'm doing this w/acrobat pro 8, and it's exporting the fields in alpha order instead of tab order. In other words, if the form has Name, Address, City, State, the columns in the csv file come out Address, City, Name, State. How do I make it export the fields in the same order as is on the form?
I sorry I can't help to much because I don't use acrobat only InDesign to build the forms....I would search for the adobe acrobat support page and post the question...
ok thanks, man. I got it to work in a newer version of acrobat, but the one I have on my home computer is reading the form or writing the csv in a weird order. i'll look into it.
Sorry about not being able to help you directly in Acrobat...by the way here is a link to a great book, (little old but) on acrobat forms: it-ebooks.directory/book-047040017x.html
my pleasure, someone else had to share with me, like I tell my students @Easel Solutions, I am just a 'midwife' of information like Leonardo daVinci once said...Merry Christmas!
Maybe do an update. I hesitated because of the upload date in 2015. Ended up here cause all the new stuff is Poo (basically). In German Type in: „Datendateien Tabelle zusammen“ Thx Again :)
let me see what I can do...here's a link from adobe: documentcloud.adobe.com/link/acrobat/pdf-to-excel?x_api_client_id=adobe_com&x_api_client_location=pdf_to_excel