Problem with Icon fields and IBM i2 Intellishare

Answer

In order to be able to see the icons in Intellishare you need to perform the following steps:

1. Start iBase Designer
2. Go to the Entity fields
3. Double click on the Icon field
   
   
   
   
4. If the field is Mandatory, un-tick this box, otherwise leave it as-is.
5. Export the Icon List linked to the Icon field.
   
   
   
   
6. Open the recently generated .txt file.
7. Add an underscore to the the name of the catalog, which in the case of the example in use was [SEXE]. It should now read [_SEXE]. Save the file.
8. Go back to iBase Designer.
9. Go to Code Lists - Pick Lists. Right-click on Pick Lists and click on Import
   
   
   
   
10. Import the .txt file that we saved previously.
11. Click OK to validate the creation of this new Pick List.
12. Go back to the Entity and in the list of fields rename the field adding the "(Icon)" suffix.
13. Move this field to the bottom. This field will no longer be used.
14. On that same entity, create a new field. This field must have the same name as the previous Icon field name.
15. Select the type "Selected from Code List" and choose the Code List from the new pick list that was created a few steps above.
    
    
    
    
16. If the Icon field was previously Mandatory, Indexed, Discriminator and Characteristic, make sure this one is the same.
17. Move this field to the same position of the previous Icon field.
    
    
    
    
18. Go to the Datasheets and modify all the Datasheets where the old Icon field was used. Replace it with the new field. Please note that this must also be done in all the sub-data sheets that are used for the links.
19. Once all the work has been done on iBase Designer, close the database, and open Microsoft SQL Server Management Studio.
20. Open the database in SQL Server Management Studio.
21. Display the fields of the table that corresponds to the entity type.
    
    
    
    
22. Please note that if the name of the entity type was changed in iBase Designer there might be a difference between the name of the entity type and the name of the table in Microsoft SQL Server.
23. The 2 fields that we need are:
    - AltEntity
    - <yourfield_> (in our case is Sexe_). That should be the last field, which is the one that has been most recently added to the table.
24. The first step is to synchronise the content of the 2 fields. Copy all the values of AltEntity into <yourfield_> (Sexe_). Please note that all the values should be blank.
25. Open a new query in Microsoft SQL Server Management Studio.
26. Run the following query:
    
    UPDATE <Entity>
    SET <yourfield_> = AltEntity WHERE <yourfield_> != AltEntity;
28. Once the 2 fields are the same the next step is to create a new query that will copy the value of the field <yourfield_> into the Icon field AltEntity.
29. Open a new query in Microsoft SQL Server Management Studio.
30. Run the following query:
    
    UPDATE <Entity>
    SET AltEntity = <yourfield_> WHERE AltEntity != <yourfield_>;
32. Save this query.
33. Create a new job in Microsoft SQL Server Management Studio.
34. Define that this job must use the query we have just saved.
35. Schedule this job to run every 2 hours (or whatever other time, according to the frequency you want the fields to be synchronised).
36. Test the job by executing it. There should be no errors.
37. Repeat the steps above for all the other Entity types that are using an icon field.
38. After this is completed the entities should now be able to display the icons in IBM i2 Intellishare.