<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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 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 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 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 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 href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>
-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</blockquote></div><br></div></body></html>