Jump to content


  • Posts

  • Joined

  • Last visited

jeh910's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. The rambling was written in the early hours so mostly likely the direct question is lacking. Or in review, the question is not one on FM but one about handling website changes in more general terms. I have been using FM (12 years) longer than I have had a site on the web(10 years). With the php api, the chance to merge FM with the website was too tempting: However, simply making the changes to the site without regard to customer's ability to find us is spooky. I will retreat and look for a web-related forum. Thanks for your time
  2. Our website is the face of a working business and we have employees who would be affected by a major loss of traffic, so much care is needed in the transition. I am still making the switchover to php/filemaker from html/Cold Fusion and from one web host to another. I have learned quite a bit on the journey but as usual there are questions. I have switched over all of the pages to php except those pages with cold fusion forms on them and the index pages. I left the original html pages on the original site though. In watching the stats, I am concerned about the final changeover because the stats show that most of the entries onto the site are still being made through the html pages. I know that redirection will have to take place but how do you get people to change their bookmarks or favorites. I have also moved the new php pages to the new site and it is still locked down from prying eyes. I have extra domains that I could use on the new site until I make the final move and I can leave the order page links as a full url link to the order form on the old site. I question the wisdom in that but there you are. I wonder if there is a full domain redirect if I did and how it would work. I want to use a shopping cart but I can't figure out how to add products from the existing individual pages to the cart. As the stats show, the individual product pages bring traffic to the site so changing that working model would be chancy. Any suggestions or comments on this transition are very welcome.
  3. It is difficult to get your head around but all items on POs and Invoices must be individual records and the PO and the Invoice are individual records. You reach this by having portals for the line items in the POs with the PO number being the key and the same idea with Invoice and the invoice number as key. What adds to the inventory is not the PO but the receiving report for the PO. You can then make the proper calculations using the related records. Receiving report line items add to the inventory and shipped invoice items subtract from the inventory. For each line item in a PO, I have 4 fields to receive the products in because vendors have been known to do partial shipments. A company with existing inventory must have a field for beginning inventory and there must be field for adjustments to the inventory after physical inventory show differences with book inventory. Make sure that you control access to physical inventory adjustment because people will use it like a cat box to cover up their mistakes. I hope this is clearer than mud. Johnny
  4. I am using the global fields to hold quoted prices for bids. The quantities and the extended prices change every record but the prices are constant. I have the estimator trained to go to the host to enter his prices and I was hoping to avoid stopping everyone working on the bid to restart. The global field is a hold over from before Version 7. Thanks for the help
  5. We enter the info in the global fields using the host computer and committed the records but we still have to restart the host to be able to see the entered fields on the client computers. Is there a method to avoid this restart workaround?
  6. I have always been over my head in building my databases. I haven't had formal training but do okay. Yhis has been going on for 10 or 12 years. I work on Macs in my business and took that same knowledge to my day job using PCs. They are now licensed on all their computers. I use FMP8Adv on Tiger and XP The problem that I have is I seldom know enough about the total system to correct something if what I am trying to do doesn't work when I do what the instructions say do. That is exactly what happened when I tried to change a main db from single user to multi-user. I changed it on the designated host computer but that was the only computer that would indicate the file was available when I clicked "Open Remote". I read all I could in the books and while they told what I should do to acheive multi-userism, nothing seem to tell me what to do if those simple steps did not work. I came here to Peer to Peer Sharing and by going through almost each topic and responses, I finally corrected all the little things that were holding back. I did not ask anything because I needed to make sure that I knew what should be asked. Someone mentioned static IP address for the host machine which was fine but how did one set up a static address amongst all the tall trees of DHCP. Someone said something about it had to be outside the DHCP range. Another cautioned to make sure that the static was not in the DHCP range. Now I understood. My DHCP range was from 1-14 so I manually set the host computer to 20. Somewhere I determined that I essentially had three firewalls up. One on the wireless router, one on Tiger, and Little Snitch. I saw how to open up port 5003 on Little Snitch and did so on every computer. The suggestion was that since I was protected by the one on the router then I turned the Tiger firewall off. I checked the settings on the Router and the Linksys firewall was up so I cautiously turned the Tiger Firewall off. I could see the hosted file on all computers then I saw one more posting by Cyborg Sam where he showed the Firewall under Sharing under System Preferences. I learned that I could use the "Other" when I selected "New" and create a 5003 port opening on the Tiger Firewall. So I did that and turned back on that firewall. It worked and I danced like a simpleton celebrating Spring. Now I have to go do the same on the XP system at the day job. Thanks to everyone who contributes here. Your time and efforts are appreciated. Johnny
  7. I had an odd adventure today and thought someone at Filemaker might need to check it out but I don't know how to attract their attention. I was pleased that you could save to excel spreadsheets since I use the subtotal feature there. I did my work in 8 Advanced then saved directly to an excel file. That was okay and I liked being able to do that but then when I went to the subtotal feature, excel would not sum. It would count but not sum. I tried all sorts of fixes but nothing (or I should say zero) worked. The formulas were stated correctly and the cells that were to be added were the right ones but the answers was incorrectly Zero. I finally exported the file in the tab-separated format then imported that into excel and when I went to subtotal feature, it summed up perfectly using the same formulas. That is when I thought it might be related to the FM 8 save function. But what would I know?
  8. I did not know that my explanation would expose that side of me but I was an accountant and I am going to Italy at the end of the month and double entry journal ledgers are still used as part of trial balance accounting methods. So how do I entice Ken Lay not swear to the stars above that the oil on the water clouded his vision so he could not grasp the futiility of his inexplicable ways. I would prefer restitution over retribution. I went back to another group of files and found that running totals placed in a regular footer did change according to the record you were in, whereas running totals in Trailing Grand Summary provided the correct grand total not matter the record. That could indicate a reason for the assumption of evil asperations on my part. So how do I get summaries from one file to use in calculation in another file?
  9. I wrote a bit about this before under the heading of Sums but the thread disappeared whenI uploaded a pdf of the relationship page. I obviously gave the server something it could not chew so it spat it out. I had a pay application form that was filled in using information from other files. With the conversion to 7, I seemed to lost the ability to use summaries from other files in my calculations. I have been reading the books and posts on here trying to find my way through this but to no avail. So, I politely knock at your door again. In the daytime, I work for a construction company and we are paid through a system of percentage of work done using activity numbers and descriptions. (I developed all this work in FM 3.) This percentage activity is set up in a file named "Pay_Core". One of the layouts is an AIA form for those of you who know construction. This file appears to have come through the conversion unscathed although minor touchups were required. The next file is a pay application form (Pay_App)but you could call it a summary form because it summarizes current work minus previous work to arrive at a pay this month total. In part of the form there is a place to list then summarize change orders. This part is not giving me a problem because each change order has a relationship to the Pay_Core and the amount for each change order shows up. In fact I have 70 CO relationships because we had close to 60 change orders on a previous job. Now to my problem, I need to derive the total pay from the Pay_Core file for a calculation in my Pay_app file. Previous to 7, I went to the CO70 (Change order 70) relationship and used the summary of total pay. The reason I went to CO70 is because it was always the last record in the Pay_Core file and only asking for the sum from the last record would give a correct sum. I have been working way beyond my knowledge with FM in Macs and PCs for years now and have developed fairly complex routines to acheive needed results but this one stumps me and I feel like a rank amateur again. I guess the main question is: how do I bring summaries from one file to another? TIA Johnny
  10. No, it wasn't. Maybe now. Pay_App.pdf
  11. Here is the pdf of the relations chart. I hope this helps
  12. I'm sure you are correct on the structure. I think the term is wing and a prayer that describes the patchwork I string together. There are probably more that 70 relationships because I am having to relate each change order number to more than one file. There is a pay core and a change order base besides the pay application file. I have yet to comprehend totally having more than one table in a file. I have used file reference to bring in other files into the tables though.
  13. I will make a pdf of the relationship graph tomorrow when I go into work. I work on Windows XP at my day job and Mac Panther in my business. This particular file is a monthly construction pay application that can have up to 50 or 60 change orders beyond the basic contract during a job. This particular file is like a culmination of several other files starting with daily reports that superintendents fill out each morning. They have been built over a 7 year period for a small company. Thank you for your interest and help.
  14. Shoot. Perhaps so, but I checked and renamed all 70 of relationships. I renamed them to bring more clarity between the name of fields and relationships. The sums had been working for several years in other versions. I admit I have not reached a complete comfort level with Tables but other calculations and lookups are working. I assumed it was the sum function because everything else seem to be working fine.
  15. In an earlier version of FM, I used the sum function to gather the various totals of change orders in a related file. I created a relationship for each change order and had the program match the change order numbers. Now in 7, I get nothing. I have read what I can find but there seems to be very little written on the sum function. What changed in 7?
  • Create New...

Important Information

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