hexxabubba

I am tryig to get a line chart to work. If I choose style of curve fitting it pretty much looks like I want; except list dates twice. Can someone please help; I have attached both files. Thanks in advance!!!

Do you know how to hide user/pass in URL? Thanks!

When I shrink down the web viewer the scroll bars maintain their proportions and look ghetto in a list view. How can I just have a preview and get rid of scroll bars? I am using : "?style=readonly&username=myuser&password=mypass" Actually I think it's fine. Looks good on web. Thanks

How is deployed? A a custom function. Does the plug-In need to be on server? This app. is being use in IWP. Thanks!

That was awesome...Thanks! [ "?style=readonly&username=myuser&password=mypass" By the way, can you trap to see if there is an image in viewer? Thanks

Thank You. It works, but I am still getting the UPLOAD FILE button; which I would like to suppress. I am trying to just view the image, and if 1 isn't there I don't want user to see dialogue. Thanks!

I tried using this, and it is making me enter authentication http://yourServer.com:8020/SuperContainer/Files/Asset/" & myTable::ID & "?style=nopreview" & "?username=myuser&password=mypass" Thanks for all your help!

It is important to read posts. I was looking in the documents folder on the server. However, I did a search by filename and did not find? Anyway, I went inside the documents folder in FMS, and there she was! Pretty as a picture! If my goal is to do a server side import from 1 FM file to another, then shouldn't I just schedule an export from source through destination file, and then the import of the same file after that, keeping the entire operation in 1 script so they don't overlap? Thanks again...

You are correct! Jacked by FM again. How come when I export txt or csv it says it happened in the scheduler, but the file is not in documents on the server??

I did this to a tee... Go to Layout [“Test” (City)] Show All Records Sort Records [specified Sort order: City::Country; ascending City::City; ascending} [Restore; No Dialog] Set Variable [$varpath; Value: “filewin:” & Get(DocumentsPath) & “testfile.txt”] Export Records [File Name: “$varpath”; Character Set “Windows (ANSI); Field Order: City::Country City::City] [No dialog] It seems to run as when schedule is over it says ok in administrator. But I can't find file??? Also , when I try to import from 1 filemaker file to another it fails...Both are on the same FM Server, have exact same admins, there are no script steps that are not allowed for server. I have tried every way possible..Including having source file with fmnet:/myserver/SourceFileName.fp7 and hard return with file:SourceFileName.fp7. Which is suppose to work?? I can run server side scripts, but the import step will not run...What do I need to do exactly to run a server side script between 2 filemaker files??? I surrender... HELP ME!!!

I'm confused...Have a box with Windows XP and FMP 9 client version with File Sharing turned off as server. There are approximately 4 users. I’ve been trying to set up a script for 1 of the users to import from an XLS. I have not been able to automate the script; as I think it should work. I simply want the user to import an XLS from the same folder on a desktop that has the same name. Works great in a non-server environment. It should work… When the database opens the “set path” script runs: Set variable [$$path;If( PatternCount ( Get ( SystemPlatform ) ; 1 ) ; "filemac:" ; "filewin:" )"] Set variable $$desktop; Get ( DesktopPath )] and then when the user is ready to import it calls the Import_from_Excel Script Set variable [$filename; "/XLS/" &"Test"&".xls"] Set variable [$fullpath; $$path & $$desktop & $filename] Import Records [no dialogue: Source: $fullpath; update matching] I am also trying to implement a simple backup script to the file. Works great in non server environment, but fails when using server. Upon closing: If [ get ( usercount ) = 1 ] Set variable [$pth ; "Filewin:/C:/Backups/" & "Filename" & substitute ( getastext ( get ( currentdate ) ) ; "/" ; "_" ) & ".fp7" ] Save a Copy As [ $pth ] I tried to do the save as from Menu but was grayed out. I did get Filepath at one point of file:../../../Backups/test.fp7. And it worked when I had file non networked. What does the ../../../ mean? I switched out a logo and when the file would reboot; the logo had switched back to the original. Yes it was the same file; being accessed through remote access. It's a global container field. To fix it, I ran tskmnger, and ended all Filemaker proccesses, dragged a copy to desktop, fixed logo. and replaced... I didn't set the server up; but the folders look like how you would expect Filemaker server; but it is using Client. And Finally. I tried to create a simple launcher, and I couldn't figure out how to close the launcher. Everything seemed to work except the last step... Set Error Capture [On] Open File [< pick your file from the list. Since you only made one file reference you'll only have one file in the list >] If [PatternCount(DatabaseNames, "YourIntendedFileName")=0] .. Show Custom Dialog ["Unable to open file at this time. Call IT Dept if you keep getting this message." / "OK"] End If Close File [Current File] I even tried to have the main file open script close it; and that didn't work. HELP!

Any good methods to generate random alpha-numeric numbers? Certificate Field=7 digit number set by script.User determines start number and amount of records to generate.This number must be unique... Each series will be 10,000 number increments. Unless someone sticks a 100,000 in there... So I guess it doesn't matter if pin is unique but it would be nice... Pin Field=6 digit random numeric. =auto-enter calc =Right("000000" & Random* 999999; 6) I want the pin to be alpha numeric... Thanks in Advance!

Thanks, I'm sure that will do the trick... maybe I'm going about this the wrong way. I have a Tournament Table, I pick Boats from a picker, and I have the angler table related both to tourney and boats picked. The list is a calculation derived from there. Can you use a field calc List(anglers) as you would a avlue list? Would this script fail in a network environment. Should I do it differently?

Thank you so much... How can I store all the id's in Variable. It seems your script doesn't deal with list(anglers) only 1 id. I have a value list of Angler ID's: say: 111 112 113 114 How can I write the script so it deals with all the values.

Doing a database for a fishing tourney. Busting my head. Need some serious help with this script. Boats are chosen with a picker from the Tournaments table as participants. Each Boat has a number of Anglers. Boats and Anglers are related by iD. I created value list of both portals. The Boat list is a list of Boats chosen, and the angler list is a list of the Anglers on those boats. From either or both these lists I am trying to create records in a seperate Table called "payments" related by tourney id. 2 value lists Boat Id's & Angler Id's The Id fields are correct but I need help with looping script. ie: boats Anglers cornelia Marie Al-Captain, Jack honey hole Sam-Captain, Jim hoof arted Charlie-Captain, Tom, Dan Trying to create payment invoices for each angler . The Captain gets 3 invoices, and everyone one else gets 2. 1 Captain per boat, varying amounts of anglers. -an invoice for "entry fee" to each boat "Captain" The value "captain" is assigned to 1 angler per boat..... -2 invoices per angler ; side bet 1 & side bet 2 record creation would look like this... Boat Angler Cornelia Marie Al Captain Entry Fee Cornelia Marie Al Captain side 1 Cornelia Marie Al Captain side 2 cornelia Marie Jack side 1 cornelia Marie Jack side 2 Honey Hole Sam Captain Entry Fee Honey Hole Sam Captain side 1 Honey Hole Sam Captain side 2 Honey Hole Jim side 1 Honey Hole Jim side 2 Hoof Arted Charlie Captain Entry Fee Hoof Arted Charlie Captain side 1 Hoof Arted Charlie Captain side 2 Hoof Arted Tom side 1 Hoof Arted Tom side 2 Hoof Arted Dan side 1 Hoof Arted Dan side 2