TrulySimple

The part that jumps out at me from this script is that you are using Get(DesktopPath) & "OrderExport" I would try using Get ( TemporaryPath) instead as the iOS devices don't have desktops (as far as I know). Otherwise I am not sure the reason to export to tab delimited file then re-import what appears to be the same data into different fields. I am sure there must be a reason, yet not relevant if the file path fixes your issue.

If the Export File step uses a Get ( TemporaryPath) to create the variable $exportPath and the Import File step is in a different script you would either be passing this local variable from the Export script into the Import script (if they are running one after another, which I think not) or you would store $exportPath as a global variable $$exportPath to pick it up for the import script when that runs. It is a little difficult to assist without seeing more of what is going on. I hope this helps.

You could try something like this. This is in an FM Go file to open images stored in containers. So I think the idea would be storing the path somewhere to open it later on your import. Cheers, Ben

I am interested to see the outcome of this. Scenario 2 is where my mind went as I read Scenario 1 as I have Scenario 2 working in some multiple file separation models (Interface, Data, and Media files) I do recall having login issues when testing for web direct and have not gone further with it. Although I do know the simplest solution is to have the Interface file auto login to a default account then Put your Floor and Manager scripts only in the Data file. The data is what you want to protect and do not need data protection in the interface file. In fact it makes new updates of the interface file easy as you don't have to code in ways to reset passwords in all files when you distribute an updated interface file. I have planned to work this out, and it is more complicated when there is one interface and data and media files. Perhaps this helps you. Cheers, Ben

Hey Nik, I am so glad I could be of help. Perhaps I can contact you on some PHP help sometime.

I don't know enough about PHP or curl to completely answer your question. However, I use RESTfm which is php and curl scripts that interact direct with a hosted FM Server database. RESTfm is under a open source license now. So I used RESTfm to interact with a license server file that can be updated by web purchases adding licenses, license seats, and other items. The vertical market software I put out does a quick license check via RESTfm to allow access into the software. So we are pushing and pulling data from the file. Some using FileMaker via RESTfm and PHP direct from our webpage. Hope that helps. Cheers, Ben

Try exiting the field to see if it allows search then. It looks like the Agents field is possible selected.

Yes, exactly what Wim has said. Once you are on 13v9 then server must be at 13v9 as well or you will not be able to access hosted files on the server. Same with FMP.

I would check that the Accounts and Privilege have access to the required tables and layouts for this to execute. You can try the process in FM Advanced from the Go layout on the desktop logged in as one of the other non-admin privilege set accounts using script debugger and see what happens.

You could do something like this: # First time log in as Demo If [ not RESOURCE::Demo_flag ] Set Field [ RESOURCE::Demo_flag ; 1 ] Set Field [ RESOURCE::Demo_End_TimeStamp ; Get ( CurrentTimeStamp ) + 864000 ] // 10 days for example Show Custom Dialog [ "Welcome to My Program" ] ; "You have 10 days to use this Demo. Enjoy exploring." Else If [ Get ( CurrentTimeStamp ) >= RESOURCE::Demo_End_TimeStamp ] Show Custom Dialog [ "GAME OVER" ; "The Demo time has expired. Be a part of Changing the world by purchasing My Program Today...." If [ Get ( LastMessageChoice ) = 1 ] Open URL [ "http://mywebdomain.com/PurchaseMySoftwarePage" ] Perform Script [ "Re-Register License" ; Parameter: 1 ] Else Close File [ Current File ] End If # Alert Every time log in if 7 days or less to end of DEMO Else If [ RESOURCE::Demo_End_TimeStamp - Get ( CurrentTimeStamp ) <= Get ( CurrentTimeStamp ) ≤ 604800 Show Custom Dialog [ "Alert" ; "You have only " & Round ( GetAsNumber ( RES_RESOURCE::Demo_End_TimeStamp - Get ( CurrentTimestamp ) ) / 86400 ; 0 ) & " Days remaining on this Demo." & ¶ & "Are you ready to change the world with My Software?" & ¶ & "Yes, will cancel the demo and allow you to enter a full registration key from a purchase or subscription on our site." If [ Get ( LastMessageChoice ) = 1 ] Open URL [ "http://mywebdomain.com/PurchaseMySoftwarePage" ] Perform Script [ "Re-Register License" ; Parameter: 1 ] End If End If You can have other scripts checking if this is a Demo to disable certain features, etc., A reset Demo Script for you as the developer and so on. Cheers, Ben

Hi Gary, One way to handle this is to use a separate mobile file that connects with a local connector file to your server where the host data file(s) are located. There are many ways to build a sync routine to synchronise the data that you wish and they can be fairly involved. I would recommend that you build the transfer in a Transaction so that the parent record with any related records posts completely to the server or not at all. You can build such a sync routine from Beverly Voths white paper the 'official Filemaker' paper on sync, and modify it to be inside a transaction. I also recommend looking at Colibri Solutions (James Wesolowski) GoConnect as a way to replace the local files on the iPad as you make changes to this file in development and going forward. Hope that helps to point you in the right direction. Cheers, Ben

I have been using it successfully for years. Infact the original GoZync from SeedCode was using this same method as well. The sequence of operation and the fmp12 script steps must be correct. I use a local intermediary file that has references to my mobile file and to the Host if that file had opened my mobile file instead of my mobile file opening the local intermediary file then I will get that error. I would have to look at it further to give any more specific answers. Starting with the Colibri Solutions files it works you might try to use those files again to see if you can get that to work and go from there.

I use a temporary or mobile Inv. No that is the Empl. No - Record No - Deployment No. The id is a numerical UUID not seen by the user. The record syncs with the server. The data file on the server uses a readable serial number that the admin user can set a new starting no. in preferences. An option I have considered is on the sync routine to simply replace the temporary mobile invoice no. with the Server InvoiceNo field thus another visual that the record has been synced, though we have a filed we set for this that shows conditional formatted "SENT" on the mobile invoice record.

Does anyone know if there is a code3of9 extended bean ( code39ext ) available to use with this script master module?

Hi all, I just was notified by The Support Group ( a filemaker support group ) that after the 11 v.4 upgrade FileMaker is good to go running Lion and that FileMaker Server 11 as well less web publishing with an update due in October. So I have installed Lion and now Filemaker Server is not hosting the files. So I try to open the Server java application and get this message. 'Unable to launch application' - I have not found anything on the web how to resolve this. Anyone else have any suggestions? with this exception listed : "CouldNotLoadArgumentException[ Could not load file/URL specified: http://imac.local.:16000/admin_console_webstart.jnlp] at com.sun.javaws.Main.launchApp(Main.java:367) at com.sun.javaws.Main.continueInSecureThread(Main.java:283) at com.sun.javaws.Main$1.run(Main.java:116) at java.lang.Thread.run(Thread.java:680) " and this Wrapped Exception: "java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432) at java.net.Socket.connect(Socket.java:529) at java.net.Socket.connect(Socket.java:478) at sun.net.NetworkClient.doConnect(NetworkClient.java:163) at sun.net.www.http.HttpClient.openServer(HttpClient.java:394) at sun.net.www.http.HttpClient.openServer(HttpClient.java:529) at sun.net.www.http.HttpClient.<init>(HttpClient.java:233) at sun.net.www.http.HttpClient.New(HttpClient.java:306) at sun.net.www.http.HttpClient.New(HttpClient.java:323) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:970) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:911) at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:836) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1172) at com.sun.deploy.net.HttpUtils.followRedirects(HttpUtils.java:45) at com.sun.deploy.net.BasicHttpRequest.doRequest(BasicHttpRequest.java:176) at com.sun.deploy.net.BasicHttpRequest.doRequest(BasicHttpRequest.java:113) at com.sun.deploy.net.BasicHttpRequest.doGetRequest(BasicHttpRequest.java:74) at com.sun.javaws.jnl.LaunchDescFactory.buildDescriptor(LaunchDescFactory.java:234) at com.sun.javaws.jnl.LaunchDescFactory.buildDescriptor(LaunchDescFactory.java:450) at com.sun.javaws.Main.launchApp(Main.java:347) at com.sun.javaws.Main.continueInSecureThread(Main.java:283) at com.sun.javaws.Main$1.run(Main.java:116) at java.lang.Thread.run(Thread.java:680) " Thanks for any help that you may have.

Hi Jim, check out the demo files from Soliant Consulting where Dawn Heady did a Webinar. See the Sales Tool file is loaded onto the iDevice and it does a push with the Invoice file on the server. So it is just setting up a relationship. When the mobile users are in an area with WIFI they can update the Server records and can receive new records as well. I found this most helpful. http://www.soliantconsulting.com/blog/2010/11/designing-fmgo-materials/

Have you set Auto-Restore Login to ON in FM Go on the devices?

Thanks Harry. I will check it out. Oh, yes I have read much of this. Liked some of the videos that were free. Not sure if i want to subscribe to see the rest. :(

Hey Fenton, I have been working on converting a group of solutions into one separation model. I have one portion pretty much done, although I do have a fair number of calculations in the data file as well as globals some for exploded string keys for dynamic portals and such. I wanted to eliminate as many calculation as possible from the data file, then I noticed in this post you mentioned putting globals in the UI. Can you explain a little about this. At this point I do not have a single field in the UI. Also really wondering about adding in the next group of tables into this solution as they are heavy with calculation fields and the thought of scripting 100 calculations is very daunting. Where do you draw the line ( if you draw a line ) on calculations in the Data file? Though this part is really the meat of this project It almost makes me want to drop separation altogether or just go ahead and keep basic calculations in the data file. The reason I want to set this up as a separation model is It will be a new release of a "shrink wrap" product that I would like to simplify the upgrade process as new versions and features are added to the UI.

Right. It would be rare that one changes their pricing structure on the items. Thanks for your help, in clarifying this.

Actually the user will use the pricing as far as reviewing their inventory and pricing in various reports in the ITEM table. My previous use of this file contains about 5000 items, though another larger company could easily double or may want all of what is available in the file meaning 20 times perhaps. Yes, the user can use several subsummary list reports that drill down into the data and the price may not be on all layouts but certainly is on some as well as on the ITEM Detail layout.

Yes, that is more clean. Here is how it looks setting it up to give the margin on the % Value entered ie Price = Cost / ( 1 - margin ) . Also including the 2 other Case statements at the front: This does look more clean. Thanks for your clarity. I think I found that the table names were required when using the data viewer and some how I had started pasting from the data viewer for some of the formulas that I test there first. And it is nice to not have the table name included. Now if I was to put this into a script from the interface file that would update a number field "Price" when an OnObjectSave or OnObjectValidate is triggered it works simple enough. Though if the global fields are modified it would need a separate script to loop through the entire ITEM table to update the records......mmmmm. Round( Cost / ( 1 - Case ( not IsEmpty ( MarkUp_@_RecordLevel ) ; ( MarkUp_@_RecordLevel ) ; PatternCount( gMarkUpChoice ; "Percent" ) ; ( gMarkUp ) ; Cost ≥ gSlideFrom[5] ; gSlideValue[5] ; Cost ≥ gSlideFrom[4] ; gSlideValue[4] ; Cost ≥ gSlideFrom[3] ; gSlideValue[3] ; Cost ≥ gSlideFrom[2] ; gSlideValue[2] ; Cost ≥ gSlideFrom[1] ; gSlideValue[1] ) ) ; 2 )

So, you mean the calc. would be : Case ( Cost => FromCost1 and < FromCost2 ; Cost/Value1 ; Cost => FromCost2 and < FromCost3 ; Cost/Value2 ; Cost => FromCost3 and < FromCost4 ; Cost/Value3 ; Cost => FromCost4 and < FromCost5 ; Cost/Value4 ; Cost => FromCost5 ; Cost/Value5 )[code] The calculation lives in the Item table, the interface file does not have any fields. So, I was incorrect in referencing this as being why the Table name precedes the field name, but it always shows in the calculation together with the Table name. When I started creating the separation model I wanted to have the least number of calcs in the data file. At this point it is not run by a script in the interface file, though I believe I can certainly put a trigger on the "Cost" and "FromCost" fields as referenced above to remove the calc from the data table. It appears the FromCost and Value field could be a single repeating field rather then my creating 5 separate fields, Correct? That would simplify the data schema, and your method would eliminate the "SlideTo" field that was used to create the range in my original formula.

It is okay. It has been in a files distributed since 1996. The user just sets up there mark up % on one layout with the mark up table below . If they choose to use a sliding scale for mark up. Many need to have a sliding scale with a higher mark up on the lower priced items, and lower on the higher priced items. The user selects on this same preference page a field "Mark Up Method" either with "Percent" or "Sliding Scale" Thats it. My original post was for the error from the field name change, which is resolved. Though if there was a streamlined way of what I was doing I am grateful to learn.

From Vaughans post the price cannot be determined because you do not have any values for the referenced fields. Forget 'levels'. This is a sliding scale table in which to mark up ( or add margin ) to create a selling price based on an items cost. In this example posted earlier are value entries to the fields referenced in Vaughans post or mine for that matter. "Eg: gSlideScaleFrom_1 $0.00 gSlideScaleTo_1 $5.01 gSlideScale%_1 33% gSlideScaleFrom_2 $5.01 gSlideScaleTo_2 $10.00 gSlideScale%_2 40% gSlideScaleFrom_3 $10.01 gSlideScaleTo_3 $25.00 gSlideScale%_3 45% gSlideScaleFrom_4 $25.01 gSlideScaleTo_4 $50.00 gSlideScale%_4 50% - $50 / .50 = $100 gSlideScaleFrom_5 $50.01 gSlideScaleTo_5 $100,000 gSlideScale%_5 60% - $100 / .60 = $166.67 $150,000 / .6 = $250,000. Though there are no items at this price level, and if there were, it may merit a larger scale to have a lower mark up on items in this price range. I had described exactly what these prices are used for above. They are used in and inventory file that is used by a retail price guide that puts the retail prices via a lookup ( for storage purposes ) into individual job records that contain labor and materials. "Huh? Run that one again?" The field names in the actual formula contain the table name preceding in this standard format: ITM_Item::Cost or as above fields would be ITM_Item::gSlideScale%_1 . So this would make the formula appear longer due to the table name preceding the field name. :D