falco925
Joined 12 years ago
Joined 12 years ago
The script will clean the file name and column headers and create the SQL statements to create the db table and upload the file to the database, automatically.
I used this script almost everyday at my past job to upload data from other teams and departments.
I recorded a tutorial on youtube for anyone that wants to try to build it out (links in the README). Hope this is helpful either as a way to easily upload files to a db or as practice getting better building python scripts to automate your work.
A mailing list is nice because you're actually collecting emails and can use them somehow in the future. You could collect emails and then send users a welcome email that also promotes your IG channel. It just wasn't obvious you have an IG channel. Hopefully this is helpful.