Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marketingmaven
Starting Member
3 Posts |
 Posted - 2009-11-19 : 11:59:04
|
| Hello,I am a complete newbie when it comes to sql and database management. Here is what I have set up so far:I have configured a cron job to run every 30 minutes. The purpose of the PHP file that is being ran is to hit Infusionsoft (a 3rd party hosted web app I use for marketing - that stores all of my client info) and grab 22 specific fields for all of the contact records in my database.Assuming I can fetch the data by utilizing the proper API calls, I still have the problem of having no idea whatsoever as to how to map or dump that data into the table I've created on my own sql server.The table contains the exact same 22 fields. I have searched like crazy though articles and forums but haven't successfully found an answer on what I am trying to do.To slim down the details and summarize, here are the 2 things I need to do:1) Run a cron job on a specified daily schedule - DONE2) Retrieve data from Infusionsosft (22 fields) - working on this but having issues.3) Once I have the data from step 2, map it to the sql database I have created - CLUELESSOne more detail that I think is important, I have seen a lot of stuff about Create Table commands, but it is vital that I don't create new tables or fields, I need these to map to what's already there because another PHP file is based on those fields and can't be changed.Here is a link to Infusionsoft's iSDK: http://developers.infusionsoft.com/sdks/php-sdk-v1-xisdk/Please let me know if you need any additional details. I appreciate any help you can offer.Best,Jarrod~JRodhttp://imarketingmavens.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
marketingmaven
Starting Member
3 Posts |
Posted - 2009-11-19 : 12:12:32
|
Well, I am pretty certain I can grab the data via a cron job and a php script, my biggest challenge is how to map that to my sql database. Is that different than what you are speaking about? If this forum is only about Microsoft SQL Server, then yes, I may be in the wrong place. Marketing Mavenshttp://imarketingmavens.com |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 12:14:04
|
| you'll want to execute an insert statement.see here: http://www.w3schools.com/SQL/sql_insert.asp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
marketingmaven
Starting Member
3 Posts |
Posted - 2009-11-19 : 12:47:16
|
| Thanks for the help Russell. I realize now I may be in the wrong place but I am grateful to find someone knowledgeable enough to give some direction. I will look into the resource you sent.Marketing Mavenshttp://imarketingmavens.com |
|
|
|
|
|
|
|
|
PHP Cron Job to SQL Dump