2 Replies Latest reply on Sep 13, 2012 2:37 PM by davidanders

    FileMaker spitting back web form submissions, Macros from Word



      FileMaker spitting back web form submissions, Macros from Word


           Hello, all!

           In our system, users input information via a website which is later automatically created (and approved) within FileMaker. When/if someone copies and pastes information into the website, rather than typing it out, the form is spit back. We then have to enter it ourselves manually into the database. The error we get is the following:

           "You are receiving this Proposal information via e-mail because there was an error #958 in the submission. This is usually due to people copying and pasting information from Word files which contain macros. Please manually enter this information in the web form."


           Is there a way to ensure the website or Filemaker strips the form of macros before submission? Would this solve the problem? What about a more updated version of FileMaker (currently use 10)?



        • 1. Re: FileMaker spitting back web form submissions, Macros from Word

               Hmmm, don't know what those embedded macros look like when pasted into a field in FileMaker so that makes it hard to suggest anything. One general purpose problem solver for fields that receive pasted text is to add this auto-enter calculation:

               textformatRemove ( self )

               and then you clear the "do not replace existing value..." checkbox.

               But I have no idea if this will make any difference or not in this particular case.

               as to newer versions, you could down load the 30 day trial version of Filemaker 12 and test it to see if it has the same issue, but 12 changes your file format so you'd need to convert a copy of your current DB (or create a small test file from scratch) in order to test this.

          • 2. Re: FileMaker spitting back web form submissions, Macros from Word

                 You have noticed the far right icon in Post a Answer?  "Paste from Word"

                 This should be implemented on the website, and the users trained to use it.


                 From a word processing document
                 When cutting and pasting from a document that was created using a word processing program, the software may
                 insert invisible characters that may not allow the information to be successfully saved.
                 Note: To avoid this problem, you should cut and paste only text into the CV and introduction letter fields in the
                 on-line application.
                 To paste from Microsoft Word
                 1. Open your document in Microsoft Word and click File in the menu bar.
                 2. Select Save As.
                 3. In the "Save as type" field, select Text only with Line Breaks (*.txt).
                 4. Save the text document to a location where it can easily be found.
                 5. Close Word.
                 6. Using Notepad or WordPad, open the new text document.
                 7. Correct the format of your new document by adding spaces to
                 align fields or by adding asterisks to denote bulleted items.
                 8. Select Edit and then Select All to select all of the text.
                 9. Select Edit and then Copy to copy the text to the clipboard.
                 10. Paste the text into the appropriate field on the online application by pressing Ctrl and V at the same time.


                 Copy and Paste Word document to HTML form

            Wednesday Jun 15, 2011

                 Many users without computer knowledge copy contents from a word document, and paste them into a HTML form (<textarea></textarea>) and expect to retain formating as well as special characters such as smart quotes and emdashes. You may opt to translate smart quotes to regular quotes and emdashes to regular dashes with a PHP script. If any user submits a non-ASCII character contents, you’ll probably see weird characters in the database and HTML page. Finding and fixing just a few of them (curly quotes and em dashes) isn’t going to solve the real problem.

                 How do you go about resolving this problem? One way to solve the problem is by educating the users to convert the special characters into ASCII text and submit them into the form. To convert special characters, you may use any of the following methods.

                 1. Save the word document as a HTML document. Microsoft Word has an option to save .DOC document into a .HTML file. Select the contents from the HTML document, and paste them into the HTML form.

                 2. Copy the Word contents, and paste them into a notepad; then select the same contents from the notepad, copy and paste them into the HTML form.