Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By stuartgoff on
I have looked around and the only thing that looks like it might work is the Import/Export Module. But let me explain;
This is for some BI for our business. I want to be able to pull info from our software provider that can provide our finacial info in xml format (protected.) (Current bookings, by day, type, and other info.) I would like to get this info dynamically no need to store in our DB as this is the reponsibility of our provider. Plus it can and will change frequently. Once this info is accessed I would like to aggregate it to show revenue by day. by website or by month. This would be in a dashboard type presentation. Other than the Import/Expot module I was looking at Jasper Reports (There's a module that integrates into drupal) anyone know 'bout that?
Example:
<ItineraryItem ResID="100" ResItemID="1" ItineraryID="1000" ItineraryItemID="x" ResDate="02/08/2007" ArrivalDate="03/12/2007" DepartureDate="03/12/2007" SupplierID="xxxxxxx" SupplierName="DMR Ski School" SalesID="xxxxxxx" ResellerName="Gateway Reservations" OriginalAmount="87" Amount="87" TaxesFees="0" RateType="Commissionable" ProductID="10" ProductName="1 Day - Next X Snowboard Camp: Full Day - 9:30am - 3:30pm" CategoryID="128" CategoryName="Ski/Snowboard School" Quantity="1" AdultCount="1" ChildCount="0" Days="0" TravelAgentID="0" TravelAgentName="*All" Customer="xxxxxxxx, Jesse" Address="PO Box 1xxx" City="Fort Worth" Region="TX" PostalCode="76136" Country="US" HomePhone="x-xxx-xxx-xxxx" Package="Durango Mountain Resort: Winter Ski Package" PackageSupplier="Gateway Reservations" />
Thanks for any ideas.
Stuart
Comments
module creation
Personally, I would write a module to handle this, likely using SimpleXML for the parsing.
Quick overview:
1) Define URLs (in Drupal, "menu callbacks") that display the data you want.
2) When the URL is accessed, send a CURL or HTTP / XML request for the data.
3) Process the data with SimpleXML or a parser of your choice.
4) Cache the processed data in Drupal (no need to hit the server every time). See get_cache() and set_cache().
5) Display the data using Drupal themes.
To get advanced, you could create nodes that display the data, but don't allow edits of the data. This approach would allow commenting, rating, etc.
The key is being able to predict what content goes with what page. The home page of your module might send a general XML request that creates a list of links to other content.
See, for example http://wonkzone.com/legisa/chamber/senate, which calls a REST interface to get legislative data. If the links on that page say "node/###' then the data has already been moved intoi Drupal. If they say something like http://wonkzone.com/legisa/legislator/4465, this is a predictive link that will activate the XML parser.
You can also use XML-RPC, I believe, but I don't know how that works, so I use HTTP methods.
--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.
What about grouper?
Grouper converts XML data to RSS.
You can check it out on their website.
geckotribe.com