Snipe-it: Problems importing assets

[Chris-2515]

Hello,

I've recently installed snipe-IT, everything is up and running but I'm having some trouble importing assets in to the database. for the sake of testing I created a few test objects and exported them into a CSV. I deleted the assets from the web interface then tried uploading the CSV with the assets on it, but it's missing a few of the fields in the mapper. I'm just using the default headings, there are no custom fields.

A few of the headings that were available when creating the assets were model and Model No. they exported the columns to the CSV with no problem, but when I try to import it again the import field drop down box doesn't seem to have these fields available. I'm just wondering if I'm overlooking something with the import feature.

• [X ] I have enabled debug mode

• [ X] I have read checked the Common Issues page

• Is this a fresh install or an upgrade?
  Fresh Install

• Version of Snipe-IT you're running
  v4.1.6-pre build 2963 (g83c8449)
• Version of PHP you're running
  7.0.19-1
• Version of MySQL/MariaDB you're running
  10.1.26
• What OS and web server you're running Snipe-IT on
  Debian 9.1
• What method you used to install Snipe-IT (install.sh, manual installation, docker, etc)
  manual
• WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
• What specific Snipe-IT page you're on, and what specific element you're interacting with to trigger the error
  import screen
• If a stacktrace is provided in the error, include that too.
  N/A
• Any errors that appear in your browser's error console.
  N/A
• Confirm whether the error is reproduceable on the demo: https://snipeitapp.com/demo.
  N/A
• Include any additional information you can find in app/storage/logs and your webserver's logs.
  N/A
• Include what you've done so far in the installation, and if you got any error messages along the way.
  N/A
• Indicate whether or not you've manually edited any data directly in the database
  N/A

[EarlRamirez]

Are you getting any errors when you try to import if debugging is on you should get some sort of an error? Are you getting the same error when you try to import from CLI? This document may help https://snipe-it.readme.io/docs/importing

[Chris-2515]

When I try importing through the gui it just seems to hang at processing. I tried importing through the command line and got the following error.

[InvalidArgumentException]
Use a flat array with unique string values

[dmeltzer]

Have you selected the import type (asset) before looking in the dropdown fields?

[snipe]

Hi there - We haven't heard back in a bit, so I'm going to close this ticket for now, but will re-open it if you're still having issues.

[raffo1987]

I've the same problem that I'm not able to fix :'(
`[15:12:59] LOG.error: InvalidArgumentException: Use a flat array with unique string values in /var/www/html/vendor/league/csv/src/Reader.php:290
Stack trace:

0 /var/www/html/vendor/league/csv/src/Reader.php(269): LeagueCsvReader->validateKeys(Array)

1 /var/www/html/vendor/league/csv/src/Reader.php(235): LeagueCsvReader->getAssocKeys(0)

2 /var/www/html/app/Importer/Importer.php(111): LeagueCsvReader->fetchAssoc()

3 /var/www/html/app/Http/Requests/ItemImportRequest.php(57): AppImporterImporter->import()

4 /var/www/html/app/Http/Controllers/Api/ImportController.php(100): AppHttpRequestsItemImportRequest->import(Object(AppModelsImport))

5 [internal function]: AppHttpControllersApiImportController->process(Object(AppHttpRequestsItemImportRequest), '16')

6 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)

7 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): IlluminateRoutingController->callAction('process', Array)

8 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): IlluminateRoutingControllerDispatcher->dispatch(Object(IlluminateRoutingRoute), Object(AppHttpControllersApiImportController), 'process')

9 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): IlluminateRoutingRoute->runController()

10 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): IlluminateRoutingRoute->run()

11 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): IlluminateRoutingRouter->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

12 /var/www/html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

13 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): IlluminateAuthMiddlewareAuthenticate->handle(Object(IlluminateHttpRequest), Object(Closure), 'api')

14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

15 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

16 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): IlluminatePipelinePipeline->then(Object(Closure))

17 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): IlluminateRoutingRouter->runRouteWithinStack(Object(IlluminateRoutingRoute), Object(IlluminateHttpRequest))

18 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): IlluminateRoutingRouter->dispatchToRoute(Object(IlluminateHttpRequest))

19 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): IlluminateRoutingRouter->dispatch(Object(IlluminateHttpRequest))

20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): IlluminateFoundationHttpKernel->IlluminateFoundationHttp{closure}(Object(IlluminateHttpRequest))

21 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(51): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

22 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): BarryvdhDebugbarMiddlewareDebugbar->handle(Object(IlluminateHttpRequest), Object(Closure))

23 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

24 /var/www/html/app/Http/Middleware/CheckForDebug.php(25): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

25 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareCheckForDebug->handle(Object(IlluminateHttpRequest), Object(Closure))

26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

27 /var/www/html/vendor/fideloper/proxy/src/TrustProxies.php(56): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

28 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): FideloperProxyTrustProxies->handle(Object(IlluminateHttpRequest), Object(Closure))

29 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

30 /var/www/html/app/Http/Middleware/CheckForSetup.php(27): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareCheckForSetup->handle(Object(IlluminateHttpRequest), Object(Closure))

32 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

33 /var/www/html/app/Http/Middleware/NosniffGuard.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

34 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareNosniffGuard->handle(Object(IlluminateHttpRequest), Object(Closure))

35 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

36 /var/www/html/app/Http/Middleware/ContentSecurityPolicyHeader.php(18): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

37 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareContentSecurityPolicyHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

38 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

39 /var/www/html/app/Http/Middleware/ReferrerPolicyHeader.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

40 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareReferrerPolicyHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

41 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

42 /var/www/html/app/Http/Middleware/XssProtectHeader.php(18): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

43 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareXssProtectHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

44 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

45 /var/www/html/app/Http/Middleware/FrameGuard.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

46 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): AppHttpMiddlewareFrameGuard->handle(Object(IlluminateHttpRequest), Object(Closure))

47 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

48 /var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

49 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): IlluminateViewMiddlewareShareErrorsFromSession->handle(Object(IlluminateHttpRequest), Object(Closure))

50 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

51 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

52 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): IlluminateSessionMiddlewareStartSession->handle(Object(IlluminateHttpRequest), Object(Closure))

53 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

54 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

55 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): IlluminateFoundationHttpMiddlewareCheckForMaintenanceMode->handle(Object(IlluminateHttpRequest), Object(Closure))

56 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

57 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

58 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): IlluminatePipelinePipeline->then(Object(Closure))

59 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): IlluminateFoundationHttpKernel->sendRequestThroughRouter(Object(IlluminateHttpRequest))

60 /var/www/html/public/index.php(58): IlluminateFoundationHttpKernel->handle(Object(IlluminateHttpRequest))

61 {main}`

[snipe]

@raffo1987 you have two columns with the same header value (possibly blank)

[Chris-2515]

I ended up getting around the issue a while back so I kind of forget what fixed it. I think it was just a problem with the field mappings. I exported a csv to get a sample template for my import, but when importing the fields didn't match exactly so it threw me off. When importing the header field was looking for Model, but the import field had named it Model Name.

Either that or I may have been leaving a required field blank.
https://snipe-it.readme.io/v3.6.2/docs/importing

Everything is working well for me now.

[raffo1987]

Solved! thnx :)