Jump to content

dav1089

Members
 View Profile  See their activity

  • Posts

    52

  • Joined

  • Last visited

Everything posted by dav1089

  1. dav1089
    Hi, It is in the Documents Folder. Now, I have changed my mind to import it from client side perform script instead of scheduled script . But now the issue is its not locating the file from remote client and I tried absolute as well as relative path.
  2. dav1089
    I am having the same issue in my import records script, can anyone please help out?
  3. dav1089
    Hi, So I was able to map the fields and schedule script in the Filemaker Server .. Now, The schedule runs fine with no error and I receive notification: But it doesn't actually import any records into the file Now to troubleshoot this, I ran the script manually and it imported records fine... So what is missing?
  4. dav1089
    I finally found a workaround to populate field names, Link is : (In my case, source file has more fields than target table) http://www.soliantconsulting.com/blog/2014/01/mapping-scripted-imports-variable-paths Another Resource which helped me: http://help.filemaker.com/app/answers/detail/a_id/7035/~/import%2Fexport-script-on-filemaker-server
  5. dav1089
    Hi, I can't get it working (FIle Name is Job Log_3_JUN_2016.csv ) .. I used : "file:"& Get ( DocumentsPath ) &"Job Log Dump/Job Log_" & Day ( Get ( CurrentDate ) ) & "_" & Upper ( Left ( MonthName ( Get ( CurrentDate ) ) ; 3 ) ) & "_" & Year ( Get ( CurrentDate ) ) & ".csv" as Local Variable Value The Log Files are in Documents/Job Log Dump Folder on Server Now. Will it work if I make the Path absolute instead of relative (Get (DocumentsPath) )?
  6. dav1089
    Will it be file: or fmnet: ?? File will be hosted in the Server and sorry I want to auto-import from remote client where logs are stored.
  7. dav1089
    Hello, I am trying to figure out a way to auto-import print job log (CSV file) into the FIlemaker every day. I know that I can schedule to run a script on Server. Now, the real issue is to setup script step where I add file. I want to import everyday log file which has that date as filename , so it's not same file I am importing.. everyday it changes and my scheduled script will import file at specific time from Server remotely. I would appreciate any suggestion. Thank you
  8. dav1089
    Hi, It works great .. and I used original timestamp string.. Thank you @comment
  9. dav1089
    I am trying to convert text to date using GetAsDate function I referred to an old answer on below link: But I couldn't get it working , my system's date format is 2016-01-05 and I used the syntax: GetAsDate ( Right ( date_start_printing_text;4 ) & "-" & Left ( date_start_printing_text;3 ) & "-" & Middle ( date_start_printing_text ; 5 ; 2 ) ) to convert the value format 01-05-2016 date_start_printing_text is a calculation field, returns text value, which calculates its value from a text field with timestamp value using Left function Left ( timestamp_printing ; Position ( timestamp_printing ; " " ; 1 ; 1 ))
  10. dav1089
    This works fine when I don't put the new record script step on firstwindowopen trigger and put it on onlayoutenter ...
  11. dav1089
    Yes it does, it's a foreign key text field, you see in above image the first line of record which has "NONDKT" value, but when script ran it added new record but didn't put cursor in the first field
  12. dav1089
    Yes , I tried that already ...
  13. dav1089
    When script runs, it just highlights the whole record instead of putting cursor in first field In Layout Mode: My Script Steps: (This script is triggered "OnFirstWindowOpen" Trigger)
  14. dav1089
    Yes, I did...(Go to field) script step.. But still the same thing
  15. dav1089
    Hello, I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record Now, I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record . Note: I also have script triggers attached to first and second field which runs on exiting the fields. (I don't think they affect anyways , but just mentioned to give idea)
  16. dav1089
    That was exactly I was looking for..Thanks @comment
  17. dav1089
    Sorry, how do I do it exactly?
  18. dav1089
    Hi @BrentHedden , I created script trigger onObjectSave for ID field but can't seem to be working : So I created self-join relationship with operator ID as match field , but how to do Go to Record/Request to find previous record with duplicate ID .. (Do I do find record)? I also created global to store entered operator ID and compare against self-joined occurance match field I have done script trigger in past to find duplicate field records but , this time it is little complicated , I am also assigning value to another field.. and coming back to new record Please help me Thank you
  19. dav1089
    I will give it a try and see how it works out Thank you @BrentHedden
  20. dav1089
    Hello, I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me: I am creating operator timesheet layout for product lifecycle in list-view. Each operator has a list of unique barcodes(printed sheet) for each production function. Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1 and Marc 2. So, on the interface(list view of functions) , when an operator scans barcode of function it will set time-in field value and name of operator in their fields based on calculation from code. I don't want STOP button for each function to set value of time-out (because it requires user interaction), rather, I want it automated. I am looking for some sort of script trigger that runs on every new code scan and search for last record with similar operator name and set time-out value as current time in that record and set the same value as time-in for new function record. Thank you
  21. dav1089
    Hah! it did the magic...thanks Steve..
  22. dav1089
    Hi, I have Contacts portal on Company layout. Now, I can do FIND in other fields of the portal but email field., I already checked inspector > Field Entry in find mode is cheked.. I have attached screenshots
  23. dav1089
    okey.. So how do I show only most recent ones?
  24. dav1089
    I also tried creating calculation field in company table which calculates max activity date and used it to find first row with highest activity date.. but had no luck
  25. dav1089
    I am using daily log table(child table) to produce report , on the same layout I have made it to sort it by Sales Person and Activity Date (Sub-Summary : Sales Person).. I have attached the screenshot of how it looks (Layout and script) I don't want duplicate company daily log sales activities from daily log Portal for each company, instead I only need first record (obviously highest activity date as Portal is sorted by activity date in descending order)
×
×
  • Create New...

Important Information

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

  I accept