The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.5 » Administration 1.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 7 posts ] 
  Print view Previous topic | Next topic 
Author Message
bigsem
PostPosted: Tue Jun 08, 2010 8:53 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 26, 2010 8:37 am
Posts: 12
Hello everybody

I need to import hundreds of weblinks to Joomla and I really don't want to add all the links separately.

Is there any way to import that from a textfile or similar? I have all the links in a whitelist.txt file. They have the form *.joomla.org..

I'm glad for any help offered.
Top
 Profile  
 
migsense
PostPosted: Wed Jun 09, 2010 12:57 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Nov 18, 2009 3:42 am
Posts: 610
Location: Panama
:) If you have a lot of web links you can drag and drop from the internet site to
dreamweaver to keep all html codes

_________________
Joomla Programmer Panama
Top
 Profile  
 
bigsem
PostPosted: Fri Jun 11, 2010 7:29 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 26, 2010 8:37 am
Posts: 12
But that's not the point. I need to import the somehow to Joomla. Is that not possible?
Top
 Profile  
 
migsense
PostPosted: Fri Jun 11, 2010 11:18 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Nov 18, 2009 3:42 am
Posts: 610
Location: Panama
:) Sure
If you have 1000 links in a webpage
you can select all links and drag it to a blank page in dreamweaver
next
select the "codes" in background and paste to any article, module, or do any that you need because you're pasting text codes (links)

Regards

_________________
Joomla Programmer Panama
Top
 Profile  
 
bigsem
PostPosted: Fri Jun 11, 2010 12:20 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 26, 2010 8:37 am
Posts: 12
In fact I will ned to sort them per departmenta and that would work perfectly with Joomla categories. I though I could write that from Excel to a MySQL database but I haven't figured out yet, how to do that.

I can get all links from my database but unfortunately I cannot add links to the excel sheet and push them back into the database table.

...ideas?
Top
 Profile  
 
glenleslie
PostPosted: Mon Apr 30, 2012 10:29 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Apr 30, 2012 10:21 pm
Posts: 2
A couple of notes in Joomla 2.5 (maybe prior too but for sure in 2.5):

I could not get the import to work in phpmyAdmin at all. The quoting from Excel -> CSV is really a pain. I did get the sqlmaestro tool, Data Wizard for mySQL to load a couple hundred URLs into the weblinks table...

1. You need to create Categories for your weblinks first and note those category IDs in the <yourprefix>_categories table (they'll have a type of com_weblinks)

2. When you create your CSV, make sure you enter the proper CATID in the <yourprefix>_weblinks table...

3. VERY IMPORTANT: MAKE SURE YOU SET ALL DATE FIELDS TO 0000-00-00 00:00:00

the date fields seem to impact whether or not you see the weblinks from the frontend. I didn't trace the query on the backend from a Weblink Category menu item to see which date is being checked.

Anyone know for sure which date is the critical one?
Top
 Profile  
 
humvee
PostPosted: Tue May 01, 2012 9:12 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 17, 2005 10:27 pm
Posts: 14709
Location: Kent, England
check out the Joomla extensions for Import, or CSV, or Excel references by searching.
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 7 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.5 » Administration 1.5

Who is online

Users browsing this forum: No registered users and 14 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group