Recognizing First- and Lastname

  • 46 Views
  • Last Post 4 days ago
zingix posted this 5 days ago

Hi Community,

The title of this question may sound easy. I have the following problem: given a sheet where staff members must write their first- and last name. Some of the staff members do exchange first- and last name (so a lookup is not successful). Is their any way to solve this (I have a SQL database containing all information)?

Ultimately, staff members can write their staff id and / or their key id on the sheet. My idea was to use on or both of this values to lookup the person. But again, sometimes none of the fields are given.

What would be they correct / a good way to solve this problem? Shall I write a web service where this four fields are sent to and a object containing the best match is returned? Any advices?

Regards,
Michael

Order By: Standard | Newest | Votes
Vladimir Dimitrijevic posted this 5 days ago

Hi Michael,

If you can use StaffId to find in database, that would be the best solution.

If employee switch FirstName and LastName and you can't find this combination in database, then check FirstName against LastName in database and vice versa. If you need to swap fields: 

http://help.abbyy.com/en-us/flexicapture/12/distributed_administrator/ifield 

 

You can also consider this, since it is ICR it may happen that you cannot recognize all letters so you can't find it in database. Then you can go with FuzzySearch, something like Ratcliff/Obershelp similarity or other... For example, employee first name is "Michael" but was recognized as "Mchael". If you compare "Mchael" against "Michael" it will not be matched. But if you use Fuzzy Search, you can get a percentage for each first name and then you will take the one with highest percentage.

 

Best regards,

Vladimir

zingix posted this 5 days ago

Hi Vladimir,

Thanks for your response. That's actually what I did so far. A lookup of the combination of the two fields using the integrated fuzzy logic. But this only works, if the staff member uses the right field for his first and last name.

In your first sentence you write: "If you can use StaffId to find in database, that would be the best solution." What are you referring to?

Regards,
Michael

Vladimir Dimitrijevic posted this 5 days ago

Hi Michael,

If you can compare Staff Id found on document against the Staff Id in database, that would be the ideal solution. There is only comparing Id against Id, not like comparing FirstName from document against First or Last from database... This is similar when you search for a Book on the internet, it is easier to find one by ISBN instead by book name, right? 

 

Please explain me how you used integrated fuzzy logic?

 

Best regards,

Vladimir

Vladimir Dimitrijevic posted this 5 days ago

Hi Michael,

If you are using database check rule, it will not help you in this case. In this is the case, you would have to create script rule and compare fields against the database from rule script instead of database check.

 

Best regards,

Vladimir

zingix posted this 4 days ago

Hi Vladimir,

Yes, I used the database check rule and linked two fields using the fuzzy option. This works quite nice if the names are not recognized 100 % at first but then are being looked up in the database.

I understand looking up an ID is simpler than a name. The problem here is, that most staff members do not know their staff id.

Do you have a sample script where two fields are looked up and validated against a database / web service?

Regards,
Michael

Close