You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-12-21 05:32:34

artifectrealm
Member
Registered: 2017-12-19
Posts: 4

Data Injection

Hi All

i have added Data Injection, I have read the instructions from many places  but i still cant it to work.

I have :
GLPI 9.1.7.1 ( i have downgraded from 9.2.1)
"File Injection" Status "Enable"
File Injection option appeared under "Tools" tab
Under "Administration" tab --> Super Admin --> File Injection, all the available options are all "checked" . I only have "READ" "UPDATE" "CREATE" "PURGE" for Model management and Injection of the file.


Issue:
Login using glpi user which is a super admin profile
When i go into File Injection option appeared under "Tools" tab, i can only see " No Model currently available". The "+" is greyed out.

Any help is much appreciated !

Last edited by artifectrealm (2017-12-21 05:33:28)

Offline

#2 2017-12-21 08:02:34

artifectrealm
Member
Registered: 2017-12-19
Posts: 4

Re: Data Injection

Hi All

managed to find the solution .... i need to click on the Home>Tools>File injection> and File Injection again to reveal more options! now i am importing my

CSV!

But i do hope there are some KB or FAQ setup in this forum for new users to check it up.

Offline

#3 2020-03-05 09:11:48

sarath84is
Member
Registered: 2020-02-23
Posts: 3

Re: Data Injection

Hello,

I am unable to upload csv and it is showing  header of the file
VM;"Powerstate;"Guest state;"PowerOn;"CPUs;"Memory;"NICs;"Disks;"Primary IP Address;"Provisioned MB;"In Use MB;"Unshared MB;";

as a whole and not separated columns in File Mapping

Thanks & Regards,

SS

Last edited by sarath84is (2020-03-05 09:13:10)

Offline

#4 2020-03-05 11:14:58

mklimasz
Member
Registered: 2017-12-14
Posts: 82

Re: Data Injection

Hi

Please check two important conditions:
- that the separator defined in the model is exactly the one used
- make sure that quotes ("") are used in each and every field (they're not paired in the example above, that would certainly cause problems...); it should have looked like:
"VM";"Powerstate";"Guest state";"PowerOn";"CPUs";"Memory";"NICs";"Disks";"Primary IP Address";"Provisioned MB";"In Use MB";"Unshared MB";""

Bests,
Michal

Offline

#5 2020-03-09 15:02:14

sarath84is
Member
Registered: 2020-02-23
Posts: 3

Re: Data Injection

Hello Michal,

Thanks for your reply.

You are right and I tried same way !
I downloaded a sample from computer field itself and tried upload , it is working fine and able to update model. But still facing the same issue most of the time raising the following error

"The number of columns of the file is incorrect. 8 awaited columns 1 found column"

The below is the  existing model downloaded

Name;"Virtual machines - Name";"Virtual machines - State";"Networking - IP";"Operating System - Version";"Virtual machines - Memory";"Virtual machines - processor number";"Components - Network interface"

So tried both(1-Your recommendation 2- as per the above entry in the existing model) - ERROR is like  mentioned above

"DELL ";"ABC";"POWERON";"192.168.10.30";"Microsoft Windows Server 2016 (64-bit)";"VMware vCenter Server 6.0.0 ";"8192";"8""

DELL ";"ABC";"POWERON";"192.168.10.30";"Microsoft Windows Server 2016 (64-bit)";"VMware vCenter Server 6.0.0 ";"8192";"8"

I doubt with the syntax of csv and unfortunately  am not familiar with that ... Support will be appreciated

Thanks & Regards,
SS

Offline

#6 2020-03-16 10:24:18

linkn
Member
Registered: 2020-03-16
Posts: 1

Re: Data Injection

mklimasz wrote:

Hi

Please check two important conditions:
- that the separator defined in the model is exactly the one used
- make sure that quotes ("") are used in each and every field (they're not paired in the example above, that would certainly cause problems...); it should have looked like:
"VM";"Powerstate";"Guest state";"PowerOn";"CPUs";"Memory";"NICs";"Disks";"Primary IP Address";"Provisioned MB";"In Use MB";"Unshared MB";""

Bests,
Michal

I have done your guidance and success. It is very useful! Thank you so much.

Offline

#7 2021-12-09 01:27:47

pgonzalez
Member
Registered: 2021-12-08
Posts: 1

Re: Data Injection

Hi, i have a issue. i create de model for users bulk load. the users is saved to db, but not show in glpi.

Offline

#8 2021-12-23 14:07:26

alanzop
Member
Registered: 2021-12-22
Posts: 1

Re: Data Injection

Thanks for the above solution, it worked for me.

Offline

Board footer

Powered by FluxBB