Convert Excel to Serif Webplus SDB format

Just sharing something that might be of interest to anyone with a similar problem.

A non-technically minded friend is attempting to use Serif WebPlus to create an E-Commerce site with Paypal integration. The problem is that all his stock is in Excel format which, although Serif claims they can handle, throws an error dialog with the helpful information that the worksheet or database does not have the required fields. There is no indication as to what these fields should be, merely that they are required and not present!

Anyway, I figured I'd have more success with an export to CSV. Nope, exactly the same problem.

Finally, after actually opening an actual "SDB" file in notepad I noticed that the Serif Database file IS a CSV file. The only difference? It comes with quotation marks around each field. Hello, there -> "Hello", "there". Great.

Anyway, in case you are one of the poor sods struggling with this and getting nowhere I've written a little utility that will take your CSV files and convert them into SDB for you. Enjoy.

Excel to SDB Converter

comment from Joanna
Hi - yes I'm one of those poor sods. I read your post and thought - YES at last a solution.... I eagerly clicked on your link and ALAS, the link is broken. Could you possibly send me the link. It would really help Big Time. Many Thanks Joanna

comment from jo
i am having problem creating databases(with tables) with Serif Webplus X2,please try and help in anyway possible.it's very urgent.tanx

comment from Michael Christensen
I'm using Webplus x4, and I'm planning to integrate some data from Excel. Since the link above doesn?t work, I would very much appreciate if you could send me a link that works or, even better, the Excel to SDB Converter via mail. Many Thanks Michael

comment from doa0101
Just add quotation marks to the first row of each letter eg.. A1 B1 C1 etc... Then Just change the extension of the file to .SDB

add a comment
name:
website:
email:
comment: