4 Replies Latest reply on Oct 24, 2010 11:30 PM by Yman

    Import / Updating Matched Records

    webflys1

      Title

      Import / Updating Matched Records

      Post

      Seems like the easiest things you get stuck on -

      I am tryting to update matched records via an IMPORT. The .csv file I am importing looks like this:

      "00010495","YES","Debra"
      "00010486","YES","Mark"
      "00010529","YES","Carol"
      "00010881","YES","lorraine"

      The match field is the first field which is the customer order number. The field itself is a TEXT field, I also tried it as a "NUMBER field. No luck - it does not find these 3 records and update the records with the other two variables. No clue why.

      So, the import script is simple:

      00010495=Order Number
      YES>Referral
      Debra>Name

      When the order number matches, update with the other two variables. The order nubers look like:

      00091111111

      Not sure if the ZEROS in the beginning are doing something? Again, I tried the field as TEXT AND NUMBER - neither way updates the records. I read all the notes on importing & matching and do not go against any of the guidelines (calculated fields, portals... bla bla)

      Thanks

      1.jpg