<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
You would also need to update the field_revision_* tables. It might
be better to use a drush PHP script to load the users one by one,
assign the value of the new field, and then save. This can also be
done with VBO.<br>
<br>
Ted<br>
<br>
<div class="moz-cite-prefix">On 6/1/2014 11:02 AM, Ashley Hall
wrote:<br>
</div>
<blockquote
cite="mid:1CA57C65-984E-4B1A-B24C-1353CB2EC26B@gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
Thanks, Walt.
<div><br>
</div>
<div>I tested a bit and copied the data from the existing table
field_data_field_twitter_name into the new table
field_data_new_twitter_field for 10 users. However, only data
that I manually enter into the field through the standard UI
gets rendered on the user profile page (or elsewhere via views).
Is it possible that twitter_username module is using multiple
tables? And if so, could you (or anyone) help me figure out any
other tables that I might need to update in order to make the
new field work properly?</div>
<div><br>
</div>
<div>Many thanks!</div>
<div>Ashley</div>
<div><br>
</div>
<div><br>
<div>
<div>On Jun 1, 2014, at 9:54 AM, Walt Daniels <<a
moz-do-not-send="true" href="mailto:wdlists@gmail.com">wdlists@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div dir="ltr">Changing field types is not easy. The best is
to add a new field of the right type, copy the data to it
and then delete the old field. There is no UI for copying
from one field to another so you have to do that by
writing code or using PhpMyAdmin.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Sun, Jun 1, 2014 at 8:21 AM,
Ashley Hall <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:knowledges33ker@gmail.com"
target="_blank">knowledges33ker@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word"><span
style="color:rgb(68,68,68);font-family:'Lucida
Grande','DejaVu Sans','Bitstream Vera
Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)">I
have a custom field on my user profile pages where
users can enter their Twitter user name. When the
user's profile is rendered (either on the user
profile page itself or via views) I would like to
rewrite this field so that it links to the user's
twitter profile following the pattern</span><a
moz-do-not-send="true"
href="http://twitter.com/%5bfield_twitter_name%5d"
rel="nofollow"
style="margin:0px;padding:0px;border:0px;font-size:14.399999618530273px;vertical-align:baseline;text-decoration:none;color:rgb(52,158,223);font-family:'Lucida
Grande','DejaVu Sans','Bitstream Vera
Sans',Verdana,Arial,sans-serif;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)"
target="_blank">http://twitter.com/[field_twitter_name]</a><span
style="color:rgb(68,68,68);font-family:'Lucida
Grande','DejaVu Sans','Bitstream Vera
Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)">.</span>
<div>
<span
style="color:rgb(68,68,68);font-family:'Lucida
Grande','DejaVu Sans','Bitstream Vera
Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)"><br>
</span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande, DejaVu
Sans, Bitstream Vera Sans, Verdana, Arial,
sans-serif" size="4"><span
style="line-height:14.5600004196167px">I
discovered the twitter username project on
DO yesterday (</span></font></span><a
moz-do-not-send="true"
href="https://drupal.org/project/twitter_username"
target="_blank">https://drupal.org/project/twitter_username</a><span
style="line-height:14.5600004196167px;color:rgb(68,68,68);font-family:'Lucida
Grande','DejaVu Sans','Bitstream Vera
Sans',Verdana,Arial,sans-serif;font-size:large;background-color:rgb(255,255,255);text-align:left">)
and this would help me accomplish the objective,
especially for new users. However, we currently
have ~900 active users on our site. </span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande, DejaVu
Sans, Bitstream Vera Sans, Verdana, Arial,
sans-serif" size="4"><span
style="line-height:14.5600004196167px"><br>
</span></font></span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande, DejaVu
Sans, Bitstream Vera Sans, Verdana, Arial,
sans-serif" size="4"><span
style="line-height:14.5600004196167px">Is
there a way to create </span><span
style="line-height:14px">a</span><span
style="line-height:14.5600004196167px"> new
field and update its tables with the
existing user's twitter names? Or is there a
way to change the field type from it's
current setting of "Text field" to the new
type made available by the twitter username
project "Twitter username"?</span></font></span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande, DejaVu
Sans, Bitstream Vera Sans, Verdana, Arial,
sans-serif" size="4"><span
style="line-height:14.5600004196167px"><br>
</span></font></span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande, DejaVu
Sans, Bitstream Vera Sans, Verdana, Arial,
sans-serif" size="4"><span
style="line-height:14.5600004196167px">Any
help would be greatly appreciated.</span></font></span></div>
<span class="HOEnZb"><font color="#888888">
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande,
DejaVu Sans, Bitstream Vera Sans, Verdana,
Arial, sans-serif" size="4"><span
style="line-height:14.5600004196167px"><br>
</span></font></span></div>
<div><span
style="text-align:left;background-color:rgb(255,255,255)"><font
color="#444444" face="Lucida Grande,
DejaVu Sans, Bitstream Vera Sans, Verdana,
Arial, sans-serif" size="4"><span
style="line-height:14.5600004196167px">Ashley</span></font></span></div>
</font></span></div>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
</div>
-- <br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/">http://lists.drupal.org/</a>
]</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
</body>
</html>