Jump to content

MarkWilson

Members
 View Profile  See their activity

  • Posts

    223

  • Joined

  • Last visited

Everything posted by MarkWilson

  1. MarkWilson
    There are various websites that can start a ping test by loading a preformatted url. Then scrap the data from the web browser. http://usa.ping.ms/#fmforums.com http://network-tools.com/default.asp?prog=ping&host=fmforums.com
  2. MarkWilson
    A number field with a calculated value of If( lockup = "yes" ; Lookup( RelatedTable::price ) ; "" ).
  3. MarkWilson
    WorkOrder::_pk_WorkOrder --> X --> Stations::_fk_WorkOrder. (or a constant key with =) Allows all the records in the Stations TO to be accessed by any and all of the records in the WorkOrder TO. Stations::_fk_Schedule --> = --> Schedule::_pk_Schedule. Allows related data be added to the Schedule table via the Stations portal on the WorkOrder TO. How can the WorkOrder::_pk_WorkOrder value pass to the Schedule::_fk_WorkOrder field?
  4. MarkWilson
    I am working on a scheduling module for our production shop. I want to display the Work Orders in a list and Schedule time to each of the Stations between the Work Order IssueDate and ShipDate. Secondly, I would like to report back the actual hours spent vs. the Scheduled time for progress reporting. Tables: Work Order (500/year) WorkOrder# Description IssueDate ShipDate Stations (7-10) StationID StationName Schedule (1 for each Work Order) WorkOrder# StationID TimeEstimated TimeTracking (1000s/year) EmployeeID EmployeeName WorkOrder# DateWorked TimeWorked Employees (20+) EmployeeID EmployeeName Thank you for your guidance. Mark
  5. MarkWilson
    Thank you webko! Final version <INPUT TYPE="text" STYLE="border:none" STYLE="font-size:1.5em" NAME="face" VALUE="...Initializing...">
  6. MarkWilson
    I am displaying a clock on the layouts of a time tracking module. How can I control the size of the text desplayed in a web viewer for the following code? <HTML> <HEAD> <SCRIPT LANGUAGE="JavaScript"> <!-- Clock -- var timerID = null var timerRunning = false function stopclock(){ if(timerRunning) clearTimeout(timerID) timerRunning = false } function startclock(){ stopclock() showtime() } function showtime(){ var now = new Date() var hours = now.getHours() var minutes = now.getMinutes() var seconds = now.getSeconds() var timeValue = "" + ((hours > 12) ? hours - 12 : hours) timeValue += ((minutes < 10) ? ":0" : ":") + minutes timeValue += ((seconds < 10) ? ":0" : ":") + seconds timeValue += (hours >= 12) ? " pm" : " am" document.clock.face.value = timeValue timerID = setTimeout("showtime()",1000) timerRunning = true } //--> </SCRIPT> </HEAD> <BODY onLoad="startclock()"> <!--------------------------------------------------------------------------------------------> <form name="clock" onSubmit="0"> <INPUT TYPE="text" STYLE="border:none" NAME="face" VALUE="...Initializing..."> </form> </BODY> </HTML> Thank you,
  7. MarkWilson
    Attached is the updated file with Parent, Child, and Grandchild with selection highlighting and active field highlighting. I have not figured out a way to allow new entries to the parent self-join portal too, as there is no record created at the time of entry. Anyone else have an ideas? Thanks to comment for the original file. NavPortal3.zip
  8. MarkWilson
    I am experiencing challenges with the server module of FM Server 11 ( up to date at v.11.0.3.309) on Windows SBS 2003 R2. On some restarts the will report back an error in the adminserver.exe file 5 times. If this happens neither the Control Console nor the Command Line Interface can access the server module. It often reports error 10502. The adminserver preforms as expected via the CLI. This error was caused over the weekend when we updated the Window SBS 2003 server with the Java 6 update 31. However I have had the same issue without performing an update at other times. What is causing the server module not to start or respond and how can it be repaired? Thanks,
  9. MarkWilson
    Thank you comment I did a few modification and seem to have it working. I will post the working as requested. I added an extra table occurance and a couple of script triggered scripts to do this. File pending... Mark
  10. MarkWilson
    How would it be possible to join three tables on a single layout using a three portal heirarchal format? Or a single table? I have three tables WorkAreas -> WorkGroups -> WorkTasks. I would like to add a line item to the WorkArea table, select that WorkArea line item and add multiple WorkGroup line items to that WorkArea line item. Then do the same with the WorkGroup; select the WorkGroup line item and add multiple WorkTask items. Production (WorkArea) -> -----Machining (WorkGroup) -> ----------Beam Saw (WorkTask) ----------CNC (WorkTask) -----Sanding (WorkGroup) -> ----------Drum Sander (WorkTask) ----------Stroke Sander (WorkTask) ----------Hand Handing (WorkTask) Install (WorkArea) -> -----Safety Training (WorkGroup) I am adding a unique code to each entry type. This will expand throughout the system to additional tables for prefixing barcode. I also require a way to validate the uniqueness of the code. Thank you, Mark
  11. MarkWilson
    Let( [ YYYY = Right( "0000" & Year( Get( CurrentHostTimeStamp ) ) ; 4 ) ; MM = Right( "00" & Month( Get( CurrentHostTimeStamp ) ) ; 2 ) ; DD = "01" ; D2 = Right( "00" & Day( Date( MM + 1 ; DD ; YYYY ) - 1 ) ; 2 ) ] ; MM & "/" & DD & "/" & YYYY & ".." & MM & "/" & D2 & "/" & YYYY )
  12. MarkWilson
    James, Attached is a set of sample files. Ensure the .csv file names fall within the date range of your testing day and the file path is set for your settings. Once it works for you, try turning the "Set Error Capture" to off. vData.zip
  13. MarkWilson
    Year( DateField ) & Right( "0" & Month( DateField ) , 2 ) & Right( "0" & Day( DateField ) , 2 )
  14. MarkWilson
    I like the idea of not leaving FileMaker to check if the file exists alot. To find the date/time information about the file from the command line. CMD /C DIR C:ClientFolderClientFile.csv /T:W /4 >FileTest.txt /T:C = Creation /T:A = Last Access /T:W = Last Written Returns: /? Volume in drive C has no label. Volume Serial Number is AAAA-1111. Directory of C:ClientFolder 11/29/2007 03:42 PM 1 ClientFile.csv 1 File(s) 1 bytes 0 Dir(s) 29,285,822,464 bytes free
  15. MarkWilson
    I have not tried it so I will ask, did you try an error capture in the script? To test for a file from the command line with FileMaker use this concept. Send Event[ CMD /C DIR C:ClientFolderClientFile.csv /B >FileTest.txt ] Pause 2 seconds Import the FileTest.txt file into its own table. If the text "ClientFile.csv" imported, the file exists. Continue regular script...
  16. MarkWilson

    tcards

    MarkWilson replied to chief's topic in Layouts

    Welcome to the forums! Where are you in your development so far? Are you using a this database to replace TCards or create TCards? For printing multiple cards per sheet this trick may help. If you are printing four (or any number greater than one per page) TCards go to Layout mode, then to Layout > Layout Setup... > Printing. Check the "Print in" __ "columns" option. Now design your layout to print one TCard on the page. When you print multiple records it will fill in the other cards on the page too.
  17. MarkWilson
    I cannot speak for the Mac side but I have been running Thunderbird on an XP box with FileMaker 5.5, 7, 8, 8.5, and 9. I have not had any issues with sending mail through Thunderbird. Is there an "Allow other applications to access..." options somewhere in the settings?
  18. MarkWilson
    Here is the basis for what I use.
  19. MarkWilson
    Attached is a sample file allowing you to do both calculations. Price.zip
  20. MarkWilson
    Welcome to the Forums! With a script, use the Set Field script step. Set Field [ DiscountPrice; BasePrice * Discount ] A script may not be needed to perform the calculation. Try an auto-entered calculation with the (BasePrice * Discount) formula. Uncheck the 'Do not replace...'
  21. MarkWilson
    1. I remotely, opened the server file to on the local machine. Performed a find (125 of 2141 records). 2. Opened the local file. File > Import Record > File... 3. Selected Remote... and selected the file. At the import dialogue matched up the fields. 2141 records imported, not the 125 from the found set. The server should give access to all the records in the table. Otherwise, one user's find could effect another user's imports. Is there any way to filter the total record during the import to my local client verion?
  22. MarkWilson
    Attached is a sample file so you can see how it works. It is recommended to use the "_" (underscore) or CamelCase for file, table, field, and relationship naming conventions. Spaces in the names will only be an issue if you start integration with other applications or use FileMaker on the web; it is part of FileMaker best practices. Left( Year( Get( CurrentDate ) ) ; 2 ) & Middle( SerialNumber ; 4 ; 2 ) This formula is to return the year. The "CurrentDate" portion prefixes the 20xx to the fourth and fifth characters of the SerialNumber field. It would be easier to write the formula as "20" & Middle( SerialNumber ; 4 ; 2 ). The current year prefix will not be required for over ninety years. Manufacturing.zip
  23. MarkWilson
    Is there a way to import a defined found set from a sever to a local file?
  24. MarkWilson
    Welcome to the Forums! You can use text and number fields with auto-entered calculated values to extract the data. These formulae should get it for you. SN_Month == Middle( SerialNumber ; 2 ; 2 ) SN_Year == Left( Year( Get( CurrentDate ) ) ; 2 ) & Middle( SerialNumber ; 4 ; 2 ) SN_Sequence = Middle( SerialNumber ; 10 ; Length( SerialNumber) - 9 ) This one is a little trickier. This formula will get the manufacturer code letter. KEY_SN_ManufacturerKey == Left( SerialNumber ; 1 ) You will need to use this in as a relationship key to lookup the value from the ManufacturerCodes table. SN_Manufacturer == Lookup( RelatedTable::RelatedField ; "" )
  25. MarkWilson
    I noticed you asked this same question about six weeks ago. What is the current import scripting look like? What is the method of finding the file references? Could the file go into an IncomingFiles folder first. The files could be imported and moved by scripting triggered from FileMaker. Only 10-20 items at a time could be imported or 200-400 items a day. That would improve your speed.
×
×
  • Create New...

Important Information

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

  I accept