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

add a comment
name:
website:
email:
comment: