Re: [ACFUG Discuss] passing a structure as wddx in url parameter. Any alternate method to avoid wddx?
Consider using a form post anyway to prevent caching of the data on the client and in the webserver logs. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] If liberty means anything at all, it means the right to tell people what they do not want to hear. -- George Orwell, 1945 On Aug 6, 2008, at 9:25 AM, Ajas Mohammed wrote: Thanks Mischa. Good suggestion, I will do that. I dont know what I was thinking, I guess I was not thinking at all ;-) . Its amazing how you get stuck to one idea and cannot see other options. Ajas. On 8/5/08, Mischa Uppelschoten ext 10 [EMAIL PROTECTED] wrote: I would only pass company_id and employee_no in the url and then run the query again to find the other info on your target system. I would agree that passing that amount of info through the url will not make you happy in the long run. If you can't run the query on the remote system, I would consider using a form post. /m : Hi there, : : I am using wddx to pass a structure as a url parameter. All I am doing is this : shown below, based on condition that query returns only 1 recordset : : cfoutput query=qryempdetails : :cfset st_Employee = structNew() : : cfset structInsert(st_Employee, company_id, company_id) : cfset structInsert(st_Employee, employee_no, employee_no) :cfset structInsert(st_Employee, employee_name, employee_name) : cfset structInsert(st_Employee, ee_id, employee_co_id) : cfset structInsert(st_Employee, manager_employee, manager_employee) :cfset structInsert(st_Employee, company_name, company_name) : cfset structInsert(st_Employee, email_address, email_address) : cfset structInsert(st_Employee, view_full, view_full) :cfset structInsert(st_Employee, phone, ss_phone) : cfset structInsert(st_Employee, hr_limit, hr_limit) : : /cfoutput : : Store this struct with wddx : : cfwddx : action=CFML2WDDX : input=#st_Employee# : output=thisUser : : The reason I had to do this is because from /A/B/test.cfm, I have to relocate : to /subApp/home.cfm and in /subApp/Application.cfm which gets called, i set : client vars using the wddx url var like this : : cfwddx : action=WDDX2CFML : input=#thisUser# : output=st_Employee : : and finally use it to set client vars. : : Is there a better/alternate way to achieve this? I heard wddx as url parameter : could be messy in the long run. : : Please advise. : -- : Ajas Mohammed / : http://ajashadi.blogspot.com : We cannot become what we need to be, remaining what we are. : No matter what, find a way. Because thats what winners do. : You cant improve what you dont measure. : Quality is never an accident; it is always the result of high intention, : sincere effort, intelligent direction and skillful execution; it represents : the wise choice of many alternatives. : - : To unsubscribe from this list, manage your profile @ : http://www.acfug.org?fa=login.edituserform : : For more info, see http://www.acfug.org/mailinglists : Archive @ http://www.mail-archive.com/discussion%40acfug.org/ : List hosted by FusionLink : - Mischa Uppelschoten The Banker's Exchange, LLC. 4200 Highlands Parkway SE Suite A Smyrna, GA 30082-5198 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web:www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN --- Original Message --- From: Ajas Mohammed [EMAIL PROTECTED] To: discussion@acfug.org Date: Tue, 5 Aug 2008 15:39:36 -0400 Subject: [ACFUG Discuss] passing a structure as wddx in url parameter. Any alternate method to avoid wddx? Hi there, I am using wddx to pass a structure as a url parameter. All I am doing is this shown below, based on condition that query returns only 1 recordset cfoutput query=qryempdetails cfset st_Employee = structNew() cfset structInsert(st_Employee, company_id, company_id) cfset structInsert(st_Employee, employee_no, employee_no) cfset structInsert(st_Employee, employee_name, employee_name) cfset structInsert(st_Employee, ee_id, employee_co_id) cfset structInsert(st_Employee, manager_employee, manager_employee) cfset structInsert(st_Employee, company_name, company_name) cfset structInsert(st_Employee, email_address, email_address) cfset structInsert(st_Employee, view_full, view_full) cfset structInsert(st_Employee, phone, ss_phone) cfset structInsert(st_Employee, hr_limit, hr_limit) /cfoutput Store this struct with wddx cfwddx action=CFML2WDDX input=#st_Employee# output=thisUser The reason I had to do this is because from /A/B/test.cfm, I have to relocate to /subApp/home.cfm and in /subApp/Application.cfm which gets called, i set client vars using the wddx url var like this cfwddx action=WDDX2CFML input=#thisUser# output=st_Employee
[ACFUG Discuss] CF8 PDFs
I just got out of a meeting and came here to ask the ACFUG while I did some research on my own and coincidentally enough tonight's meeting looks like it is going to cover my exact question. The problem with that is that there is no way that I will be able to attend the meeting tonight. I also saw mention of it being recorded, so I am going to try and watch that once the details are posted. I figured that it couldn't hurt to still ask my questions since I am researching this still anyways to report back this afternoon on if what we need to do is possible and easier in CF8 than CF7. Basically, the situation is this: We get POs from a customer that come in the form of a PDF. Until this point, accounting has been entering the information from the PO into a db by hand. I know that CF8 added many PDF enhancements and was wondering if you can extract information from a pdf to import into a db. The point being, trying to improve accuracy to 100%. Currently we use CF7 and when I presented that as a possibility, I was told we could have CF8 by the end of the week if this were possible. Otherwise, I think the approach I am going to have to take is converting to a text file and then using regular expression to pull the needed info out and then save that to the db. I am not trying to play spoiler to tonight's meeting, but can anyone give some feedback on the feasibility of CF8 to do what I need? If it can't, does anyone have a better suggestion than the convert to text and then using regular expression to accomplish this goal with CF7? Thanks, Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] cfqueryparam for application or session scoped variables
I'm using QueryParam Scanner to identify any potential vulnerabilities. It is flagging code that uses application or session scoped variables such as: WHERE DeptID = #Application.DeptID# ORDER BY Lastname Should Application.DeptID be cfqueryparamed? What about: WHERE PersonID = #GetAuthUser()# Thanks, Sam - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] cfqueryparam for application or session scoped variables
Even though you have a solid idea that those scoped variables won't be messed with, why wouldn't you use CFQUERYPARAM anyway? There is more benefit to using it than just protecting against vulnerabilities. - Original Message From: Sam Singer [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, August 6, 2008 12:40:15 PM Subject: [ACFUG Discuss] cfqueryparam for application or session scoped variables I'm using QueryParam Scanner to identify any potential vulnerabilities. It is flagging code that uses application or session scoped variables such as: WHERE DeptID = #Application.DeptID# ORDER BY Lastname Should Application.DeptID be cfqueryparamed? What about: WHERE PersonID = #GetAuthUser()# Thanks, Sam - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] cfqueryparam for application or session scoped variables
Thanks guys, that answers my question. On Aug 6, 2008, at 11:48 AM, shawn gorrell wrote: Even though you have a solid idea that those scoped variables won't be messed with, why wouldn't you use CFQUERYPARAM anyway? There is more benefit to using it than just protecting against vulnerabilities. - Original Message From: Sam Singer [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, August 6, 2008 12:40:15 PM Subject: [ACFUG Discuss] cfqueryparam for application or session scoped variables I'm using QueryParam Scanner to identify any potential vulnerabilities. It is flagging code that uses application or session scoped variables such as: WHERE DeptID = #Application.DeptID# ORDER BY Lastname Should Application.DeptID be cfqueryparamed? What about: WHERE PersonID = #GetAuthUser()# Thanks, Sam - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
re[2]: [ACFUG Discuss] passing a structure as wddx in url parameter. Any alternate method to avoid wddx?
: I didnt know, you cannot send structure var in form post. So I guess I have to: use wddx. You can use wddx and plop it all in one field as a piece of text, or you can take apart your structure and send all your fields individually: cfhttp method="post" url="" port="8500" throwonerror="Yes" cfhttpparam name="company_id" type="FormField" value="abc" cfhttpparam name="employee_id" type="FormField" value="232" /cfhttp This will result in a neat structure (form) on the receiving end. Just think of it as your CF server acting as a browser: a struct (or object or query etc.) cannot exist in a browser, it only exists on the server and as such, CF cannot post that variable to another page. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF8 PDFs
Are you receiving PDF documents or PDF forms? Tonight I will cover how to use CF 8 to get data from PDF forms, however, I will not cover how to get data out of PDF documents because PDF documents don't have a data structure from which to get data. You can, however, obtain the text of a PDF using CF 8. It's not a built-in tag option, but Raymond Camden's PDFUtils CFC (see http://pdfutils.riaforge.org; note that rather than using the GetPage method, I recommend you use cfpdf action=merge and use only one sub cfpdfparam tag, which has the net result of extracting pages from the specified PDF) has a GetText method that uses DDX to extract all the text of a PDF document. Josh From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Wednesday, August 06, 2008 12:06 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF8 PDFs I just got out of a meeting and came here to ask the ACFUG while I did some research on my own and coincidentally enough tonight's meeting looks like it is going to cover my exact question. The problem with that is that there is no way that I will be able to attend the meeting tonight. I also saw mention of it being recorded, so I am going to try and watch that once the details are posted. I figured that it couldn't hurt to still ask my questions since I am researching this still anyways to report back this afternoon on if what we need to do is possible and easier in CF8 than CF7. Basically, the situation is this: We get POs from a customer that come in the form of a PDF. Until this point, accounting has been entering the information from the PO into a db by hand. I know that CF8 added many PDF enhancements and was wondering if you can extract information from a pdf to import into a db. The point being, trying to improve accuracy to 100%. Currently we use CF7 and when I presented that as a possibility, I was told we could have CF8 by the end of the week if this were possible. Otherwise, I think the approach I am going to have to take is converting to a text file and then using regular expression to pull the needed info out and then save that to the db. I am not trying to play spoiler to tonight's meeting, but can anyone give some feedback on the feasibility of CF8 to do what I need? If it can't, does anyone have a better suggestion than the convert to text and then using regular expression to accomplish this goal with CF7? Thanks, Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] CF8 PDFs
I'm assuming that at some point in the process that the PO is a PDF form since the PDF document is fairly static, but when we get it, it is just a PDF document. That is kind of what made me ask the questionl. It is definitely in a statc format (which is also why I thought about converting to text and using some regular expressions to extract the data). So, I thought that with that being the case, CF8 may have some new PDF utilities to help in the process. I'll have to consult with my team and see if maybe we can get a copy of the PDF form rather than the document because obviously there are different approaches to handling this based on which format we recieve the data. Thanks. On Wed, Aug 6, 2008 at 1:22 PM, Josh Adams [EMAIL PROTECTED] wrote: Are you receiving PDF documents or PDF forms? Tonight I will cover how to use CF 8 to get data from PDF forms, however, I will not cover how to get data out of PDF documents because PDF documents don't have a data structure from which to get data. You can, however, obtain the text of a PDF using CF 8. It's not a built-in tag option, but Raymond Camden's PDFUtils CFC (see http://pdfutils.riaforge.org; note that rather than using the GetPage method, I recommend you use cfpdf action=merge and use only one sub cfpdfparam tag, which has the net result of extracting pages from the specified PDF) has a GetText method that uses DDX to extract all the text of a PDF document. Josh *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Wednesday, August 06, 2008 12:06 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] CF8 PDFs I just got out of a meeting and came here to ask the ACFUG while I did some research on my own and coincidentally enough tonight's meeting looks like it is going to cover my exact question. The problem with that is that there is no way that I will be able to attend the meeting tonight. I also saw mention of it being recorded, so I am going to try and watch that once the details are posted. I figured that it couldn't hurt to still ask my questions since I am researching this still anyways to report back this afternoon on if what we need to do is possible and easier in CF8 than CF7. Basically, the situation is this: We get POs from a customer that come in the form of a PDF. Until this point, accounting has been entering the information from the PO into a db by hand. I know that CF8 added many PDF enhancements and was wondering if you can extract information from a pdf to import into a db. The point being, trying to improve accuracy to 100%. Currently we use CF7 and when I presented that as a possibility, I was told we could have CF8 by the end of the week if this were possible. Otherwise, I think the approach I am going to have to take is converting to a text file and then using regular expression to pull the needed info out and then save that to the db. I am not trying to play spoiler to tonight's meeting, but can anyone give some feedback on the feasibility of CF8 to do what I need? If it can't, does anyone have a better suggestion than the convert to text and then using regular expression to accomplish this goal with CF7? Thanks, Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] CF8 PDFs
Additionally, (like Word is) PDF has been a binary format for some time now so pulling that data out isn't going to be as simple as using a regex. On Wed, Aug 6, 2008 at 2:35 PM, Josh Adams [EMAIL PROTECTED] wrote: Here's a question for you: if the data came back in a Word document, how would you get the data out? You would have to pull out all the text and parse it, right? A PDF document is no different. -- Howard Fore, [EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] CF8 PDFs
Ok, I took your advice from your first post and converted it to text and dumped it just to see what I would be dealing with. I understand what you are saying about pulling structured data from an unstructured source. I guess my thought was if the the document was created from a form, that there may be a way to pull the form fields out once the document had been created and the answer is no. Thanks again for the help. I downloaded the suggested utilities and played with them some and it will obviously be much easier if we can get the form submission and work from there in CF8. Otherwise it looks like I'll be dealing with the beast of converting to text and parsing which I guess can be done using CF7 still if the accounting department saves the pdf as text before uploading, which was the main question I was trying to answer. I'll present those options to them and let them decide. Thanks again. On Wed, Aug 6, 2008 at 2:35 PM, Josh Adams [EMAIL PROTECTED] wrote: If you can get the process changed such that what goes out is a PDF form that comes back to you populated, it will be very easy for you to work with that with CF 8. Here's a question for you: if the data came back in a Word document, how would you get the data out? You would have to pull out all the text and parse it, right? A PDF document is no different. We have implemented a lot of great functionality for working with PDF documents in CF 8—including the ability for you to process DDX that can do things like pulling all the text out of document—but there is no functionality for pulling structured data out of an unstructured document because doing such is impossible (or, technically, it's document-dependent which makes it impossible for us to build the functionality—however, you can still build the functionality yourself for your own documents). Josh *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Wednesday, August 06, 2008 2:22 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] CF8 PDFs I'm assuming that at some point in the process that the PO is a PDF form since the PDF document is fairly static, but when we get it, it is just a PDF document. That is kind of what made me ask the questionl. It is definitely in a statc format (which is also why I thought about converting to text and using some regular expressions to extract the data). So, I thought that with that being the case, CF8 may have some new PDF utilities to help in the process. I'll have to consult with my team and see if maybe we can get a copy of the PDF form rather than the document because obviously there are different approaches to handling this based on which format we recieve the data. Thanks. On Wed, Aug 6, 2008 at 1:22 PM, Josh Adams [EMAIL PROTECTED] wrote: Are you receiving PDF documents or PDF forms? Tonight I will cover how to use CF 8 to get data from PDF forms, however, I will not cover how to get data out of PDF documents because PDF documents don't have a data structure from which to get data. You can, however, obtain the text of a PDF using CF 8. It's not a built-in tag option, but Raymond Camden's PDFUtils CFC (see http://pdfutils.riaforge.org; note that rather than using the GetPage method, I recommend you use cfpdf action=merge and use only one sub cfpdfparam tag, which has the net result of extracting pages from the specified PDF) has a GetText method that uses DDX to extract all the text of a PDF document. Josh *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Wednesday, August 06, 2008 12:06 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] CF8 PDFs I just got out of a meeting and came here to ask the ACFUG while I did some research on my own and coincidentally enough tonight's meeting looks like it is going to cover my exact question. The problem with that is that there is no way that I will be able to attend the meeting tonight. I also saw mention of it being recorded, so I am going to try and watch that once the details are posted. I figured that it couldn't hurt to still ask my questions since I am researching this still anyways to report back this afternoon on if what we need to do is possible and easier in CF8 than CF7. Basically, the situation is this: We get POs from a customer that come in the form of a PDF. Until this point, accounting has been entering the information from the PO into a db by hand. I know that CF8 added many PDF enhancements and was wondering if you can extract information from a pdf to import into a db. The point being, trying to improve accuracy to 100%. Currently we use CF7 and when I presented that as a possibility, I was told we could have CF8 by the end of the week if this were possible. Otherwise, I think the approach I am going to have to take is converting to a text file and then using
RE: [ACFUG Discuss] CF8 PDFs
I'm a bit confused. I have been working a bit with pdf forms in Acrobat 8, and was under the impression that the fields could do a dump of just that data and potentially in a comma-delimited format IF the original pdf was designed to do so. Is this not true? Donna M. Martin Applications Developer/Analyst, Sr Pathology Laboratory Medicine N251 EUH Annex Building Phone: 404-727-5918 Pager:404-686-5500 x15657 email:[EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Josh Adams Sent: Wednesday, August 06, 2008 2:36 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CF8 PDFs If you can get the process changed such that what goes out is a PDF form that comes back to you populated, it will be very easy for you to work with that with CF 8. Here's a question for you: if the data came back in a Word document, how would you get the data out? You would have to pull out all the text and parse it, right? A PDF document is no different. We have implemented a lot of great functionality for working with PDF documents in CF 8-including the ability for you to process DDX that can do things like pulling all the text out of document-but there is no functionality for pulling structured data out of an unstructured document because doing such is impossible (or, technically, it's document-dependent which makes it impossible for us to build the functionality-however, you can still build the functionality yourself for your own documents). Josh From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Wednesday, August 06, 2008 2:22 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CF8 PDFs I'm assuming that at some point in the process that the PO is a PDF form since the PDF document is fairly static, but when we get it, it is just a PDF document. That is kind of what made me ask the questionl. It is definitely in a statc format (which is also why I thought about converting to text and using some regular expressions to extract the data). So, I thought that with that being the case, CF8 may have some new PDF utilities to help in the process. I'll have to consult with my team and see if maybe we can get a copy of the PDF form rather than the document because obviously there are different approaches to handling this based on which format we recieve the data. Thanks. On Wed, Aug 6, 2008 at 1:22 PM, Josh Adams [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Are you receiving PDF documents or PDF forms? Tonight I will cover how to use CF 8 to get data from PDF forms, however, I will not cover how to get data out of PDF documents because PDF documents don't have a data structure from which to get data. You can, however, obtain the text of a PDF using CF 8. It's not a built-in tag option, but Raymond Camden's PDFUtils CFC (see http://pdfutils.riaforge.orghttp://pdfutils.riaforge.org/; note that rather than using the GetPage method, I recommend you use cfpdf action=merge and use only one sub cfpdfparam tag, which has the net result of extracting pages from the specified PDF) has a GetText method that uses DDX to extract all the text of a PDF document. Josh From: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Howard Sent: Wednesday, August 06, 2008 12:06 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] CF8 PDFs I just got out of a meeting and came here to ask the ACFUG while I did some research on my own and coincidentally enough tonight's meeting looks like it is going to cover my exact question. The problem with that is that there is no way that I will be able to attend the meeting tonight. I also saw mention of it being recorded, so I am going to try and watch that once the details are posted. I figured that it couldn't hurt to still ask my questions since I am researching this still anyways to report back this afternoon on if what we need to do is possible and easier in CF8 than CF7. Basically, the situation is this: We get POs from a customer that come in the form of a PDF. Until this point, accounting has been entering the information from the PO into a db by hand. I know that CF8 added many PDF enhancements and was wondering if you can extract information from a pdf to import into a db. The point being, trying to improve accuracy to 100%. Currently we use CF7 and when I presented that as a possibility, I was told we could have CF8 by the end of the week if this were possible. Otherwise, I think the approach I am going to have to take is converting to a text file and then using regular expression to pull the needed info out and then save that to the db. I am not trying to play spoiler to tonight's meeting, but can anyone give some feedback on the feasibility of CF8 to do what I
Re: [ACFUG Discuss] CF8 PDFs
I think (Josh please correct me) that the availability of the data in the final PDF file has more to do with how the PDF was created. If you just use a PDF printer to create the file your data isn't available, but my understanding was that if you used a PDF form on in the input side then the data is still in those form fields in the binary file and thus extractable. Otherwise I don't see what the excitement would be about with PDF workflows in Livecycle. On Wed, Aug 6, 2008 at 3:14 PM, Jeff Howard [EMAIL PROTECTED] wrote: Ok, I took your advice from your first post and converted it to text and dumped it just to see what I would be dealing with. I understand what you are saying about pulling structured data from an unstructured source. I guess my thought was if the the document was created from a form, that there may be a way to pull the form fields out once the document had been created and the answer is no. -- Howard Fore, [EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
re[2]: [ACFUG Discuss] CF8 PDFs
It is not necessary to use a true PDF form (with identified fields and values) to be able to extract text from it. I just printed a PO from our system using an open source PDF printer and then converted it back into Excel. There are some applications that use a bitmap format like tiff or jpg as an intermediary to produce a PDF. Documents from these systems could obviously not easily be converted back into text. /m : I think (Josh please correct me) that the availability of the data in the: final PDF file has more to do with how the PDF was created. If you just use a: PDF printer to create the file your data isnt available, but my understanding: was that if you used a "PDF form" on in the input side then the data is still: in those form fields in the binary file and thus extractable. Otherwise I: dont see what the excitement would be about with PDF workflows in Livecycle.: : On Wed, Aug 6, 2008 at 3:14 PM, Jeff Howard [EMAIL PROTECTED] wrote:: : Ok, I took your advice from your first post and converted it to text and: dumped it just to see what I would be dealing with. I understand what you: are saying about pulling structured data from an unstructured source. I: guess my thought was if the the document was created from a form, that there: may be a way to pull the form fields out once the document had been: created and the answer is no. : -- : Howard Fore, [EMAIL PROTECTED]: "The universe tends toward maximum irony. Dont push it." - Jeff Atwood: : - : To unsubscribe from this list, manage your profile @ : http://www.acfug.org?fa=login.edituserform : : For more info, see http://www.acfug.org/mailinglists : Archive @ http://www.mail-archive.com/discussion%40acfug.org/ : List hosted by FusionLink : -Mischa UppelschotenThe Banker's Exchange, LLC.4200 Highlands Parkway SESuite ASmyrna, GA 30082-5198Phone:(404) 605-0100 ext. 10Fax:(404) 355-7930Web:www.BankersX.comFollow this link for Instant Web Chat:http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN --- Original Message --- From:"Howard Fore" [EMAIL PROTECTED] To:discussion@acfug.org Date:Wed, 6 Aug 2008 15:39:08 -0400 Subject:Re: [ACFUG Discuss] CF8 PDFs I think (Josh please correct me) that the availability of the data in the final PDF file has more to do with how the PDF was created. If you just use a PDF printer to create the file your data isn't available, but my understanding was that if you used a "PDF form" on in the input side then the data is still in those form fields in the binary file and thus extractable. Otherwise I don't see what the excitement would be about with PDF workflows in Livecycle. On Wed, Aug 6, 2008 at 3:14 PM, Jeff Howard [EMAIL PROTECTED] wrote: Ok, I took your advice from your first post and converted it to text and dumped it just to see what I would be dealing with. I understand what you are saying about pulling structured data from an unstructured source. I guess my thought was if the the document was created from a form, that there may bea way to pull the form fields out once the document had been created and the answer is no.-- Howard Fore, [EMAIL PROTECTED]"The universe tends toward maximum irony. Don't push it." - Jeff Atwood- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] cfqueryparam for application or session scoped variables
Charlie could answer this best, but 'rule of thumb' if it can be rendered as part of an SQL statement (the variable parts as in this = #var#) then yes absolutely use cfqueryparam so you can specify var type, length etc.. (cfsqltype, maxlength, value etc...). That way you can block/filter bad/incomplete/incompatible requests. Catch/throw the errors (involves some work) - but his way you can ensure that someone can't answer 'yes I am' to a Boolean field (should have been caught elsewhere higher up, but this is just an example) On Wed, Aug 6, 2008 at 12:40 PM, Sam Singer [EMAIL PROTECTED] wrote: I'm using QueryParam Scanner to identify any potential vulnerabilities. It is flagging code that uses application or session scoped variables such as: WHERE DeptID = #Application.DeptID# ORDER BY Lastname Should Application.DeptID be cfqueryparamed? What about: WHERE PersonID = #GetAuthUser()# Thanks, Sam - To unsubscribe from this list, manage your profile @http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Darin Kohles RIA Developer - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -