[Expo-tech] Django status update

[Sam Wenham]

On 26/06/2019 04:25, Wookey wrote:
> Now the website doens't just hang with wgsi enabled and databasereset runs.
> 
> However it falls over after a while with:
> Loading personexpeditions
> Traceback (most recent call last):
>   File "databaseReset.py", line 206, in <module>
>     reset()
>   File "databaseReset.py", line 91, in reset
>     import_people()
>   File "databaseReset.py", line 50, in import_people
>     parsers.people.LoadPersonsExpos()
>   File "/home/expo/repositories/hg/troggle/parsers/people.py", line 72, in LoadPersonsExpos
>     rawlastname = personline[header["Lastname"]].strip()
> KeyError: 'Lastname'
> 
> Which seems to be something to do with Sam's last commit on people/name processing.

I added the label "Lastname" to the second field in folk.csv as this
seemed to be what it is and now use that to fill in the last_name field
in the database (don't mention how this doesn't work, I didn't design
it). I then added fullname to the model to store all of the first column
minus the stupid html tags and the () nickname section.

> There is a pending commit on expoweb/folk/folk.csv, but there is no
> 'Lastname' column either before or after that commit.  (The 'Lastname'
> column is actually the 'sort' column strictly speaking)
> 
> Looks like the folk.csv file is out of sync with troggle. Do you have
> a newer version Sam?

We should look at this tonight as there are several issues with this
data that need someone who knows the people to resolve them.

> Titling the 2nd column 'Lastname' means we get further. And it's defo bedtime so I'll see where it's got to in the morning. 
> 
> (That script has a got lot less noisy Sam, well done :-)

You will also find problems processing the data get logged to the Data
Issue table so we can hopefully go through the source data and fix some
of the stupid there.

> Wookey
> 
> 
> _______________________________________________
> Expo-tech mailing list
> Expo-tech at lists.wookware.org
> https://lists.wookware.org/cgi-bin/mailman/listinfo/expo-tech
>