AnsweredAssumed Answered

Import / Updating Matched Records

Question asked by webflys1 on Oct 15, 2010
Latest reply on Oct 24, 2010 by Yman

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

Outcomes