ShosMeister

Searching for a solution to my issue and thinking ScriptMaster may help. I'm just not sure it's worth going through all the issues with the plug-in just to be able to do what I want. Rather than completely reposting here (unless you want or a new thread), Topic Here is the thread I've been working on. Thanks!!!!

I think I'll avoid the web viewer as I will have multiple SC images/files/whatever you call them per patient record. With that, I'm getting the impression I can't use the web viewer but must use a portal view. I've managed to figure out how to edit the scripts to handle updating the necessary fields in my SC table so I think that will be the way to go - posted this question in the Logic Check topic here.

Awesome!!! I didn't find anything in the regular docs which is why I posted here. Looking in the Plugin docs, I found the references you are talking about and changed my script to Open URL(SCDownload(STP_Patients_SC:_cResourceIdentifier)) Works like a charm!

As Ideal indicated, it's sorta required now. Check under File:File Options" menu and turn on the "Login Using" to whatever one you want (the default Admin works as Ideal indicated). That will stop the prompt.

Hey Phil, Thanks for the input!!! I'd thought of that, but, I'm wondering if that would work since the script step to hide it doesn't. Since they are both in the Adjust Window step, why would moving it work and not hiding it? The only solution I've found so far is to actually close the window. The issue with this is that when the user navigates back to that file/db, they are back at the first record. That's the problem I'm trying to solve. I may resort to just leaving the windows there as they are all sized nearly (within a couple of pixels) the same and stacked on top of each other. Only way it would mess up is if the user moves them (which they usually don't). Since It's been running for 15+ years, they are pretty comfortable with the windows they way they show up and I'm trying to get that functionality back. Thanks again for replying to the weeping bump :)

Is there a way to allow a user to click on the image in a portal view and have it open or is this something that is only allowed in the web viewer? The one workaround that I've found is to script an OpenURL to the cFileURL when the user clicks on the image in the portal. This opens the image in their web application using SC and then the user can click on it from there to actually open it with whatever application is necessary.

I'm just starting to play with the demo to see if it will work for my solution - I'm pretty darn sure it will just don't know how to do it. Here's the situation: Want to store scanned copies of forms to a db. The problem is that each patient will have multiple forms and in some cases multiple copies of each form. Directory Structure so far: .../Patients/[PatientID]/Forms .../Patients/[PatientID]/Letters Here's the logic I'm working under so far: Can't use WebViewer as each patient will have multiple images so I need to resort to the portal method. First off, if this is an incorrect assumption, please tell me what I'm missing. Since SC only prefers 1 file per folder and my relationship for the portal is the PatientID, need to manually create the sub-directory for the new form. To add a form, use the SCChooseFile to allow the user to find the local file. If valid, lookup the PatientID in the Patients_SC db and get the found count. Add 1 to that number and embed that into the path so a new form for patient 1008 would be: .../Patients/1008/Forms/8 if this were the 8th form added. Using the demo copy, I'm building the cResourceIdentifier field (since it's already setup to use that one) and changed it from a calculation to a static text (could probably figure out how to leave it a calc later) and build it on the fly based on script parameters passed in (namely "Patients", "Forms", and "[PatientID]". Reason is that if this works, I will also setup a db for Doctors forms and letters. So, what's wrong with my logic? Anything? As will all programming problems, there are numerous ways to solve them. I'm just trying to find the simplest for now. Thanks!!

Just started playing with the demo. I noticed the "batch" import is run with a script that automatically appends a new director (1, 2, .....) to the path. Not a problem to edit that for my purposes. The problem is that if I use the "Upload" button that is in the WebViewer, it does the same thing but I can't seem to find a script for that. What am I missing?

As John said, from native FM access it's not since the db structure is significantly different. But, what about using ODBC or JDBC to access it? Never thought about it and haven't tried it, but, it may be a way around it for your "pilot".

I ran into the same question myself upgrading a 30 file solution from 6.x to 9.x. I tried to find lots of AppleScripts or Automator solutions to it and finally settled on the following which worked out great. I took a copy of the files and separately worked on converting them cleaning up relationships and other minor errors. Once they were all clean and working, I took the current production version and created a second folder for them. I took all of those files and dropped them onto my FM9 application which performed the basic conversion. These were not working as relationships and all would be invalid, but, they served as my "dirty" converted. Within the converted copy, I created a script that would import the records directly from it's matching converted (in the above step) production file. The script would open file 1 of my clean converted, delete all records and then import from the "dirty" converted files. Worked great for me. It took a while to get the scripts setup, but, once done, I could run it a bunch of times to test and ensure all was working before my final conversion. The final step that I did manually (since I only had 3 files to deal with) was to adjust the auto-enter ID number fields to the correct next increment. Hope that helps! Good luck.

I had similar "seemingly inconsistent" issues in one of my files after upgrading from 6 to 9. The culprit? COMMIT RECORDS. In prior versions, whenever a user entered data in a field, it was pretty much immediately entered in the db. Now it's not. Check if you are pasting data or editing field contents anywhere prior to the script and add a Commit Record script step. May not be your issue, but, it's one that we pre 7.x users never had to deal with until now. Good luck.

Bump :)

Okay, I know that the "active" window has changed significantly from FM < 7 to FM => 7. The solution that I've had in place since 1991 for a company is causing me lots of headaches. The navigation is via a "Main Menu" that I setup. There is a common "Button Bar" across the top of every file (table/db/whatever you want to call it) used to navigate the 27 files in the solution. Previously, I had the navigation scripts in each file. The steps were simple: I had a Goto Main Menu script that would hide itself and then execute the script in Main Menu to go to the appropriate layout. WORKED GREAT! It kept the screen clean and only 1 file was visible at a time. After the upgrade to FM 9, I decided to change the navigation buttons to execute the scripts directly in Main Menu (since it's now allowed to do that) and will delete all of the navigation scripts in the other 26 files (once all is working). The issue though is that I can't hide the original window. I've been fighting with this for months. My solution to get the upgrade done and deployed was to use the close window script step. The issue with this now is that the user is complaining that when they navigate away from one file and then go back, they are back at the first record so I need to fix this. Here's what I've tried to troubleshoot what's going on. I have my Goto xxxxx script setup to call a Hide Current Window script so that I can edit that easily and not have to change all of the other navigation scripts. In there, I displayed a custom dialogue to show me the current window name, state, etc. As suspected, all shows the Main Menu because that is where the script is executing from. Not a problem so far. I have a global that contains the name of the DB that the user last navigated to, Patients for example. So I tried using the Adjust Window: Hide step using the name as defined in the global. I included the value of this global in the custom dialogue so I could be sure it was accurately reflecting the file/window I wanted to hide and it is. So now the script displays the dialogue, selects the window based on the global and then attempts to hide with the Adjust Window: Hide step. The problem is, it does not get hidden. If I manually hide the window from the menu, the name shows up in the Show Window menu. When I run this script, it is still visible on the screen and in the main Windows menu. Any help? Anyone else find a workaround for this? I'd hate to have to write a bunch of scripts to manage what record a user was currently on when they leave a db and then go back to that record when they re-enter it. All this is on Macs running OSX 10.4 and 10.5 and the server is FM Server 9 on a OSX 10.5 box as well. Thanks for any insight, thoughts, condolences, solutions, flowers, beer, etc.

I'm not sure where you are talking about. If I do a Get Info and click the + to add someone, the Select User & Group dialogue shows up but there is no fmsadmin or fmserver listed. Should they actually be there or are they hidden somehow? I found a work-around by assigning the owner and group using the terminal (chown/chgrp). That seems to have worked for now, but, I'd still like to know if I should see those in the User & Group dialogue. Also, is there a way to write an AppleScript to change all of the permissions? I'm guessing yes but I know next to nothing about AppleScript.

Searched around and was not able to find anything on this that seemed to help. Client has a bunch of paper forms and wants them in FM. Short of creating a whole new set of databases (some of the forms have 70+ data elements), I'm thinking it would be easier to simply get the paper into PDF on the server then use a container field to point to them. Clicking on the container field will open the PDF. Is this possible? How?