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

    Importing a .DAT file problems

    GaryIlcyn

      Summary

      Importing a .DAT file problems

      Product

      FileMaker Pro

      Version

      11.0v3

      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
          TSGal

          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.

          TSGal
          FileMaker, Inc.