Jump to content

  •  

Photo

Importing Records via Scripts


  • Please log in to reply
2 replies to this topic

#1 Jarvis  wannabee

Jarvis
  • Members
  • 571 posts
  • FM Application:11 Advance
  • Time Online: 16h 29m 56s

Posted 29 January 2014 - 08:09 PM

I am not sure if this is a scripting question or an importing question.

 

I am trying to import found records from one table into another.

Both tables reside in the same database.

 

I would like to able to perform a FIND in Table B and have the found records imported into Table A.

 

I can do this from the File menu.

When I select "Import Records" I have to then select the file I want to import from.

 

I would like this to be a one button process.

I ALWAYS want to select the found records from same specific file.

 

Is there a way to script this so that the user does not need to make any selections?

 

 

 


  • 0

#2 Manjit Behera  novice

Manjit Behera
  • Members
  • 35 posts
  • LocationBhubaneswar, Odisha, India
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Certification:11, 12
  • Time Online: 11h 4m 36s

Posted 30 January 2014 - 05:16 AM

Hi Jarvis,

 

If you are need you want to do this importing then you need to follow the steps as shown in the attached image.

 

You need to provide the file name directly or can select your currently using Filemaker file from your system so that it will easily take the name. Once you selected the file/provide the file path as shown here then just provide the field mapping and  checked the checkbox on the left of import script step option to disable the import dialog during importing.

 

ImportRecord.png

 

https://www.dropbox....mportRecord.png

 

Hope this will help you.

 

Thanks

Manjit


  • 0

Manjit Behera
Senior Software Developer, Mindfire Solutions, India
http://www.mindfiresolutions.com
email:manjitb@mindfiresolutions.com
Skype: mfsi_manjitb

FileMaker 11 and 12 Certified Developer


#3 Jarvis  wannabee

Jarvis
  • Members
  • 571 posts
  • FM Application:11 Advance
  • Time Online: 16h 29m 56s

Posted 30 January 2014 - 08:59 PM

Hi Manjit,

 

Thank you so much for explaining this to me.

What you wrote was very easy to understand and works perfectly!

 

Jarvis


  • 0




FMForum Advertisers