Filling a External Data field (BCS) in a list trough Powershell I have a list of which one of the columns is of the "External Data" type, linked to a BCS service.  We called this column "Organisation", and when I check the generated fields in powershell (with $list.Fields | select Title) I see that an Organisation and an Organisation_ID field was added to the column.  What I'm trying to do is to add a new item to this list and cause the BCS to retrieve data (trough an ID that I write to Organisation or Organisation_ID)   It would also be OK if I can trigger a workflow upon adding an item, that does this.  Any suggestions? Googling seems very hard on this matter.
How to automate entry of external column data in BCS? I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated.  I have an external content type ( ECT ) that is mapped to a table that lists EmployeeID and several other columns of information. I added this ECT to the library as an External Column.    I am looking for a good way to automatically go through all items in the document library, and copy the value from the "regular" EmployeeID column into the External EmployeeID column and have it update the other columns from the ECT. Any techniques are useful (PowerShell, Object Model, Workflow?) When we have tried this in the past with workflows the setting of the External Column did not report failure, but didn't actually trigger a lookup of the other data and the value didn't seem to actually get saved.  [Update] I have been working on this and am getting closer. I am using PowerShell to access the list and set the external column ID field to the value I want it to be.  The problem is that it doesn't seem to be triggering a lookup of the external data when that field is set.  my "list" (a document library) has a few normal fields and a set of external columns mapped to an ECT "EmplData".  When you use the GUI to add or edit the properties of an item, it works. When I use PowerShell to do the following:  $spList = $spWeb.Lists["Resumes"] $spListItem = $spList.GetItemById(1) $spListItem["EmplData_ID"] = "00300"    $spListItem.Update()   Sometime the external ID field gets updated when I the refresh the web page, other times it says "(blank)". In all cases it does not load in the other fields.  Is there some Update method that updates the rest of the elements?  I gather from research that these are called "secondary fields", is the method to update the secondary fields based on the external item ID available in PowerShell cmdlets someplace?  [Update] I am finding that if I use:  $spListItem["EmplData"] = "000300"   instead of $spListItem["EmplData_ID"] = "00300" it gets around the problem of the column showing "(blank)".   I still need to figure how to make it update the other external columns (also known as "secondary columns" I think)
Do spice containers need to be hermetic? I want to use VBScript to catch errors and log them (ie on error "log something") then resume the next line of the script.  For example,   On Error Resume Next 'Do Step 1 'Do Step 2 'Do Step 3   When an error occurs on step 1, I want it to log that error (or perform other custom functions with it) then resume at step 2. Is this possible? and how can I implement it?  EDIT: Can I do something like this?   On Error Resume myErrCatch 'Do step 1 'Do step 2 'Do step 3  myErrCatch: 'log error Resume Next Indirect return of all elements in an array The Bash man page describes use of ${!a} to return the contents of the variable whose name is the contents of a (a level of indirection).  I'd like to know how to return all elements in an array using this, i.e.,  a=(one two three) echo ${a[*]}   returns  one two three   I would like for:  b=a echo ${!b[*]}   to return the same.  Unfortunately, it doesn't, but returns 0 instead.  Update  Given the replies, I now realise that my example was too simple, since of course, something like:  b=("${a[@]}")   Will achieve exactly what I said I needed.  So, here's what I was trying to do:  LIST_lys=(lys1 lys2) LIST_diaspar=(diaspar1 diaspar2)  whichone=$1   # 'lys' or 'diaspar'  _LIST=LIST_$whichone LIST=${!_LIST[*]}   Of course, carefully reading the Bash man page shows that this won't work as expected because the last line simply returns the indices of the "array" $_LIST (not an array at all).  In any case, the following should do the job (as pointed out):  LIST=($(eval echo \${$_LIST[*]}))   or ... (the route that I went, eventually):  LIST_lys="lys1 lys2" ... LIST=(${!_LIST})   Assuming, of course, that elements don't contain whitespace. Is it possible for some integer $n&gt;1$ that $2^n-1\mid 3^n-1$ ?   I have tried many things, but nothing worked. Hopefully I'm using the right terminology. I'd basically like to know how specific of a location I can make a Pokemon Lure. An Address will not cut it, would need to be like 5ft of my phone or something for it to be useful.  I do not currently play the game and am only interested in this to attract new customers similar to,  but I wouldn't be in a storefront with an address. How can I run Maniac Mansion through ScummVM? Day of the Tentacle Remastered Edition includes Maniac Mansion as a .  The game appears to be exactly the same as the old DOS release (albeit, the enhanced version).  If possible, how can I run this game through ScummVM?  Pointing ScummVM at my installed game doesn't work.  What do I need to do to play this version of Maniac Mansion? Unable to correctly install pip3 using apt-get I am using Ubuntu 16.04, and was experiencing issues with my pip3. Specifically, when I attempted to uninstall a package via  sudo pip3 uninstall   I encountered   Traceback (most recent call last):   File "/usr/bin/pip3", line 9, in &lt;module&gt;     from pip import main ImportError: cannot import name 'main'   I attempted to resolve this issue by reinstalling pip3, specifically   sudo python3 -m pip uninstall pip &amp;&amp; sudo apt install python3-pip --reinstall   which succeeded. However, I no longer have a local version of pip3 at all  bash: /home/kurt/.local/bin/pip3: No such file or directory   Using which pip3 in a new terminal I find,  $ which pip3 /usr/bin/pip3   and attempting to use pip3 at all brings me  $ pip3 Traceback (most recent call last): File "/usr/lib/python3/dist-packages/pip/_vendor/__init__.py", line 33, in vendored     __import__(vendored_name, globals(), locals(), level=0) ImportError: No module named 'pip._vendor.pkg_resources'  During handling of the above exception, another exception occurred:  Traceback (most recent call last): File "/usr/bin/pip3", line 9, in &lt;module&gt;     from pip import main File "/usr/lib/python3/dist-packages/pip/__init__.py", line 13, in &lt;module&gt;     from pip.exceptions import InstallationError, CommandError, PipError File "/usr/lib/python3/dist-packages/pip/exceptions.py", line 6, in &lt;module&gt;     from pip._vendor.six import iteritems File "/usr/lib/python3/dist-packages/pip/_vendor/__init__.py", line 75, in &lt;module&gt;     vendored("pkg_resources") File "/usr/lib/python3/dist-packages/pip/_vendor/__init__.py", line 36, in vendored     __import__(modulename, globals(), locals(), level=0) File "&lt;frozen importlib._bootstrap&gt;", line 969, in _find_and_load File "&lt;frozen importlib._bootstrap&gt;", line 958, in _find_and_load_unlocked File "&lt;frozen importlib._bootstrap&gt;", line 664, in _load_unlocked File "&lt;frozen importlib._bootstrap&gt;", line 634, in _load_backward_compatible File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2927, in &lt;module&gt; File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2913, in _call_aside File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2952, in _initialize_master_working_set File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 956, in subscribe File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2952, in &lt;lambda&gt; File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2515, in activate File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2097, in declare_namespace File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2047, in _handle_ns File "/usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl/pkg_resources/__init__.py", line 2066, in _rebuild_mod_path AttributeError: '_NamespacePath' object has no attribute 'sort'   However, I am able to execute without incident when typing sudo -H pip3 -v. Reinstalling pip3 from apt, e.g.  sudo apt-get install python3-pip --reinstall   has no effect. If anyone has any insight, or has encountered a similar problem, I would greatly appreciate any input on how to approach this problem. Making Change for a Dollar (and other number partitioning problems) I was trying to solve a problem similar to the "how many ways are there to make change for a dollar" problem.  I ran across a  that said I could use a generating function similar to the one quoted below:     The answer to our problem (293) is the   coefficient of $x^{100}$ in the reciprocal   of the following:      $(1-x)(1-x^5)(1-x^{10})(1-x^{25})(1-x^{50})(1-x^{100})$   But I must be missing something, as I can't figure out how they get from that to $293$. Any help on this would be appreciated. I'd like to get an advanced frame in Firefall. I've been told that I can use "Pilot Tokens" to unlock other frames without having to pay money.  How soon would I be able to unlock an advanced frame? Do I have to level a base frame all the way to level 40? More than once? Having a UV maping problem, does anyone know what this is, and how to fix it? How can I scale all images in a folder to the same width? I want to scale all images in a given folder to the same width (but different appropriately scaled heights). How can I do this using  a GUI-based or command-line tool?  For bonus points, is it possible to restrict which images are scaled based on their initial width (that is, only scale images that have a width > x and/or a width &lt; y)? How to convert Strings to and from UTF8 byte arrays in Java In Java, I have a String and I want to encode it as a byte array (in UTF8, or some other encoding). Alternately, I have a byte array (in some known encoding) and I want to convert it into a Java String. How do I do these conversions? What is C# analog of C++ std::pair? I'm interested: What is C#'s analog of std::pair in C++? I found System.Web.UI.Pair class, but I'd prefer something template-based.  Thank you! Why shouldn't I use getnonfreefonts to install additional fonts? Why shouldn't I use updmap when installing or removing fonts? [Probability]need help to understand the following expression So assume $Y$ and $X$ are exponentially distributed with parameters $y_1$, and $x_1$ respecitively.  assume c is a constant.  I am having huge trouble to understand the integration of the following expression.  $P(Y&lt;c/u(X))$  $=\int_{t}^{\infty}f_X(x)\int_{0}^{c/u(x)}f_Y(y)dydx +\int_{0}^{t}f_X(x)\int_{c/u(x)}^{\infty}f_Y(y)dydx$  where t is the cross-point that $u(x)$ change sign    here $c/u(x)$ is given by the plot below, t is the point crossing the zero:   Confusion:   I don't understand the second integration of the second term "$\int_{c/u(x)}^{\infty}f_Y(y)dydx$", this isn't right because Y an X only defined for y>0, and x>0. So it's the first quadrant in this plot. Checkbox in listview control Can you have a multicolumn listview control where one of the columns is a checkbox?  Example code or links would be greatly appreciated.  I am using visual studio 2005 Tunnel traffic through another machine over ssh I'm trying to configure a ubuntu server network. [Edit] My ifconfig: lo: flags=73&lt;UP,LOOPBACK,RUNNING&gt; mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10&lt;host&gt; loop txqueuelen 1000 (Loopback Local) RX packets 352 bytes 26160 (26.1KB) RX erors 0 dropped 0 overruns 0 frame 0 TX packets 352 bytes 26160 (26.1KB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0  I edited the /etc/network/interfaces file and here is how it is: auto lo auto eth0 iface eth0 inet static address 192.168.15.141 netmask 255.255.255.0 gateway 192.168.15.1  I'm trying to restart the server and I'm using: sudo ifdown --exclude=lo -a &amp;&amp; sudo ifup --exclude=lo -a  This command is an answer from this link:  And I'm getting the following error: Cannot find device &quot;eth0&quot; Failed to bring up eth0.  I'm pretty lay in configuring a server, so I have no idea what's going on. Can someone help me please? Why does latex stretch small sections across the whole page vertically? I'm writing my bachelor-thesis and have a couple of small sub-sub-sections explaining conversions, like in the following  \subsubsection*{Assignment}  This document only explains non-compound assignments. The other kind, i.e \texttt{a += b}, is supported by the language too, but is not yet implemented.   \begin{itemize} \item If the first is an \texttt{auto} variable, no conversion takes place when assigning       the right hand side to the variable designated by the left hand side.  \item Otherwise, an assignment conversion takes place converting the given value to the type       of the designated variable.  \item Assignment requires an lvalue as the left hand side, and yields an lvalue result.  \end{itemize}  \subsubsection*{Multiplication} % ...   But latex renders it quite ugly with much space in between the items. I think it does so to fit the whole page. How can I tell it not to do so? Is what I'm doing right at all? I'm starting on mono blue mill deck and I saw . I'm not sure about its ability.     {tap}: put a charge counter on Grindclock      {tap}: target player puts the top X cards of his or her library into his or her graveyard, where X is the number of charge counters on Grindclock.   If I just cast  and use its first ability, will the second ability take effect, or do I just put a charge counter on it? If there's already one charge counter on it and I use the first ability again, it will have two charge counters on it? Then the second ability will take effect with two cards being sent to graveyard?  If I use spells or ability to untap it after being used can I use its ability again on the same turn?