digitaljunkie Posted September 11, 2006 Share Posted September 11, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
comment Posted September 11, 2006 Share Posted September 11, 2006 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. Link to comment Share on other sites More sharing options...
digitaljunkie Posted September 12, 2006 Author Share Posted September 12, 2006 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! Link to comment Share on other sites More sharing options...
comment Posted September 12, 2006 Share Posted September 12, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6563 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now