Solved

Help with forms that look like PDF and populate form DB

Posted on 2014-10-08
9
240 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
[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
  • 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 53

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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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 53

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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Suggested Solutions

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
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…

739 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