- About the import from CSV
You may try this script to help you: http://www.hotscripts.com/Detailed/18098.html
(but you'll still need knowledge of the tables from the documentation)
- About printers:
Inventory's concept is that you can attach hardware to 3 objects: computers, locations and users.
> With computers it's clear: installed hardware inside a computer, or attached hardware like a monitor fits here (and that's the most intuitive)
> With users - you can assign hardware like usb-drive, PDA, cell-phone etc - which is more personal, and not attached to a computer all the time
> With locations - you can assign hardware that is not personal and not in a computer: A printer that serves a department is a good example, the router in the server room is another.
So answering your question more directly:
- If the printer is attached to one computer: just create one in the hardware section, and assign it to the computer.
- If it's a floor/department printer, create the printer same way, just attach it to a location instead.
Hope this helps
Dan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have existing mysql db from ocsinventory.sf.net, but OCS don't have yet web interface issue.
Your inventory project is very useful, but if starting inventoring from the begining:) I mean step-by-step inserting every needed info(computers, hardware, software...), but if I've large number of PCs for invertoring i must lose many hours for this.
My question is: Are you planning writing client script for automate collecting and inserting/importing informations from every existing PC in a domain/workgroup in corporate networks for example.
I'm ready to start from blank db, but I need the client script collector ( like philosophy in ocsinventory project ).
If you realize the client script (may be runs from server share), I think your inventory project will be more powerful and popular for System Adminisrators:)
I'm ready help with the client side script, but my php kwonlage is "beginer".
However, your project have a potential to grow up!
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm aware that easy import of data is a feature that will make life easier, expecially for those in transit from other solutions. (From Excel to other applications).
The down side is that you'll have to read about the tables and understand what to import where.
I don't know yet if I'm allowed to use this script, since the author isn't answering my emails. It can make a good base for an import utility sepecific for Inventory.
The other direction I'm considering is using WMI (on windows) to automatically discover hardware/software on windows - and update inventory.
Both these paths require time to implement, but I think they can give a good answer to this problem.
Cheers
Dan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there any possibility to import a list of users, computer etc?
I already have our info in excel files...
G
Hi
Right now there's no import script that supports this functionality.
You can try exporting the data into CSV (or similar) format, and then try and load it directly into MySQL from file.
The tables format was published in the documentation in version 0.81 (realeased today)
Dan
ok...nice project...
how do you handle printers? like computers?
Hi,
- About the import from CSV
You may try this script to help you:
http://www.hotscripts.com/Detailed/18098.html
(but you'll still need knowledge of the tables from the documentation)
- About printers:
Inventory's concept is that you can attach hardware to 3 objects: computers, locations and users.
> With computers it's clear: installed hardware inside a computer, or attached hardware like a monitor fits here (and that's the most intuitive)
> With users - you can assign hardware like usb-drive, PDA, cell-phone etc - which is more personal, and not attached to a computer all the time
> With locations - you can assign hardware that is not personal and not in a computer: A printer that serves a department is a good example, the router in the server room is another.
So answering your question more directly:
- If the printer is attached to one computer: just create one in the hardware section, and assign it to the computer.
- If it's a floor/department printer, create the printer same way, just attach it to a location instead.
Hope this helps
Dan
Hi, Dan
I have existing mysql db from ocsinventory.sf.net, but OCS don't have yet web interface issue.
Your inventory project is very useful, but if starting inventoring from the begining:) I mean step-by-step inserting every needed info(computers, hardware, software...), but if I've large number of PCs for invertoring i must lose many hours for this.
My question is: Are you planning writing client script for automate collecting and inserting/importing informations from every existing PC in a domain/workgroup in corporate networks for example.
I'm ready to start from blank db, but I need the client script collector ( like philosophy in ocsinventory project ).
If you realize the client script (may be runs from server share), I think your inventory project will be more powerful and popular for System Adminisrators:)
I'm ready help with the client side script, but my php kwonlage is "beginer".
However, your project have a potential to grow up!
Thanks!
Hello
I'm aware that easy import of data is a feature that will make life easier, expecially for those in transit from other solutions. (From Excel to other applications).
I can again offer the CSV import script:
http://www.hotscripts.com/Detailed/18098.html
The down side is that you'll have to read about the tables and understand what to import where.
I don't know yet if I'm allowed to use this script, since the author isn't answering my emails. It can make a good base for an import utility sepecific for Inventory.
The other direction I'm considering is using WMI (on windows) to automatically discover hardware/software on windows - and update inventory.
Both these paths require time to implement, but I think they can give a good answer to this problem.
Cheers
Dan