Re: Import Script Help Please
If you put the data into the array before you do your save, Cake does the magic under the covers to figure out if the record exists already or not. When you do the save, Cake does a lookup to figure out if the request needs to be an insert or delete (assuming you have the constraints set properly). I would expect that whether you can take advantage of this is entirely dependent on the data you are getting sent. If your customer information includes a unique key, then you should be able to use that as your ID, and Cake will automagically do an insert or update. If it doesn't give you a primary key, you'll need to do a lookup and figure out if you want to do the insert yourself anyway. On Dec 25, 2:37 pm, Chad Casselman ccassel...@gmail.com wrote: Let's see if I can explain this better. I have the models setup correctly or so I think - new to all of this. But I am getting lots of information posted from an external source so let's say field1, field2, field3, etc. etc. Fields 1-10 are customer information Fields 11-15 are product information Fields 16-20 are order information I need a script the can accepted the above fields, but the catch is for me to check to see if the customer exists, if not add it. Then check to see if the product exists, if not add it, then the same with the order. I don't understand how the current magic save stuff works - because it is all hidden from me. I need to see it working to understand it, but most examples just say use it. I am not using it the typical way so without understanding it, I am struggling to create the script to accept the posted information. Does that help or hurt? Chad On Thu, Dec 25, 2008 at 3:02 PM, Webweave webwe...@gmail.com wrote: So are you saying you're getting data posted to you somehow that isn't related to the tables you outlined? I'm not clear on whet you mean by I can't control the name of the fields coming in, but it sounds like you have the basic idea. Cake should handle the magic for you as long as you build the table structure, model and relationships properly. All you need to do is build the Model structure into $this-data, and do a saveAll (or save for each bit you are interested in). There are lots of examples on how to do this floating around. On Dec 23, 8:11 am, Chad Casselman ccassel...@gmail.com wrote: Very new to cakePHP and of course the first thing I try doesn't follow the model. I am trying to create a script which takes a lot of post variables (from 1shoppingcart exactly) and then puts them in the corresponding values in my database design. Let's say my database is: customers customers_products products I haven't figured out exactly how to do the associations but that is not my hang up right now. I can't control the name of the fields coming in, but I need for the save/post to go through the data and put the customer info into the customer table (always new inserts), then go through the product information (unknown count) (product1name, product2name, etc) and put them in the product table (record of source) if they do not exist and then connect the customer to the products that they ordered. I am completely stumped on how to even tackle processing form information that was not generated by cake. Chad --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com 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?hl=en -~--~~~~--~~--~--~---
Re: Import Script Help Please
So are you saying you're getting data posted to you somehow that isn't related to the tables you outlined? I'm not clear on whet you mean by I can't control the name of the fields coming in, but it sounds like you have the basic idea. Cake should handle the magic for you as long as you build the table structure, model and relationships properly. All you need to do is build the Model structure into $this-data, and do a saveAll (or save for each bit you are interested in). There are lots of examples on how to do this floating around. On Dec 23, 8:11 am, Chad Casselman ccassel...@gmail.com wrote: Very new to cakePHP and of course the first thing I try doesn't follow the model. I am trying to create a script which takes a lot of post variables (from 1shoppingcart exactly) and then puts them in the corresponding values in my database design. Let's say my database is: customers customers_products products I haven't figured out exactly how to do the associations but that is not my hang up right now. I can't control the name of the fields coming in, but I need for the save/post to go through the data and put the customer info into the customer table (always new inserts), then go through the product information (unknown count) (product1name, product2name, etc) and put them in the product table (record of source) if they do not exist and then connect the customer to the products that they ordered. I am completely stumped on how to even tackle processing form information that was not generated by cake. Chad --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com 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?hl=en -~--~~~~--~~--~--~---
Re: Import Script Help Please
Let's see if I can explain this better. I have the models setup correctly or so I think - new to all of this. But I am getting lots of information posted from an external source so let's say field1, field2, field3, etc. etc. Fields 1-10 are customer information Fields 11-15 are product information Fields 16-20 are order information I need a script the can accepted the above fields, but the catch is for me to check to see if the customer exists, if not add it. Then check to see if the product exists, if not add it, then the same with the order. I don't understand how the current magic save stuff works - because it is all hidden from me. I need to see it working to understand it, but most examples just say use it. I am not using it the typical way so without understanding it, I am struggling to create the script to accept the posted information. Does that help or hurt? Chad On Thu, Dec 25, 2008 at 3:02 PM, Webweave webwe...@gmail.com wrote: So are you saying you're getting data posted to you somehow that isn't related to the tables you outlined? I'm not clear on whet you mean by I can't control the name of the fields coming in, but it sounds like you have the basic idea. Cake should handle the magic for you as long as you build the table structure, model and relationships properly. All you need to do is build the Model structure into $this-data, and do a saveAll (or save for each bit you are interested in). There are lots of examples on how to do this floating around. On Dec 23, 8:11 am, Chad Casselman ccassel...@gmail.com wrote: Very new to cakePHP and of course the first thing I try doesn't follow the model. I am trying to create a script which takes a lot of post variables (from 1shoppingcart exactly) and then puts them in the corresponding values in my database design. Let's say my database is: customers customers_products products I haven't figured out exactly how to do the associations but that is not my hang up right now. I can't control the name of the fields coming in, but I need for the save/post to go through the data and put the customer info into the customer table (always new inserts), then go through the product information (unknown count) (product1name, product2name, etc) and put them in the product table (record of source) if they do not exist and then connect the customer to the products that they ordered. I am completely stumped on how to even tackle processing form information that was not generated by cake. Chad --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com 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?hl=en -~--~~~~--~~--~--~---
Import Script Help Please
Very new to cakePHP and of course the first thing I try doesn't follow the model. I am trying to create a script which takes a lot of post variables (from 1shoppingcart exactly) and then puts them in the corresponding values in my database design. Let's say my database is: customers customers_products products I haven't figured out exactly how to do the associations but that is not my hang up right now. I can't control the name of the fields coming in, but I need for the save/post to go through the data and put the customer info into the customer table (always new inserts), then go through the product information (unknown count) (product1name, product2name, etc) and put them in the product table (record of source) if they do not exist and then connect the customer to the products that they ordered. I am completely stumped on how to even tackle processing form information that was not generated by cake. Chad --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com 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?hl=en -~--~~~~--~~--~--~---