generator

First the excel file was converted to a CSV file using LibreOffice Calc.

Then using the web generator https://codebeautify.org/csv-to-sql-converter and entering some database specific details (tablename, columnname identifier, columnname targetvalue) and choosing "CSV to SQL(INSERT)" an SQL script was generated that inserts into each row with the identifier the corresponding value from the CSV file.

The output was saved as an .sql file.
A a database backup created.
Afterwards the sql-file was uploaded into phpMyAdmin as an import script and executed perfectly.

Submitted by Marian Berendes on Sat, 11/17/2018 - 19:23
Related Question: 
import excel data table into database with only phpMyAdmin access

Taggings:

ProgrammingLanguage:

SocialTags:

Generating a barcode image within a Rails application

For a sport charity event with participants signing up beforehand online I needed to generate a barcode representation as an png file within a Rails application.

Taggings:

Submitted by Marian Berendes on Sat, 11/17/2018 - 18:45
Subscribe to generator