Attached is a single line bulk import csv file to add a cabinet to your datacenter "Test"
Go to Bulk Importer and select Bulk Cabinet import.
Upload the attached csv file
verify the contents and then hit process.
It fails with a ----- This page isn’t workingdev.opendcim.org is currently unable to handle this request.
HTTP ERROR 500
Looked at bulk_importer.php and found...
From bulk_cabinets.php original (v.23.04): lines 139 to 144
• Fails to load cabinets from clean file that demonstrated clean import on v21.*
• Fails with an http 500 error.
dcim_bulk_cabinets_php.png
Then added these lines from bulk_importer.php
else {
$row[$fname] = "";
}
From bulk_importer.php original (v23.04): lines 165 to 173
• Works loading devices
dcim_bulk_cabinets_fix.png
Modified the bulk_cabinets.php file to match the bulk_importer.php snippet and demonstrated a clean adding of cabinets using the exact file that it had failed on previously.
Is this a good fix? What say you guys?
Please let us know...
Chris B.
On another note:
I have a big dataset ~44000 lines and couldn't get the report_assets_Excel.php report to work. I edited line 151 of this file and increased my memory for the file to 2048M and now the report works effortlessly.
23.04 DCIM - Bulk Cabinet importer fails after processing upload file
To Reproduce Steps to reproduce the behavior:
Looked at bulk_importer.php and found...
From bulk_cabinets.php original (v.23.04): lines 139 to 144 • Fails to load cabinets from clean file that demonstrated clean import on v21.* • Fails with an http 500 error. dcim_bulk_cabinets_php.png
Then added these lines from bulk_importer.php else { $row[$fname] = ""; }
From bulk_importer.php original (v23.04): lines 165 to 173 • Works loading devices dcim_bulk_cabinets_fix.png
Modified the bulk_cabinets.php file to match the bulk_importer.php snippet and demonstrated a clean adding of cabinets using the exact file that it had failed on previously.
Is this a good fix? What say you guys?
Please let us know...
Chris B.
On another note: I have a big dataset ~44000 lines and couldn't get the report_assets_Excel.php report to work. I edited line 151 of this file and increased my memory for the file to 2048M and now the report works effortlessly.
<img width="388" alt="dcim_bulk_cabinets_php_fix" src test.csv ="https://github.com/opendcim/openDCIM/assets/78433633/02891b17-3b32-42ba-b0dd-16e0897adf20">