You are here

README.txt in Feeds SQL 7

FEEDS SQL
=========

Adds SQL options to the FEEDS import and aggregation framework for Drupal.
http://drupal.org/project/feeds_sql

Features
========

- Adds SQL options to the Feeds module UI, to enable importing data
  from external databases. 
- Imports nodes, taxonomy, and users.


Requirements
============

- Feeds
  http://drupal.org/project/feeds
- Drupal 7.x
  http://drupal.org/project/drupal

Installation and Quick start
============================

- Install Feeds SQL and enable it
- Add custom database to settings.php
- In Admin interface -> Goto Feeds IU (admin/structure/feeds)
- Click tab "New importer"
- Fill out as needed, click "create"
- Configuration:
  - Basic -> Setting:
             Choose appropriate in "attach to content type"
             ("standalone form" might be the best option)
             Choose appropriate for cron settings
  - Fetcher -> Change: Choose "SQL Fetcher", click save.
    Fetcher -> Settings: Choose your source database(s) (the one(s) you added to
                         settings.php earlier), click save.
  - Parser -> Change: Choose "SQL Parser", click save.
    Parser -> Settings: Use this area to pre-fetch your intended query. This
              will allow you to test the query itself and to populate the
              mapping array. You will see the results of the query after saving.

  Now configure the Processor settings, e.g. for "node", choose the appropriate 
  content type, and map the fields appropriately at Processor -> Mapping.

  Next, you can go to "http://example.com/import", the new importer should be available.
  Enter your final query, choose your database, and click "import".

File

README.txt
View source
  1. FEEDS SQL
  2. =========
  3. Adds SQL options to the FEEDS import and aggregation framework for Drupal.
  4. http://drupal.org/project/feeds_sql
  5. Features
  6. ========
  7. - Adds SQL options to the Feeds module UI, to enable importing data
  8. from external databases.
  9. - Imports nodes, taxonomy, and users.
  10. Requirements
  11. ============
  12. - Feeds
  13. http://drupal.org/project/feeds
  14. - Drupal 7.x
  15. http://drupal.org/project/drupal
  16. Installation and Quick start
  17. ============================
  18. - Install Feeds SQL and enable it
  19. - Add custom database to settings.php
  20. - In Admin interface -> Goto Feeds IU (admin/structure/feeds)
  21. - Click tab "New importer"
  22. - Fill out as needed, click "create"
  23. - Configuration:
  24. - Basic -> Setting:
  25. Choose appropriate in "attach to content type"
  26. ("standalone form" might be the best option)
  27. Choose appropriate for cron settings
  28. - Fetcher -> Change: Choose "SQL Fetcher", click save.
  29. Fetcher -> Settings: Choose your source database(s) (the one(s) you added to
  30. settings.php earlier), click save.
  31. - Parser -> Change: Choose "SQL Parser", click save.
  32. Parser -> Settings: Use this area to pre-fetch your intended query. This
  33. will allow you to test the query itself and to populate the
  34. mapping array. You will see the results of the query after saving.
  35. Now configure the Processor settings, e.g. for "node", choose the appropriate
  36. content type, and map the fields appropriately at Processor -> Mapping.
  37. Next, you can go to "http://example.com/import", the new importer should be available.
  38. Enter your final query, choose your database, and click "import".