How to import selected data to Inventory from Excel or CSV file

infomate · 2011-06-18 04:03:22

Is there a way to import selected fields of data from an Excel or CSV file?

I still haven't got the time to install and setup OCSInvenroty and all our inventory files are on Excel.

A little step by step "How to" will be much appreciated.

Thank you

-------------------

Operating Systems : Linux web3.vital.x10hosting.com 2.6.18-238.5.1.el5.028stab085.3 #1 SMP Mon Mar 21 20:05:12 MSK 2011
i686
PHP 5.2.13 (PDO, Reflection, SPL, SQLite, SimpleXML, Zend Optimizer, bcmath, calendar, cgi, ctype, curl, date, dom, exif,
filter, ftp, gd, gettext, hash, iconv, imap, ionCube Loader, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl,
pcre, pdo_mysql, pdo_sqlite, pgsql, posix, pspell, session, soap, sockets, standard, tidy, tokenizer, wddx, xml, xmlreader,
xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: memory_limit="64M" max_execution_time="30" safe_mode="" session.save_handler="files" post_max_size="16M"
upload_max_filesize="16M"
Software: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8e-fips-rhel5 mod_mono/2.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 ()
Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
MySQL: 5.0.92-50 (support@localhost/support_helpdesk)

wawa · 2011-06-18 18:31:54

take a look at the csv file plugin

infomate · 2011-06-19 00:45:14

unfortunately csv plug still doesn't work for 0.80

any other suggestion? or I have to just wait?

wawa · 2011-06-19 12:51:26

sure it works in 0.80, try the "trunk" version
take it here, and test it : https://forge.indepnet.net/tarballs-plugins/

infomate · 2011-06-20 15:15:45

Bingo!
Next thing is learning how to actually import the file....

Thanks a lot.

tottobauer · 2011-06-20 15:59:20

its qiet easy:

open Installation / Plugins and install the file injection Plugin

THan goto Plugins -> File Injection
->Model management
-> add Model : +
-> select a name
-> select a entity
->choose Type of datas you want to import e.g. Computer / application or SIM Cards
if you want to add new items
-> Allow lines creation = yes
-> allow lines update = yes

and so on.

than you choos csv as format

than add/ ok

tottobauer · 2011-06-20 16:02:33

after this switch to the new model:
Plugins->Fileinjection -> Model
change from the "Standard" view to the "file to inject" view
here you upload the examplefile for your Import with all lines and fieldnames

tottobauer · 2011-06-20 16:08:53

You have to change back to the "Standard View and choos the seperator "File delimitor" (i have to change vorm ";" to "," if i use an excel generated csv)
Now switch to the "Mapping View" and you get your fieldnames wich you can map to GLPI-Tables and Fields
for examlpe:

Header of the field: Com_name -> (i choos in table dropdown) Computer -> and match it to the Field "Name"
Header of the field: Serialnumber -> Computer -> Serialnumber (autoselected) quite ineligent this tool ;-)
and so on
than submit

Last edited by tottobauer (2011-06-20 16:10:23)

tottobauer · 2011-06-20 16:22:11

in general i dont need the additional Information, you can test it, its useful if you have to use it.
Than you need the verification.
i did not realised what this part is usful, but i think others knows better i am only a stupid user

Now choos plugins -> File Injection -> choos your injection Model (Dropdown Existing Model)

Upload your File
and follow the Dialog

infomate · 2011-06-21 15:00:24

Very well appreciated.

You just saved me a million hours of painstaking encoding.

Will try this...Thanks again

flashbacknl · 2011-06-22 16:42:33

sorry to hijack this topic

but when adding a new model
the field Type of datas to import : is empty
and there is no submit button?

Last edited by flashbacknl (2011-06-22 16:43:49)

tottobauer · 2011-06-24 08:41:39

In general the file to upload is to define after the submission of the Base informations.
the problem you describe i have never seen.

Greetings from Germany
Thorsten BAuer

infomate · 2011-07-07 05:49:19

I think my plugin is broke.......

I can access and open the model management but the form only goes as far as "Type of datas to import :" line. There are no more lines after that. so i dont have anything to choose and theres no submit button as well.

Is this a problem of GLPI or the plugin?

infomate · 2011-07-09 01:27:32

Tried to download/install the new tarball dated 08-07-2011 but still the same results

nycjay01 · 2011-07-20 23:27:49

Hello

I downloaded the trunked version from this thread I do see the plugin on my web browser but I am not able to add a new model. I start the plugin then when I try to add/create a new model the page just reads "During Loading" Am I missing a step here?

Thanks

nycjay01 · 2011-07-26 16:33:34

nycjay01 wrote:

Hello
I downloaded the trunked version from this thread I do see the plugin on my web browser but I am not able to add a new model. I start the plugin then when I try to add/create a new model the page just reads "During Loading" Am I missing a step here?
Thanks

Anyone? I really like the product by my manager cant agree to it if I cant load our spread sheets into it... If anyone sees this message my problem is basically I cant create a new model it just hangs saying "During Loading" I have .80 glpi.

Thanks

infomate · 2011-09-12 10:13:26

working like clockwork. I upgraded to GLPI 0.80.2 and the latest injection plugin. VERY USEFULL

Thanks

Laura090 · 2011-09-16 02:00:41

Any major differences then with the new upgrade?! crate training puppies puppy toilet training puppy biting

infomate wrote:

working like clockwork. I upgraded to GLPI 0.80.2 and the latest injection plugin. VERY USEFULL
Thanks

puppy training puppy training tips puppy chewing puppy barking why do dogs eat grass why do dogs eat poop
puppy crying how to leash train a puppy puppy separation anxiety weaning puppies puppy growling puppy aggression

infomate · 2011-09-19 04:56:17

before I upgraded to 0.80.2 I cannot make the plugin to work...

wawa · 2011-09-19 10:57:07

infomate wrote:

before I upgraded to 0.80.2 I cannot make the plugin to work...

wow, what a description.
how am I supposed to help you with 'the plugin doesn't work' ?

infomate · 2011-09-19 11:52:26

To wawa,

I was replying to Laura090, asking for the difference with the new upgrade. I wasn't able to make the plugin work under 0.80.1. After upgrading to 0.80.2 the plugin just worked.
So, my setup is now working fine.

To Laura090,

Let me know if you need help..

Thanks

wawa · 2011-09-19 22:03:31

ok sorry infomate

sector7gp · 2017-11-30 22:03:57

get this fork feature/9.2-compat

https://github.com/pluginsGLPI/datainjection/issues/47

Forum GLPI-Project

Announcement

#1 2011-06-18 04:03:22

How to import selected data to Inventory from Excel or CSV file

#2 2011-06-18 18:31:54

Re: How to import selected data to Inventory from Excel or CSV file

#3 2011-06-19 00:45:14

Re: How to import selected data to Inventory from Excel or CSV file

#4 2011-06-19 12:51:26

Re: How to import selected data to Inventory from Excel or CSV file

#5 2011-06-20 15:15:45

Re: How to import selected data to Inventory from Excel or CSV file

#6 2011-06-20 15:59:20

Re: How to import selected data to Inventory from Excel or CSV file

#7 2011-06-20 16:02:33

Re: How to import selected data to Inventory from Excel or CSV file

#8 2011-06-20 16:08:53

Re: How to import selected data to Inventory from Excel or CSV file

#9 2011-06-20 16:22:11

Re: How to import selected data to Inventory from Excel or CSV file

#10 2011-06-21 15:00:24

Re: How to import selected data to Inventory from Excel or CSV file

#11 2011-06-22 16:42:33

Re: How to import selected data to Inventory from Excel or CSV file

#12 2011-06-24 08:41:39

Re: How to import selected data to Inventory from Excel or CSV file

#13 2011-07-07 05:49:19

Re: How to import selected data to Inventory from Excel or CSV file

#14 2011-07-09 01:27:32

Re: How to import selected data to Inventory from Excel or CSV file

#15 2011-07-20 23:27:49

Re: How to import selected data to Inventory from Excel or CSV file

#16 2011-07-26 16:33:34

Re: How to import selected data to Inventory from Excel or CSV file

#17 2011-09-12 10:13:26

Re: How to import selected data to Inventory from Excel or CSV file

#18 2011-09-16 02:00:41

Re: How to import selected data to Inventory from Excel or CSV file

#19 2011-09-19 04:56:17

Re: How to import selected data to Inventory from Excel or CSV file

#20 2011-09-19 10:57:07

Re: How to import selected data to Inventory from Excel or CSV file

#21 2011-09-19 11:52:26

Re: How to import selected data to Inventory from Excel or CSV file

#22 2011-09-19 22:03:31

Re: How to import selected data to Inventory from Excel or CSV file

#23 2017-11-30 22:03:57

Re: How to import selected data to Inventory from Excel or CSV file

Board footer