LOAD DATA for MySQL

Load Data can be used to send bulk records from a CSV file to a MySQL table.

The first step is to dump the database records to a utf-8 *.CSV file.

sql - exporting text file with utf-8 encoding in ms access - Stack Overflow

Then use MySQL Load Data. . .

What is LOAD DATA and how does it work | MySQL Server Blog

For Load Data Errors see:

MySQL LOAD DATA LOCAL INFILE on WINDOWS not WORKING - Stack Overflow

Useful MySQL Workbench Query Statements

SET GLOBAL local_infile = 1;

show variables like '%secure_file_priv%';
show variables like 'local_infile';

Pipes are safer than commas or semi-colons

Remote Server

LOAD DATA INFILE 'file'
IGNORE INTO TABLE table
CHARACTER SET UTF8
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Local Server

LOAD DATA LOCAL INFILE "file" INTO TABLE tblName CHARACTER SET UTF8 COLUMNS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"';

Other options not shown above include:  Ignore duplicates.

That's it !

Bill of Material - BOM Part Numbers with Leading Zeros

Leading zeros can be dropped from Mfr Part Numbers in Excel if the part number is numeric and the cells in the Excel worksheet column are formatted as General, which is the default format in Excel. To preserve the leading zeros format the cells in the Excel template as text.

Example:  Molex P/N 0039281043

Try the Generic XLS File Format to preserve leading zeros in part numbers. 

You can find example BOM templates in the Parts Download.



That's it !

Altium - Working from Home and using VPN

To speed up placing parts in your schematic from the Components Panel . . .

If you see pricing and stock then you have Parts Providers enabled.



Preferences >  System > Network Activity > UnCheck Parts Providers.



That's it !