Exporting FMP database to DB Browser for SQLite

[ChangeAgent]

SQLite is built into the Mac OS.  One can use for example DB Browser for SQLite to take advantage of it.  If I want to export a FMP database, to SQLite does anybody know where I find detailed instructions? 

Thanks

[comment]

I am not familiar with SQLite and the answer depends on what format/s SQLite can import. A quick Google search suggests it can import CSV - which is one of the formats that Filemaker can export. I also see there are tools to convert CSV to SQLITE (which seems to be SQLite's native format).

A note to this as well as to your previous question: the only way to get data out of a Filemaker file is to open it in a Filemaker application. Then you can export from it in one of the supported formats or - if it is hosted - connect to it through ODBC or Data API and query it.

 

[rivet]

this might work for SQLite — here are some xsl's for exporting from FileMaker to mySQL. Perhaps you can work with those and tweak for SQLite if required.   

Steps:  export as XML, select fields, then when prompted for XSL choose one of the files attached.

SAMPLE OUTPUT

DROP TABLE IF EXISTS contact;

CREATE TABLE contact (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
comment text,
deleted_at timestamp,
name text,
type text,
ENGINE=InnoDB DEFAULT CHARSET=utf8


INSERT INTO contact VALUES(…

 

mysqlFromFileMaker.zip