Solved

Joomla + CSV/XLS Import (Table Creation+Search)

Posted on 2010-08-26
2
1,600 Views
Last Modified: 2012-08-14
Can someone help me with a solution for importing data into Joomla. More specifically data of XLS/CSV files. My task is to create a company intranet ,  a inventory database contraining xls, csv files. Having used Sharepoint 3.0 in the past we were able to create sortable tables with custom headers. My task is to recreate something similar using Joomla as a backbone. If such a solution exists I'd also need a custom search of some kind (search specific inventories/search all,search part of the word, search exact), ability to display results in different tabs or same page sorrted via inventory names.

Once again Im not looking for anyone to code the solution for me or do I expect an extension that will take care of all this tasks.  Some discussion and tips would be nice.  I kinda expect that I'm do a hack job on some existing scripts.
0
Comment
Question by:Anti-Mhz
2 Comments
 
LVL 9

Accepted Solution

by:
Snarfles earned 250 total points
ID: 33532623
Mmm I'm not sure that there is anything out there that will just allow that.

I am assuming you have already searched http://extensions.joomla.org for something like that?

I would probably code my own component for this.

Check out the Joomla MVC model http://docs.joomla.org/Developing_a_Model-View-Controller_Component_-_Part_1 which will give you some background on how to build a component. When I first went through this it took about a day to get my head around it and get my component fully built so it doesn't take that long.

You will want to just provide a form with a file upload box that allows the xls/cvs file and then use a process file to extract the info you require and insert that into some custom database tables. From there it should be fairly easy to generate a frontend grid with this data.
0
 
LVL 25

Expert Comment

by:lenamtl
ID: 33549499
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Joomla Redirect 9 145
Add data page to Joomla 1 305
[JOOMLA] Unable to connect to the back office 1 256
How do I publish in Joomla? 9 30
This is our step by step to setting up and configuring a Joomla Install on a Windows 2003 Server. This is the perfect solution for an Intranet Website using Joomla. What you need (only use the following versions) : A fresh copy of Joomla http…
Have you ever wanted to use that sweet jQuery gallery plugin on your Joomla site but couldn't get it working due to jQuery conflicts or your lack of knowledge about what's under the Joomla hood? This article will step you through the process of impl…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

777 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