Very Computer

I am working on exporting huge database from a filmaker (Mac) system
to
MySQL(Linux) system.

While exporting from filemaker,I create a Text file and then load that
in MySQL.

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
show up.
Any quick trick for this??

2)say I have a layout in FM with fields like
    (name,number,expr(name-number)).
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,
                        number int)

create table my_final (select name ,number ,concat(name,'-',number)
from my_temp).

......

Is there an easier way out to all this!!

Any advise or suggestion is welcome

~sanglevt

Hi all,

We are using FM Pro 5.0 and need to have a submit form (just like an HTML
submit form) within one of our databases.  Yeah, I've heard about CDML,
but our databases are not published on the web, nor are they accessed from
the web.  We hope to find a solution that can simulate an HTML form, so
that when you hit a Submit button, it creates the same action that an HTML
form would.

Any ideas?

Thanks,
Ryan

<posted and mailed>

Hi Ryan,

Who do you need to submit the HTML form.  If it is for people outside your
network you will need to have the database hosted so they can access it.
However if it is for people on your local network you will have an easier
time.  Filemaker has it's own built in web server (well sort of).  All you
will need to do is share the database and enable web companion for it.

On the point of CDML - you might be able to use the built in web companion
thingo (sorry I can't for the life of me remember what it's called) - but
CDML is not that difficult and can be alot easier to customise.

If it is for your internal network and you won't have more that 10 people
accessing it in the 24 hours period you won't even need to get Filemaker Pro
Unlimited.

I hope this make sense.  Let me know if it needs clarification.

gibby

Hi all,

I'm using FMPro 5.0 on a Windows 2000 machine, and I'm trying to find a
way to switch between applications using FMPro.  In my script, I have
FMPro open a URL.  Once it does that, Internet Explorer takes over, and
I can't find a script step to bring me back to FMPro.

Any suggestions on how I can get back to FMPro once my script has opened
up IE?

Thanks,
Ryan

Try using Send Message, instead of Open URL. You can either hard code the
URL as text, or use a field value. Then, follow that step with a second
Second Message, to open the current Filemaker file. That will return focus
to Filemaker.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance

GenoaSoftware.com just released a new plugin that does exactly what
you are asking for. You can POST or GET with a query string to send
form information where you want it to go. Single user price is 39.95,
site or redistribution is 399.50, see them at
http://www.genoasoftware.com

The plugin name is DoHTTP and besides forms you can use it to retreve
pages into a FM field.