Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Excel into links

Quote Reply
Excel into links
I have a relatively simple excel document that I would like to import into links. I have searched here and found some posts, but to be honest they confuse the heck outta me :(

In any event, I have a spreadsheet with three rows:
ROW 1: Category Name
ROW 2: Link Name
ROW 3: Link Description (in html, uses only the <br> tag to seperate lines

I know this isn't exactly the intended use of links, but I want to use it as more of a CMS then what it was actually intended to be used for. My entries above are all articles. Both row 1 and row 2 contain a number of duplicates, but I wouldn't want to to create say 'category 1' 15 times if it's duplicated 15 times, just once of course.
Is there a way to easily do this?
Thanks!
Quote Reply
Re: [ibold] Excel into links In reply to
Hi,

Have you considered exporting it in CSV or tab-delimited format from Excel? This would put it something like;

Code:
Category Name Link Name Link Description

..and then use my Data_Import plugin to import them into GLinks.

Hope that helps Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Excel into links In reply to
This sounds like exactly what I need.
I went through the list of plugins and couldn't seem to find a Data_Import one. Where can I find it?
Thanks!

Quote Reply
Re: [ibold] Excel into links In reply to
And ignore that, just saw the link in your sig :)