Projects:Image Reference BLOB

Contents 1 Implement new type of Image Reference - Functional Specifications 1.1 Overview 1.1.1 Purpose 1.2 Functional Requirements 1.2.1 Business process definition 1.2.2 Functional requirements based on business processes 1.2.3 User Interface Mockups 1.3 Open Discussion Items 1.4 Closed Discussion Items 1.5 Testcases 1.5.1 Add Image Reference BLOB field to an existing window 1.5.2 Upload a new image to a record not having an image 1.5.3 Replace an existing image 1.5.4 Delete an existing image 1.5.5 Check that Export Client / Import Client preserve images

Implement new type of Image Reference - Functional Specifications

Overview

Purpose

The purpose of this project is to implement a new type of Image Reference, which has two key properties:

• Generated windows can contain fields of this kind of reference, and the image is displayed in the window when the user views it.
• The user can upload the image through the Openbravo User Interface when editing records, can re-upload a new image if he wants to change it, and can also delete the image.

Functional Requirements

Business process definition

• Developers should be able to select the new reference when creating new fields
• The image should be displayed in the window when the user is in editing view
• The user should be able to upload a new image through the user interface, re-upload an image when the image needs to be changed, and delete it

Functional requirements based on business processes

Num	Requirement	Importance	Status
1.1	Openbravo developers can define new fields using the new image reference	Must Have
1.2	Openbravo users can upload new images through the user interface, can re-upload them to change them, and can delete them, while working with a generated window in editing view	Must Have

User Interface Mockups

A field of image BLOB type reference:

This is the window that opens if the user clicks the image field:

Open Discussion Items

• None

Closed Discussion Items

• None

Testcases

Add Image Reference BLOB field to an existing window

Steps to execute:

1. Add a new database column for the image field to the c_bpartner table
   1. ALTER table c_bpartner add column image_id varchar(32) references ad_image(ad_image_id);
2. Login into openbravo
3. Switch to System Administrator role
4. Set module core to in development
5. Goto Application Dictionary -> Tables and Columns
6. Goto the record: 'Business Partner'
7. Click the button 'Create Columns from DB' and confirm process in the popup
8. The process should finish and display 'Created 1'
9. Goto to 'Columns' tab of this record
10. Navigate to the record with the 'DB Column Name' 'Image_ID'
11. Change its reference to 'Image BLOB' and save changed record
12. Goto Application dictionary -> Windows, Tabs & Fields
13. Navigate to the record 'Business Partner'
14. Navigate to its tab 'Business Partner'
15. Open its tab: Fields
16. Click new record
17. Enter name: Image
18. Select column: Image_ID
19. Save new record and logout
20. Recompile the 'Business partner' window and redeploy changes to tomcat
21. Login into openbravo
22. Switch role to Openbravo Admin
23. Goto Masterdata Management -> Business Partner
24. Check that the window has a new column for the Image reference and does display the picture for 'no image'.
25. Check that when clicking on the 'no image' picture the 'Image Selector' is opened
26. The selector should not display an image

Upload a new image to a record not having an image

Steps to execute:

1. Go to Masterdata Management -> Business Partner
2. Navigate to the first record
3. Click on the 'no image' picture of the new field to open the 'Image Selector' popup
4. Click on browse and select an png-type image from your system in the file browse dialog
5. Click the upload button
6. The image selector popup should automatically close and the 'Business Partner' record should now display the uploaded image in the new field
7. Click save to save the modified business partner record

Replace an existing image

1. Go to MasterData Management -> Business Partner
2. Navigate to the record which has the image attached
3. Click on the displayed image for the new field to open the 'Image Selector' popup
4. Check that the image selector does display the image and has a 'Delete' button showing next to it
5. Click browse and select a different png-type image from your system in the file browse dialog
6. Click Upload
7. The image selector popup should automatically close and the business partner record should now display the newly uploaded image.
8. Click save to save the modified business partner record
9. Go to another window (Masterdata Management -> Product)
10. Go back to the 'Business Partner' window
11. The business partner record should still display the newly uploaded image

Delete an existing image

1. Go to MasterData Management -> Business Partner
2. Navigate to the record which has the image attached
3. Click on the displayed image for the new field to open the 'Image Selector' popup
4. Check that the image selector does display the image and has a 'Delete' button showing next to it
5. Click the delete button
6. The image selector popup should automatically close and the business partner record should now show the picture for 'no image'
7. Click save to save the changes business partner record
8. Go to another window (Masterdata Management -> Product)
9. Go back to the 'Business Partner' window
10. The business partner record should still display the picture for 'no image'

Check that Export Client / Import Client preserve images

1. Go to General Setup -> Export Client
2. Select the client you did the tests in
3. Click OK
4. Check that a file ${source.path}/referencedata/client_data.xml was created
5. Move the file in the referencedata/importclient folder
6. Switch role to System Administrator
7. Go to General Setup -> Client -> Import Client
8. enter a new name for the client (i.e. newtest)
9. Click OK to import the client
10. Relogin and switch role to 'newtest admin'
11. Go to Masterdata Management -> Business Partner
12. Navigate to the Record which has the image attached
13. Check that the uploaded image is present in the new field