Windows Automation

I have a VBasic program that calls a run script via ActiveX. for the most part it runs fine, but since I have both FMP versions 6 and 8.5 installed, The ActiveX activates the Version 6 copy of FMP sometimes. If I reboot and then run FMP Ver 8.5 it works fine. as soon as I run ver 6, its continues to try and call it. The program then crashes, debuging reports a Runtime error '13': Type mismatch on the following line: Set FMApp = CreateObject("FMPro.Application") FMApp is defines as follows: Dim FMApp As FMPro70Lib.Application Has anyone had this problem or a suggestion on fixing it? With fingers crossed, Charles

I'm trying to collect data from PLCs. Filemaker cannot read directly from them, but I can write a driver to get the data. Question? How do I get the data into FM automatically. Does FM support ActiveX controls. If not, are there some ODBC driver toolkits that I can use for custom driver development. Ultimately I would like to set up a data table in FM that stores the PLC addresses to read from, have the custom driver get the info from FM, then collect the data based on the addresses from the PLC, and transfer the retrieved data back into FM. Any help would be greatly appreciated and would earn a Great Master of the FM Universe Title

Hi guys Is there a way of sending a command from FM to Word to insert an image at a specified point in the file? I have an rtf report created by exporting xml and transforming with an xslt sheet. However, I can't export the contents of a container field, so would like to be able to export to a specified location and then use a command to 'pick it up' and insert at a place holder in the rtf / word doc. Is this possible? Thanks in advance.

Hi All I have a standlone solution that exports out a textfile. For example textfile.tab I’m trying to create a button that runs a script that will directly print the file from without the user having to locate the file and then print. And the ultimate would be to print to a virtual pdf print driver. Any ideas... :

does anybody know any on-screen key board which are freeware other than window xp on screen key board ? thanks , mike

I'm trying to make an update system for a set of runtimed files we use at work. I've made a Web Viewer download a text file from my server, parse it and see which files and been updated, the next stage of my plan was to download the files, close the open ones and replace them with the downloaded versions. But I got stuck with the downloading. I've tried using an internetexplorer object from VBScript, but had no luck. Just wondering if anyone has done anything similar or has any ideas/tips on how I could do this. Thanks

Can I use VBScript to automate faxing out of FM on Windows XP Pro(using the built-in fax server) and bypass the fax wizard? I read somewhere that this is possible with Windows Server but not XP Pro due to the way that objFaxDocument.ConnectedSubmit(objFaxSer ver) works, but that may not be right. Thanks! James

How do I open an excel workbook to a specific worksheet whose name matches the contents of a field in FM7? I have tried to use a hyperlink but can't get FM to pass worksheet i.e. c:/workbook.xls#sheetname I also tried using the Send Event script step but couldn't get it to pass the worksheet name either. How can this be done using VB Script or ANY other solution? Again, I need to pass the contents of a field in FM7 to some soft of external script that will select and display an Excel worksheet of the same name as the contents of the field. Thanks in advance! ~ Tyler

Hi guys (Probably Wim), I did try googling this first but... How do you center VBScript created objects when you get them to pop up... e.g. how do you get this to center on the screen when it appears: Set ObjFSO = CreateObject("UserAccounts.CommonDialog") ObjFSO.Filter = "All Files|*.*" ObjFSO.InitialDir = "C:" InitFSO = ObjFSO.ShowOpen If InitFSO = True Then Wscript.StdOut.Write ObjFSO.FileName End If

Is there any way that VBScript (or another method) on a Windows box under Windows 2003 FMSA8 can capture a problem at our (networked) printer. Microsoft pops up with printer error messages all the time. We have printings that are critical. If we have a problem, sometimes we need to stop a process until the proper documents are printed. I want my script to know (not only from User verification) that everything went smoothly. They read the message, "Did bla-bla print correctly?" and, no matter how big I make the message; no matter how I word it, they sometimes click "YES" when it didn't. Very very bad. Can I make script pause until it DOESN'T receive a print er…

There's gotta be some kind of simple app or solution for what I'm trying to do. In Mac OS X, (and all Linux boxes) there's a shell program called "curl" that lets you download something off the web and store it to a specific location on the hard drive. Is there anything like this that is already installed on Windows (XP) machines? Or, are there any simple utilities I can easily access with FileMaker to accomplish the same result?

Hello guys. I'm trying to get FM run a VBS Script that does the following: 1. Open an existing Word Doc 2. Enter the address in a text field 3. Enter the date 4. Enter the Customer number 5. Enter Quote number 6. Save the Doc to the this formula: Quote-Nr. & ", " & Name & ", " & Place & ", " & Get(CurrentDate)& ".doc" 7. Leave the Doc Open and ready for editing Any Help would greatly be appreciated. Thanks in advance. Best regards. Ron

(If this post isn't in the correct forum, Moderator, then please move it there. Thanks!) First, I want to say I'm totally clueless how to do this so if you can provide a simple or technical answer I'll forward it to the Web developer for his analysis. I have an FM-8.0 runtime solution that I want to export data from it to our company's PC-based web server without having someone redirect or convert the data to another form; the process needs to be fully automated. The Web developer sent me the attached form that he would like to have auto-populated with the exported data. The big question is, since I'm on the sending end of things (sending the exported data from …

Without using a plug-in, is there a way to activate a TWAIN scanner from within FM (through VBS perhaps)? I do see a plug-in at http://www.powersolutions.it/en/insidescan.html but can't tell much about it from that page. Plus, it doesn't appear to have been updated in a while. If there's a better plug-in, I'd be open to it as a second choice. Thanks for any suggestions! James

I would like to link the CAD application VectorWorks with FM so that I can find a specific record (by a unique ID). VectorWorks can open a URL in the form file:///pathname or http://pathname with the unique ID embedded within it. The ideal solution would be that opening the URL in VW would display the referenced record in FM. I am completely new to the Windows environment so what mechanism should I be looking at to perform a function like this? Many thanks, Joel.

On my Mac in can run an Applescript to access a shell script thus:- set the_data to (do shell script "/usr/local/bin/babel /Public/acetophenones.fs -osmi -xt -s 'c1ccccc1F'") set cell "Results" of current record to the_data Can I do something similar on Windows? If so can some give me a simple example? TIA

I sure hope someone can help me with this. kind of ironic that I have spent more time trying to get odbc working than on major portions of the data base. I have the Datadirect 5.4 driver and have used the Win XP control panel [Adm tools; ODBC] to "Add". This worked for user DSN but for System DSN, I get this error #2306. "[DataDirect][ODBC Sequelink][sequelink Client]TCP/IP error, connection refused" I get this when I press the '...' button. I cannot set up a file DSN either; same error. I have tried the network sharing on and off. I have the odbc sharing on. I need this to work so I can connect Tracer ODBC Link to the FM data base, to connect th…

We are running Goldmine in house and am trying my best to phase it out... but... Is there a way to pull contact info from Goldmine into filemaker 8.5 advanced? I downloaded a lil prog that will copy to clipboard but it's hacky and I know how people feel about clipboard usage... I tried every goldmine forum and no luck. One chap told me about a VBScript and I've been going through every post here looking for an answer. Any advice?

I had a 'Send Mail' script sending some static and variable text to a general email message in notes: After completing a work order you would hit a button and Lotus notes would create a new message that said here's your workorder number, blah blah, and cc the project manager, etc. I've recently upgraded to Lotus Notes 6.5.5 and now the text that used to port to the message field of the email ports to the cc field of the email??? Any suggestions. Regards, Johnny

Hello, I found a sample VBScript posted by Wim Decorte that executes a script maker script on a database, however I tried modifying the VB script to open a runtime application rather than FileMaker itself.. is this functionality possible with a runtime, and if so, can someone please post a sample script as how to reference a runtime app? I just started learning VBScript.. I am more into AppleScript but need to do some PC work -) BTW. Thank you Wim for all the great stuff posted on this subject. -- Best wishes, Daniel Taylor

I have been having a little difficulty with a scipt to export data out as a merge file, rename the file, and move it to a mapped network drive. I am running a script to loop and export multiple exports with a three second pause to rename and move the file from the curent folder. The exported file is placed in the current folder as “Cutlist.csv.” Using the Send Mesage script step the file is renamed and moved with a Send Mesasge script step. Rename: "CMD /C " & "RENAME " & """" & Substitute( Substitute( Substitute( Status( CurrentFilePath) , "file://" , "" ) , "/" , "" ) , Status( CurrentFileName) , "" ) & _Optimizer_FileName & """" &am…

I work a lot with XML API's using Classic ASP where I simply use an HTTP POST to an API and parse the response accordingly. Is there a way to access FM's XML API in a similar way so that I can use that method instead of ODBC to grab data from it? Any information would be greatly appreciated. Thanks!

Trying to get this script to work in send event in PC, but all it does is open c drive. anyone can help? thx $filepath is defined as Right ( Get ( DesktopPath ); Length ( Get ( DesktopPath ) )-1) & "PDF Folder/" "Set objFSO = CreateObject("Scripting.FileSystemObject")" & "¶" & "If objFSO.FolderExists("" & $filepath & "") Then" & "¶" & " Set objFolder = objFSO.GetFolder("" & $filepath & "")" & ¶ & "Else" & "¶" & "Set objFSO = CreateObject("Scripting.FileSystemObject")" & "¶" & "Set objFolder = objFSO.CreateFolder("" & $filepath& "")" & "¶" & "End If"

Is there a way to store value list items in a recordset from a web application? In FileMaker, we have a Products file. Within that file is a field attached to a value list called Categories. This value list contains different categories for products. I'm trying to create the same list of categories on a web site for browsing but using the SQL SELECT Categories FROM Products doesn't work because there are some products in the DB that have manually typed categories (don't need to be displayed on the site). There are too many that aren't accurate and it makes the list look really stupid and a lot longer than it needs to be. So, if I could could create the rec…

I'm developing some things for a client of mine that uses Filemaker. Most of the scripts I do simply use FM as a backend; it does it calculations and then simply populates fields in Filemaker. My client does have lots of internal Filemaker scripts that are setup that they use as well. Quick overview of my project...my client sales primarily on eBay. They have an Auctions file in Filemaker that stores all of the auction details. I've created a script to automatically update all of the FM auction records with data from eBay. My client uses an internal FM script attached to a button within the auction records to Send Checkout, which of course, sends checkout in…

Hello I used FM to classe vector constructions. I want to open a file in a different programs (Vector NTi). I was able to make the link to open pdf file but not these other type of files. Thank you Raphael

A bunch of records got updated with false data that needs removed. The data is an address and is kept in a notes field. The data was inserted with an external script via ODBC and uses chr(13) for cairrage returns to format the address: Name Street 1 City, ST 00000 (000)555-3432 I simply need to remove this. Is a Find/Replace the best way to do this? And if so, can I use chr(13) within that the same way I did in the script that inserts the data? So my Find would be Namechr(13)Street 1chr(13)City, ST 00000chr(13)(000)555-3432 Replace would be blank. Will that work?

If I try to use the scripts I wrote when I was designing the database locally it wont work now that I have the database hosted on FM8 Server. Something about the database being open. How can I trigger a script to import records at a certian time? It used to work, but now that it's hosted VB can't seem to touch it? I'm using the admin login/pass as well to test it... still doesnt have permission. The database shouldn't have to be closed to import these records in? Help!

I have the start of some VBS that opens a word doc. I then want to somehow grab the contents of the document and insert the contents into field in my database. Is this possible? I also want to call on a FMP script at the end of the VBS if possible. Here is my VBS so far.......I hope it makes sense. Set objWord = CreateObject("Word.Application") objword.Visible = False Set objDoc = objWord.Documents.Open("192.168.0.50adminHRSCvsDaxtraCVs14123819122005_4622_original.doc") [color:red]I need Help here objWord.Quit [color:red]I need Help here objFMfiles.DoFMScript ("test1")

I need to create unique identifers that follow the following format: A unique identifer for a particular call. If the same InvocationID is passed in after it has been passed in once on a call that succeeded for a particular application and user, then an error will be returned. The identifier can only contain digits from 0-9 and letters from A-F. The identifier must be 32 characters long. For example, 1FB02B2-9D27-3acb-ABA2-9D539C374228. In SQL Server I can simply run SELECT newid() and it'll return an ID in that exact format. Is there something similar I can do in FM to create this for a record? Any information would be greatly appreciated. Thanks!

I am working on a solution that exports from a series of access tables via ODBC to FileMaker. FileMaker is creating a report basically showing a production routing listing work centers and an operation sequence number. The operation sequence number is represented as a bar code (barcode 128AB). Just representing the data as a given barcode will not work, when scanned. It appears as though the data is converted with a control character at the beginning and a calculated check sum value again converted to ASCll code, at the end. I was given a utility program and a file used to import into either excel or an access table that via Visual Basic scripting converts the data. T…

I'm trying to build a very simple login for a web page. I've created a table in FM to store username's and password's. Right now I have 2 records in there: testUser1 testPW1 testUser2 testPW2 When I create a recordset like: SELECT * FROM POWebUsers I indeed get a recordset with both records in it. However, if I try and check for values in username and password to authenticate a user: SELECT * FROM POWebUsers WHERE username = 'testUser1' AND password = 'testPW1' I get an empty recordset!? What on earth is going on here that's causing me to waste so much time on such a simple task? Any information would be greatly appreciated. Thanks…

I'm connecting to FM via ODBC and inserting, updating, deleting reords, etc. Many of the files I'm working with have fields for Created By:, Updated By:, etc., and it automatically fills these fields with the current User Name set in FileMaker preferences. My scripts that insert and update records via ODBC, though, use the login username here. Is there way I can set what this should use as a UserName for ODBC connections? Any information would be greatly appreciated. Thanks!

I've got a Filemaker file that stores auction information for eBay. One field I have in there is called Sandbox is has a Yes, No drop down menu where you can select Yes or No and it holds that value. When I'm creating a recordset in my ASP scripts outside of FM, If I use the following: SELECT Auction_Number, Auction_ID FROM Auctions WHERE Auction_Status = 'Current' AND Sandbox = 'Yes' that works perfectly. It returns only the auction records where Sandbox has been set to Yes. Now I'm trying to return only non-sandbox records, so I use the following: SELECT Auction_Number, Auction_ID FROM Auctions WHERE Auction_Status = 'Current' AND Sand…

I've got a timestamp field in FM that a script is bringing in as GMT and it's 5 hours ahead of my actual time. Is there a way in FM to subract 5 hours from whatever is in that field so that it's correct for our time zone? Any info would be greatly appreciated. Thanks!!

I do most of my scripting with ASP and just populate fields back in filemaker at the end. To fire these scripts I attach it to a button that simply uses Open URL and attaches any values from Filemaker I need as querystrings to the URL. Is there a variable for current user I can use to also attach the current user's name as a querystring value with the URL? Any info would be greatly appreciated. Thanks!

I think I have seen this covered in the apst but I could not find it by searching, so I apologize in advance if this topic has been covered in the past. Is there a way to trigger a script (event) byt the act of tabbing into or out of a field? It sure would be handy! I thought I saw this covered through a plug-in, but then I thought I also saw a work arouond. any ideas? Thanks, Steve

Hi there. Thanks for reading my question and even more thanks for answering the issue.... Tried to find an answer in the forum, but alas... Services/programs like skype and voipstunt have the possibility to act on a callto: command. I want to use voipstunt for calling from my database, running on an XP (sorry; no choice here) In the FM scripting I can find dial, but than it will search for a modem, which isn't around. Does anybody know a way to insert a button&script for it? Thanks again, JP (Have to mention I'm no professional programmer and often just glad the xp works without problems)

How can I write to an appropriate field the name of another field? the Get ( ActiveFieldName ) doesn't do this as using this Set filed (my_field, Get ( ActiveFieldName )) I get "my_field" into my_field as this is the Active Field I would like something like copy "Get ( ActiveFieldName )" to then go to my_field and paste that content, but I can't figure out how to do so. It seems as every function requires a field name, and I am lost. Thanks a lot

Hope someone can help. I’m normally a mac guy so the specifically windows only areas of filemaker are new to me. As you know, Filemaker is unable to call one of its own scripts by a calculated value. ‘Perform Script [xx]’ You always have to specify the existing script name and ‘hard code’ it into the trigger (button, other script or whatever). What I’m wanting to do (as I’m sure many developers do) is to call a script based on a name stored in a record. I have a series of ‘resources’ or ‘tasks’ that appear in a menu (using a portal). I want to allow the user to click on a task and for filemaker to run a script based on that name stored in that record. I hav…

The following script works in Filemaker Pro 8 Go to Layout {"InvoiceViewer"(Invoiceviewer)} Show All Records Delete All Records[] Send Event ["aevt", "odoc"; "cmd/c dir /b M:FolderfolderPDFfolder >c:outputfile.txt"] Pause/Resume Script [Duration(seconds):5] Import Records["outputfile.txt";Add; Windows ANSI] Show All Records But when I create a runtime it fails with the following message: The file "outfile.txt" could not be found and is required to complete this operation If I hit the OK button it allows me to select the file and the script continues. It worked in the previous runtimes I created. Any ideas?

I was looking at the template for resource scheduling in filemaker and there is a function called add project. When you press it it takes you to a different layout where you add information then press continue. This takes you back to the original layout and adds all the details in the field. Could someone please explain how this works as this is idealy the function I want to use for my database. I think I need to understand it in order to create it and would be very greatful for all help I can get. Frida Lindholm

I'm trying to create a script in FM that shows a dialog box and only continues on if the user presses OK. Right now I've got it setup like: Perform Script [] Show Custome Dialog[] Open URL [] I'd like for the Open URL part to only happen if the user clicks OK. If they click cancel it needs to halt here and not run the Open URL part. What do I need to do to make this happen? Any info would be greatly appreciated. Thanks!

Hi, Does anybody have a clue how to automatically send mail and close mail app (Outlook) on WinXP (SP2)? Thx in advance VJ

Hi, I am using FMP 8 and one VB Script. With this VBS I like to launch FM Script on other FMP file on other computer (standar office LAN net - IP) ... but I have problem with writing right network file path ... VBS is: Set objFM = CreateObject ("FMPRO.Application") objFM.Visible = True Set objFMfiles = objFM.Documents.Open("????c:Proba.fp7","Admin","") objFMfiles.DoFMScript("test") Thx VJ

Folks I have been experimenting with VBS and have run into a snag. The objFMfiles = objFM.Documents.Open has thrown me for a loop. If I format it as any of the following it errors out (405): objFMfiles = objFM.Documents.Open("C:t.fp7","") It does work however if I format it like: objFMfiles = objFM.Documents.Open("C:t.fp7","UserName","Password") I would like to use a local opener without a password if possible (I authenticate all my folks through our LDAP server and don't wish to duplicate this structure in the local file), but I can't get the file to open unless I have a Users and Password setup in the file and in the VBS. Vince Dolan …

I'm trying to figure out how I can grab the value of a newly inserted records ID for use in adding data to related tables later. In SQL Server and Access I can use SELECT @@IDENTITY to get this value. This doesn't seem to work for me with Filemaker. What can I use here to make this work? Any information would be greatly appreciated. Thanks!

Hi all, I am wondering whether there is a possibility to execute a program on the server side using "Send Event" script step. I was able to execute on the client computer, but deploying the executable to the server would be more economica. The current script line looks like: (after "Send Event["aevt"; "odoc";...) "cmd /k" & ¶ & "java -jar c:fm8_update_MySQl.jar " & test::text1 I would expect that some network mapping should be done on all clients (to point to a shared directory on the server). Is this feasible or are there better ideas? Thank you, Gavril

Hi, I am trying to execute a java program with a parameter from within FM8. I am only able to launch a .bat file using "Send Event" script step and monitor the execution in a DOS window. Is there more flexibility with "Send DDE Execute" script step? I would appreciate your help or some best practices to achieve something similar. Thank you, Gavril

I have a field that is a PATH to an image that is important to the record. ie: L:datav01imagesequence_0001.jpg What I would like is 3 buttons. Button #1 This would open a file browser to select the image. This would be the same image that is displayed in a container for the record as well. So if we can minimize redundant mouse clicks and have it put the image in the container, as well as put the path and file name in the "SeqPath" field, that would be great. Button #2 This second button would launch an imageviewer/ RAM player that would play the image sequence in its entirety. I assume this is simpler. This would essentially be, c:programfi…

I've got an ASP web script that runs updates on some Filemaker records. One of the things it does is includes notes in the Invoice records. It includes line-breaks in the notes to keep it nice and clean and that does work, however, in FM you end up with a little square at the end of each line where my script put in a line break. Is there any way to make this stop happening? It's a little annoying. Any information would be greatly appreciated. If you'd like a look at what I'm talking about you can see an example here: http://www.dealsdirectinc.com/temp/fmNotes.jpg Thanks!

I'm not sure if this is the right forum, if not please direct me to were I should post this. My problem is this, I have a FM7 File that needs to periodically update via ODBC, some of the tables require existing records be deleted and imported again. Solution has worded well for months. But now the record updates are VARY SLOW (aprox time is 10-15mins) It’s not just the ODBC it is the record delete step that is slow. It will also hang filemaker from time to time. Originally time was aprox 1 min or less. File size is consistently about 1 meg, record import is about 10,000 records consisting of 4 to 9 fields depending on the table of which there is a total of 4. The Machine …

My usual way of doing this in a very limitimg case is to create an FM file that executes a startup script, which in turn executes a script in the target file. I can create a floating tool bar in WinBatch that has a number of buttons each of which I'd like to link to a different FM script. The functionality would need to be available in a runtime. Does ActiveX do it, and is it available in a runtime. This only needs to work on Windows. Steve

From a VB applicaion I call a Script within FileMaker which does an export. I would like to be able to know when the export has completed, so that the VB application can continue. I have looked at sending a DDE message in FileMaker so that VB can detect it but haven't managed to get it working, has anyone else ever tried this or got any other ideas? Cheers

I have a script that loops through 1500 records and prints an associated pdf. I find that now it has missed printing some of these pdfs. Some are 50 pages long and may take 7 or 8 seconds to send to the printer. But others are only a few pages long and still are not printing. I ran some tests on a batch of 100 and of course they all printed fine. So I wonder if there is a way to find out when a pdf has been printed and then go to the next record without an arbitrary pause. LoopScript.pdf

I have a script that inserts files (only the reference) in a container field, then he copy them from the original location to a folder on the server. When I delete the record I want FileMaker to delete also the file on the server. On the Mac is just working fine with an AppleScript, but I don’t have a clue how to let this work on a Windows XP. Any help would be great.

We had a solution running in the office that exported the contents of a field into a text file. In FM7 the resulting file is 2 byte unicode, and there is no option to export it any other way. We needed to convert the resulting text file to ascii. The quick and dirty method is to scan the file and simply delete any occurrence of the bytes 00, FE and FF (hex). On the Mac, I use a one line shell script to do this with TR, and we were using a perl script on the Windows machine. That is, until the IT guys came and refomatted the disk without asking anyone, and wiped out the only copy of the script. The guy that wrote the script is no longer around. So, now I need to recreate t…

Hi: I have a script that reads a folder of images and then creates a text file containing the image name information. That file is then imported into a table. That table is used to create a dynamic value list that the user can select from via a drop down menu on the main table. Question is how will the script know when the text file is finished before importing that file. The folder can contain varying amounts of images. Hence the need for a dynamic value list. Right now I have put a pause with a duration of 4 seconds. But depending on the anount of files the command line can take a longer or shorter duration to read the folder. Send Event [open document/…

Anyone know of a way to rename a backup to current date and time? I've tried writing batch files / researching the code... but no luck, i just can't seem to find the appropriate code for it. Wim, i'm looking in your direction here, pretty please? Cheers, ~Genx

Hi, My company is running FM7. To maintain the files, I come in after hours every few weeks, open the files in Developer 7 and run the File Maintenance feature. Is there a way to automate this type of file maintenance?

There I was having a random read through the FM help manual and what do you know, i stumble on a wonderful section that lets me execute scripts in filemaker files without showing the application. Okay, well thats fun, really it is, however, my question is the following. I need a specific script executed once a day. However, it requires uploading somewhere, so the internet connection has to be valid. What i need to happen is, if the internet connection isn't available, i need to execute the script again in 5 minutes (i suppose i could build this into the actual FM script). Okay, then slight change in question, if i wanted to put this on the server, how proc…

Hi, I am trying to make Queue Solutions for retail, I am using Scala software (multimedia sw) and FileMaker conected through VBS. I have situation that I have 10 cashier which can have same service, I mean, service „A“ must be available on cashier no. 2 and no. 8, sooo, I must share „the number“. So, I tried with 3 FMP – One Host and 2 clients. All FMP communication is through FMP Scripts. But problem is that sometimes client succeed to run FMP Script on Host, sometimes not, sometimes it open new record with RecordNumber and export it sometimes not ... Any suggestion to solve this problem or hole solutins? Thx in advance VJ PS. WinXP, FMP Advance 7…

Hi all, Is there an easy way to update an old version of a solution into a new version? Currently, i'm doing the updating at home then back to my client PC with an empty new version then import all records from all tables in the old version. The problem I got so far on this approach is on those serealized fields in the solution. Sometimes I missed to update them with the current value. Any suggestions to get it updated accurately? Regards, Garry

I'd like to automate connection to VPN if a server can't be reached via network. My users connect over VPN vs. WAN so local resources can be accessed etc. Anyone have any ideas as to how to automate this via cmd line or run? Cheers, ~Genx

hopefully this thread posted at a right place. it was very good and wonderfull lay out i hereby attached. when i click a button 'invoice' which located at upright, then the lay out flip to next record. how to do this script INVOICE_Copy.zip

Is there a way to capture a User's IP Address when a script is fired by them? I've realized that two people can be logged on as the same Account, ie, sometimes I'll log on as many people (smile) but it is impossible for two people to be using two different IP Addresses at the same time, right? I would like to use this information if it's possible. LaRetta

I'm trying to run an FM script from Microsoft Word VBA Code. While this is pretty easy to do if the database is local, I'm having trouble figuring out how to do this over a network. The trouble occurs at the following VB line: Set FMProDoc = FMProApp.Documents.Open(filepath, password) Basically, it opens a database using the specified filepath and password, and then stores a link to that database inside the FMProDoc object. Unfortunately, I cannot determine what filepath to provide for a database on a network. From Filemaker, I would normally go to "Open Remote", choose "Local Hosts", and pick the shared database I want from the list. Is there a filepath…

I have an applescript, that "processes" images, I want to know if there is a way to do this with VBScripting, or anything else on the Windows side. Here is my applescript. ConvertFiles() on ConvertFiles() -- set the folders that you want to use set inputfolder to "Macintosh HD:O_Images:input:" set outputFolder to "Macintosh HD:O_Images:hires:" set copyFoldername to "Macintosh HD:O_Images:thumbs:" tell application "Finder" set filesList to files in folder inputfolder end tell tell application "Adobe Photoshop CS" set display dialogs to never close every document saving no end tell repeat with aFile in filesList…

I would ike to know if it is possible to access a filemaker database using visual basic?? Just like a Access database? I would need to write "0" or "1" to a field in filemaker, can I do this using VB.NET (or any other third party programming language?) I'm using FileMaker 6

I found a very useful event script example on this forum for creating a folder, which i have tested and works wonderfully. I though i would go one step further and get it to copy a file from my desktop to the c drive. The event script text is as follows: cmd k copy "C:Documents and Settingssteve-wDesktopsource.fp7" C:source.fp7 If i go directly to the command prompt and copy the above less cmd k it works. This seems to prove that there is no weird syntax. However, it will not run it through the event script. Does the event script in filemaker prevent certain dos commands from working or am i missing something obvious.

Hey All, I am trying to use FMServer 5.5 to run a command file each night. The purpose of the command file is to run a Filemaker Pro "database" that archives my main company databases. It is modeled after the Filemaker example for recalculating the "Today" function. Basically I have the FMServer set to close all company files (using a command file) at 12 midnight. This has been acheived successfully each night. FMServer then runs another command file at 12:30 to open all the company databases. This has been running sucecssfully. Finally, I scheduled FMServer to open a "database" on the server (using a command file) that automatically …

How can I automate the process of changing the filename after the fact. For example, if the filename is "Data" I'd like to rename it to "01312006_Data" where the numerals represent the date. Thanks.

can you create folders in a designated drive with scripts? example: i have a layout where people put in the file name of pictures and first they have to go in to the directory and find where it goes make the folder then put in the file path in the filemaker feild i want them to be able to put in the file name(just the file name not the path) and it creates and or puts it in the proper folder it goes in

I'm unsure where to post this. At work, a User (station running FMP7) accidently hit a strange keyboard button (while in FileMaker) and received this message (which looked like an internal FM-generated message) Sleep Request: System has received a Sleep Request but cannot while FM is shared. Do you want to close the Shared File to allow the Request? I don't want our served file closed! I don't want Users to have the ability to do it either! I was afraid to test it (by saying YES) because there were 6 Users currently using it. I was going to test it at home (I'm networked) but my keyboard doesn't even have a key like that. It's a recessed button with a qua…

Hello, Let's say I have the path to a folder stored in a field, and I want to open all the files in that folder. For example, let's say I have a folder full of JPGs. I would like to either open them with a specific app (like Photoshop), or with whatever program is associated with .JPG I'm guessing the logic would be to get a directory listing of the files and them pipe them to some command, which will then open the files. Would I pipe them to the start command? Regards, Sean Mills

Hi: I am not that familiar with automation tools on Windows. So here is a brief explanation of how I automate this task on the MacIntosh. I read the contents of a folder of PDF files and then write the returned string to a text file. That file is then imported into filemaker. Here is the Applescript/Shell Command that reads the file. set theFolderList to do shell script "ls '/Volumes/main/Business/ADD/Export/'". How would I achieve the same on the Windows side. Thanks in advance

The following lines run fine... [color:blue]Dim fmApp Set fmApp = CreateObject( "FMPRO.Application" ) fmApp.Visible = True ...and I get a new instance of FM in the foreground. However, when I try and get the Documents object like this... [color:blue]Dim fmDocs fmDocs = fmApp.Documents ...I get a COM exception error. I have also tried it in VB and it fails at the same point. Any ideas?

Um, basically im trying to do some cmd automation... namely... im trying to execute another application and then use that application with flags etc... ie.. the problem im coming up with is trying to execute a second command following the first by using the filemaker carriage return... i.e. The following works... cmd /c pathd c:application path & P The following doesnt... cmd /c pathd c:application path & P & Lap -i window.jpg -o window2.jpg & P im clearly doing something wrong... how do you send multiple ''events''? Cheers, genx

Need to open the application FileMaker 8 to specific size then open a specific file (then allow user to enter user name and password). Any help appreciated!

# '# This script will open FileMaker and run the Fax Script '# Set FMApp = CreateObject("FMPRO.application") Set FMDocs = FMApp.Documents FMApp.Visible = True Set myOpenFile = FMDocs.Open("orders.fp7", "Admin", "") myOpenFile.DoFMScript ("sbtSaysUpdateConfSendApprovalSheets") Now how can I tell FM8 to navigate to a specific record. The program thats going to be calling FM8 knows the jobkey to have FM8 search for. This will be a unique record. I just need FM8 to navigate to this record, then call this script. Thanks.

Anyone have a good reference for this? I know that when you reference FM as FMPRO.application you also have: .Open .Documents .Documents.Open .Documents.DoFMScript What else is there? I would be willing to buy a book that has this information.

Hi, I am using FMPro Dev 7, on Win XP and I am trying to write VBScript which will start FMScript in my file Tmob.fp7 ... but it does not work : Any help? Here is a VBScript: Set objFM = CreateObject ("FMPRO.Application") objFM.Visible = True Set objFMfiles = objFM.Documents.Open("c:Tmob.fp7","") objFMfiles.DoFMScript ("Novi") Thx in advance VJ

Hello, I´ve written a script which creates a new record by copying given fields from a specific record to DIFFERENT fields in the new record. The way I have it set up, the record which originates the information for the new record is referenced with a globalID field which is copied from the RecordID. The script works fine but goes back and forth between the two records a number of times in order to copy all the necessary fields. The problem with this is that I had certain fields which were configured as "Not Empty" and validated. Needless to say I have to turn of field validation for the script to work, because certain fields aren´t yet filled in while the …

Here is my wish ... If our served file ever crashes, I (and Owner) are notified immediately. It could be emails to several addresses, phone call (smile), siren blaring over the whole city, carrier pigeon, I don't care. I assume I can view FMS_EventLogs.fp7 or Server Admin. But the sooner I know, the sooner I can replace the file before Users try working in it! And some staff wouldn't tell me if it happened. And what if we lost electricity in the night? I have UPS but I think that's just good for 4 hours and then what? System loses power and trashes us? Even RAID would backup the trashed file. I wouldn't know because I'd be at home! I am now greatly paranoid…

I am using send event to connect through ftp (command prompt) navigate to a directory, and then copy an image down. Here is my event. @ECHO > script.ftp ECHO USER CSRi01r readonly >>script.ftp ECHO cd export/L000/x2400/602421_09192005_090421_00/ >>script.ftp ECHO binary >>script.ftp ECHO lcd C:wpc >>script.ftp ECHO get Dsc00050.jpg >>script.ftp ECHO quit FTP -n -s:script.ftp" & $$IP & "TYPE NUL >script.ftp DEL script.ftp exit GOTO End :End It keeps telling me application @ECHO cannot be found. So I figure that thats the problem, I add this to the top of it command @ECHO Then it runs…

Microsoft offers a free Access database with some 2000 useful VBscripts. They were kind enough to allow me to rework this as a FileMaker database and make it available to the FileMaker community. You will find it in the downloads section of my website. Enjoy, Wim. Wim Decorte www.connectingdata.com T +49 (0)8024 3030752 F +49 (0)8024 3030753 Certified FileMaker 7 Developer

Is there any way to talk to an FM8 runtime using VBScript? Thanks

This is possibly a silly question, but I couldn't find it anywhere so here it goes. I have a DB that has many different jobs. All of them have identifying numbers (ie job# 42, job #43, etc). In a seperate table, I want to create records and have each record have a unique serial number for that job. For example I want the 1st record for Job#42 to be 42-001. The next would be 42-002. However if I then create a record for job# 43 it should be 43-001. I want this number to calculate automatically when I create a new record. Any help is appreciated.

I'm not sure where to put this, folks ... I thought I read somewhere (or was told awhile back) that it isn't good to drag-copy an FM file that is open (while networked LAN or stand-alone). Is this also true for a file being served? I can not explain when or why it is happening (I know but I just can't tell you); however, I was asked to explain exactly WHY it wasn't a good idea. And I couldn't provide reasons. I am known as a fuss-bucket and overly protective of our files. If this is a bad idea, can someone explain why it's bad so I can pass that information on? And if I'm wrong, this fuss-bucket is willing to lighten up on this point. I like taking risks but N…

Guys, Can anyone (possibly Wim?) point me in the right direction. Ive got a FileMaker Database and I'd like to schedule a task in it and then parse the data to create an outlook task with a reminder. Can I do this using vbs or do I need the full blown Visual Basic? Cheers

Can someone explain to me how i can add and read records out of FileMaker using visual Basic ADO. What i want to do is add some records in Filemaker using Visual basic 6 ? And if possible i would like to know how to read information out of Filemaker. Any help would be nice !

I'm using FMPro 6 and FM Server 5. One of the FMPro clients acts as a data source (SQL) to a VB Script. If an error occurs (such as a server-side loss of database connectivity), an error box is displayed on this mostly unattended PC. This halts any further SQL processing and essentially ends up stalling my web page. Is there any way to tell filemaker to NOT put up error boxes or some other way to prevent FileMaker stalling in this way? Thanks a bunch - again...

Can anybody share a VBS with added FileMaker Pro 7 lib inside? Please?!

I have a FileMaker Pro 7 database done. Can I use Visual Basic 6.0 as the front end and my FileMaker Pro 7 database as the backend. I know you can with Access and several others. It would be great if it can be done with FileMaker Pro.

Hi, I have a program that opens a new window that runs a new record script. I have a submit button that closes and commits the records based on data entry validation. The problem is that if you close the window using the 'X' button in the window title bar, the record commits as a blank record. My question is there a way to grey out those buttons in the titlebar or is there a script that will do this for us? Thanks in advance.

Is there a script or something that can launch a windows or executable program from the FM database?

Hi, I posted a question about closing a pdf file when exiting FMP and was told that Autoit and maybe VBScript would do this. Can anyone direct me as to how to accomplish this? Thanks

We are using FileMaker Pro 6 and we have a virtual printer that creates PDF files. What I want to be able to do is this: A VB Script should be able to access FileMaker (already running with the target database open), perform a "Find" to select a set of desired records (already done with SQL), THEN activate a given layout and Print to a non-default printer (thereby creating the PDF file). The parts I can't figure out is how get VB Script to tell FileMaker to print a given layout to a non-default printer. I've looked at the FileMaker ActiveX help. I could call the DoFMScript () method, but there' sno way to tell a script to remember a non-default printer to p…

I need some help from VB.Net gurus. I have a main FM7 solution and I need to run a number of FM scripts at various times during the day. I've developed a simple database for each script which simple launches the appropriate script upon opening and then closes itself. My problem is developing executable scripts which can be launched by Windows XP Task Scheduler. I've come close but can't seem to get the correct syntax down. Any and all help is appreciated. I've spent about four weeks playing around with this.

We have an application that grabs records from Filemaker and creates an ADO recordset using VB and ODBC. The application has been working for about 3 years. We are using a Filemaker host. We are just migrating to Filemaker 7.0, and when I attempt to open the filemaker database using VB I am getting the message telling me I should be using the hosted version of the database. I did create a dummy database with a script that will open the hosted version. Should I be able to run SQL statements against that open database to write to my SQL tables? Jim