Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By drupalize on
For example, how to import data from existing application.
If you declare profiles to be nodes and data is stored in several tables how does one import?
Comments
I don't think there's a book
I don't think there's a book specifically about converting a site to Drupal from another platform. However I did find the table references and other info in Pro Drupal Development to be useful to me in writing the necessary SQL queries to convert one of my community sites to Drupal. You can see the queries I used on my Drupal lessons link.
-- David
davidnewkerk.com | absolutecross.com
View my Drupal lessons & guides
what model did you end up using for your profile data storage
do you simply select data with your own custom queries and display on your own formatted page, or do you rely heavily on drupal to handle this via advanced_profile?
Online handbook
Probably you know, there is also drupal.org's online documentation on Migrating to Drupal, in the Getting Started section.
method to import data from sql table
do you know if one of these modules is suitable for importing, say, profile data, from an sql table?
I have installed content_profile with cck on drupal 6.
Robert
"This can be done by exporting the databases first to CSV or similar files. Tools such as phpMyAdmin for MySQL can make this task easier. You can then import these files with import/export modules such as Node Import, User Import, or CSV Parser. Note that content is often imported as Content Construction Kit (CCK) custom content types."
Re: method to import data from sql table
drupalize wrote:
>do you know if one of these modules is suitable for importing, say, profile data, from an sql table?
I have installed content_profile with cck on drupal 6.
Those modules import data into Drupal from CSV files (comma-separated values), which you can obtain from MySQL databases using phpMyAdmin.
I'm not sure but, since in your case CCK nodes are involved, I think User Import is not for this currently, and I would try CSV Parser for Drupal 6, or Node Import for Drupal 5, upgrading then the site to Drupal 6.
Also, CCK support for Node Import (Drupal 6 version) is currently under development, and probably comming soon at least partially (see the issue Port node-import to Drupal 6).
RE: Csv Parser
I read the following about CSV Parser
"CSV Parser is a FeedAPI add on that allows FeedAPI to aggregate entries from a CSV file or a zipped CSV file. Together with Feed Element Mapper"
And this will help me import my data?
:)
Rob
Re: Csv Parser
>And this will help me import my data?
It seems so. See for example this post.
RE: Csv Parser
It does say CSV Parser, in combination, somehow, with feed_mapper and feed_api, csv data can be imported
But the documentation seems to be written for the already initiated with the jargonics