I would migrate it using pentaho. Then you can run cake's encryption function on the data. You could make a temporary table /model and then append it to the production table.
On Tue, May 1, 2012 at 7:01 PM, Steven Scaffidi <ssca...@gmail.com> wrote: > Thanks for the plugin that worked great. I still don't understand how > to use pentaho though to encrypt social security numbers listed in the > access database. > > On Apr 30, 5:28 pm, Justin Edwards <justinledwa...@gmail.com> wrote: > > #1http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl. > .. > > #2http://www.pentaho.com/download/ > > > > > > > > > > > > > > > > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <ssca...@gmail.com> > wrote: > > > Hi - I'm looking for information on how to encrypt data in Cakephp. My > > > employer had a client management system built in Microsoft Access, and > > > I recently took that application and put it on a web-based space built > > > in cake. I need to now two things: > > > > > #1 How can I encrypt social security numbers from new clients coming > > > into the system? I'm encrypting passwords right now, but I'm not sure > > > how to do social security numbers. > > > > > #2 How do I take social security numbers that are currently listed in > > > Microsoft Access with no encryption and put them into the MySQL > > > database encrypted? > > > > > Thanks for the help, > > > > > Steven > > > > > -- > > > Our newest site for the community: CakePHP Video Tutorials > > >http://tv.cakephp.org > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > cake-php+unsubscr...@googlegroups.com For more options, visit this > group > > > athttp://groups.google.com/group/cake-php > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
