Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

can I import a tab delin text file via script?

Featured Replies

Can I import a text file via the Import Records script step?

So far I don't see how I calculate the filename I am going to import.

I have a file, I know where it is, its path is stored in a global variable, I even copied the record into a variable but when I enter filemac:/$g_variableName in the file area FileMaker Pro complains:

The file "g_variableName" could not be found and is required to complete this operation

Is this possible?

Set Variable

$$gPath = filemac:/MacVolume1/Docs/Import.tab

In your import script, reference $$gPath

You say "global variable", but your $variable above is local, not $$global. So it will only work if the variable was set within that script. Another thing to check is whether the file path already has the 1st / (slash); most of the FileMaker calculation functions do: Get (DesktopPath), etc.. Use the Data Viewer to see what the Variable is before exporting. Is it a full path, from the root? It doesn't take much for a file path to be wrong.

  • Author

Thank you for the replies. My problem was twofold: I wasn't including the filemac:/ in my variable definition and also the stored path I had was HFS so I needed to convert the colons to slashes.

Set Variable [$$g_pathToFileFile; Value: "filemac:/" & Substitute ( LineItems::g_pathToFileFile ; ":" ; "/" )

Thanks!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.