[FX.php List] [Off] Import RAW XML to a field - FM9
beverlyvoth at gmail.com
Thu Nov 1 06:31:25 MDT 2012
how are you re-importing 'to a field', Webko? Since this is the fx.php list, I just wondered how php is involved, if at all?
On 31 Oct 2012, at 9:33 PM, Tim 'Webko' Booth wrote:
> I can quite happily get FM 11 to export a transformed XML and then re-import it to a field. It creates XML that looks like:
> <?xml version="1.0" encoding="UTF-8"?><party><party-type>Person</party-type><surname>Booth</surname><first-name>Time</first-name><birth-date>None of your beezwax</birth-date></party>
> This is good.
> FM9 seems to insist on:
> <?xml version="1.0" encoding="UTF-8"?>
> Worse, that return appears to be something like a CRLF, as I get three records if I import to a test database.
> Is there a way to persuade 9 to not do this?
> If it was just one return, the workaround is fairly easy - just tell it that the first record is headers, and then paste the XML declaration back in later. But two is annoying - I'd have to create a new sub-table, import, paste the master ID and create a link to then concatenate the related records...
> This project all looked so good until these old version compatibility issues started...
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
More information about the FX.php_List