Solved

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

Posted on 2010-08-26
2
1,571 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
Comment Utility
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 24

Expert Comment

by:lenamtl
Comment Utility
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Welcome Friends, This is the tutorial for how to create new simple module in joomla 1.5. In the module has two important files. One is XML file and another file is PHP controller file. First you need to create the XML file. (CODE) …
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

13 Experts available now in Live!

Get 1:1 Help Now