从oracle dB的多选列中获取价值，并在SharePoint列表中进行更新 [英] Get value from multi choice columns from oracle dB and update in SharePoint list

问题描述

亲爱的

我目前正在使用PowerShell脚本来从oracle dB的多选字段中读取值，对其进行处理并将其更新为SharePoint列表中的文本"字段.

I am currently working on a PowerShell script to read the values from multi- choice fields from oracle dB, process them and update them as Text field in SharePoint list.

我目前能够从Powershell连接到Oracle DB，并且能够读取简单字段(文本，数字等)的值.即使在oracle db中有可用数据的情况下，在多选字段的情况下也会导致结果.

I am currently able to connect to Oracle DB from Powershell and able to read the values of simple fields (text, number etc.) However I am getting "blank" results in case of multi choice fields even though there is data available in the oracle db.

你能帮我吗?

事先感谢.

推荐答案

Hi Amogh Kulkarni,

如果可能，请与我们分享您的脚本以跟踪您的问题，也可以直接在ps脚本中命中断点并逐步移动并检查返回的值，然后检查它是否在列表项更新时引发异常，或者任何转换 返回的值，并在此步骤中引发异常，只需要简单地通过在脚本中命中一个断点来跟踪问题，然后逐步调试即可.

if possible share with us your script for tracking your issue, Also you can simply hit breakpoints in your ps script and move step by step and check the returned values , then check if it throws exception on list item updating , or you do any conversion on the returned values and it throws exceptions on this steps, simply you need to track the issue by hitting a breakpoints in your script then debug step by step . 

这篇关于从oracle dB的多选列中获取价值，并在SharePoint列表中进行更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！