How to manipulate images

[alisaif]

Hi,

We do the following currently:

1. Scan the invoices
2. Save in folder "\GRAPHICS\PRODUCTS" with serial no of the invoice, let say "SI100105"
3. In form I apply the following code in order to display the invoices according to the serial no.

micode = allt(upper(This.value))
mpic = micode+'.jpg'
This.Parent.ItemImage.Picture = '\GRAPHICS\PRODUCTS\&mpic'
If ! File("&mpic")
This.Parent.ItemImage.Picture = '\GRAPHICS\PRODUCTS\no_image.jpg'
Endif

So, it is necessary to save the images exactly with the serial no.

Is it possible if I upload the image in the form, path should be saved somewhere in the table.

In this way the user will be free from saving the file according to the serial no. of the doc.

I hope I delivered what I am looking for.

Thanks!!

Saif

 

[Mike Lewis]

I think the way I would have handled this would be to say that, at the point where the user is dealing with the customers' complaints or comments, the user should first bring the original invoice to the screen. They then press a button to scan the second page. The system would then display the scanned-in image alongside the original invoice, so that they user can check they have scanned the correct page. Finally, the system would store the image in a way that maintains the link to the original.

The above is how I would approach the problem, but of course I don't know anything about the nature of your business, or how the employees work, or the customs in your industry and in your country.

That said, I would question the whole basis of the system. First, the idea that a customer acknowledges receipt of an invoice by sending back the second page of the physical document. I've never come across that system before. Why does the customer even need to acknowledge an invoice?

Also the idea that the customer uses that physical document to record under- or over-deliveries. That seems very hit and miss to me. I would let the customer register their complaint by whatever means is easiest for them, and for your users to then directly enter that information in the customer's records in the system. As it stands, all you have is an image of the complaint. It still needs to be interpreted and acted on in some way.

Have you considered letting the customer submit their complaint (and even their acknowledgement of receipt of the invoice) electronically, perhaps by entering details into your website? That way you eliminate all the paper-handling and scanning, not to mention greatly improving the accuracy of your data?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

I agree, all the paperwork could be done online. Maybe we just talk about a low rate of very conservate customers. Does their feedback perhaps even come in as a FAX?

You could also consider using standard software for both document management and for customer relation management, unless that's what your own software already is and you want to extend.

Bye, Olaf.

 

[alisaif]

About the quantity: Does this happen to all invoices or just the complaints?
I ask because of the value of the effort to spare the assignment of the invoiice number

Secondly, you say employees "open the image one by one in order to refer a particular invoice."

I assumed the invoices are already named when they are scanned by your employeesand that's the point of interest to you.
Perhaps we should judge only after knowing: How many new scans do you need to process per day?

ADF = Batch Scanner

Thanks

Saif

 

[Olaf Doschke]

OK, fine, one of 3 questions answered.

Bye, Olaf.

 

[HuHe456]

https://www.universalthread.com/ShowHeaderArticleOneItem.aspx?ID=39125

 

[Scott24x7]

Alisaif,
If this happens after the invoice is printed, and you're scanning the paper, you could use an OCR to read the SN# from the scanned image. It would be very easy to narrow down, if your invoice # always appears in the same location of the page. We use and OCR (Transym) which I can highly recommend for this, with our own imaging. Then you can do something like the following:

1) Scan the document
2) OCR the text
3) Extract the SN#
4) Save the scanned image as lcSNumber (the variable that holds the SN# you just extracted) to (lcSNumber)+".jpg" (use the SNumber extracted as the file name, you can add path as needed).
5) Store the full path and filename of the .jpg in a memo field in your table, so that when you reference it later, you just pass that value to the image object control.

Done
No manual entry, scan of a printed doc is going to be reasonably clear so that it recognizes the text accurately.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[alisaif]

Thanks for Mr.Scott, Idea seems to be very good. How can i use OCR (Transym), is it a device or software?

Saif

 

[Olaf Doschke]

Alsaif, it's a software, I also already pointed you to thread184-1754724, you seem not to have read that.

Bye, Olaf.

 

[Scott24x7]

Alisaif,
Transym OCR (TOCR) is a software, a set of DLL that work really nicely. We use EZTwain (full version which is not cheap, but there are other versions available). TOCR fits in with just 1 or two lines of code. The scanning and prepping is the bigger issue.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[alisaif]

Thanks Mr.Scott, I will try that and Sorry Mr.Olaf, I missed that reply of 28th Feb.

Saif