Solved

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

Posted on 2010-08-26
2
1,615 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Here is a tutorial for making your own Joomla templates. Note before reading, you should have some existing knowledge of web development using HTML and CSS. Design Layout: Design your template in a graphics program like Adobe PhotoShop or Corel…
First of all, we will need Jumi component or Sourcerer plugin for this to work. We need either of these because the main focus here is custom development outside of the standard modules or articles within Joomla. You can find Jumi here...it's my …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 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