Lookup [Solved]

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
noel
Posts: 25
Joined: June 16th, 2012, 7:32 pm
Location: Libreville, Gabon

Re: Lookup

Post by noel »

Dear Arkagwa,

There is a problem with your lookup file. For the first KANDA (Kati) I only find Dodoma as Mikoa. If you have a more completed lookup file it should work. If you have a more completed you publish and I will check.
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

Re: Lookup

Post by arkagwa »

My lookup file is okay. see attached
Attachments
Screenshot 2017-07-07 18.32.14.png
Screenshot 2017-07-07 18.32.14.png (137.53 KiB) Viewed 8156 times
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

Re: Lookup

Post by arkagwa »

My lookup file is okay. see attached. You can aslo use Txt program like notpad++ or wordpad to view it
sah
Posts: 97
Joined: May 28th, 2015, 3:16 pm

Re: Lookup

Post by sah »

Kindly check this for similar lookup function :
http://teleyah.com/cspro/SouthAfricaOct ... apter6.zip
noel
Posts: 25
Joined: June 16th, 2012, 7:32 pm
Location: Libreville, Gabon

Re: Lookup

Post by noel »

Dear arkagwa,

I have exported the lookup file you have posted with your application, the excel file of your lookup is attached. In this file, you can see the MKOA of each KANDA.

Kaskazini : Arusha
Kati : Dodoma
Kusini : Iringa
Magharibi : Katavi
Pwani : Dar es Salaam
Zanzibar : Kaskazini,Kusini,Mjini Magharibu
Ziwa: Geita

Finally, in the lookup file you posted only Zanzibar has more than one MKOA. As said yesterday, in your LOOKUP file, I don't find TABORA. If you have a more completed lookup file, you can post it.
TAWALA_LOOKUP_REC.xlsx
(53.85 KiB) Downloaded 297 times
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

Re: Lookup

Post by arkagwa »

Dear Members

The program load-cases which are not required when department and semester have been entered. I find the code okay but, i don't understand why why this is happening?? ​Kindly help i have attached it for checking .Example when i load department 05 from lookup file for semester 2 entered (052) i get also the list of course-codes from department 07 semester 2 such as TX102 and others

​I also wish to copy the course title from a selected ​course code. The current code does not match course title to corresponding course code. This means that the entry person can assign wrong title to a course code.

Find attached files
UG COURSES-version2.xlsx
(120.93 KiB) Downloaded 288 times
UG FORM.zip
(48.26 KiB) Downloaded 306 times
UG LOOKUP.rar
(29.94 KiB) Downloaded 293 times
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

Re: Lookup

Post by arkagwa »

Dear Josh

Hoe to use lookup file in android device!!!
I have managed to prepare CSEntry capi form in PC and i have generated .pen file. I have copied .pen and .pff files into android device. When i try data entry the variable (course-code) which is supposed to loadcases from lookup does not work.

What is the secret behind??
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Lookup

Post by josh »

You need to copy the lookup file to the Android device too.

The relative path from your application to the lookup file when running on the Android device has to be the same as it was on Windows. If you had the .ent, the .pff and the lookup file in the same directory on Windows, put them in the same directory on Android. If you had the lookup in a different folder on Windows then replicate the same folder structure on Android.
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

Re: Lookup

Post by arkagwa »

Dear Josh

Does not work ...im my PC i have UG FORM FOLDER, INSIDE IT THERE ARE TWO FOLDERS, UG FORM (for capi entry form) and UG LOOKUP (with lookup.dat and dictionary files).I have done similar to android tablet but lookup file does NOT loadcases.

see attached pictures
Screenshot 2017-07-29 17.17.21.png
Screenshot 2017-07-29 17.17.21.png (59.46 KiB) Viewed 8095 times
Screenshot_2017-07-29-17-47-23.png
Screenshot_2017-07-29-17-47-23.png (36.58 KiB) Viewed 8095 times
Screenshot_2017-07-29-17-41-35.png
Screenshot_2017-07-29-17-41-35.png (22.37 KiB) Viewed 8095 times
Screenshot 2017-07-29 17.17.21.png
Screenshot 2017-07-29 17.17.21.png (59.46 KiB) Viewed 8095 times
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Lookup

Post by josh »

That seems like it should work. If the lookup file works on Windows and doesn't work on Android I can only think of a few things that can go wrong:

1) Lookup file is not in the right folder on Android
2) Copied wrong version of lookup file to Android
3) Copied wrong version of pen file to Android (maybe didn't republish pen file after latest changes)
4) Copied wrong version of pff file to Android (pff is what sets location of lookup data file)
Locked