Hi,

I am wanting to automate my import procedure for an XML file.

I have the style sheets and want to be able to do the following scenerio....

STEP 1 - user clicks "import xml"

STEP 2 - popup asking where the file is.

STEP 3 - user navigates to said file.

STEP 4 - filemaker temp place path into "mycontainer" field.

STEP 5 - filemaker imports xml using predifined stylsheet 1.

STEP 6 - filemaker imports xml again using predifined stylesheet 2 and using the "mycontainer" field for the xml file path.

Repeat STEP 6 - 2 more times for predifined stylesheets 3 and 4.

STEP 7 - END

Okay so I am fairly ok with everything except the filepath thing.

I am thinking its a set fieldname get fieldname, scenerio but can't get my head round it.

Hope my 7 steps are clear enough.

Edited September 11, 200619 yr by Guest

Not quite sure I am following this, but - if your first step is:

Insert File [Reference ; yourTable::DummyContainer ]

you can then extract the selected file path by parsing this expression:

GetAsText ( yourTable::DummyContainer )

and set a variable to the result. See also this thread.

Thanks although its not working....

Running the script in the "specify xml and xsl options" window it throws the filepath in twice into the http request window.

file:XML Finished/myfile.xml

filemac:/Macintosh HD/Users/timeact/Desktop/XML Finished/myfile.xml

Deleting either file path and leaving just one still doesn't work.

I'm not sure the link you posted will help me either unless I'm reading that thread wrongly!

Not sure exactly what's not working. You should have your path in a variable, and enter the variable directly into the path list. Or, if you are importing from XML, you can also use a calculation and enter the variable, or just the container field, there (this can work even in version 7).

---

If you are importing from a local file, how did you get to the HTTP request window?

Edited September 12, 200619 yr by Guest