Solved

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

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

Expert Comment

by:lenamtl
ID: 33549499
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the following article I will try to explain some of the issues I had learning Joomla and I hope this helps all of you beginners out there that love the concept but find it confusing and difficult to manage and configure a Joomla website. Like …
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…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

937 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

7 Experts available now in Live!

Get 1:1 Help Now