Thursday

"This file requires a newer version of Anki" apkg error resolved

Unfortunately, anki software just jammed all those fields into one field the database with some kind of separator.Which is a very messy way to store data. And apparently different version of Anki storing data into different database inside apkg file. Here is new version of apkg converters that reads data from correct database.

Friday

convert excel file into sql and import all data

  • Here are steps how to convert convert excel file into sql and import all data
  • In step 1:Click on Open input file and open excel file
  • Click on Next Step button
  • In step 2:Specify sql database type (sql server, mysql, sqlite)
  • Click on Next Step button
  • In step 3:Click on Save Result file to save SQL script
  • sql script will have create table and insert instructions
  • Run sql script into database tool to export data from excel into database.

excel-to-sql

test smtp server with powershell

Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...