vdubeau

I'm working with a client adapting FMSP version 4 (they use FM 13). The map always shows the same area of California no matter what the address is. The same thing happens with the latest version of FMSP and FM 15. When I run through the debugger to get the actual coordinates and plug them into Google on the web the are plotted correctly. Is there something I'm missing in the setup for this to work properly? Thanks

As I stated, this was meant to be just a simple example that people could enhance and expand to suite their needs.

Many years ago I wrote an article for Clarion Magazine on creating a simple registration code generator and validator using Clarion. As I'm getting closer to thinking about building a few smaller solutions and distributing them as runtimes, I wanted to translate the code to Filemaker. It is a very basic code scheme and can certainly use some enhancements. I plan one putting a lot more work into it be using it. I thought that it might be a good start for anyone else looking into it. I put the file in a public folder on my Google Drive the link is: https://drive.google.com/open?id=0ByyiDIpmElpyTWExdmlGdkRmb1k&authuser=0

Hi All. I have a strange issue with the script below. My client wants to drag a PDF into a container field (works great), automatically create a cover page, merge the two with the cover page on top and place the new PDF into a different container field. I export the original PDF to the temp directory, export a cover page PDF to the temp directory and then run a command line line app called pdftk to merge the two. All of the files are in the temp directory including the newly merged one. Everything works great until the Insert File script step. When Filemaker hits the Insert File step it will: 1) Work 2) Appear to work but nothing is inserted into the other container field 3) Bring up the insert file dialog Obviously #1 is what I want all of the time. Does Filemaker have an issue with the temp directory perhaps? Is there something I'm missing? I've also tried using Insert PDF but that has been even less reliable. BTW, I'm using FM 13 and the clients DB is a hosted FM server 13. Set Error Capture [On] # # Variables # Set Variable [$X; Value:Inquiries::ClientRecords Temp] Set Variable [$TempRecord; Value:Get ( TemporaryPath ) & GetAsText ( Inquiries::ClientRecords Temp )] Set Variable [$TempSave; Value:Get ( TemporaryPath ) & "Temp Save.pdf"] Set Variable [$TempPath; Value:Get ( TemporaryPath )] Set Variable [$Litserv; Value:Inquiries::LitServ#] # Export Field Contents [inquiries::ClientRecords Temp; “$TempSave”] # New Window [style: Document] Go to Layout [“Records Cover Page” (Inquiries)] Enter Find Mode [] Perform Find [Restore] Set Variable [$FaxCover; Value:Get ( TemporaryPath ) & "Fax Cover.pdf"] Save Records as PDF [No dialog; “$FaxCover”; Records being browsed] # Set Variable [$Execute; Value:"cmd.exe /C pdftk "" & $FaxCover & "" "" & $TempSave & "" cat output "" & $TempRecord & """] Set Variable [$Execute; Value:Substitute ( $Execute; "/"; "" )] Set Variable [$Execute; Value:Substitute ( $Execute; "C:"; "C:" )] Set Variable [$Execute; Value:Substitute ( $Execute; "cmd.exe C"; "cmd.exe /C" )] Set Variable [$NewPDF; Value:Right ( $Execute ; Length ( $Execute ) - Position ( $Execute ; " " ; Length ( $Execute ) ; - 1 ))] Set Variable [$NewPDF; Value:"filewin:" & $TempRecord] Send Event [“aevt”; “odoc”; $Execute] # Go to Layout [“Inquiries Raw” (Inquiries)] Go to Field [inquiries::ClientRecords] Insert File [inquiries::ClientRecords; “$NewPDF”] Close Window [Current Window] # Set Variable [$Exit_Script; Value:"Pause"] Thanks

Has anyone come up with a brilliant solution for printing in WebDirect?

Hi All, I have a client who recently switched to FM 13 server to allow their clients to use WebDirect. Some of the tables have container fields that store PDFs. Nothing happens when they click on the container field. They have tried all different browsers to no avail. They have tried setting the default applications within the browser to Acrobat (their clients use Windows). I have set the container field to be interactive and not interactive to see if it makes a difference. It hasn't. Is there anything else I should be doing or looking into. Thanks

Hello to everyone.Obviously I'm a Filemaker developer. I work with clients around the US and I have clients in the UK and New Zealand. I primarily work remotely. Most of the work I have gotten via Elance. My Elance profile is: http://vdubeau.elance.com. Feel free to contact me to discuss your database needs. Vince Dubeau