BE03: VALIDATE DATA CELL APPROPRIATE WITH TITLE COLUMN

[nnh53]

(US-03)

• Must be done after BE02: Compare the title of column with the properties of product in system #6

• Description:

  • Check the format of the cell compare to the title
    • exp: title: "loại", data: "áo" -> correct
    • exp: title: "tiền", data: "vnd" -> correct
    • exp: title: "price", data: "$" -> correct
    • exp: title: "loại", data: "13$" -> wrong

• Approval Standards:

  • BE03.1
  • BE03.2
  • BE03.3
  • BE03.4
  • BE03.5
  • BE03.6
  • BE03.7
  • BE03.8
  • BE03.9
  • BE03.10
  • BE03.11
  • BE03.12

[nnh53]

• Frontend need 3 list after this function: addNewRowList, updateRowList, ErrorRowList

[nnh53]

[nnh53]

• Dòng trống xử lý sao
  

[lcaohoanq]

• Frontend need 3 list after this function: addNewRowList, updateRowList, ErrorRowList

@nnh53
I don't really understand what you mean, does this my require as well or you just notify for FE team

[lcaohoanq]

@nnh53
#6 not done yet, can i do on my own generated fake data?

• Employees Dreame.vi.xlsx
  
• Products Dreame.en.xlsx
  

[nnh53]

@lcaohoanq do what ever u can to the task, urge @huy1707developer to do #6 faster

[lcaohoanq]

@nnh53
Does this issues can be divide to smaller, the validate requirement is huge large, i don't know how to start with

• As my demo data for the Products Dreame.en.xlsx
  
• The data type of data when read file can be a string, number base on xlsx default, does i need to check the data type as well, the requirement do not specify this (i'm do not have the legit data, now just on demo and when i can get the real data?)

Requirement

• exp: title: "loại", data: "áo" -> correct
  • Now with demo of Product Dreame.en.xlsx and Employees Dreame.vi.xlsx, will have other file type also, i mean when loại -> áo, product (may be split in smaller like vaccum cleaner, robot,... ), nhân viên (admin, manager, dev, sales,...), i need to group all these data
• exp: title: "tiền", data: "vnd" -> correct
  • Which is the data in Price column ($99.99 or 99,99 only), (100.000 VND or 100.000 VNĐ or 100.000 only)
• exp: title: "price", data: "$" -> correct
  • The price column when see in excel it become: $99.99 but when read file it only 99.99, mean that the currency are handling by excel as well
• exp: title: "loại", data: "13$" -> wrong
  • As above, the legit data we still not have, demo for this is huge difficult

[nnh53]

@lcaohoanq yes, in the next breakdown metting we will discuss about this

[hoangday185]

For non-mandatory data fields, if the data field is empty, the empty string is returned, otherwise it is checked as usual

[nnh53]

• Break down to multiple smaller task

[hoangday185]

We have to manage objects like model and manufacturer. When we add a new object in the excel file, we will ask the user if they want to add a new one. If not, ignore that product. If so, popup and add it. #35 và #27

[lcaohoanq]

@nnh53 @hoangday185 @huy1707developer

• The title will be lower case only, instead of capitalize the first word

• Sample data here

Products Dreame.en.xlsx

Products Dreame.vi.xlsx

[nnh53]

No, let the user choice however they want, we will lower in BE code @lcaohoanq

[lcaohoanq]

No, let the user choice however they want, we will lower in BE code @lcaohoanq

Yes, base on user choice, i just want to notify everyone that i will work on the sample data fix to lower case the title