AnsweredAssumed Answered

Formatting Data for Import

Question asked by gbrown007 on Jul 29, 2016
Latest reply on Aug 3, 2016 by beverly

Hi guys,

I have data that is exported from another program that basically comes out looking like this:


Record Import.jpg

This sample represents 2 records with data and links to images. The goal is to import the data into specific fields. And then link in the given images into a table linked to a portal. When accessing this data from the original program I scan the file till I find a given keyword like "Data3 : " and then read the rest line beyond it. Or use the key word "Images" in a loop to create an array of the image files. Looking here FileMaker Pro 15 Help it seems I would not be able to import the data because of how the file is organized. Can a script be written to better control how filemaker imports this data? Or do I need to reformat how this text file is written? And if so, what's the best way to put the image files into their own table?


Thanks for the help in advance!