1 Reply Latest reply on May 16, 2016 6:37 AM by SteveMartino

    Importing Data into Groups

    SeattleSquirrel

      Hi - not sure if I'm asking this correctly, but here it goes. I am using an online scheduling software where I can only export the data into a .csv sheet. Projects have ID of a full number (example: 4). The subgroups and tasks then become 4.1, and then 4.1.1. All items with a 4 belong to the same project and I would like FileMaker to keep it as part of that record. But because they all come in on separate lines, FM recognizes them all as separate records. Any way to work around this? This is an import I would do daily so it can't be something that I have to fix in the spreadsheet every time. I should mention I'm not a savvy FM user unlike so many of you!

       

      Thanks for any advice you may have!

        • 1. Re: Importing Data into Groups
          SteveMartino

          I don't fully understand your work flow, but I do something similar, so I know it can be done.

          I don't know if your ID is your key field (hope it's not).

          I import the records to separate table.  Do a find for blank lines/records, and delete found set.  This leaves you with the usable records.

          What happens next I guess would depend on how you append your project ID.  For example, for Project 4, today you append records (4.1, 4.1.1 respectively).

          What happens tomorrow when you append project 4?   4.1.1.1 or 4.2