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
Solved

Help with forms that look like PDF and populate form DB

Posted on 2014-10-08
9
236 Views
Last Modified: 2014-10-09
I am looking for a software that will allow me to create forms for a Web application.
Some of the forms data comes from a MS SQL database and should populate the form, the rest user should be able to type in the form and save it, then open it again and see all the information as it is was when they last saved it.

Does Adobe has any solutions that can do this ?  Any other provider ?
0
Comment
Question by:amucinobluedot
  • 4
  • 3
  • 2
9 Comments
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 333 total points
ID: 40369391
sharepoint comes to mind, depending on your infrastructure, it may be overkill.

adobe does offer form building functionality, if that's what you're familiar with, it's probably the best solution.

did you not want a classic asp solution?
0
 

Author Comment

by:amucinobluedot
ID: 40369451
what would classic asp solution be?
0
 
LVL 52

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 167 total points
ID: 40369452
The best way is to simply save the data back to the database.

If you are not great with html, you can use a forms builder like http://bootsnipp.com/forms or http://www.phpform.org/.   phpform will output code for php, just ignore it and replace with asp code to accept a form.

If you are not sure about how to accept form data, there are two parts, accepting the input (<%request.form("somefield")%>) and writing do the database.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:amucinobluedot
ID: 40369459
Don't get me wrong. I can create ASP pages that will gather the data from each form and save it in the database, that is all fine, the problem is at the end, the data needs to be presented in the exact way the PDF form from government looks like and generate a 2D bar code as well.
If I have all this information in my database already how can I export it to a PDF file and populate it with all this data ?  so that it can be emailed, printed 2D bar code created, etc.
0
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 333 total points
ID: 40369463
what would classic asp solution be?

to write the code yourself. I haven't come across any 3rd party classic asp form builders...

it's pretty straightforward, if you already have a connection to your database, you're half way there!

I guess before proceeding any further, what do you rate your skill set in classic asp? if you feel comfortable enough to tackle it on your own, I would suggest going that route. all to often form builders generate a lot of unnecessary code, creating your own you're able to keep it as clean as possible.
0
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 333 total points
ID: 40369464
ok that's good, sounds like you have most of it nailed down.

to create a pdf file, you'll need a 3rd party component, such as aspPDF
0
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 333 total points
ID: 40369468
I would first create your form, make sure it's saving/retrieving the data as it should, then once that's working, work on generating a pdf file. There's lots of questions on here that deal with pdf generation, or if you have a specific issue, just ask and I'm sure someone will be able to help you out.
0
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 167 total points
ID: 40371088
You can populate the a pdf dynamically using xml.   You can use adobe acrobat to create the form and fields.  You can generate static xml from that and use that to create your dynamic xml.    The other options is using  a pdf generator like  http://www.asppdf.com/ or http://www.websupergoo.com/abcpdf-1.htm.

If you want to do this on the fly without one of those tools, I generate the bar code with js/jquery.  There are a lot of options

https://github.com/lindell/JsBarcode
http://www.barcoderesource.com/htmlBarcode.shtml
http://www.jqueryscript.net/other/Simple-jQuery-Based-Barcode-Generator-Barcode.html

Check out http://www.telerik.com/kendo-ui#a-complete-framework-for-modern-web-and-mobile-app-development.  I think sencha has this too.  Kendo has some open source options but I think the barcode is not open source.
0
 

Author Comment

by:amucinobluedot
ID: 40371115
Thanks
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

789 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