Return to fm2sql.dtd CVS log

Up to [Repository] / FM2SQL / doc

- reorganisation of project files
- fixed bug with initialisation of fm8 jdbc driver

<?xml version="1.0" encoding="UTF-8"?>
<!-- root element -->
<!ELEMENT convert (source,destination)>
<!ELEMENT source (database+)>
<!ELEMENT database 
  (url,user,password,delimiter?,mode,usenormantounicodemapper?,table+,sqlcommands?)>
<!ELEMENT url (TEXT)>
<!ELEMENT user (TEXT)>
<!ELEMENT password (TEXT)>
<!ELEMENT delimiter (TEXT)>
<!ELEMENT mode (TEXT)>
<!ELEMENT usenormantounicodemapper ((true|false))>
<!ELEMENT table (select|create?)>
<!-- sql select statement special characters must be masked as entities -->
<!ELEMENT select (TEXT)>
<!-- sql create statement  special characters must be masked as entities -->
<!ELEMENT create (TEXT)>
<!--
table
name name of table
layout filemaker layout name
id id field name
targetID id field name of target table important if field has a different name 
than in destination Table
important for synchronize mode 
<table name = "bib_annot" layout = "" id = "ID" targetID="id" indexList ="">
-->
<!ATTLIST table name CDATA #REQUIRED layout CDATA #IMPLIED id CDATA #IMPLIED 
  targetID CDATA #IMPLIED indexList CDATA #IMPLIED >
<!-- Database element just needs url,user,passwd tables are not needed and not read-->
<!ELEMENT destination (database+)>
<!ELEMENT sqlcommands (sqlcommand*) >
<!ELEMENT sqlCommand (TEXT) >
<!--  
  execute before conversion or execute after conversion  
  -->
<!ATTLIST sqlcommand execute (before|after) #REQUIRED >