Jump to content

Loading a a FMP table in batch


Daniel Paquin
 Share

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

Recommended Posts

I have an Applescript program which read the content of a directory. Each files contained in the directory becomes a record in a FMP table. It is used to fill the Product table.

All of this process is done behind the scene in batch.

I do have a problem and do not know if there is a solution.

In order for all of the information to get loaded in the Product table I must ensure nobody is accessing the file either from via the layout for the Standard form, a Table view and a List View. If someone is accessing the Product table at the same time the batch program is starting the load nothing gets loaded in the Product Tbale.

Is there something I can do to make this working?

Thanks in advance!

Daniel

Applescript program

.

.

try

tell application "FileMaker Pro Advanced"

do script "LoadProductTable"

end tell

end try

End Applescript progran

LoadProductTable: Perform Applescript

[

repeat with i from 1 to count of sortedMPGFiles

set theRecord to create new record at table "Products"

tell theRecord

set cell "PictNo" to (text 5 thru 8 of item i of sortedMPGFiles)

set _PictNo to (text 5 thru 8 of item i of sortedMPGFiles)

set _SubFolder to (text 5 thru 6 of item i of sortedMPGFiles)

set cell "OriginalName" to (text 5 thru 8 of item i of sortedMPGFiles)

set cell "PathVideoFile" to "/Users/UserName/" & _SubFolder & "/AVI10" & _PictNo & ".AVI"

set cell "Category" to "Video"

set cell "Status" to "Loaded"

end tell

end repeat

]

Link to comment
Share on other sites

This topic is 4390 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
 Share

×
×
  • Create New...

Important Information

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