Importing Data from FileMaker

[jonas]

I try to import e-mails and data from a Filemaker-database and it doesn't work right now.

I took a look at the example which comes with the product. I've created the DATA-field in my database and copied the script. The data-field looks exactly as it looks in your example.
But when I start the script MaxBulkMailer doesn't import and pops up with the following error:

"FileMaker script ('DATA' field)".

Any idea what could be wrong?

Thanks.

 

[stanbusk]

It depends on your FM version. The example is actually different because of the DATA field. Note that 100% of problems come from this field.

 

[jonas]

I'm on FM 8.v03 Advanced Developer.

The DATA-field looks the following:

"\\" & "\\" & "\\" & email & "\\" & Kundennummer &"\\" & PLZ & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\"

And the result is e.g.

\\\[email protected]\1634\8304\\\\\\\\\

I just want to bring 3 fields over.

Any idea what could be wrong?

 

[stanbusk]

This one works fine when all fields are available:

Firstname & "\\" & Surname & "\\" & Company & "\\" & Email & "\\" & Opt1 &"\\" & Opt2 & "\\" & Opt3 & "\\" & Opt4 & "\\" & Opt5 & "\\" & Opt6 & "\\" & Opt7 & "\\" & Opt8 & "\\" & Opt9 & "\\" & Opt10 & "\\"

For the fields you have, it should be:

"\\" & "\\" & "\\" & Email & "\\" & Kundennummer & "\\" & PLZ & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\" & "\\"