Jump to content

Import Records Script Step work on fm pro client but not PSoS on Filemaker server 14. Help!


YST

This topic is 3069 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi All!

Relatively new to building filemaker solutions, but stuck on this problem that have me pulling my hair out!.

I have a filemaker server 14 running on a Mac Mini os X 10.10 and I want to schedule a Filemaker script to run on the server that every night updates a table with new entries from a excel sheet that gets updated daily (in .xlsx format).

The import records script works fine when I run the script locally on my laptop (filemaker pro 14) but when I schedule it to run on the server, it runs successfully every time and throws out no error codes. However the table does not get updated at all with any changes or new entries to the excel sheet. 

I have made sure that the file paths are correct and scripted a variable filepath to point to the correct file in the form of filemac:/Volume/Library/FileMaker Server/Data/Documents/filename.xlsx so that it can work on the server but still it does not work. Built a layout to capture what the script ($filepath was the variable file path, documentList was returned with Get (DocumentPathListing) ) was doing and it looked all correct.

ScreenShot.png.6d0ef87b67caf0cbcdbe16bbd

I have built a test solution to replicate the problem and attached it to this post ( username: admin, password: fm123 ) (removed the local reference to the file in the import record>specify file step, hence anyone helping to look through the file will have to input their own filepath there). I used buttons to have a script to launch the import script via PSoS and it also doesn't work.

Seems to me that everything is running smoothly except that filemaker server looks at the target file but does not import any of the data into the table.

 Any help will be greatly appreciated!

Cheers!

Yong

file3.xlsx

FMImportTest.fmp12

Edited by YST
addition of info
Link to comment
Share on other sites

This topic is 3069 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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