AnsweredAssumed Answered

Import Records issue

Question asked by NathanJones on Dec 5, 2013
Latest reply on Dec 5, 2013 by NathanJones

Title

Import Records issue

Post

     We are using FileMaker 12.0v4.Working in pinksheet.  When we go to file > Import > file, then select a file to import, it brings up the Import Field mapping dialog box. This is where the issue is. It has source fields on the left, and target fields on the right. The issue is that it is dumping as much data as possible on one line, and then it breaks down to the next line, and so on. For instance, for instance the first 3 targets fields on the right are ( Last name, Social security number, and Date of Birth ). When you look at the source fields on the left, I should just see the last name. Instead it has the next 7 target fields worth of data all on ONE line in the source fields. It fills that line with as much data as it can and then breaks down to the following line. So then the next target field should be SSN, and it starts with the address ( which is about 7 target fields down ), and then it has about 7 fields worth of data, before it breaks and goes on down to the next source field. So in the end - there is only about 10 target fields that will get any data. The rest are blank all the way down the page.

     I will attach an image. As you can see, multiple fields are stacked on top of each other. The fields aren't lining up.

     Has anyone seen this?

importissue.png

Outcomes