Adding blocks in bulk?

Permalink
I have a project for a mortgage banking site that includes a page for closings. I made a block for adding new closings one by one: name, project type, location, amount of financing. Pretty simple, really.

Now, I've been hit with a spreadsheet that contains over 400 closings. This is way more than I ever anticipated, but if they insist on having them all included then they have to be included. I was wondering if there is any database file that can be edited directly (I have the closings as a CSV file), rather than going through "Add Block" for hours on end.

1db
 
JohntheFish replied on at Permalink Reply
JohntheFish
The problem you will have is that blocks are spread across more than 1 table. There is a table for the block type, then a table that links block IDs to block types, then tables that put blocks into versions of collections (pages), and maybe more that I don't know about.

If you can get your head round all of that, you can import csv to any database table using phpMyAdmin.
1db replied on at Permalink Reply
1db
Dang. Oh well.