XML Help...

[Eukanuba]

Hi guys,

I'm working on this database and i need to get data from my vb.net code to the fmp database... i was wondering if there is a way to program my program to automatically import the xml data to the FMP database...

thanks in advance,

Euka

[Colin Keefe]

Not that I know anything about .NET or vb.NET, but you might want to look here:

fmDotNET - press release

Connecting Data fmDotNET info page

[elo]

If the XML route doesn't work for you, you can connect to FMPro (basic version) using ADO.NET or plain ADO if you install the ODBC drivers that come with your FileMaker CD.

Also, I posted a simple Ruby script that pulls from FileMaker into SQL Server 2005 using 2 ODBC connections and ADO. The reverse could probably easily be accomplished--pretty sure FileMaker's ODBC supports INSERT statements. [My script uses the basic COM/Win32OLE flavor ADO.]

Let me know if you want me to post my Ruby source code since Ruby source code should be somewhat understandable to a Visual Basic user (I always take Visual Basic COM/Win32OLE documentation to help make my Ruby scripts).

[Eukanuba]

XML is working fine...

i just need to get it into FMP automatically...

[Eukanuba]

ok since nobody has posted in a while...

how about this...

what if i created a script (that ran automatically after hitting the save button) in vb.net that ran from all of my parameters...

how would that look?

thanks in advance,

Euka