Brudderman

I am using Scribe (version 2.15) to create a directory of names, addresses and biographical information in Word 2010 (on Windows 10 running in Parallels Desktop 11) but don't know how to make the one final adjustment that I need. The biographical information in my FMP 15A database is a text field with multi-paragraph data, and when that field is written into word with the following command, the paragraphs that appear in Word are separated by line breaks (created by Shift-Enter in Word) rather than by actual carriage returns (created by Enter). This means that a multi-paragraph entry is actually just a single large paragraph with sections separated by line breaks, so my custom Word styles do not work properly. So I need to get the line breaks replaced by real carriage returns. (ScribeDocSubstitute( "[bio]";Directory::Bio) I've tried to address this by adding placeholders ([..] where paragraphs should be broken) to the data that’s written into Word with hopes of then substituting carriage returns for the placeholders. ScribeDocSubstitute( "[bio]";Substitute(Directory::Bio;Char(13);"[..]")) This certainly puts the placeholders in the right places, and then I've tried to substitute the placeholders with carriage returns: ScribeDocSubstitute( "[..]";Char(13)) This does replace the placeholders, but line breaks rather than the "pilcrow" carriage returns are inserted. I've also tried copying actual pilcrow carriage returns from both Word and FM and pasting them into the ScribeDocSubstitute function, but line breaks still appear. It's pretty easy to fix these in Word with a simple find/replace or with a short VBA macro, but I'd rather not have to do manual adjustments. I've even tried creating an auto open macro in Word to do the replacements, but that requires a document in DOCM format rather than DOCX, and Scribe doesn't appear to work with DOCM macro-enabled documents. So how can I get true carriage returns into Word? I'm new to Scribe and am certainly missing something. Thanks for any help! James

I have heard back from Matt Petrowsky, and he has changed a server setting that permits proper downloads of zip files with IE8. So all is well now. James http://james-mc.com Words To Live By

I'm a subscriber to FilemakerMagazine.com and am using a web viewer to browse articles and pull titles and summaries to build an index of those I want to save. This all works well. There are usually links to download both a technique file and a movie file, and I can activate the links through the web viewer. When so doing, however, the movie files download and open OK, but not so the technique zip files. They download, but I get this error when trying to open them: "Cannot open file: It does not appear to be a valid archive." Downloading the same file from my Firefox browser gives a slightly larger file size, and the zip file opens properly. I have the web viewer set to interact with content and to display status messages and am using FMP11A (Windows XP) with all updates installed. I have the same problem when trying to download the same zip files in Internet Explorer 8, so the issue may be related to my IE settings. I've also found a couple of links that point to server-side issues that affect downloads with IE and not Firefox: http://social.msdn.microsoft.com/Forums/en/iewebdevelopment/thread/bf4077dd-20bc-4f66-bf73-b79a2440cf30 http://forum.joomlatools.eu/viewtopic.php?f=50&t=5668 I have sent a support request to FilemakerMagazine.com but am wondering if anyone knows what I might try on my end. James www.james-mc.com Words To Live By Thanks!

Thanks so much for the demo!! James www.james-mc.com Words To Live By

Do you use Microsoft Office, Matt? And if so, what version? Thanks! James www.james-mc.com Words To Live By

Thanks for the info, Brent. Which version of Windows 7 are you using? I use Office 2007 without any plug-in so should be OK there. James www.james-mc.com Words To Live By

I am using FMP 11 Advanced and need to buy a new computer. I'm looking at Windows 7 64-bit OS but see that Filemaker doesn't officially support it: http://help.filemaker.com/app/answers/detail/a_id/5587/kw/windows%207%2064-bit On the other hand, Microsoft alleges compatibility: http://www.microsoft.com/windows/compatibility/windows-7/en-us/Details.aspx?type=Software&p=Filemaker%20Pro&v=FileMaker%2c%20Inc.&uid=11&l=en&pf=0π=3&s=FileMaker%20Pro&os=64-bit I'm just wondering if anyone is using Filemaker on a Windows 64-bit OS and with what results. Thanks! James www.james-mc.com Words To Live By

Thanks for letting me know. I'm going to get it soon, I think. James www.james-mc.com

I'd be interested in how you like the course as I am considering purchasing also. James www.james-mc.com

Thanks, Barbara! I'll head over there and get the update! James www.james-mc.com Words To Live By

Can you give some more detail about which files you placed in the 11 package? My 10 package has lots more files and folders than 11. But if this works, it's great news. Thanks! James www.james-mc.com Words To Live By

I don't know if any of the material in this article will help, but there is a hint in the comments about possibly pulling data in from PDF's: http://www.filemakermagazine.com/videos/populating-pdf-forms.html James www.james-mc.com

I'd love to see that demo if you ever get time. : James www.james-mc.com

The Generate Report button runs the Generate Matrix Report script where all the report magic is done. The script basically creates an HTML table from the data and then exports it as file (e.g., Web Viewer Example1.html). The URL of the path to this file is then loaded into the web viewer, where it is displayed. I would guess that a clever person could use the same technique without the HTML and separate the columns by tabs and put the results into a global text field as Comment did in his example. Unfortunately, I don't think I'm that clever. James www.james-mc.com

You may not have seen this, but there is an example file that shipped with FM 9 called Web Viewer Example.fp7. One of the examples in that file is for a matrix report (click on Reports) that generates HTML displayed in the web viewer. It may give you some ideas as well as it produces the kind of output you're seeking. James www.james-mc.com

This works well, LaRetta, with one small adaptation. Since I'm naming my layouts as Jobs Detail, Jobs List, Vehicles Detail, etc., my conditional formatting equation now looks like this: LeftWords(Get ( LayoutName );1) = Self Now if I just had a way to keep from hard coding specific text into the script parameter in the script attached to each button. When I click the Jobs button, for example, I'd like to have something like Self in the script parameter without having to hand code "Jobs." Thanks for the help on this! James www.james-mc.com

Thanks for defining this more clearly. I tried typing the address in directly, and it doesn't send. But in this case, I do get an error message dialog: "Email(s) could not be sent successfully." In the case of setting the address by variable or by calculation, there is no error message dialog. There may be an error generated, but I haven't tried to trap it. So for now it looks like I need to use the email address without the name. I appreciate the help. James www.james-mc.com

I'm having trouble calculating the proper form of an email address for use in the Send Mail options dialog. I'm using the SMTP server option. If, for example, I have a person named John Doe (found in Name field) whose email address is john@mymail.com (found in Email field) and point the TO section of the Send Mail options dialog to the Email field only, all works well. The email sends properly. But I'd like to send using both the person's name and email address, not the email address alone. In my email client I would simply type John Doe , and that would work. But I can't get a calculation configured to do the same thing. I've tried a couple of things: Name & " <" & Email & ">" -- Trying to create what I would type """ & Name & "" <" & Email & ">" -- Trying to enclose Name in quotes in case that makes any difference After setting the results of a calculation to a variable (which I use in the Send Options dialog), I've looked at the results of both of these in the data viewer and they both look OK but neither works. So I must be leaving something out but don't know what. I'd appreciate any suggestions. Thanks! James www.james-mc.com

Perfect! Thanks for the help! James www.james-mc.com

I have a several identical buttons (Jobs, Vehicles, Tasks, etc.) that I'm using for navigation among layouts. All of this works OK, but here's what I'm wondering: If I give each button an object name that corresponds to a layout name, can I use conditional formatting to give that button a different formatting when that particular layout is active? In other words, if I assign the Jobs button the name JobsDetail, can I change the formatting of the Jobs button when the JobsDetail active is active? I generally know how to use conditional formatting but don't know how to set up this particular formula. Thanks for any help. James www.james-mc.com

My screen has flickered badly since about FM 8 (as I recall), and I hope that each new release will provide a resolution to the problem. But so far it has not abated. I have tried the various remedies others have mentioned here (including adjusting the hardware acceleration) with no benefit. What I have discovered, however, is that the problem seems to be related to my mouse. I have a Microsoft Comfort Optical Mouse 3000 (4 button) that uses their IntelliPoint software to configure the features. If I remove the IntelliPoint software, the flashing problem goes away. I'm on Windows XP Pro SP3. James

Thanks for getting back with me on this. I have read the info on his blog and hope that some of the material is covered in his forthcoming book. I've been using the method presented in this video up to this point: http://www.filemakermagazine.com/videos/function-scripting.html

In one of his books? I'd like to read about this if you can give me a pointer to the source. Thanks!

Will have a look. Thanks!

Thanks, Steve! Before getting your reply, I had already ordered "VBScript Programmers Reference" published by Wrox. Got it used as well,and it looks good, too. James www.james-mc.com