<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>If the real point is proof-of-concept that Drupal can handle this, then just copy the table into the Drupal database where you can access it like any other table. You can easily explain that it is not up-to-date at the moment because you are still in test. As the testing goes on, it can be refreshed at any point with a simple export/import. If you get a go-ahead nod, then import it one last time and turn the old application off.<BR> </DIV>
<P><FONT face="bookman old style, new york, times, serif" color=#ff007f size=4><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Christopher M. Jones <cjones@partialflow.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> consulting@drupal.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wed, November 17, 2010 11:04:16 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [consulting] Approaches for retrieving external site's data<BR></FONT><BR>Don't use FeedAPI, if you choose to go the feeds route. Use Feeds, its <BR>successor. This opens up a whole new line of possibilities for you, as <BR>you can combine Feeds.module with Data.module. Feeds.module will import <BR>your data into custom tables. Data.module will surface those tables and <BR>expose the data to views.<BR><BR>Whatever you do, I wouldn't mess with the external database connection. <BR>Aside from the security risk, it could be very messy.<BR><BR>Yet another alternative would be to implement an XMLRPC webservice on <BR>your non Drupal
site and let Drupal consume it. This would provide the <BR>ability for authentication. (Drupal does not, to my knowledge, have any <BR>ability to handle password protected feeds. Someone correct me if I'm <BR>wrong).<BR><BR>On 11/17/2010 06:12 AM, Victor Kane wrote:<BR>> The migrate module http://drupal.org/project/migrate was designed for<BR>> this kind of problem and is a joy to work with. Depends on a few other<BR>> modules, but one of the end results is that if you can get it onto a<BR>> MySql database, you can work to get views going with it! Etc. etc.<BR>><BR>> Victor Kane<BR>> http://awebfactory.com.ar<BR>><BR>> 2010/11/17 Alfonso Montero López <<A href="mailto:amontero@tinet.org" ymailto="mailto:amontero@tinet.org">amontero@tinet.org</A><BR>> <mailto:<A href="mailto:amontero@tinet.org" ymailto="mailto:amontero@tinet.org">amontero@tinet.org</A>>><BR>><BR>> Hi
listers.<BR>><BR>> I have recently got in charge of a non-Drupal website and I need some<BR>> advice in approaching an issue.<BR>> The site is about listing learning centers along their training<BR>> courses and allowing users to request more info by filling a form. No<BR>> big deal here. You fill the form, data gets dumped into a table and<BR>> the webmaster (me) receives a mail.<BR>> All the subsequent workflow is done more or less manually on the table<BR>> that gets the information requests. However, it's a custom coded PHP<BR>> site and expanding or trying to automate the workflow any further<BR>> seems not worth the investment as in its current state, it's kind of a<BR>> mess. I think it's a good Drupal candidate.<BR>> The problem is that the website
cannot be replaced quickly enough<BR>> because of its design and look that I'm not able to translate to<BR>> Drupal. By now, no budget will be allocated to theming and<BR>> consequently I can't port it to Drupal. Since Drupal still has to<BR>> prove its worth in the eyes of decision makers. A site rebuild with<BR>> Drupal from scratch is not [now] an option, since management thinks<BR>> "hey! we've invested >6 mo and blahblahblah". I would like to shift<BR>> this by creating an extranet to show what can be done and get some<BR>> serious attention upstairs :)<BR>><BR>> What I'm figuring out how to accomplish is to create a<BR>> non-public-facing extranet for the learning centers built with Drupal,<BR>> so I can use nodes to get info requests, route them according
my<BR>> workflow and do all the fancy stuff that Drupal can do with rules,<BR>> views, etc. This extranet would be used initially by us and later by<BR>> our customers (the learning centers) and not by site visitors, they<BR>> should only fill the form in the website exactly as they're doing now.<BR>> The missing gap is in how to move data from the custom app table to<BR>> Drupal. Thus, I'll be able to do automatic mails, route leads from one<BR>> user/departments to another, do reports with views, etc.<BR>><BR>> So, here I am thinking in how to approach this one the right way. I've<BR>> thought in installing a Drupal alongside the current website, so I can<BR>> access the site's MySQL DB from Drupal and someway and import the<BR>> records periodically into nodes, but for
hosting limitations, it's not<BR>> possible now.<BR>><BR>> The solutions I found are these:<BR>> *Connecting remotely to MySQL via port 3306 and load new leads. Has<BR>> firewall issues and may not be supported by all hostings all the time.<BR>> Also, seems to require quite some programming effort and still have to<BR>> test Data module capabilities. As long as I can see, data will not be<BR>> nodes, so I will lose all future workflow, rules, etc. capabilities,<BR>> right?<BR>> *Create a [password-protected] RSS feed script for the source site and<BR>> fetch the leads from it to the Drupal extranet via FeedAPI and alikes.<BR>> By now, it's the most elegant solution I've found. I assume that<BR>> FeedAPI won't have problems if I periodically empty the source
site<BR>> leads table and it will gracefully catch up.<BR>> *(All and every single alternatives are welcome here)<BR>><BR>> Obviously, when the extranet is finished and working, I plan to move<BR>> all to a fully Drupal site and make it hit the front page.<BR>> BTW, planning to do it in D6.x.<BR>><BR>> So, previous experiences and caveats will be very welcomed. I'm sure<BR>> awesome ideas from the listers here will come up. I learnt a lot by<BR>> lurking here and in devel during 3 years.<BR>> Thanks in advance.<BR>><BR>> Alfonso.<BR>> _______________________________________________<BR>> consulting mailing list<BR>> <A href="mailto:consulting@drupal.org" ymailto="mailto:consulting@drupal.org">consulting@drupal.org</A> <mailto:<A
href="mailto:consulting@drupal.org" ymailto="mailto:consulting@drupal.org">consulting@drupal.org</A>><BR>> http://lists.drupal.org/mailman/listinfo/consulting<BR>><BR>><BR>><BR>><BR>> _______________________________________________<BR>> consulting mailing list<BR>> <A href="mailto:consulting@drupal.org" ymailto="mailto:consulting@drupal.org">consulting@drupal.org</A><BR>> <A href="http://lists.drupal.org/mailman/listinfo/consulting" target=_blank>http://lists.drupal.org/mailman/listinfo/consulting</A><BR>_______________________________________________<BR>consulting mailing list<BR><A href="mailto:consulting@drupal.org" ymailto="mailto:consulting@drupal.org">consulting@drupal.org</A><BR><A href="http://lists.drupal.org/mailman/listinfo/consulting" target=_blank>http://lists.drupal.org/mailman/listinfo/consulting</A><BR></DIV></DIV></div></body></html>