1 Reply Latest reply on Mar 29, 2012 6:39 AM by TSGal

    Importing a .DAT file problems



      Importing a .DAT file problems


      FileMaker Pro



      Operating system version

      windows 7

      Description of the issue

      I have a website and I create a .dat file in Miva Merchant which is my shopping cart software. I download that file and import it into Filemaker and it creates a record for each individual order. This has been working flawlessly for a year. A few weeks ago after I imported the file into Filemaker it created 2 records for 1 order, the 2nd order was missing some of the information. This happens randomly we tried to see a pattern but cannot find one. It must be something in filemaker corrupting that .dat file. If I delete the orders and import the exact same .dat file a 2nd time it does not create that duplicate order. Some of the data on the duplicate order is missing and seems to have been pushed into other fields the first time, but again after I delete the orders and import the same file again it looks perfect. Any ideas of how to fix this problem?

        • 1. Re: Importing a .DAT file problems

          Gary Ilcyn:

          What file type is the .dat file?  Is it a comma-separated values (CSV) text file?  A tab-separated values (TSV) text file?  Is there any data with carriage returns in the field?  In your import script step, are you specifying a file type?  What other applications do you have running at the time of import?

          Since this "has been working flawlessly for a year", do you recall if anything changed in your system a "few weeks ago"?

          If you revert to a older backup of the file, does the problem still occur?

          Anything else you can provide may be helpful.

          FileMaker, Inc.