Jump to content
Server Maintenance This Week. ×

Limits to "set contents of cell"


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

Recommended Posts

There seems to be a limit imposed on the amount of text that one can read into a cell from AppleScript in this way.

Does anyone know a way to get around this?

I have a text file that I read in and then copy into a text record in FileMaker. AppleScript reads 2500 lines, but then only transfers 85!

-- request the file containing the text 

set filePath to POSIX path of (choose file with prompt "Select text file for import" without invisibles)



-- get the text of file and put it in current FileMaker record

open for access file filePath

set fileText to read POSIX file filePath as text

close filePath



try

	tell application "FileMaker Pro Advanced"

		tell table "ImportTable"

			set contents of cell "filepath" to filePath as text

			set contents of cell "filetext" to fileText as text

		end tell

	end tell

end try

Link to comment
Share on other sites

Just a quick further note to say that it works fine when you manually transfer the text via the clipboard. If I try to copy and paste using AppleScript, I get the same limiting problem.

Link to comment
Share on other sites

This topic is 5804 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.