How can I read in a list of my Value-mapped items in ConnectAll?

Question ID: 109104
0
0

I see how to do value-mapping (for Status fields not matching between my two endpoints in connectAll, for instance).
but we have a map I need to do with two fields that have many values, can I do this from a list maintained in Excel?

Marked as spam
Posted by (Questions: 180, Answers: 13)
Asked on July 29, 2019 4:44 pm
1 views
Answers
0
Private answer

You can easily do this with the help of Excel, but you would be working with CSV (comma-separated value) files.

It involves having ConnectAll write out or read in the value-map list (lookup list) from a CSV file.

An easy process is to create a field map for a single-select (''Priority'' or ''Severity'' for instance), Put in a few value-maps interactively, then EXPORT the mapping (with the single record or two) into a CSV so you can get the format of what needs to be in the table, then open the CSV in Excel, populate it with other corresponding value-maps from your 2 tools, then re-import the CSV back into the mapping as the value-map. Make SURE to save the file as CSV.

You could also save this Excel table to refer back to if you need to change or add some values. Then you can just re-import back on top of your list later to replace.

See section about it here (about half-way down the page - look for ''import/export to csv''):
https://wiki.connectall.com/ca/latest/user-guide/field-mapping

Marked as spam
Posted by (Questions: 3, Answers: 454)
Answered on July 29, 2019 4:52 pm