dav1089

Members
  • Content count

    52
  • Joined

  • Last visited

Community Reputation

0 Neutral

About dav1089

  • Rank
    member

Profile Information

  • Gender
    Male

FIleMaker Profile

  • FM Application
    13 Client
  • Platform
    Mac OS X El Capitan
  • Skill Level
    Novice

Recent Profile Visitors

790 profile views
  1. 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. I am having the same issue in my import records script, can anyone please help out?
  3. 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. 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. 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. 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. 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. Hi, It works great .. and I used original timestamp string.. Thank you @comment
  9. 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. This works fine when I don't put the new record script step on firstwindowopen trigger and put it on onlayoutenter ...
  11. 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. 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)
  13. Yes, I did...(Go to field) script step.. But still the same thing
  14. 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)