A "heirarchy" suggests to me that this isn't only node data. How it's stored in the db depends on what kind of data it is. Is this Drupal 6? When you log in to the site (as admin) and view the Content Types, is there one that represents a single instance of what you are exporting? For example, a Company with fields (look at manage fields) that represent address and products and such?
If so, then you are exporting node data and the CCK fields. If not, look at the Taxonomy lists. If what you are trying to export are the taxonomy associations to nodes, that'll be more complicated. You can write a script to do either and save it to a csv, but yes, that's not a quick thing ;-) The migrate module migrates into Drupal but the code might help you. This is assuming you can't just create a feed. If the data is only a node, I think that's the path to stay on. Diana -- typed with my thumbs On Apr 11, 2012, at 1:05 PM, Doug Boude <[email protected]> wrote: > Joaquin, yes, as I understand nodes (which isn't very well), those are all > node types. The client was using a module called cck or ckk or something like > that to allow them to create new node types, fields, and relationships > between the data. > > Tim, that would be awesome! Please do connect me with your expert friend! > > On Wed, Apr 11, 2012 at 12:41 PM, Tim Ziegler <[email protected]> wrote: > One great way to do this is to set up an RSS feed of all your site content > and then used various Feeds modules to use logic to basically translate all > the fields from the old site into fields on the new site and save each post > as a new node, including all its content, author, meta data, etc. > > The Feeds modules are now very sophisticated, let you use a variety of > methods like regular expressions, or even CSS selectors from the old site, to > parse the content and translate to the new fields. > > I know someone in town who is a pro at this if you want a contact. > > On Wed, Apr 11, 2012 at 12:25 PM, Joaquin Bravo Contreras > <[email protected]> wrote: > Those companies, locations, categories and products... are all node types? > > > On Wed, Apr 11, 2012 at 11:32 AM, Doug Boude <[email protected]> wrote: > 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 [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 > > -- > 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 > > -- > 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 > > -- > 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
