Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


ejpvi last won the day on March 1 2015

ejpvi had the most liked content!

Community Reputation

1 Neutral

About ejpvi

  • Rank
  • Birthday 04/17/1981
  1. Greetings Filemaker Gurus. When FMP 12 was first released I tried installing it on one of my workstations, and did a database conversion from 10 to 12 "locally." At the time I was not very pleased with the performance drop I saw from switching to 12. The database appeared to be running slower, and all sorts of graphical issues were making my layouts look very ugly, like buttons were no longer clicking, just would go to the page. I am not sure if performance would be better or worse once I upgraded our FMP Server 10 to Server 12, but I wasn't willing to risk it, I decided to wait a while
  2. Greetings Filemaker Gurus, I was wondering if anyone has setup a server side script that will look at a network location at a scheduled time... if a particular file exists (MyImport.xls) .. import it. (Always in the same format, always named the same thing). It would be nice if the script could validate the file is present before trying to import... and even better if it could delete the file after the script has run, so it isn't importing the same file over and over again if someone forgets to put the updated one in that location. Any ideas? Thanks!
  3. Would that plugin work on Filemaker Pro 10 Advanced Server? I couldn't find anything information about server edition on the site you sent. I had considered using an auto-Calculation, but couldn't wrap my head around it, since it would require new records to be populating another table... but then again.. with a timestamp as one of the join criteria which would always be different, would ensure unique records, but and the before and after part is a little tricky. Still trying to think of something... seems like a changelog should be pretty easy.. I just don't see how to make it avai
  4. Greetings, I have a large database I maintain for a company I work for. They have asked me to keep track of changes on one particular field. I have a good idea how to accomplish this with script triggers on that field, the problem I am facing is that this field could be on hundreds of layouts, and it is always possible someone could add it temporarily to a layout through the "modify layout" button. My changelog script would simply be another table with Key Index, Time Stamp, User ID, Before, and After. I think a script trigger would be easy enough to do it.. I think a on modify tr
  5. I am seeking some advice on how to tackle a project I am working on. there may be some flaws in my logic, but My idea made sense at the time, but I am still missing a key piece to keep everything tied together. We have PO information kept in Quickbooks that I am deriving Vendor Status reports in FMP. The information will be updated regularly from QB... but the users need to make their own notes pertaining to each line item that will remain in the historic table in FMP...when the Table of QB information is cleared and re-imported.. I am hoping I can sync it back up with the historic no
  6. Greetings, This may be answered elsewhere, but I can't find a specific response to my question. I am using a "Robot" client to automate a script I need to run nightly. I would have preferred to use Filemaker Server's Scheduled Run Scripts to do this, but everytime I run it, it gets stuck in an infinite loop or something, and the only way to get rid of it, is to reboot the server. I am performing an ODBC SQL import through the script, it should be supported.. I think the problem is the 3rd party driver that has to be initalized... it just doesn't want to work when the scheduled
  7. Within the Script you write, just make sure it is pulling the data from that field. In case you have never used a script trigger... it is pretty easy. Just right click the field you want to apply it to in Layout Mode.. and choose script triggers. There are several options... I suggested OnModify since it would only trigger if someone changes the data in that field. It is about the same as created a button, except it will execute whenever someone modifies the field. The script you would need to write would be very basic as well.. Probably something like: Freeze Window set vari
  8. There may be better ways to do it, but perhaps you could use an "OnModify" Script Trigger for that field. Create a new table to house the changes and Timestamp fields. The script could create a new record and populate the information into the newly created table, and have the Timestamp field auto-populate the current time whenever a record is created. You could also make a "Submit" button that executes that script, if you don't like using Script Triggers. I have done something similar for tracking changes to a field. A table with a record for each change and have a times
  9. I am dabbling with the QODBC driver that offers ODBC support with Quickbooks Enterprise, and there is also a POS version. While not perfect, it does seem to work. The driver doesn't work with the usual ESS capability that Filemaker can utilize... but you can use a direct "SQL Query" to import records. That is what I am going to use it for. I am going to collect daily inventory and previous days sales on a daily basis, and set it up to run overnight. So far, the client side works fine, as long as the driver is installed. It is horribly slow, which is why I am opting to import into a
  10. I had a similar need the other day. I had several items in my database that have the same item number but a different version of a drop down.. blue, green, etc... So I only wanted it to count it once. Reading the article below gave me the idea on how to figure it out. Unfortunately, I am not sure how you would do it without some kind of loop to check the flag. You first must make sure you sort by the Field you are checking, otherwise this won't work. You can do this with any found set, or just show all records. I then used the function GetNthRecord() I created an unstored
  11. Greetings FM Colleagues, I have recently been working on grabbing data from our Outlet's system (Quickbooks POS) for reporting purposes within FMP. It appears that QODBC now supports POS.. so I got my hands on the demo, and have had very successful results. I noticed the driver does not seem to support the typical ESS connection... but, you can script an ODBC Import via SQL Command. I have basically written two scripts. One pulls daily inventory numbers and updates a table. The other script pulls order line items for the previous day, and imports them into another table.
  12. Greetings, I apologize if I posted this in the wrong forum.. couldn't determine the best choice. I am wondering if anyone knows of any built in tools that would report Database Memory usage. Right now I have a database that is about 3GB. I have determine that about 1.3 GB are images that users have added. I plan to go through the images and shrink them to more "web size" levels to shrink the database size down. But I am still curious what is causing the mass inflation of my database. I do have lots of records, but still, I feel some users have been adding things rampant
  13. I know I have done this before, but cannot seem to get this to work. I have a table with related values. I need to be able to summarize the related values into a total in a Sub-summary. The sub-summary is sorting properly, but the summary of the values only gives me the total of the first value. I have tried calling the summary from a related table. I have tried doing a calculation that calls a "getsummary" I have even tried just summing the related values. Always gives me the same result. Can anyone advise a good way to summarize numbers that are in a related table? Like I sa
  14. I am curious how people deal with Record locking with their scripts. Is there a way to kick someone out of a record? So your script can take control of it. Or do you simply test to see if the records are available, then lock them? What happens if someone enters a record, while the script is running.
  15. I did eventually get it to work. My issue was a connectivity one. Can't remember exactly what I did, but I think it had something to do with my mail settings. My email addresses were always typed in, so I haven't dealt with the calculation issue, but I think I heard other people have had similar issues. You may want to verify that their are "quotes" around your email address.. may make no difference, but I did notice the system adds them in whenever I enter mine in, maybe it doesn't when there is a calculation being used.
  • Create New...

Important Information

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