C:/Users/h_kaw/AppData/Local/Temp/ocr9ADB.tmp/src/_macro.rb:222:in `block in ' C:/Users/h_kaw/AppData/Local/Temp/ocr9ADB.tmp/src/_macro.rb:216:in `each' C:/Users/h_kaw/AppData/Local/Temp/ocr9ADB.tmp/src/_macro.rb:216:in `with_index' C:/Users/h_kaw/AppData/Local/Temp/ocr9ADB.tmp/src/_macro.rb:216:in `' undefined method `index' for nil:NilClass 差し込みしようとした際に上記のエラーで処理が完了しません。 PC2台でテストしましたが、同じ結果でした。対処法を教えてください。よろしくお願いします。

ECマスターズの田中です。差し込みを行おうとした対象のデータの中に、空白のセルは含まれておりましたでしょうか。私にて確認したところ、データの中に空白のセルが含まれている場合、それが原因でエラーが発生することがわかりました。プログラムの修正を行う必要がございますので、ご不便をおかけして大変申し訳ありませんが、修正完了まで今しばらくお待ちいただきますようお願いいたします。

ECマスターズの田中です。大変お待たせいたしました。いただいた内容をもとに修正した「CSVパーツ差込・置換君」のテストバージョンをお渡しいたしますので、こちらで問題なく動作するか、ご確認いただけますでしょうか。下記URLより、ダウンロードをお願いします。 http://xfs.jp/mWTY0A ダウンロードパスワードは csv です。（※広告が多く表示されます。周りに表示される赤や緑の大きいボタンを押さないようご注意ください）

CSVパーツ差込・入替君　エラーについて

Warning (2) : Undefined array key "agtlogin" [in /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 141]

Code


        $showDrafts = ($auth['alogin'] || $auth['agtlogin']);
        $post = $this->ForumPosts->get($id, contain: [

Cake\Error\ErrorTrap->handleError() /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 141
App\Controller\ForumController->view() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/Controller.php, line 503
Cake\Controller\Controller->invokeAction() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 166
Cake\Controller\ControllerFactory->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 141
Cake\Controller\ControllerFactory->invoke() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/BaseApplication.php, line 362
Cake\Http\BaseApplication->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 86
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php, line 159
Cake\Http\Middleware\CsrfProtectionMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Middleware\BodyParserMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php, line 118
Cake\Routing\Middleware\RoutingMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php, line 71
Cake\Routing\Middleware\AssetMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/src/Middleware/HostHeaderMiddleware.php, line 35
App\Middleware\HostHeaderMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php, line 115
Cake\Error\Middleware\ErrorHandlerMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 60
Cake\Http\Runner->run() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 98
Cake\Http\Server->run() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (2) : Undefined array key "agtlogin" [in /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 250]

Code

        $dispatchStaff = [];
        if ($auth['alogin'] || $auth['agtlogin']) {
            $conn = ConnectionManager::get('default');

Cake\Error\ErrorTrap->handleError() /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 250
App\Controller\ForumController->view() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/Controller.php, line 503
Cake\Controller\Controller->invokeAction() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 166
Cake\Controller\ControllerFactory->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 141
Cake\Controller\ControllerFactory->invoke() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/BaseApplication.php, line 362
Cake\Http\BaseApplication->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 86
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php, line 159
Cake\Http\Middleware\CsrfProtectionMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Middleware\BodyParserMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php, line 118
Cake\Routing\Middleware\RoutingMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php, line 71
Cake\Routing\Middleware\AssetMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/src/Middleware/HostHeaderMiddleware.php, line 35
App\Middleware\HostHeaderMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php, line 115
Cake\Error\Middleware\ErrorHandlerMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 60
Cake\Http\Runner->run() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 98
Cake\Http\Server->run() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (512) : Unable to emit headers. Headers sent in file=/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php line=37 [in /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65]

Code

            $message = "Unable to emit headers. Headers sent in file={$file} line={$line}";
            trigger_error($message, E_USER_WARNING);
        }

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (2) : Cannot modify header information - headers already sent by (output started at /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 158]

Code

        $reasonPhrase = $response->getReasonPhrase();
        header(sprintf(
            'HTTP/%s %d%s',

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 158
Cake\Http\ResponseEmitter->emitStatusLine() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 68
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Code

            foreach ($values as $value) {
                header(sprintf(
                    '%s: %s',

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 191
Cake\Http\ResponseEmitter->emitHeaders() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 69
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Code


        return setcookie($cookie->getName(), $cookie->getScalarValue(), $cookie->getOptions());
    }

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 228
Cake\Http\ResponseEmitter->setCookie() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 212
Cake\Http\ResponseEmitter->emitCookies() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 200
Cake\Http\ResponseEmitter->emitHeaders() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 69
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

CSVパーツ差込・入替君 エラーについて

CSVパーツ差込・入替君　エラーについて