The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.5 » General Questions/New to Joomla! 1.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 14 posts ] 
  Print view Previous topic | Next topic 
Author Message
naeemdal
PostPosted: Wed May 16, 2012 2:08 pm 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
I am looking for an inventory/warehouse management extension for an organization, having 10 branch offices and i have to enter their inventory i tried weberp and inventory locator but its useful can some one plz suggest or find me? i did googling alot:(

Thanks in advance

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Sat May 19, 2012 4:18 am 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
Can you explain the data you need to store and how you use it? There may be a more generic extension that you can customize to fit your needs.

Let me know.

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
naeemdal
PostPosted: Sat May 19, 2012 4:56 am 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
wlrdq thank you so much for your reply, i am employee of a NGO, having 10 field offices, i need to enter their inventory database like:

for instance field office 1 include below inventory information, and same for the other.
Inventory tag or code
Chairs (number of chairs, condition, color, etc)
tables
pc
Laptops
stationary etc
blah
blah

I need an extension which store above information, i worked on joomD but did not fulfill, can you please help me?

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Sat May 19, 2012 8:56 am 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
Do all offices have the same inventory? It seems like it could be represented by a spreadsheet or single MySQL table. Something like:
Code:
Office   # chairs    chair color     ...
#1       14          red
#2       12          blue
#3       35          green
...


Or do you need it where you declare the types of inventory items that offices will be reporting and then you have entries for each office? That's more complex, but there still may be a generic extension out there that does something similar.

Have you looked at extensions like Sobi2?
http://extensions.joomla.org/extensions/directory-a-documentation/directory/1113

Let me know what you think.

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
naeemdal
PostPosted: Sat May 19, 2012 11:11 am 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
i attached a sample excel format of 1 field office, i added few record, kindly check and then suggest me extension?
thanks for your kind help :) deeply appreciated


You do not have the required permissions to view the files attached to this post.

_________________
Regards
Top
 Profile  
 
naeemdal
PostPosted: Sat May 19, 2012 11:14 am 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
each admin officer from the field station will be responsible for updating their inventory online, i am bit confuse regarding this :S job in danger :(

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Sun May 20, 2012 12:25 pm 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
Are there requirements for how the user interface should look/work or at this point do you just need something in place? Would you prefer it to be like a spreadsheet or more like a table and form (like users, articles, etc in the Joomla! backend)?

If each admin officer can update their own inventory, are they allowed to view other office inventories? Can they update them?

I would look at SOBI2 and see if it would work for you:
http://www.sigsiu.net/manual/chapter_1_introduction/what_is_sobi2.html

You can create categories (in your case, you may just have one called asset). And then you can create fields for that category (in your case: date of purchase, donor's name, etc). Then users can enter (and I assume edit) instances of your category. I don't know how well it handles user access and limiting certain data to certain users. If that's something you need, there still may be ways to do it with SOBI2.

If you just want a spreadsheet, I assume you could create a Google Doc spreadsheet (https://docs.google.com/) and embed that in an article on your website or something.

Let me know what you are thinking.

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
naeemdal
PostPosted: Sun May 20, 2012 3:41 pm 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
Thanks for your kind help, is any component like spreadsheet? i think i should give a try to sobi2 else i will try to find a component like spreadsheet, because i also want to export in excel on the monthly bases. Are you familiar with any component like spreadsheet? because embedding googles spreadsheet is not a solid solution, any way thank you so much :)

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Sun May 20, 2012 7:27 pm 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
I haven't used it, but this was the first thing that popped up when I searched:
http://extensions.joomla.org/extensions/core-enhancements/data-reports/13634

If you end up using it, let me know what you think. If it's good, I could see using it for other applications as well.

Thanks

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
naeemdal
PostPosted: Mon May 21, 2012 1:49 pm 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
I installed Jgrid free version, which contain only limited features which are useless for me and pro include more useful features, I also worked on sobi2 which is bit useful but i am unable to export data into excel, plugin of exporting data into excel is premium, company will not pay me a single penny, so cant purchase both extensions :S so i surrender . I wish i could final this tonight hmph.

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Mon May 21, 2012 2:10 pm 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
Everything in Joomla! is stored in a MySql database. I'm guessing, you could use mysqldump to dump your SOBI2 data to a CSV file that Excel can then import.

Let me know if you think that would be a good solution.

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
naeemdal
PostPosted: Tue May 22, 2012 7:50 am 
Joomla! Intern
Joomla! Intern

Joined: Tue Nov 16, 2010 1:45 pm
Posts: 50
Location: hyderabad
hey bro I have installed Event table edit component but i don't like the export system, because i am for Vehicle logbook entries, at 10 field stations and the number of vehicles are almost 70 , the thing is that it export into text field when i copy and paste into excel it shows me data into one column of excel, although i created columns in event list, now its really hard to use this extension, is any way to export data column wise into csv format so it would be easy for us to analysis data. or any other extension which export Event table edit database into excel? iam not good with SQL queries etc. here is link of component: http://extensions.joomla.org/extensions ... ement/2433

_________________
Regards
Top
 Profile  
 
wlrdq
PostPosted: Tue May 22, 2012 1:01 pm 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Thu Jul 24, 2008 12:48 pm
Posts: 2678
Location: Austin, TX
Do you have access to phpMyAdmin? Most hosting providers have it available.

You can export data with it pretty easily. It has a graphical interface that can help you with the queries. If not, I can help come up with the query that will dump exactly what you want. Here's a post on how to export data:
http://stackoverflow.com/questions/1802410/how-to-export-a-single-table-from-phpmyadmin-to-a-comma-delimited-text-file

Let me know what you find.

_________________
Will Mavis - Joomla Developer
http://www.covertapps.com/jam <<< Joomla! on your Android, iPhone, iPad, and iPod Touch
If you think I can help you, PM me a link to your post and I will respond. Please don't hijack another user's thread.
Top
 Profile  
 
HarryLee
PostPosted: Sat Jun 08, 2013 6:24 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Jun 08, 2013 5:56 am
Posts: 1
Location: India
Yes the given thread is really informative for my inventory/warehouse management and I always find such kind of informative thread. I hope you will keep to share more info here.
http://www.yfsindia.com/inventory-management
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 14 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.5 » General Questions/New to Joomla! 1.5

Who is online

Users browsing this forum: No registered users and 19 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group