Jump to content

omegagoh

Members
  • Posts

    55
  • Joined

  • Last visited

Everything posted by omegagoh

  1. Hi All, Just a little sharing. Actually, I was a bit disappointed when I realized that FM12 not longer provide object effect such as embossed, engraved and drop shadow. However, I didn't give up totally. I tired the various themes and objects. Yes, I found that Tab control under the Classic Theme is embossed! Pressed on! I formatted rectangles with embossed, engraved and drop shadow in FM11.0v3 and convert it to FM12.0v3. Then, I used Format Painter to copy and paste to other objects. It works! Regards, Omega Goh Speedy Scaleable Solutions www.speediDB.com omegagoh@speedidb.com
  2. Dear DLC, I would suggest that you register to be a FileMaker Technical Network member (which is FREE) and download the FileMaker 12 standalone converter at: For Mac User, http://fmdl.filemaker.com/maint/emea_fba_ftn/fm12_standalonedbconverter_osx.zip For Win User, http://fmdl.filemaker.com/maint/emea_fba_ftn/fm12_standalonedbconverter_win.zip Hope that the dedicated converter does help! Regards, Omega Goh Speedy Scaleable Solutions www.speediDB.com omegagoh@speedidb.com
  3. Hi Jon, I would suggest that you try App Maker from FIleMaker Inc, which creates an icon to open the FM DB directly. Regards, Omega Goh Speedy Scaleable Solutions www.speediDB.com
  4. Hi all, If what you want is an icon on the iPad (or iPhone) to open the FM DB (either locally or remotely), try: - App Maker (Free) from FileMaker Inc, or - GoWrap (Free/Pro) at www.gowrap.net. However, if you really want to make your FM DB to sell in itune, then consider - fmtouch at http://www.fmtouch.com, or - some form of help from Richard at www.rcconsulting.com who produced - FM Notify (free download from itune) - Sales Beaver Lite (free download from itune, runs on iPad) Note: There are some other FM developers who had successful put the FM DB in itune for sales. But, I can't remember at this moment. Regards, Omega Goh Speedy Scaleable Solutions www.speedidb.com omegagoh@speedidb.com
  5. Thanks for the detail description of the desired function. It combined the features of OS, FM Custom Function and Script. I am not able to do exactly what you want, but you may consider the following alternative/modification: 1. Copy, move and rename as options set and modifiable. 2. A default (but modifiable) source path and destination path. 3. Auto check and process (either copy, move or rename) whenever there is/are file(s) in source folder. 4. A log of files processed in FM and the respective file size. As for: 1. Progress bar, it is artificial unless I can find way for FM to communicate with the OS seamlessly. 2. Time spend it possible by logging time start/end. 3. Cancellation involve reverse process. 4. Incomplete copying flags by different in File Size. Note: Chances is a fm plug-in is required. Email me at omegagoh@yahoo.co.uk if you are interested in engaging my service. Regards, Omega Goh Speedy Scaleable Solutions
  6. I suggest that you check the user's access to the fmp6 file, the folder containing this file, the access of the user to the FMP6 application folder and subfolders. Reason: fmp needs to create temp file for processing, usually the temp file is created in the same folder as the .fp5 file. The temp file will be deleted when you open the .fp5 file. Regards, Omega Goh Speedy Scaleable Solutions
  7. Dear John, I think it is quite hard for anyone to help you based on the description provide. I suggest that you make a Clone of your file then add few good dummy data for processing. Specify the Script (and Step, if possible) and upload the file for the experts to investigate. If it is a complex solution, you may consider simplifying it, both for yourself and others to investigate the cause of problem. Regards, Omega Goh
  8. Dear Gammada, I suggest that you store all the titles and the respective price in a Table, then define a Value List with Title as the first Field and Price as the second Field. Regards, Omega Goh Speedy Scaleable Solutions
  9. Dear Bruce, If I didn't get Matt wrong, he is interested in getting either a list of field names or a count of number of fields of a specified table. He also mentioned that FieldNames ( ) only returns a list of field names from a specified layout, which you had pointed me to the official documentation. What I was saying is, while it is not in the official documentation, FieldNames ( ) can return a list of field names from a table (occurence), which is exactly what Matt wanted. I hope that I had make myself clear is round. Regards, Omega Goh
  10. Dear Daniele, It was very surprising to me too. I ran DDR in FMPD6 and use Analyzer 3.5 (from Waves in Motion / WorqSmart; much prior version of Inspector Pro 3, now from Beezwax)) to check for error, none of the calculation fields was flag as error. So, it is really very odd. Neither me nor the client has a prior version of the file. It was developed by an Indian FM develop who is no longer contactable. I think, at worst, I will try to explain to my client about the oddity of this file. Thanks anyway. Regards, Omega Goh
  11. Dear Bruce, Thanks for pointing to the (official) documentation and suggesting to name Layout different from Table Occurrence. However, I strongly encourage you to download the attachment to see that I wasn't wrong (tested with FMPA8.5 and FMPA11; non-officially it works!). Regards, Omega Goh Speedy Scaleable Solutions Table vs Layout Field Names.zip
  12. Dear Bruce, The problem is the file function normally in .fp5 but not in .fp7! This project that I will be taking involved 2 systems in FMP6. The first system have 48 FM6 files and the second has 31 FMP6 files. Trial convention of all files seem good except this one. While this isolated component is by itself, it is deem important for the user in specifying their request visually. To re-build this file (original version has some 85 layouts) would mean a lot of time and cost as I have little knowledge of the industry that my client is in. It is difficult to justify the cost of re-building this file as compare to migrating the 2 systems. Furthermore, client may be suspicious of my ability, integrity and may result in losing the project. Hence, it is important for me to be able to make it work in .fp7 with as little time as possible (I am not interest how bad the design was!). Regards, Omega Goh
  13. Dear Matt, I think the easiest is to run Database Design Report if you have FileMaker Pro Advanced. Else, consider doing either of the following: 1. Create a layout with all fields for each table and use the FieldNames ( File Name; ""). 2. For a more dynamic method do: a. Use TableNames( File Name ) to get a list of Tables and split them into records ( 1 Record for 1 Table ). b. Use FieldNames ( File Name; Table Name) to get a list of Fields for the Table. Regards, Omega Goh Speedy Scaleable Solutions
  14. Hey! nobody is able to help?
  15. Dear Vaughan, You are right to say that Evaluate( ) will produce the result and ignore the spaces. However, as an educator ( I was a Maths teacher ), ones also concern about the presentation. It is therefore important to train the students to present their working as "reasonable" as possible right from the beginning. On the other hand, it is also not realistic to expect all students to do it right initially, hence IT can be of help for these little irritating problems an educator is facing. I think Daniele shown a excellent simple version of what is expected of. However, as the grades (usually, a Maths teacher is required to teach a few levels) gets higher, it is insufficient. Thus, the expectation may be fulfilled by features as illustrated by FileMaker Calculation Formatter at http://www.aptworks.com/tools/. Unfortunately, it was not convert to a custom function or plug-in. Should anybody come across one, please update me. Thanks. Regards, Omega Goh
  16. Hi Glen, This is Omega Goh from Singapore. I think Dave is right. You may need to know more about the system your client is having now. Preferably, a demo by a key user to you and where possible get a clone system from the client. Also, find out the version of FMP they are using (I will not be surprise if they are running on FMP6.), the OS (Windows, Mac or mixed) and the overall setup (FM Server, say). Since you are considering remote support, I would suggest that you go for Data Separate development model. As for cleaning of data, you may need to be the key player unless your client is comfortable of a remote developer login to their system. I started using FM since v2, that is since 1980s. Email me at omegagoh@yahoo.co.uk if you are interested to work with me. Regards, Omega Goh Speedy Scaleable Solutions
  17. Dear John, You are possibly a Maths teacher for the young Kids. While your request may seem straight forward, the actual work is not. I suggest you visit the following URL for FileMaker Calculation Formatter (This is the closest alternative I have for you): http://www.aptworks.com/tools/ Chances is you may need a (complex) custom function or plug-in to achieve what you wanted. For a list of custom functions, you may visit the following URL (unfortunately, they are not categorized, so may not easy to find what one's is looking for): www.briandunning.com/filemaker-custom-functions/list.php For a FM plug-in, you may visit the following URLs: developer.filemaker.com/solutions/ (then search for "plugin"), or filemaker-plugins.com I am sorry to say that chances are you may not find a solution to your problem ( I searched many more URLs and didn't find one). Anyway, hope that the above URLs are good resources for FileMaker, happy exploring! Regards, Omega Goh
  18. Dear Comment, You win. That's indeed a much better alternative. Hehe! I was using a similar self-join for showing both detail and summarized info from the same table (FMP8). Hence, too used to it. Dear Wickerman, Further to Comment's approach, you would need to empty Publisher table, change Field definition and re-import from Book. Same warning as before: Ensure that the Relationship to Book for delete Related Records is uncheck, else you could accientally delete all the Books! Happy exploring FMP! Regards, Omega Goh
  19. Dear AlisonHollier, I guess you are new to FileMaker and yet to explore on Portal and Relation Predicates. Anyway, do take a look of the attachment. Regards, Omega Goh Speedy Scaleable Solutions (Asia) Student.zip
  20. Dear Wickerman, Usually, I will define a Value List referring to the Field concerned and use function, ValueListItems to obtain the unique values (then use a Script to split the values into records). However, you may proceed from where you are now. You are close to it! Steps: 1. Consider the self-join Relation you had created. Let's call the Table Occurrence on the left, PUBR and the right, pubr_PUBR_Publisher. 2. Define a number Field, Publisher No (Number, Auto-Enter, Serial number, next number: 1, increment by: 1) in the Publisher table. 3. Define a calculation field, First Occurrence = If( pubr_PUBR_Publisher::Publisher No = Publisher No; 1; 0) 4. Add both fields to a list/table layout (base table: Publisher). 5. Show all Records and sort by Publisher. 6. Go to first Record then go to Field, Publisher No. 7. Records > Replace Field Contents (Replace with serial numbers, Initial value: 1, Increment by: 1, Update serial number in Entry Options). 8. Ta'la, all the Records with Field Value 0 in First Occurrence are the duplicates which you may delete now. Warning: Ensure that the Relationship to Book for delete Related Records is uncheck, else you could accientally delete all the Books! Regards, Omega Goh Speedy Scaleable Solutions (Singapore)
  21. Dear Comment, I created the clone in FMP6 with the password, "admin" and set the file to try default password, "admin". Now that I managed to convert it to .fp7. It opens using account, "admin" with some unknown password. I had reset the password to "admin" I am attaching 4 files (OPADRAW Clone.fp5, OPADRAW Clone.fp7, Convertion.log and ghost field in FM6.jpg ) for your investigation. The file, "ghost field in FM6.jpg" is a screen capture of the field definition in FMP6 and FMP8. Consider the field, visDelivery. In FM6, it refer to an mysterious field, Recovered which I can't find it. After converted to FM8, the mysterious field was commented. FYI, the original file had about 85 layouts which I couldn't convert it. Whereas, the attached clone had only a few layouts (I deleted many layouts to simplified it) as I think the key problem is got to do with the mysterious field, Recovered. Do update me if you discovered anything new. Thanks. Regards, Omega Goh Dear Daniele, Please refer to my reply to Comment, especially the screen capture of field definition for visDelivery. Regards, Omega Goh ghost field in FM6.zip
  22. Hi, Based on your description, you are possibly an archaeologist or work with someone who is an archaeologist. Anyway, basically what you have is possibly an input field which user enter the so-called "free text" and an output field which translate that free text into a date range. The mysterious part to you is the translation logic. Two possible reasons that the translation logic is not available to you: 1. You don't have access to the field definition to the table concerned (usually, the Full Access account and password). If the is the case, I suggest that to try to look for the developer's contact within the solution and contact him/her for the logic concerned. 2. If you have Full Access to the solution, possibly the translation logic utilizes Custom Function which you can view/edit only if you have FileMaker Pro Advanced. As the need is "quite niche and complex", I think not many developers are interested to look into it without a fee. You may try exploring the custom functions at www.briandunning.com/filemaker-custom-functions/list.php. Alternatively, if you are willing to pay for a fee, I am sure Brian will be able to help you (so sorry to quote your name without permission, Brain). Regards, Omega Goh
  23. Dear Sharlene, Just 2 suggestions for you: 1. Try to upload a copy (simplified and having a few records if possible) of your file for the expert to "investigate". It will help others to understand your need better. 2a. If you need only to draw info, consider using a free plug-in, ExifPlugin at http://jensteich.de/exif-plugin/ 2b. If you need also to manipulate the image, consider using a a paid plug-in, MediaManager at http://www.newmillennium.com/index.php?src=directory&view=products&srctype=display&id=5 Regards, Omega Goh
  24. Dear Daniele, Thanks for looking into the file. The file wasn't created by me. However, if you view the fields by "creation order", visDelivery is the first field that refer to the ghost field, Recovered. I had no idea what was the original formula in visDelivery. What is most important to me now is to be able to convert it to run on FMP11 (and function as before, of course). You help is most appreciated. Thanks again. Regards, Omega Goh
  25. Dear Keith, The password is "admin". Please send the converted file to me. Thanks. Regards, Omega Goh
×
×
  • Create New...

Important Information

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