Importing data directly to database
Permalink
So I created a custom block for our employee list. Now I have a csv with about 150 employee's I want to import. I attempted to do this via SQL statement in phpmyadmin. So I inserted 150 records into Blocks table with a btID of 35 (my custom block id) and then imported the data into btDCEmployeeDir with a matching bID. No data showed up. I know I am missing something or is there an easier way to do this via php?
Blocks Table
bID: 104
bName: NULL
bDateAdded: 2013-03-01 12:59:36
bDateModified: 2013-03-01 12:59:36
bFilename: NULL
blsActive: 1
btID: 35
uID: 1
btDCEmployeeDir
bID: 104
first_name: Test
last_name: User
phone_no: 5554
start_date: 2013-03-01
dob: 2013-03-01
emp_pic: NULL
Blocks Table
bID: 104
bName: NULL
bDateAdded: 2013-03-01 12:59:36
bDateModified: 2013-03-01 12:59:36
bFilename: NULL
blsActive: 1
btID: 35
uID: 1
btDCEmployeeDir
bID: 104
first_name: Test
last_name: User
phone_no: 5554
start_date: 2013-03-01
dob: 2013-03-01
emp_pic: NULL