Jump to content
Sign in to follow this  
73142

"copy record" script not working

Recommended Posts

I can't figure it out.

I'm logged in with full access, the button works fine in the client application but the web browser isn't copying the record. What could it be?

Share this post


Link to post
Share on other sites

Are you using it for copying only some of the fields to a new record? The easiest way is to make a few Autoenters which updates and let them blank the field you desire empty after duping the record.

To make this happen only in some cirkumstances, make the autoenter conditional by using:

http://www.filemaker.com/help/FunctionsRef-261.html

This way will you not be urged to let the script turn to a layout where the desired fields are shown ...which probably is why you're having problems.

By and large isn't it professional to engage the users clipboard with inner database mechanics, and especially not now a days when there are several other ways to accomplish pretty much the same.

--sd

Share this post


Link to post
Share on other sites

Søren,

Thanks for taking the time.

What I need is that the users through the web can have all fields on their excel sheets. Since IWP doesn't enable exporting, the second best thing for me is to let the users copy records to their excel sheets. Usually, copying one record at a time will suffice since they only need 1-3 records at a time.

The button is set to "copy records" but it doesn't perform the action on the web browser.

There is only one layout and it is set to full access to all.

I am logging in from the web as administrator, so privileges couldn't be the issue.

Strange.

There are some fields that are not on the layout (auto ID is one) - do you think it is the culprit?

Edited by Guest

Share this post


Link to post
Share on other sites

The button is set to "copy records" but it doesn't perform the action on the web browser

Yes that's also my understanding of the things going on, there are web-compatability indicated when you look at:

http://www.filemaker.com/help/Script-Steps64.html

But if you take a look at page 648 in SEU Filemaker 8 - would you read:

In General, any action that interacts with another application, the file system, or the operating system is not posible via IWP[/quote

So there isn't not much more you can do than paste the stuff gathered with the command, in a field, and then let the user grap it via a plugin like:

http://autocopy.mozdev.org/documentation.html

--sd

Share this post


Link to post
Share on other sites

Yeah, I figured as much but I didn't see the text you quoted. I got my clue from the following in the IWP manual:"...any script that modifies data should include the Commit Records/Requests step, because all data changes aren’t visible in the browser until the data is saved, or “submitted” to the server. This includes script steps such as Cut, Copy, Copy Record/Request, Copy All Records/Requests, and Paste."

Of course 'copy' doesn't naturally fit the description, but it is included nonetheless because in fact the FM team sees it only as an internal function, and thus akin to 'request and 'cut'.

Another case of gaps in the Technical Writing.

Share this post


Link to post
Share on other sites

but it is included nonetheless because in fact the FM team sees it only as an internal function

Yes, and it's pretty bad actually ...commands like this are kept for legacy purposes only, say someone upgraded an old solution and have an urge to som ROI in a jif... but why turn into the list of allowed commands in IWP???

Used in native non IWP mode tampers it with what the user might have stached away in his/her clipboard, and it really a bad habit to use any of the layout dependant commands, exept perhaps Replace( but it even have it's snags to it, when it comes to multi user scenarios.

Another case of gaps in the Technical Writing

Such things happens, my guess is that no-one inside FMI ever have thought of Anchor Buoying the RG, this happens every day in unversity research, something occures but the fuller picture might occure way way later, and not nessersarily by the people who made the discovery.

--sd

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By AlesD
      Hi I can not fiddle out how to make it work. I have tried several browsers with same result. We are using FM 12 server. I tried this file paths
      file:///C:/file.jpg
      C:/file.jpg
      file://localhost/C:/file.jpg
      and few others
       
      I'm using this code in the Web Viewer which is working fine in FM client but not in browser
      "data:text/html, <html> <head> <style type=text/css> " & table::style & " </style> </head> <body> <div class='thumb'> <span class='helper'></span><img class='thumb' src='" & table::ThumbnailPath & "'> </div> </body> </html>"  
      If it's caused by fact image is not present in web site folder as stated in document then my question is if it possible use unc network path in filename like file://///other_than_fmserver/networkpath/file.jpg. I wasn't successful either. 
      Any help appreciated
       
      Thank you
    • By KevinArevalo
      Good morning! I need some help getting something working.
       
      We have a company website, and we are trying to create a instant web publishing portal for our customers to login and view their open invoices. Pretty simple. We have all of our information on a FileMaker solution that is hosted with FileMaker Server 12. The problem is we can't get it to work the way we want it to. 
       
      This is our idea and how we kind of want it to work. We want the have our customers create their accounts/passwords on our actual website. We will store their account information on our web server. We will authenticate their login on our web server. Then, after they log into our website, we want to take their username, bypass the filemaker instant web publishing login page, and then set their username (which they used to log into our website, not filemaker) to a global variable or a field or something, we just need it in filemaker so we can do searches on it. We have the instant web publishing layouts built and we can get all that part working fine, we have the login authentication working on our site, that part is fine. It's just bridging the two together. 
      We are using WordPress to build the website, and our site is hosted on GoDaddy. Our problem is that we can't find a way to auto-login and bypass the login web publishing page. We currently have one account called "WebLogin" which we have been trying to use as a general login (since the actual customer login is authenticated on our website, not FileMaker) but we can't seem to bypass the page. I found this page through google searching: http://lnx.acidsoft.net/problemsolved/bypass-filemaker-iwp-login-via-url.html
      and tried to do it the way that he describes, but it is not working. It gives me an error saying:
      Bad Request
      The server could not process your request due to a missing command: ""
       
      And I get another dialog box that says: 
      Bad Request
      The server could not process your request because your session has timed out, been closed, or communication with the server has been lost.
      Please reselect the database to begin a new session. If you cannot open the database, please contact your database administrator.
       
      That is one of the problems, how can I resolve this?
       
      My other problems is we are trying to pass through the username that the customer uses to login to our website as a variable in filemaker or even set it to a field. I am not sure how to do this. Is this even possible?
      Thank you so much!
    • By djlane
      I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps.
       
      After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices.
       
      So, I set up an alternative server using FM12.
       
      A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL.
       
      Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect."
       
      I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. 
       
      Anyone know where I can find it ?
       
      thanks
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance!
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance.
×

Important Information

By using this site, you agree to our Terms of Use.