Importer not working #3106
Comments
|
The .csv only contains 143 lines of data, all in line with the new sample import .csv |
|
Update: Broke the .csv file down and was able to upload 11 assets. Tried again with 30 and it finishes the upload and allows me to select "process" but then gives the error 500 page. |
|
Turn on debugging and tell me what the 500 error is when you try to process |
|
It's 129 lines, sorry! |
|
[2016-12-28 08:34:02] production.ERROR: exception 'InvalidArgumentException' with message 'The array must contain unique values' in C:\inetpub\wwwroot\assets\vendor\league\csv\src\Reader.php:249 |
|
I was able to get everything uploaded by breaking it down into groups of 20-30. Not sure why it wouldn't let me upload all assets at once... |
|
Did you possibly have two columns with the same header name? That error looks like you might have had two "asset_tag" columns or similar. |
|
I think that error was due to not having the correct headers. I just copied
and pasted the asset info onto a blank excel sheet. That's my bad.
The sheet I was trying to upload prior to and after that was whole, correct
headings and all.
…On Dec 28, 2016 2:27 PM, "Daniel Meltzer" ***@***.***> wrote:
Did you possibly have two columns with the same header name? That error
looks like you might have had two "asset_tag" columns or similar.
—
You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
<#3106 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AObZDoAyX5X2bVXfpmdNEeisGe8_XiMdks5rMsZBgaJpZM4LWhqa>
.
|
|
The usual cause for that is extra columns in your CSV. You won't see them in excel, but if you open it in a text editor, extra columns show up as a bunch of commas. The importer expects every column to be unique and when you have multiple blank headers, it sees those as duplicates. |
Expected Behavior (or desired behavior if a feature request)
Click import, choose file and successfully import assets
or
run CLI command and successfully import assets
(what you expect to happen goes here)
Actual Behavior
The progress bar goes up to 100% but doesn't do anything from there. Whether I wait 10 minutes or 2 hours the assets are still not imported into the database.
The CLI command just goes back to the prompt.
(what actually happens goes here)
Please confirm you have done the following before posting your bug report:
Please provide answers to these questions before posting your bug report:
Version v3.6.2 build 10 (g927a12f)
Server 2008 / IIS
Manual
n/a
No error message
n/a
n/a
The demo allowed me to select the file to import, got to 100% and then gave me a red "x" and said the feature is disabled
app/storage/logsand your webserver's logs.[2016-12-27 15:26:07] production.ERROR: exception 'Illuminate\Session\TokenMismatchException' in C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php:3227
Stack trace:
#0 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
Fix depreciation math #1 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Ability for admin to check out an asset to a user #2 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Add reports - depreciation, people with no assets, etc #3 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add category back to Models blade/controller #4 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(13213): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Needs sexy dashboard summary #5 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
Disallow models/depreciations/categories to be deleted if they have assets associated #6 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Add location to users, propagate those to assets #7 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Figure out how to handle multi-seat licenses #8 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Search box isn't hooked up to anything #9 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(13150): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Improve UI of category display to show nesting #10 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
Build-out ACLs to set who can view which sections (reports, etc) #11 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
A user (non-admin) should be able to request an asset [$15] #12 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Column sorting on table displays #13 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add "clone" option in edit screen for assets #14 C:\inetpub\wwwroot\assets\app\Http\Middleware\Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Option to mark assets as requestable. #15 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Add warrantee field to assets/models #17 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Move validation out of the controllers and into the models where it belongs #18 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Seed database with models, manufacturers, categories, etc. #19 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Import functions for users, assets, models, etc #20 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Merge licenses table into assets table #21 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
Fix depreciation on model vs asset #22 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
Support multiple companies [$500 awarded] #23 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
Tighten up checkin/checkout UX #24 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
Show number of assets for each asset model in listing page #25 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
Handle errors more sanely when nothing in the DB #26 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Depreciation fix #27 C:\inetpub\wwwroot\assets\app\Http\Middleware\CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fix tables on mobile #28 [internal function]: App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))
Integrate barcode generation #29 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Confirmation screens on delete #30 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Fixing bootstrap process with default values. #31 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Added confirmation popups for deletes #32 C:\inetpub\wwwroot\assets\vendor\fideloper\proxy\src\TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Add notion of lost, stolen, out for deployment, RTD, etc #33 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
Update asset index/view blade to reflect new status #34 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Add CSV export for reports #35 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Make the Edit Profile page look less assy #36 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
incorrect command chown in README #37 C:\inetpub\wwwroot\assets\app\Http\Middleware\CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Develop #38 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
Implement settings #39 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Settings edit #40 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Add asset_type to Asset controller #41 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Fix delete-check on licenses #42 C:\inetpub\wwwroot\assets\app\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fix checkout for licenses #43 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
Fix depreciation report with new licenses structure #44 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
When you soft-delete a user, should free up all associated resources #45 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Fix miscount on assets in user view #46 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
When the number of seats is edited, handle that smartly #47 C:\inetpub\wwwroot\assets\app\Http\Middleware\XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
LDAP authentication #48 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
Calendar view(s) for asset check out/in, due date, etc. [$20] #49 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
XSS Issues #50 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Add postcode to locations #51 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Make the report columns sortable #52 C:\inetpub\wwwroot\assets\app\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Add autocomplete to the search box #53 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
New button weirdly placed on my iPad (3rd gen) #54 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Show months until asset is fully depreciated #55 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Disable sorting on action column #56 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Spaces get filtered out #57 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Modal stops passing title/message/href through if modal is canceled #58 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
Checkin message is wrong #59 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
CSRF protect all of the things #60 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
DB seed fails when mysql is in strict mode #61 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add 'retired' status #62 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Asset Notes #63 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
Notifications for when warranties are expiring... #64 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Invalid SQL #65 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Broken Gravatar URL in SSL-only environments #66 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Patch 1 #67 C:\inetpub\wwwroot\assets\vendor\misterphilip\maintenance-mode\src\MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fix insecure content warnings #68 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
Initial install script failing on db installation, tries to drop tables that don't exist #69 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9963): call_user_func_array(Array, Array)
Modify the Assets and Licenses controllers and database schemas to work #70 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Can't edit address fields on locations #71 C:\inetpub\wwwroot\assets\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add address to location form #72 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Email input types #73 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
change location to status on assets table header #74 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
License Count misreporting #75 C:\inetpub\wwwroot\assets\bootstrap\cache\compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
Purchase as separate entity #76 C:\inetpub\wwwroot\assets\public\index.php(60): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
Allow '+' in Model Name & No #77 {main}
I've been running in production for over a year now. I did upgrade to the latest version this morning (from v3.3 or something similar)
No. I did purge a lot of data with the soft delete / purge soft delete method prior to trying the upload.
The text was updated successfully, but these errors were encountered: