I created SSN through using regular sql and just literally copying whats in
the ssn field to the ssn_temp field. And then, this would work if it didn't
time out on me. How can I change the timeout time? There has to be a better
way to do this though.
public function encryptssn() {
$ssns = $this->User->find('list', array('fields' => array('id',
'ssn_temp')));
$j = 1;
foreach ($ssns as $i) {
$this->User->id = $j;
$this->User->saveField('ssn', $i);
$j++;
}
$this->redirect(array('action' => 'index'));
}
On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:
>
> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:
>
> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));
>
> Would something like that work? I'm really confused by the documentation
> on saveMany
>
> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:
>>
>> Sorry temp table* not temp folder
>>
>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards
>> <[email protected]>wrote:
>>
>>> Steven,
>>>
>>> Create a controller method.
>>>
>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.
>>>
>>>
>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-savemany-array-data-null-array-options-array
>>>
>>>
>>>
>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <[email protected]>wrote:
>>>
>>>> Ok I have the data migrated already (I probably should have used
>>>> something like pentaho instead of writing my own queries but oh well). How
>>>> do I use cake's encryption function on the data?
>>>>
>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:
>>>>>
>>>>> 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 <[email protected]>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 <[email protected]> wrote:
>>>>>> > #1http://bakery.cakephp.org/**articles/jmillerdesign/2011/**
>>>>>> 12/29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>> ..
>>>>>> > #2http://www.pentaho.com/**download/<http://www.pentaho.com/download/>
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <[email protected]>
>>>>>> 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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> > > more options, visit this group
>>>>>> > > athttp://groups.google.com/**group/cake-php<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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<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
>>>> [email protected] For more options, visit this
>>>> group at http://groups.google.com/group/cake-php
>>>>
>>>
>>>
>>
On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:
>
> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:
>
> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));
>
> Would something like that work? I'm really confused by the documentation
> on saveMany
>
> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:
>>
>> Sorry temp table* not temp folder
>>
>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards
>> <[email protected]>wrote:
>>
>>> Steven,
>>>
>>> Create a controller method.
>>>
>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.
>>>
>>>
>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-savemany-array-data-null-array-options-array
>>>
>>>
>>>
>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <[email protected]>wrote:
>>>
>>>> Ok I have the data migrated already (I probably should have used
>>>> something like pentaho instead of writing my own queries but oh well). How
>>>> do I use cake's encryption function on the data?
>>>>
>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:
>>>>>
>>>>> 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 <[email protected]>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 <[email protected]> wrote:
>>>>>> > #1http://bakery.cakephp.org/**articles/jmillerdesign/2011/**
>>>>>> 12/29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>> ..
>>>>>> > #2http://www.pentaho.com/**download/<http://www.pentaho.com/download/>
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <[email protected]>
>>>>>> 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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> > > more options, visit this group
>>>>>> > > athttp://groups.google.com/**group/cake-php<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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<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
>>>> [email protected] For more options, visit this
>>>> group at http://groups.google.com/group/cake-php
>>>>
>>>
>>>
>>
On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:
>
> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:
>
> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));
>
> Would something like that work? I'm really confused by the documentation
> on saveMany
>
> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:
>>
>> Sorry temp table* not temp folder
>>
>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards
>> <[email protected]>wrote:
>>
>>> Steven,
>>>
>>> Create a controller method.
>>>
>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.
>>>
>>>
>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-savemany-array-data-null-array-options-array
>>>
>>>
>>>
>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <[email protected]>wrote:
>>>
>>>> Ok I have the data migrated already (I probably should have used
>>>> something like pentaho instead of writing my own queries but oh well). How
>>>> do I use cake's encryption function on the data?
>>>>
>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:
>>>>>
>>>>> 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 <[email protected]>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 <[email protected]> wrote:
>>>>>> > #1http://bakery.cakephp.org/**articles/jmillerdesign/2011/**
>>>>>> 12/29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>> ..
>>>>>> > #2http://www.pentaho.com/**download/<http://www.pentaho.com/download/>
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <[email protected]>
>>>>>> 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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> > > more options, visit this group
>>>>>> > > athttp://groups.google.com/**group/cake-php<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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<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
>>>> [email protected] For more options, visit this
>>>> group at http://groups.google.com/group/cake-php
>>>>
>>>
>>>
>>
On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:
>
> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:
>
> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));
>
> Would something like that work? I'm really confused by the documentation
> on saveMany
>
> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:
>>
>> Sorry temp table* not temp folder
>>
>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards
>> <[email protected]>wrote:
>>
>>> Steven,
>>>
>>> Create a controller method.
>>>
>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.
>>>
>>>
>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-savemany-array-data-null-array-options-array
>>>
>>>
>>>
>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <[email protected]>wrote:
>>>
>>>> Ok I have the data migrated already (I probably should have used
>>>> something like pentaho instead of writing my own queries but oh well). How
>>>> do I use cake's encryption function on the data?
>>>>
>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:
>>>>>
>>>>> 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 <[email protected]>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 <[email protected]> wrote:
>>>>>> > #1http://bakery.cakephp.org/**articles/jmillerdesign/2011/**
>>>>>> 12/29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>> ..
>>>>>> > #2http://www.pentaho.com/**download/<http://www.pentaho.com/download/>
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <[email protected]>
>>>>>> 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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> > > more options, visit this group
>>>>>> > > athttp://groups.google.com/**group/cake-php<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+unsubscribe@**googlegroups.com<cake-php%[email protected]>For
>>>>>> more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<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
>>>> [email protected] 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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
