I am working on exporting huge database from a filmaker (Mac) system
While exporting from filemaker,I create a Text file and then load that
1)Some of the 'layouts' in FM files,have fields which are are based on
relationships with other tables.While exporting these fields do not
Any quick trick for this??
2)say I have a layout in FM with fields like
while exporting to txt file I see only (name,number) which may have
been the two columns created.
Now in MySQL...i need to first create
create table my_temp ( name text,
create table my_final (select name ,number ,concat(name,'-',number)
Is there an easier way out to all this!!
Any advise or suggestion is welcome