yarindeoh / safe-home-haytiSham

THE MICHAL SELA HACKATHON
https://hayti-sham.co.il/
5 stars 4 forks source link

"additionalnfo" is missing from all originalStory Data (from the excel) #235

Open rotem12345678 opened 3 years ago

rotem12345678 commented 3 years ago

when doing http://localhost:5000/api/getStoryForEdit?originalStory=5f96df576c491f0f3064bfc3

the field "additionalnfo" is missing in originalStory but existed in ModeratedStory

This happens for all original stories that were converted from the original excel file (all but id: 5f9dc71d4e1e4100375c9e19 that was inserted afterwards).

This should be fixed by copying this field from the moderated stories db into the public stories db (no api for that). While you're at it, please also fix the createdDate field into 15/5/2020 and delete 3 fake/tests testimonies that were inserted on 19/11

orlylev commented 3 years ago

This specific story does not have the files in the DB In general, stories have it. What do you expect in this case?

rotem12345678 commented 3 years ago

we expect that If the field existed in ModeratedStory it should exist in OriginalStory too.

orlylev commented 3 years ago

I checked again looks like the additionalnfo info is an empty string and it returns as an empty string by the BE API

moranw commented 3 years ago

@orlylev I checked the original excel and there is data there and it is very important data, maybe it was some corruption on the data transfer method? I see that the excel file is filled with this data, but no original story has it (as seen on the admin side)! The hebrew title for this field was: בכמה משפטים, מה הכי היית רוצה לומר למי שבמצב דומה? I'm sharing with you the original excel again