Also be sure to put set_time_limit(0); in your bootstrap.php file.
Thanks for all the help Justin.
On Wednesday, May 2, 2012 4:02:03 PM UTC-5, Justin Edwards wrote:
> You can do it in batches. You can also set the timeout.
> http://php.net/manual/en/function.set-time-limit.php
> 'conditions' => array('User.id <' => '200')
> On Wed, May 2, 2012 at 3:39 PM, Steven Scaffidi <ssca...@gmail.com> wrote:
>> 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 <
>>>> justinledwa...@gmail.com> 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<http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...>
>>>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>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 <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/**ar**ticles/jmillerdesign/2011/**12/
>>>>>>>> **29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>>>> ..
>>>>>>>> > #2http://www.pentaho.com/**downl**oad/<http://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+unsubscribe@**googlegro**ups.com<cake-php%2Bunsubscribe@googlegrou ps.com>For more options, visit this group
>>>>>>>> > > athttp://groups.google.com/**gro**up/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.organd help others with their CakePHP related questions.
>>>>>>>> To unsubscribe from this group, send email to
>>>>>>>> cake-php+unsubscribe@**googlegro**ups.com<cake-php%2Bunsubscribe@googlegrou ps.com>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
>>>>>> cake-php+unsubscribe@**googlegroups.com<cake-php%2Bunsubscribe@googlegroups .com>For more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<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 <
>>>> justinledwa...@gmail.com> 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<http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...>
>>>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>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 <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/**ar**ticles/jmillerdesign/2011/**12/
>>>>>>>> **29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>>>> ..
>>>>>>>> > #2http://www.pentaho.com/**downl**oad/<http://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
...
