search

nus-cs2103-AY2223S2 / pe-dev-response

1 stars 0 forks source link

Unable to batch add even though all phone numbers are valid #2185

Open nus-pe-bot opened 1 year ago

nus-pe-bot commented 1 year ago

Running batchadd exported_database.csv does not work.

exported_database.csv:

Name,Phone,Email,Address,Department,Payroll,Leave Count,Date of Birth,Date of Joining,Tags
a,87438807,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-40",Marketing,4000 15,,,,
b,99272758,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-18",Marketing,4000 15,,,,
c,93210283,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-04",Marketing,4000 15,,,,
d,91031282,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-43",Sales,4000 15,,,,
awefawef,92492021,irfan@example.com,"Blk 47 Tampines Street 20, #17-35",Sales,4000 15,,,,
f,92624417,royb@example.com,"Blk 45 Aljunied Street 85, #11-31",Sales,4000 15,,,,
g,98765432,markd@example.com,"311, Clementi Ave 2, #02-25",Marketing,1000 15,,,,
h,96399990.14,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-41",Marketing,4000 15,,,,
i,97113023.39,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-19",Marketing,4000 15,,,,
j,97826056.64,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-05",Marketing,4000 15,,,,
k,98539089.89,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-44",Sales,4000 15,,,,
l,99252123.14,irfan@example.com,"Blk 47 Tampines Street 20, #17-36",Sales,4000 15,,,,
m,99965156.39,royb@example.com,"Blk 45 Aljunied Street 85, #11-32",Sales,4000 15,,,,
n,87438807,markd@example.com,"311, Clementi Ave 2, #02-26",Marketing,1000 15,,,,
15,99272758,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-42",Marketing,4000 15,,,,
16,93210283,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-20",Marketing,4000 15,,,,
17,91031282,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-06",Marketing,4000 15,,,,
18,92492021,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-45",Sales,4000 15,,,,
19,92624417,irfan@example.com,"Blk 47 Tampines Street 20, #17-37",Sales,4000 15,,,,
20,98765432,royb@example.com,"Blk 45 Aljunied Street 85, #11-33",Sales,4000 15,,,,
21,96399990.14,markd@example.com,"311, Clementi Ave 2, #02-27",Marketing,1000 15,,,,
22,97113023.39,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-43",Marketing,4000 15,,,,
23,97826056.64,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-21",Marketing,4000 15,,,,
24,98539089.89,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-07",Marketing,4000 15,,,,
25,99252123.14,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-46",Sales,4000 15,,,,
26,99965156.39,irfan@example.com,"Blk 47 Tampines Street 20, #17-38",Sales,4000 15,,,,
27,87438807,royb@example.com,"Blk 45 Aljunied Street 85, #11-34",Sales,4000 15,,,,
28,99272758,markd@example.com,"311, Clementi Ave 2, #02-28",Marketing,1000 15,,,,
29,93210283,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-44",Marketing,4000 15,,,,
30,91031282,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-22",Marketing,4000 15,,,,
31,92492021,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-08",Marketing,4000 15,,,,
32,92624417,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-47",Sales,4000 15,,,,
33,98765432,irfan@example.com,"Blk 47 Tampines Street 20, #17-39",Sales,4000 15,,,,
34,96399990.14,royb@example.com,"Blk 45 Aljunied Street 85, #11-35",Sales,4000 15,,,,
35,97113023.39,markd@example.com,"311, Clementi Ave 2, #02-29",Marketing,1000 15,,,,
36,97826056.64,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-45",Marketing,4000 15,,,,
37,98539089.89,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-23",Marketing,4000 15,,,,
38,99252123.14,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-09",Marketing,4000 15,,,,
39,99965156.39,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-48",Sales,4000 15,,,,
40,87438807,irfan@example.com,"Blk 47 Tampines Street 20, #17-40",Sales,4000 15,,,,
41,99272758,royb@example.com,"Blk 45 Aljunied Street 85, #11-36",Sales,4000 15,,,,
42,93210283,markd@example.com,"311, Clementi Ave 2, #02-30",Marketing,1000 15,,,,
43,91031282,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-46",Marketing,4000 15,,,,
44,92492021,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-24",Marketing,4000 15,,,,
45,92624417,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-10",Marketing,4000 15,,,,
46,98765432,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-49",Sales,4000 15,,,,
47,96399990.14,irfan@example.com,"Blk 47 Tampines Street 20, #17-41",Sales,4000 15,,,,
48,97113023.39,royb@example.com,"Blk 45 Aljunied Street 85, #11-37",Sales,4000 15,,,,
49,97826056.64,markd@example.com,"311, Clementi Ave 2, #02-31",Marketing,1000 15,,,,
50,87438807,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-40",Marketing,4000 15,,,,
51,99272758,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-18",Marketing,4000 15,,,,
52,93210283,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-04",Marketing,4000 15,,,,
53,91031282,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-43",Sales,4000 15,,,,
54,92492021,irfan@example.com,"Blk 47 Tampines Street 20, #17-35",Sales,4000 15,,,,
55,92624417,royb@example.com,"Blk 45 Aljunied Street 85, #11-31",Sales,4000 15,,,,
56,98765432,markd@example.com,"311, Clementi Ave 2, #02-25",Marketing,1000 15,,,,
57,96399990.14,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-41",Marketing,4000 15,,,,
58,97113023.39,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-19",Marketing,4000 15,,,,
59,97826056.64,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-05",Marketing,4000 15,,,,
60,98539089.89,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-44",Sales,4000 15,,,,
61,99252123.14,irfan@example.com,"Blk 47 Tampines Street 20, #17-36",Sales,4000 15,,,,
62,99965156.39,royb@example.com,"Blk 45 Aljunied Street 85, #11-32",Sales,4000 15,,,,
63,87438807,markd@example.com,"311, Clementi Ave 2, #02-26",Marketing,1000 15,,,,
64,99272758,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-42",Marketing,4000 15,,,,
65,93210283,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-20",Marketing,4000 15,,,,
66,91031282,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-06",Marketing,4000 15,,,,
67,92492021,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-45",Sales,4000 15,,,,
68,92624417,irfan@example.com,"Blk 47 Tampines Street 20, #17-37",Sales,4000 15,,,,
69,98765432,royb@example.com,"Blk 45 Aljunied Street 85, #11-33",Sales,4000 15,,,,
70,96399990.14,markd@example.com,"311, Clementi Ave 2, #02-27",Marketing,1000 15,,,,
71,97113023.39,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-43",Marketing,4000 15,,,,
72,97826056.64,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-21",Marketing,4000 15,,,,
73,98539089.89,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-07",Marketing,4000 15,,,,
74,99252123.14,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-46",Sales,4000 15,,,,
75,99965156.39,irfan@example.com,"Blk 47 Tampines Street 20, #17-38",Sales,4000 15,,,,
76,87438807,royb@example.com,"Blk 45 Aljunied Street 85, #11-34",Sales,4000 15,,,,
77,99272758,markd@example.com,"311, Clementi Ave 2, #02-28",Marketing,1000 15,,,,
78,93210283,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-44",Marketing,4000 15,,,,
79,91031282,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-22",Marketing,4000 15,,,,
80,92492021,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-08",Marketing,4000 15,,,,
81,92624417,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-47",Sales,4000 15,,,,
82,98765432,irfan@example.com,"Blk 47 Tampines Street 20, #17-39",Sales,4000 15,,,,
83,96399990.14,royb@example.com,"Blk 45 Aljunied Street 85, #11-35",Sales,4000 15,,,,
84,97113023.39,markd@example.com,"311, Clementi Ave 2, #02-29",Marketing,1000 15,,,,
85,97826056.64,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-45",Marketing,4000 15,,,,
86,98539089.89,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-23",Marketing,4000 15,,,,
87,99252123.14,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-09",Marketing,4000 15,,,,
88,99965156.39,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-48",Sales,4000 15,,,,
89,87438807,irfan@example.com,"Blk 47 Tampines Street 20, #17-40",Sales,4000 15,,,,
90,99272758,royb@example.com,"Blk 45 Aljunied Street 85, #11-36",Sales,4000 15,,,,
91,93210283,markd@example.com,"311, Clementi Ave 2, #02-30",Marketing,1000 15,,,,
92,91031282,alexyeoh@example.com,"Blk 30 Geylang Street 29, #06-46",Marketing,4000 15,,,,
93,92492021,berniceyu@example.com,"Blk 30 Lorong 3 Serangoon Gardens, #07-24",Marketing,4000 15,,,,
94,92624417,charlotte@example.com,"Blk 11 Ang Mo Kio Street 74, #11-10",Marketing,4000 15,,,,
95,98765432,lidavid@example.com,"Blk 436 Serangoon Gardens Street 26, #16-49",Sales,4000 15,,,,
96,96399990.14,irfan@example.com,"Blk 47 Tampines Street 20, #17-41",Sales,4000 15,,,,
97,97113023.39,royb@example.com,"Blk 45 Aljunied Street 85, #11-37",Sales,4000 15,,,,
98,97826056.64,markd@example.com,"311, Clementi Ave 2, #02-31",Marketing,1000 15,,,,

[original: nus-cs2103-AY2223S2/pe-interim#1799] [original labels: type.FunctionalityBug severity.Medium]

gyulong1 commented 1 year ago

Team's Response

These are not valid phone numbers as they contain a decimal point as stated in the UG.

96399990.14 97113023.39 97826056.64 98539089.89 99252123.14 99965156.39

Duplicate status (if any):

--