Importing multiple telephone types

We've got some donors for which we have columns where we have work phones, and some have home phones, and some have cell phones, and some have more than one. (Otherwise I'd be inclined to merge them all into one column/field and call it good.)

I've gotten the json to validate. But still can't upload the import mapping, and this is the sticking point.

invalid json for refinery options for group Donor/source 3 =

"relationshipType": "^19", 

"entityType": "ind"  

"displayname": "^10"

"attributes": 

 "email": "^11", 

 "telephone": "^15", "type": "cell",

 "telephone": "^16", "type": "home",

 "telephone": "^17", "type": "work",

 { "address": 

  {"address1": "^3", 

  "city": "4", 

  "stateprovince": "^24", 

  "postalcode": "^25", 

  "country": "^6" }  } }


How do I import telephone numbers of different types? And are there other issues with this refinery?

Thanks!

Comments

  • Well, I actually got that sorted. That piece was fine.


    My remaining error is  

    Could not insert new record for object lot: Invalid relationship reference for lot_status_id

    I've been tweaking my date in OpenRefine (which is amazing for this, by the way!), and I went so far as to create a column just for this, and it is, I think, using that column. Just want to verify: this error refers to the relationship between the entity and the lot, correct? (I updated the text in these fields to use the exact object lot types identifiers, so I'm not sure what I'm missing.

  • Okay, so we have it mostly working save for the telephone numbers. The e-mail and the address all comes in, but the telephone number(s) do not. If we try to bring in just one telephone number, it successfully reads the type ("home" in this example) but not the number. Ultimately, we have three phone numbers - work, cell, home - that we'd like to bring in for each entity, so we tried using a JSON list notation (square brackets) - but nothing comes in. Here are some examples. Could you give us a push in the right direction here?


    Thank you!


    {

      "relationshipType":"^27",

      "entityType":"ind",

      "displayname":"^10",

      "attributes":{

       "email":"^11",

       "address":{

         "address1":"^3",

         "city":"^4",

         "stateprovince":"^24",

         "postalcode":"^25",

         "country":"^6"

       },

       "telephone":[

         {

          "telephone2":"^15",

          "telephone3":"home"

         },

         {

          "telephone2":"^16",

          "telephone3":"work"

         },

         {

          "telephone2":"^14",

          "telephone3":"cell"

         }

       ]

      }

    }



    ^ -- What we want -- a listing of telephone numbers

    ----

    v -- What we get closer -- in debug output, we get telephone3/home showing up, but not the telephone2


    {

      "relationshipType":"^27",

      "entityType":"ind",

      "displayname":"^10",

      "attributes":{

       "email":"^11",

       "address":{

         "address1":"^3",

         "city":"^4",

         "stateprovince":"^24",

         "postalcode":"^25",

         "country":"^6"

       },

       "telephone": {

        "telephone2":"^15",

        "telephone3":"home"

       }

      }

    }


    In the "metadata elements", we have:

    "telephone": container -->

      "telephone1": container -->

        "telephone2": text

        "telephone3": list (contact_types)

Sign In or Register to comment.