Insert Variable into Laravel CSV file import array

Question

I have a file I am uploading and I am passing an partid along with it. I need to insert the records from the csv file into the table along with the partid in each record.

Inserting the records from the file works fine.

I need to add the partid to the array. I have not been able to figure out how. Any suggestions would be appreciated.

Submit Form

<form style="border: 4px solid #a1a1a1;margin-top: 15px;padding: 10px;"
      action="/part/importbom" class="form-horizontal" method="post"
      enctype="multipart/form-data">

    {{ csrf_field() }}
    <input type="file" name="file"/>
    <input type="hidden" name="part_id" value="{{ $part->id }}"/>
    <button class="btn btn-primary">Import File</button>
</form>

Controller

public function importExcel(Request $request)
{
    $partid = $request->part_id;

    $validator = \Validator::make($request->all(), [
        'file' => 'required',
    ]);

    if ($validator->fails()) {
        return redirect()->back()->withErrors($validator);
    }

    $file = $request->file('file');
    $csvData = file_get_contents($file);

    $rows = array_map('str_getcsv', explode("\n", $csvData));
    $header = array_shift($rows);

    foreach ($rows as $row) {
        $row = array_combine($header, $row);
        // dd($row);
        Bom::create([
            'item'             => $row['item'],
            'qty'              => $row['qty'],
            'designators'      => $row['designators'],
            'hand_add'         => $row['hand_add'],
            'hand_solder'      => $row['hand_solder'],
            'hand_solder_pins' => $row['hand_solder_pins'],
            'notes'            => $row['notes'],
            'install'          => $row['install'],
        ]);
    }

    return redirect()->back();
}

I can get the part id, how do I add it to the array so it is inserted with each record? — user2325548
– user2325548, Commented Jun 20, 2018 at 15:19

Rwd · Accepted Answer · 2018-06-20 18:06:53Z

2

You should just be able to include it in the foreach loop:

foreach ($rows as $row) {

    $row = array_combine($header, $row);

    Bom::create([
        'part_id'          => $request->part_id,
        'item'             => $row['item'],
        'qty'              => $row['qty'],
        'designators'      => $row['designators'],
        'hand_add'         => $row['hand_add'],
        'hand_solder'      => $row['hand_solder'],
        'hand_solder_pins' => $row['hand_solder_pins'],
        'notes'            => $row['notes'],
        'install'          => $row['install'],
    ]);
}

Or to make your code shorter you could do:

foreach ($rows as $row) {

    $row = array_combine($header, $row);

    $row['part_id'] = $request->part_id;

    Bom::create($row);
}

answered Jun 20, 2018 at 18:06

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Rwd Over a year ago

@Subtlebot I'm not sure I follow, the above code isn't creating any new CSV. It's simply taking each row from a CSV file and adding that row to a new row in the db. The OP mentioned that the adding of the CSV data is working fine and that they just weren't sure of how to add the part_id into the array.

user2325548 Over a year ago

I tried both of your suggestions and still get the ErrorException (E_WARNING) array_combine(): Both parameters should have an equal number of elements

Rwd Over a year ago

@user2325548 In that case can you add the csv data from the file you're uploading to your question. The reason you would get that sort of error is because one of the rows has a different number of columns to the header row.

user2325548 Over a year ago

Well that was it. I did not have data yet for the fields past designators. I added the blank commas for the respective null fields and it worked. ugh... Thanks so much!

Rwd Over a year ago

@user2325548 Glad I could help!

Maytham Fahmi · Accepted Answer · 2018-06-20 18:08:44Z

1

Regarding Laravel doc: https://laravel.com/docs/5.6/requests

public function store(Request $request)
{
    $partId = $request->input('part_id');

    //
}

Then you pass your variable $partId where ever you need it.

edited Jun 20, 2018 at 18:08

answered Jun 20, 2018 at 15:43

Maytham Fahmi

33.2k17 gold badges132 silver badges159 bronze badges

4 Comments

user2325548 Over a year ago

In the controller code above, i need to get $partid in the Bom::create array. As I mentioned I can ready get $partid, i just don't know how to include it in the create array that is parsing the csv file and inserting the record.

user2325548 Over a year ago

for example, and i know this is wrong, but what i am trying accomplish Bom::create([ 'part_id' => $partid, 'item' => $row['item'],

Maytham Fahmi Over a year ago

ok I go your point, so what is wrong with the method in your comment, do you get error? does the key part_id created in your model?

user2325548 Over a year ago

ErrorException (E_WARNING) array_combine(): Both parameters should have an equal number of elements

Collectives™ on Stack Overflow

Insert Variable into Laravel CSV file import array

2 Answers 2

5 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related