Solved

How to upload an excel file to joomla

Posted on 2009-06-28
2
6,202 Views
Last Modified: 2013-12-13
I am trying to upload the contents of an excel file to my joomla website. What I am trying to do is create a local directory on my website of local businesses. however instead of just having a list of them I would like to upload a file so that each business on my excel file creates its own article. All I want the article to contain is what is on the excel file i.e. business address,phone# etc.. I know that there is most likely an extension that i will have to dl to assist me but i don't know what it would be called in order to search for one. I cannot do this manually as there are over 25k listings.

is this possible? please help!
0
Comment
Question by:Mbielaszka
2 Comments
 
LVL 1

Accepted Solution

by:
Anti-Mhz earned 250 total points
ID: 24748827
i think i can help u. However instead of .xls have excel save the file as csv (comma seperated values) as there a few existing joomla solutions that support that. The category that you might want to checkout is here:

http://extensions.joomla.org/extensions/migration-&-conversion/data-import-&-export

The solution that I used is free and its called Bulk Import:

http://extensions.joomla.org/extensions/migration-&-conversion/data-import-&-export/7243/details

Here's the feature list


"
- Import Article Title, Article Intros, Article Body, Article Title, Metadata Description, Metadata Keywords
- Configurable column mapping definition Multiple delimiters supported, including Pipe (|, reccomended) and Comma (, for CSV).
- Selectable assignment to section and category
- Use of common attributes, like Creator and Published status, applied to all articles in the upload
- Auto-creation of article alias from title if no alias is provided
- Removal of special characters to reduce the chance of parsing errors.
- Bulk Import has been tested on Joomla 1.5 for over 2000 article imports. See the demo link to see the results.
"

0
 
LVL 11

Assisted Solution

by:j-b-t
j-b-t earned 250 total points
ID: 24866487
ANother addon that could do what you want is jix - http://www.jix.com.au/index.php/download

I would actually do this differently though. I would copy your excel table - merge and format columns as you wish   eg you could add a <br /> say to the end of each cell in the name column (this is an html line break) then mergge it with eth address column so address appears underneath (generally I woudl vene add in html tags like <P> etc).

Then I woudl use a program like navicat  [www.navicat.com] - go into yoru joomla database and import into jos_content from yoru excel table - you will however need to add columns for title and section and category etc.

Not sure if this is the slow way - but that's how I would do it - obvously  back up first - I imagine it is still a few hours work but should be quite acheivable
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article, we will look at our content management system as a whole, to get an idea of how we will start to manage these content items.
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now