Page 2 of 3
Re: Lookup
Posted: July 7th, 2017, 10:40 am
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.
Re: Lookup
Posted: July 7th, 2017, 11:36 am
by arkagwa
My lookup file is okay. see attached
Re: Lookup
Posted: July 7th, 2017, 11:37 am
by arkagwa
My lookup file is okay. see attached. You can aslo use Txt program like notpad++ or wordpad to view it
Re: Lookup
Posted: July 7th, 2017, 5:09 pm
by sah
Re: Lookup
Posted: July 9th, 2017, 11:36 am
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
Re: Lookup
Posted: July 26th, 2017, 3:57 pm
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
UG FORM.zip
UG LOOKUP.rar
Re: Lookup
Posted: July 28th, 2017, 4:22 pm
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??
Re: Lookup
Posted: July 28th, 2017, 5:51 pm
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.
Re: Lookup
Posted: July 29th, 2017, 10:56 am
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-47-23.png
Screenshot_2017-07-29-17-41-35.png
Screenshot 2017-07-29 17.17.21.png
Re: Lookup
Posted: July 30th, 2017, 6:58 am
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)