Hi, having spent many hours searching drupal.org, without success, though I might ask here. Did lots of searchs on "Links", URLS's etc, but l found little relating to the management of external links. Modifying a site for a not-for-profit org. They have an unrelated to Drupal MySQL table of 150-200 entries relating to service organisations. The table has the name of the organisation, service offered and the organisations website URL. They would like me to put this up on their website for public access with users being able to go straight to a listed service website. Having little desire to re-type all the data, looking for a Drupal module that will manage external links, preferably with an import facility. As many of the service organisations can be quite dynamic - name changes, mergers, etc. being able to update changes without too much hassle would be an advantage. Any help would be appreciated. Thanks.
Does bulk export work on this one? Thanks. On Tue, Mar 26, 2013 at 7:46 PM, Alison <penguin@alisoncc.com> wrote:
Hi,
having spent many hours searching drupal.org, without success, though I might ask here. Did lots of searchs on "Links", URLS's etc, but l found little relating to the management of external links.
Modifying a site for a not-for-profit org. They have an unrelated to Drupal MySQL table of 150-200 entries relating to service organisations. The table has the name of the organisation, service offered and the organisations website URL. They would like me to put this up on their website for public access with users being able to go straight to a listed service website. Having little desire to re-type all the data, looking for a Drupal module that will manage external links, preferably with an import facility. As many of the service organisations can be quite dynamic - name changes, mergers, etc. being able to update changes without too much hassle would be an advantage. Any help would be appreciated. Thanks.
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Linux Registered User #383849 http://lakbaytaodev.com/ http://tdanotech.blogspot.com http://atats.blogspot.com/ http://sedemdbs.blogspot.com/
You could do an import of the data into a custom node type and use the link module. There are lots of options for importing data. If you want something that Will import updates consider the feeds module. Hope this helps. On Mar 26, 2013 9:11 PM, "tata dano" <lakbay.taodev@gmail.com> wrote:
Does bulk export work on this one? Thanks.
On Tue, Mar 26, 2013 at 7:46 PM, Alison <penguin@alisoncc.com> wrote:
Hi,
having spent many hours searching drupal.org, without success, though I might ask here. Did lots of searchs on "Links", URLS's etc, but l found little relating to the management of external links.
Modifying a site for a not-for-profit org. They have an unrelated to Drupal MySQL table of 150-200 entries relating to service organisations. The table has the name of the organisation, service offered and the organisations website URL. They would like me to put this up on their website for public access with users being able to go straight to a listed service website. Having little desire to re-type all the data, looking for a Drupal module that will manage external links, preferably with an import facility. As many of the service organisations can be quite dynamic - name changes, mergers, etc. being able to update changes without too much hassle would be an advantage. Any help would be appreciated. Thanks.
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Linux Registered User #383849 http://lakbaytaodev.com/ http://tdanotech.blogspot.com http://atats.blogspot.com/ http://sedemdbs.blogspot.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
On 27/03/13 11:11, tata dano wrote:
Modifying a site for a not-for-profit org. They have an unrelated to Drupal MySQL table of 150-200 entries relating to service organisations. The table has the name of the organisation, service offered and the organisations website URL. They would like me to put this up on their website for public access with users being able to go straight to a listed service website. Having little desire to re-type all the data, looking for a Drupal module that will manage external links, preferably with an import facility. As many of the service organisations can be quite dynamic - name changes, mergers, etc. being able to update changes without too much hassle would be an advantage. Any help would be appreciated. Thanks.
It shouldn't be too hard to describe that table to drupal and then use it just like any other drupal table. I'm pretty new to Drupal, but I suspect views might be able to report on it.
http://drupal.org/project/weblinks Nancy
________________________________ From: Alison
having spent many hours searching drupal.org, without success, though I might ask here. Did lots of searchs on "Links", URLS's etc, but l found little relating to the management of external links.
If your drupal site site can have access to the mysql table directly (doesn't need to be in the same database). This could be done pretty easily in Forena http://drupal.org/project/forena . (reporting tool). Full disclosure: I'm the module maintainer. Dave -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Alison Sent: Tuesday, March 26, 2013 7:46 PM To: support@drupal.org Subject: [support] Links Manager Hi, having spent many hours searching drupal.org, without success, though I might ask here. Did lots of searchs on "Links", URLS's etc, but l found little relating to the management of external links. Modifying a site for a not-for-profit org. They have an unrelated to Drupal MySQL table of 150-200 entries relating to service organisations. The table has the name of the organisation, service offered and the organisations website URL. They would like me to put this up on their website for public access with users being able to go straight to a listed service website. Having little desire to re-type all the data, looking for a Drupal module that will manage external links, preferably with an import facility. As many of the service organisations can be quite dynamic - name changes, mergers, etc. being able to update changes without too much hassle would be an advantage. Any help would be appreciated. Thanks. -- [ Drupal support list | http://lists.drupal.org/ ]
I think the following should be easy and probably the right way to do this unless the separate custom table is being managed by some 3rd party system a) Export existing table as a CSV file b) Create content type in Drupal with fields like you have in the table from which the data was exported c) Use node_import (http://drupal.org/project/node_import) module to import the CSV file exported in step (a) into Drupal as nodes into the content type created in step (b) d) Use views for listing out the data in the site and normal node add / edit / delete to manage existing / new data. Cheers Anoop |-- | Zyxware Technologies | http://www.zyxware.com |-- | Be the change you wish to see in the world, M. K. Gandhi |--
participants (7)
-
Alison -
Anoop John -
John Summerfield -
Metzler, David -
Ms. Nancy Wichmann -
Steve Kessler -
tata dano