Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About transpower

  • Rank
  • Birthday 05/24/1951

Profile Information

  • Title
    President, Transpower Corporation
  • Industry
    commercial and custom software; systems/mechanical engineering; theoretical physics
  • Gender
  • Location
    Trevose, PA
  • Interests
    all branches of science and engineering and management; philosophy

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
  • OS Version
    7 or higher

FileMaker Partner

  • Certification

Recent Profile Visitors

3,435 profile views
  1. OK, understood, thanks for the responses.
  2. I commonly use the same field names and some scripts in different Filemaker files. If I import a script I have to change the table name for all the fields in the script (although the actual field names are the same), which is a nuisance. Does anyone have a utility to do this automatically?
  3. Exporting a Column of Numbers from a Text Field

    OK, so now I have the export working and the Send Event script step which runs a Windows batch file to take the exported field and change it to Win ASCII and run the True BASIC program to get the output (in an ASCII file, of course). Now I went back into the script editor, and lo and not behold there is no script step to import a file into a field (a text field in my case). So now what??? What am I missing? Why would FM have an Export Field step but not an Import field step? Ah, I now see the Insert File script step--let's see how this does! Well it doesn't--and least not yet. I've tried text, calculation, and container as the aspect of the importing field--none work so far. If I use the "reference only" option and make sure the file has a .txt exention, FM will provide an arrow in the container field so that one can click on that and Notepad will open--displaying the data. But that's kind of a nuisance--I want the numbers directly displayed in the field. OK, this morning I added a line to the batch routine: type myfile.txt | clip. Then in the FM script I navigate to the importing field, select all, and paste. And voila the text is there! So, all's well that ends well. Still, FM needs to revise the Export Field script step to export to a Windows ASCII file and FM should add an Import Field script step to import from a Windows ASCII file
  4. Exporting a Column of Numbers from a Text Field

    Fenton's answer is for Mac, not Windows, and UTF-8 will not work--only ASCII. After some more hours of searching, I found iconv_for_windows, which can, in fact, convert UTF-16LE to ASCII. Then, I have to apply sed_for_windows to fix the line-endings. I think that FM should provide a patch for all versions from 7 to the present to allow the specification of the encoding for the resultant text export--like Windows ASCII.
  5. Exporting a Column of Numbers from a Text Field

    After some more hours of experimenting, I see that FM is exporting the field as MAC format UTF-16LE (as verified in EditPad Lite 7). The "type" command will not work properly with that format--nor will my back-end program. What I need in Windows is US 7-bit ASCII text format!
  6. Exporting a Column of Numbers from a Text Field

    I'm on Windows 7 Pro. If I load the file in EditPad Lite, I get the column of numbers. So why the heck doesn't "type" work for this file???
  7. Exporting a Column of Numbers from a Text Field

    Using FileMaker 11 Advanced, I'm exporting a single text field (via script) to disk to be read by True BASIC, which I'm using as a back end (because of the complexity of the math). I updated my profile, as requested. I'm using "type file.txt" from the command prompt; the result is just one number. But if I load the file into Notepad, I get the row of numbers. This whole thing is very strange
  8. Suppose I have a column of numbers in a text field and I wish to export that field. What happens is that only the last number of the column gets exported. If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works: all numbers are exported. The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers. So: is there any way to export a column of numbers (contained within one text field) to the disk?
  9. The Reciprocal System: Macrocosmos Database is the world's only astronomy/astrophysics database for the Reciprocal System of theory. It contains numerous examples of every class of celestial object: galaxy clusters, galaxies, star clusters, stars, planets, moons, minor bodies, gas-nebulae-dust, and voids. It also includes calculations for the properties of the universe as a whole and calculations for the number of habitable planets. Property explanations are given in terms of the Reciprocal System. Also included are thousands of images and videos. For Windows XP and higher; download link will be provided at time of purchase. Available from www.amazon.com and www.transpowercorp.com.
  10. FileMaker 11 Advanced Compatibility with Windows 10

    Lee, thanks, but that link doesn't really tell me anything.
  11. I and most of my clients are still on Windows 7 and Windows Server 2003. I have several FileMaker executable files (solutions) developed using FileMaker 11 Advanced. Will these run on Windows 10? Will the Windows 10 compatibility mode (i.e., Windows 7) run these files? I don't have a Windows 10 machine to test.
  12. You could read 100 books on Quantum Mechanics and still not be able to calculate the interatomic distance, specific heat, enthalpy, entropy, thermal expansion, compressibility, and numerous other properties of elements, compounds, and mixtures. But you could with the Reciprocal System of physical theory created by scientist-engineer Dewey B. Larson and presented in his numerous books, including The Structure of the Physical Universe, The Case Against the Nuclear Atom, Beyond Newton, New Light on Space and Time, Quasars and Pulsars, Nothing But Motion, The Neglected Facts of Science, The Universe of Motion, Basic Properties of Matter, and Beyond Space and Time. The Founder and Chair of the International Society of Unified Science, Dr. Ronald W. Satz, has computerized all the Reciprocal System calculations for the microcosmos into one easy-to-use database module. Dr. Satz is the author of The Unmysterious Universe-a primer on the Reciprocal System-and scores of papers on the theory. The software is written in Filemaker Advanced and will run on Windows XP and higher. Five licenses are included, so five users can access the database simultaneously. Tool tips for many of the fields explain what data to enter. The Reciprocal System calculations are compared with actual experimental or observed data or with empirical regression equations. Results may be plotted out, e.g. as a function of temperature or pressure. Solid, liquid, vapor, and gas properties are included, as are the properties of subatoms, cosmic (inverse) atoms, and photons. A link on the Main Menu takes the user to the official Web site for RS research where numerous papers and books can be read freely. The screen shots are also there. The Reciprocal System: Microcosmos Database price: $295 from www.amazon.com or http://transpower.wordpress.com.
  13. "Not Responding" Problem

    I couldn't think of anything else to try, so I restored an image backup of my system and then restored individual files (created after the image) from my backup computer. Everything is working properly now, but I would still like to know the source of the "not responding" problem. If you have any insight into this, please respond; thanks.
  14. I've been using FM 11 Advanced for some time now without an issue. But with recent upgrades in Bitdefender and Flash, FM is now hanging, and I get the awful Windows message "so and so program is not responding." I took off Bitdefender 2014 and went back to 2012, and even removed that, but I still get this message on my main system. I have a backup computer with FM 11 Advanced, as well, and my FM solution runs perfectly on that system, with no "not responding message." I have run the Windows Memory Test--no problems. I have run chkdsk /f on all drives, no problem. I have run the "repair" function of the FM 11 Advanced CD, and even that didn't make a difference. I have run Recovery on the file, and even that didn't make a difference. I've run ReImage to restore any missing or corrupt Windows 7 Pro 64 files--and even that didn't make a difference. Can any of you suggest other things to try? My solution worked fine on my main system up until a few days ago; and it's only the layouts with the most complicated calculations which hang. The backup computer is slower, but doesn't hang....
  15. Registering FileMaker Solution to Computer Name

    Josh, yes, it appears that every 30 days a user could download a new copy of the file and have another 30 days, etc. However, he would be unable to import any records he previously created or modified. DropBox tech support is not very quick at responding to questions like this; I'm still not sure if I can disallow a user from downloading the link again; from what I know to date, the answer appears to be 'No.'

Important Information

By using this site, you agree to our Terms of Use.