Data entry from an excel file

[tweyandt]

I am new at scripting and not very good. I have a problem, I need to get over 14,000 clients put into this application via data entry. I have the data I need in an excel spread sheet. I have created a script to open up the excel spreadsheet and then ask how many records you want to process. After it gets the first row and puts the data into variables is goes to a subroutine that positions the cursor to the correct field and puts that variable in the field and goes on to the next positions doing the same and then saves the new customer record and sets up for the next new customer. That part works fine the first time around. The second time around it gets the next row and puts the data into variables and goes to the subroutine to fill in the screen again. This time however sometimes is skips fields or puts two variables into one field and I can't figure out why it works the first time around but not the second. Can anyone help? Please!

Add Customers.scp

[hagchr]

Hi,

Not sure if the issue but I note that towards the end of the loop you have
Press LCTRL
Press LALT
Press LALT

Not sure if you need them for the script but if you do then I think you need to Release them (Release>LCTRL Release>LALT...) or LALT and LCTRL will be active/pushed when you go to the second round in the loop.

You also have Press LShift * 5 and LShift * 2 - does that trigger anything in the App? or can be removed?

Also I note you do a lot of clicking to find the input fields in the app. Is it possible to move between the fields using TAB?