| 20 | | * Null exception in creation of (db) index. (DONE) |
| 21 | | * Some field was null |
| 22 | | * When retrieved from DB the table contact contains : |
| 23 | | * id, |
| 24 | | * !FirstName, |
| 25 | | * !MidInitials, !LastName, |
| 26 | | * '''Affiliation, ,<---- this is strange. Is not contained in the DB , where does it come from ?? ''' |
| 27 | | * Address, |
| 28 | | * Phone, Email, Fax, tollFreePhone, labworker, xref_Affiliation.name AS Affiliation_name FROM Contact LEFT JOIN Institute AS xref_Affiliation ON xref_Affiliation.id.... |
| 29 | | * Affiliation exists in model? but not in db ! update database . |
| 30 | | * database now empty |
| 31 | | * upload xls ..ok |
| 32 | | * rebuild index. |
| 33 | | * Search in the db index was not working for the field name |
| 34 | | * name is not included in the model or the database, but data are here! |
| 35 | | * this creepy feature is because this column was created by the XLS IMPORT! |
| | 20 | * |
| | 31 | * Null exception in creation of (db) index. - resolved (DONE) |
| | 32 | * Some field were null |
| | 33 | * When retrieved from DB the table contact contains : |
| | 34 | * |
| | 35 | * id, |
| | 36 | * !FirstName, |
| | 37 | * !MidInitials, !LastName, |
| | 38 | * '''Affiliation, ,<---- this is strange. Is not contained in the DB , where does it come from ??''' |
| | 39 | * Address, |
| | 40 | * Phone, Email, Fax, tollFreePhone, labworker, xref_Affiliation.name AS Affiliation_name FROM Contact LEFT JOIN Institute AS xref_Affiliation ON xref_Affiliation.id.... |
| | 41 | * Affiliation exists in model? but not in db ! update database . |
| | 42 | * database now empty |
| | 43 | * upload xls ..ok |
| | 44 | * rebuild index. |
| | 45 | * Search in the db index was not working for the field name |
| | 46 | |
| | 47 | * name is not included in the model or the database, but data are here! |
| | 48 | * this creepy feature is because this column was created by the XLS IMPORT! |
| | 49 | * '''Search inside the field description is WORKING : try "accurately" HIV .''' |