Jump to content

Recommended Posts

Hey,

I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example.

I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. 

So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that.

Thanks in advance,

Mike

Share this post


Link to post
Share on other sites
3 hours ago, 123 said:

one line describes an order, another line describes a payment

You left out the part explaining how to tell these two apart.

Share this post


Link to post
Share on other sites

Hey,

each line has a certain keyword. For example Payment or Order. Those keywords are in the same position in every line.

Thanks for your response,

Mike

Share this post


Link to post
Share on other sites

Basically, you have two options:

1. Import the file twice, once into the Payments table and once into Orders. In each table, define a Type field and set it to validate by calculation:

 Self = "Payment" 

and:

Self = "Order"

respectively, validate always. When importing, map the keyword to the Type field.

 

2. Import into a temp table first, then do a find for each type and import the found set into the corresponding target table.

 

Both options can be scripted so that the user only needs to select the file.

Edited by comment
  • Like 1

Share this post


Link to post
Share on other sites

Hey,

thanks for the quick response. The first way you described sounds like a good solution, I will give it a try tomorrow, thank you so much.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Similar Content

    • By Gilles Plante
      Hi,
       
      I am running version 17.0.2 - in demo mode for not but we will a buy a licence today.
      In the bottom pane I have a list of fields for a table and would like to get that list inside a FileMaker file. When I right-click on the list - all items are selected - I get a choice Calle Copy for FIleMaker. What do I get when picking this menu choice, and how can I paste in FileMaler ?
      Thanks
       
    • By Prasad Khandagale
      MetaBiz is FileMaker based Multi-platform business management software for small and medium businesses. For more info - https://www.metasyssoftware.com/meta-biz

      MetaBiz.mp4
    • By HOnza
      [FOR IMMEDIATE RELEASE]
      24U releases 24U Phidgets Plug-In 3.0  for FileMaker® Pro 14-17
      This new version of the popular hardware integration plug-in adds compatibility with VINT
       
      Prague, CZ — July 30, 2018 — 24U has released 24U Phidgets Plug-In 3.0 for FileMaker Pro 14 through 17. The popular plug-in for integrating FileMaker solutions with hardware devices, such as relays, envrionmental sensors, RFID, and more,  now adds support for the smart VINT interface announced by Phidgets Inc. in August 2017.
       
       
      About 24U Phidgets Plug-In:
       
      24U Phidgets Plug-In allows FileMaker Pro to interact with various Phidgets boards to let your solution control physical devices and physical devices to control your solution.
       
      24U Phidgets Plug-In allows FileMaker Pro users to:
      Read and write RFID tags to track goods, assets and people Capture sensor data to collect environmental data such as temperature or force Control servo motors to automate moving parts of robots and machines Read digital and analog inputs to control your solution by physical controls Set digital outputs to switch lights and other electrical devices Display text on an LCD display to create custom user interface such as cashbox Set analog outputs to control electronic equipment  
       
      About VINT
       
      VINT stands for Versatile Interface, and it's the system that all modern Phidgets use to communicate. The main advantages of VINT are versatility, modularity, connectivity and stability. A VINT Hub Port is a versatile interface that combines the functionality of analog inputs, digital inputs, and digital outputs. The mode of each port can be selected in software by creating a new object and opening it on the desired port. Many VINT devices also come built-in with data and power isolation to prevent power fluctuations from entering the system.
       
       
      Sample uses of 24U Phidgets Plug-In
       
      Existing customers use 24U Phidgets Plug-in in a wide range of different industries, including compliance testing of electrical equipment, sorting sheep, opening door to gym for customers identified by RFID loyalty card, or robotics prototyping.
       
      “We had a hospital client and we used the 24U Phidgets Plug-In together with an RFID reader for tracking patient charts. The results were quite amazing. Prior to installing this the hospital lost charts on daily basis. When a chart was misplaced it was very difficult to find. The introduction of the chart tracking system meant that everyone knew the location of the chart by looking at the patient screen,” said Joe Byrne, CEO of Glanmire Electronics
       
      For Owen Caldwell, technology manager at Cal Poly Pomona Foundation, Inc., 24U Phidgets Plug-In makes it possible to prepare useful projects for electrical engineering major students. At FileMaker DevCon 2014 Owen said: “With Phidgets we’ve been able to create projects that are not only pertinent to their field but also beneficial to the workplace. We are looking at wiring up the offices to do 3D temperature mapping. With this I am hoping to be able to determine what effect the occupancy of the office has on the overall environment.”
       
       
      What's new in 24U Phidgets Plug-In 3.0:
       
      Compatibility with VINT lets you use the modern versatile Phidgets devices Support for Stepper Controller Support for SBC 4  
       
      Recommended configuration:
      Mac OS X: Any Intel Mac, 4096 MB RAM, macOS High Sierra 10.13, FileMaker Pro 17 Advanced
      Windows: Dual Core 1.6 GHz processor, 4096 MB RAM, Windows 10, FileMaker Pro 17 Advanced
       
      Minimum requirements:
      Mac OS X: Any Intel Mac since 2008, 2048 MB RAM, Mac OS X 10.10 Yosemite, FileMaker Pro 14.
      Windows: 1 GHz processor, 2048 MB RAM, Windows 7, FileMaker Pro 14.
       
      FileMaker Pro Compatibility:
      Fully compatible with FileMaker Pro 12, 13, 14, 15, 16 and 17
      Compatible with FileMaker Pro 17 in both 32-bit and 64-bit modes
      Compatible with both 32-bit and 64-bit versions of FileMaker Pro 17 on Windows
      Older versions with limited functionality are available for FileMaker Pro 8 thru 11
       
       
      Availability and Pricing of  24U Phidgets Plug-In 3.0
       
      24U Phidgets Plug-In 3.0 is immediately available for download free of charge as a fully functional 14-days trial version, which can be activated after purchasing a license code.
       
      Licenses for 24U Phidgets Plug-In start at US$79 per user and device or $249 per user with unlimited devices.
       
      Existing customers can upgrade to the new version at 30 % off the regular prices. Until 15 August 2018 customers can upgrade at 50 % off the regular prices!
       
      Optional Premium Support and Implementation service are available with the purchase of 24U Phidgets Plug-In 3.0.
       
      More information: https://www.24usoftware.com/Phidgets/
      Download: https://www.24uSoftware.com/Phidgets#download
      Buy: https://www.24uSoftware.com/Phidgets#buy
       
       
      About 24U Software
       
      With a team of full-time testers, web, plug-in, Mac, Windows, Linux, iOS, and Android native app developers, and FileMaker certified developers, led by the FileMaker DevCon 2015 Developer Cup champion, 24U excels in taking care of existing FileMaker solutions, optimizing their performance, identifying and resolving potential issues and liabilities, improving reliability, stability and scalability, integrating them with other systems including various hardware devices, and extending them beyond expectation.
       
      As a platinum member of the FileMaker Business Alliance, we help global businesses around the world to maintain sustainable growth by working with their in-house developers or completely taking care of the maintenance and development of their business solutions.
       
       
      Customer contact:
      HOnza Koudelka
      Software Division Manager, 24U s.r.o.
      sales@24usoftware.com
      http://www.24usoftware.com
       
      Press Contact:
      pr@24uSoftware.com
       
      ###
       
      (c)2018 24U s.r.o. All rights reserved. 24U, 24U Software, and FM Bench are trademarks of 24U s.r.o. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.
    • By HOnza
      [FOR IMMEDIATE RELEASE]
       
      24U Software releases Gonector for custom mobile FileMaker® apps
      Gonector connects a custom native app built with the FileMaker iOS App SDK directly to mobile hardware devices
       
       
      Prague, CZ — July 27, 2018 — 24U Software releases Gonector, a FileMaker plug-in that allows a native application for iPhone or iPad, built using the FileMaker iOS App SDK, to communicate directly with mobile hardware devices.
       
      Being able to interact with professional mobile devices enables developers to use the FileMaker platform to create POS, Inventory and lots of other heavy-duty mobile business apps with friendly, fast, and reliable user interface.
       
       
      Gonector Features:
       
      - qID mini UHF RFID reader enables custom mobile apps to read UHF RFID tags
      - Support for reading NFC tags on iPhone 7 or later lets a custom mobile FileMaker app read NFC without additional hardware
      - Linea Pro and Infinea support enables custom apps to read and write RFID/NFC tags, and read barcodes, 2D codes, and magnetic stripe cards
      - Reading data from digital scales allows custom FileMaker apps to capture weight data directly from the scale without interfering with the user interface
      - Support for BlueTooth mobile receipt printers allows for printing professionally looking receipts directly from a mobile FileMaker app
       
       
      Requirements:
       
      Recommended configuration for development:
      - Mac: Any Intel Mac, 4 GB RAM, macOS 10.12, FileMaker Pro 16 Advanced.
      - Windows: CPU: 1 GHz or faster x86- or x64-bit processor RAM: 2 GB or more, Windows 10 Pro Edition, FileMaker Pro 16 Advanced.
       
      Minimum requirements for development:
      - Mac: Any Intel Mac, 4 GB RAM, macOS 10.12, FileMaker Pro 16 Advanced.
      - Windows: CPU: 1 GHz or faster x86- or x64-bit processor RAM: 1 GB, Windows 7 SP1 Professional Edition, FileMaker Pro 16 Advanced.
       
      Minimum requirements for building and deployment:
      - macOS 10.13 and Xcode 9.2/Swift 3.2 (or build online at https://www.24uSoftware.com/Xgode)
      - iOS 11.3
      - developer.apple.com account (for testing and deployment on device)
      - FileMaker iOSAppSDK 16.0.1 or newer
      - Gonector is fully supported by Xgode, 24U’s online service for building iOS apps
       
       
      Warning:
       
      According to the FileMaker iOS App SDK, “FileMaker, Inc. does not recommend or support using the App Store to distribute apps created with iOS App SDK. FileMaker, Inc. recommends using the Apple Developer Enterprise Program to distribute your iOS apps. You can also use the Volume Purchase Program (VPP) to distribute your iOS apps through the VPP store.”
       
       
      Availability and Pricing of Gonector:
       
      Gonector is immediately available for download free of charge. Incuded a placeholder
      desktop plug-in for development can be used without limitation. iOS version of the plug-in works with one bundle ID for one hour, and can be activated after purchasing a license.
      Gonector license costs US $499 per application (bundle ID).
       
      More information: https://www.24uSoftware.com/Gonector
      Download: https://www.24uSoftware.com/Gonector#download
      Buy: https://www.24uSoftware.com/Gonector#buy
       
       
      About 24U Software
       
      With a team of full-time testers, web, plug-in, Mac, Windows, Linux, iOS, and Android native app developers, and FileMaker certi ed developers, led by the FileMaker DevCon 2015 Developer Cup champion, 24U excels in taking care of existing FileMaker solutions, optimizing their performance, identifying and resolving potential issues and liabilities, improving reliability, stability and scalability, integrating them with other systems including various hardware devices, and extending them beyond expectation.
       
      As a platinum member of the FileMaker Business Alliance, we help global businesses around the world to maintain sustainable growth by working with their in-house developers or completely taking care of the maintenance and development of their business solutions.
       
       
      Customer contact:
      HOnza Koudelka
      Software Division Manager, 24U s.r.o.
      sales@24usoftware.com
      http://www.24usoftware.com
       
      Press Contact:
      pr@24uSoftware.com
       
      ###
       
      (c)2018 24U s.r.o. All rights reserved. 24U, 24U Software, and FM Bench are trademarks of 24U s.r.o. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.
    • By Jhon Doe
      Hi everyone,
      I'm a beginner in FM, and i'm trying to develop a solution that allows me to import data from a csv file. I have two related tables Customer ("parent") and Alerts ("child"), each one has a primary key and the Alerts table has a foreign key to conect with the Customer table. I have to populated the alerts table from a cvs file that could have lots of records so I want to relate this new data to the right customers automatically when i import it, the new data does not have a field with the customer ID (primay key) only has its name. Could you please give me any advice with that?
×

Important Information

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