the data i'm trying to get out is a hierarchy of companies, locations, product categories, and products. I've attempted to use the views data export module, but couldn't understand what to do with it. That is when I saw that I could create a view that was XML, and that view could utilize relationships between the data. XML is just as good for me. Now, if I can figure out what to do with the myriad of options presented to me when creating a view!!!
I like your diagram, by the way. I haven't touched those other CMSs, but the Drupal graph line...dead on! On Wed, Apr 11, 2012 at 11:17 AM, Joaquin Bravo Contreras < [email protected]> wrote: > Well, you have to take into consideration the Drupal learning curve ( > http://webchick.net/files/open-source-cms-learning-curve_0.png). 4 hours > looking at meaningless tables and relations is just part of the "fun" of > Drupal =P. > > Anyway, for what you are trying to do I would try using the > http://drupal.org/project/views_data_export module and export. CSV may be > an easier format. What data are you trying to get out of Drupal? > > - Joaquín > > > On Tuesday, April 10, 2012 1:07:58 PM UTC-5, Doug Boude wrote: >> >> Glad my pain wasn't all in vain, Bert! :) >> >> I was thinking of something more on this subject, though, while I was >> making pee pee: I never realized there was a polar opposite of genius, >> where the mind is still fully capable of engineering something that >> actually produces the desired result, but in such an ass backwards, >> convoluted, "mousetrap", anally overcomplicated way. I mean, I knew that >> there probably existed such anti-geniuses engineering the motor >> compartments of foreign cars...but they exist in software architecture, >> too! Thanks Drupal! :) >> >> On Tue, Apr 10, 2012 at 1:01 PM, Bert Grantges <[email protected]>wrote: >> >>> >>> Sorry I can't help - but wanted to thank you for that email in my inbox >>> - I've been there with Drupal an that ha me laughing out loud! >>> >>> Good luck! >>> >>> ---------------------- >>> Bert Grantges >>> >>> >>> Coming to you from my iPhone. Strange words to be expected. >>> >>> On Apr 10, 2012, at 11:59 AM, Doug Boude <[email protected]> wrote: >>> >>> Having managed to avoid dealing with any PHP-based CMS products up until >>> now, and after having spent 4 hours last night attempting to extract >>> meaningful data from a Drupal database, I am now convinced that it was >>> designed by an alien race whose idea of data normalization is exponentially >>> beyond the extreme. I'm attempting to "beam" a client's data out of Drupal >>> and into a database schema that's more human. Being no whimp when it comes >>> to SQL, I figured I'd just go in the back door, figure out how the tables >>> relate real quick, and write some extraction queries. I ended up being bent >>> over a log by Drupal and squeeling like a pig for quite a while instead. So >>> I decided I'd go through the front door and see what options existed. Such >>> a strange animal...allowing me to export views, and create multiple types >>> of views for a given page (as I understood it), but I was never able, >>> again, to extract anything meaningful. What I finally discovered though was >>> that I could create an XML view, complete with filters and relationships >>> defined between the data! "Ah, sweet jeebus!" I said to myself, "I'm almost >>> there!". But alas, I could not manage to get an XML view set up that >>> provided me the kind of hierarchical output that I envisioned and needed. >>> >>> SO...is there anybody out there who knows exactly what I'm talking about >>> who is willing to spend an hour or two helping me create the XML view(s) >>> needed for me to extract my data from this dreaded Drupal??? I'll pay. >>> >>> Please respond to me off-group if you're interested or just want to make >>> fun of me or want to weep openly with me because you've endured the same >>> demeaning experience before. >>> >>> I need to go take a long shower now. >>> >>> Doug >>> >>> -- >>> Our Web site: http://www.RefreshAustin.org/ >>> >>> You received this message because you are subscribed to the Google >>> Groups "Refresh Austin" group. >>> >>> [ Posting ] >>> To post to this group, send email to >>> Refresh-Austin@googlegroups.**com<[email protected]> >>> Job-related postings should follow http://tr.im/** >>> refreshaustinjobspolicy <http://tr.im/refreshaustinjobspolicy> >>> We do not accept job posts from recruiters. >>> >>> [ Unsubscribe ] >>> To unsubscribe from this group, send email to >>> Refresh-Austin+unsubscribe@**googlegroups.com<[email protected]> >>> >>> [ More Info ] >>> For more options, visit this group at http://groups.google.com/** >>> group/Refresh-Austin <http://groups.google.com/group/Refresh-Austin> >>> >>> -- >>> Our Web site: http://www.RefreshAustin.org/ >>> >>> You received this message because you are subscribed to the Google >>> Groups "Refresh Austin" group. >>> >>> [ Posting ] >>> To post to this group, send email to >>> Refresh-Austin@googlegroups.**com<[email protected]> >>> Job-related postings should follow http://tr.im/** >>> refreshaustinjobspolicy <http://tr.im/refreshaustinjobspolicy> >>> We do not accept job posts from recruiters. >>> >>> [ Unsubscribe ] >>> To unsubscribe from this group, send email to >>> Refresh-Austin+unsubscribe@**googlegroups.com<refresh-austin%[email protected]> >>> >>> [ More Info ] >>> For more options, visit this group at http://groups.google.com/** >>> group/Refresh-Austin <http://groups.google.com/group/Refresh-Austin> >>> >> >> -- > Our Web site: http://www.RefreshAustin.org/ > > You received this message because you are subscribed to the Google Groups > "Refresh Austin" group. > > [ Posting ] > To post to this group, send email to [email protected] > Job-related postings should follow http://tr.im/refreshaustinjobspolicy > We do not accept job posts from recruiters. > > [ Unsubscribe ] > To unsubscribe from this group, send email to > [email protected] > > [ More Info ] > For more options, visit this group at > http://groups.google.com/group/Refresh-Austin > -- Our Web site: http://www.RefreshAustin.org/ You received this message because you are subscribed to the Google Groups "Refresh Austin" group. [ Posting ] To post to this group, send email to [email protected] Job-related postings should follow http://tr.im/refreshaustinjobspolicy We do not accept job posts from recruiters. [ Unsubscribe ] To unsubscribe from this group, send email to [email protected] [ More Info ] For more options, visit this group at http://groups.google.com/group/Refresh-Austin
