404 Error after upload #44

alexWaterfront · 2022-07-07T13:30:30Z

After i click on choose file and i select a csv document

it just shows me a 404 error see image attached:

HeadStudios · 2022-07-20T04:29:47Z

I just had this issue... so going to check this - first time I'm trying to figure out how this whole thing works... I guess I have to update the files downloaded by my composer require thingie with this new commit let me check

jigsawsoul · 2022-07-21T08:56:25Z

Same issue for me, it's just returning a 404

HeadStudios · 2022-07-21T09:51:40Z

Just wanted to pipe in - the link included here: #45 - fixed the 404 issue for me. I just copy/pasted the raw file and replaced the src/Http/Controllers/ImportController.php file from here: 8dd4796 .... so if you do that it should fix it... however that didn't solve "ALL" my problems because after I did that I could import - everything looks good on the import and it says 28 records imported successfully or whatever... but... nothing is imported!

Hopefully the creator peeks in here - because this has a lot of potential for me and I'm sure the fix to my thing is fairly straightforward - btw for anyone experiencing this issue - let me know if doing what I recommended fixed your issue and if you encounter the "second" import issue I encountered (where everything works... but it doesn't really work if that makes sense)

alexWaterfront · 2022-07-21T10:20:15Z

Thanks for the input everyone hopefully by getting traction the author will have a look soon. I tried your solution @HeadStudios but unfortunately it didn't work for me I still get 404 error.

HeadStudios · 2022-07-21T10:38:51Z

@alexWaterfront that's a shame... yes please keep me updated... I am one step ahead (404 page fixed.. imports not working) - but hoping to get resolution.. let's work together and keep each other informed - I'll be checking back here.

gcjbr · 2022-07-23T22:38:43Z

My PR only prevents the 404, but the Resource causing it can't be configured when imported.

The error goes all the way to NovaRequest's rulesForCreation method, but I can't pinpoint what's the difference between the Resources that are being imported successfully and those which are not

HeadStudios · 2022-07-24T04:24:16Z

Hm good point, I've only tried one Resource for import - I could technically try other Resources to see if the issue is with my resources.. like I could try and import some Users as that is like the default mode. I appreciate your PR though because copy/pasting that did help me get to the next step.. I don't know why this Debugbar or whatever it is won't show me the SQL query that is attempted to be performed on insert.. I'm new to Laravel and not the best at debugging - but you've given me the idea to test with other resources to try to pinpoint the problem down - and thank for rulesForCreation method to look at. Chrs.

archambaultalex · 2022-07-25T00:04:44Z

Got the same problem. I am getting a 404 error when uploading the csv file.
For me, the error was caused by resources that had a belongsTo field.
In ImportController@extractValidationRule the function $resource::rulesForCreation is called which in turn calls the function getCreationRules at /nova/src/PerformsValidation@rulesForCreation on each field.
For a reason that I do not understand, if it's called on a belongsTo field, it returns a 404 error.

gcjbr · 2022-07-25T00:45:31Z

Got the same problem. I am getting a 404 error when uploading the csv file. For me, the error was caused by resources that had a belongsTo field. In ImportController@extractValidationRule the function $resource::rulesForCreation is called which in turn calls the function getCreationRules at /nova/src/PerformsValidation@rulesForCreation on each field. For a reason that I do not understand, if it's called on a belongsTo field, it returns a 404 error.

Same

HeadStudios · 2022-07-25T02:57:11Z

Hmmmm.... interesting... because the resource I'm importing into - there's a chance that has a BelongsTo field to... or more so a BelongsTo function or something.. I will test without them and see what happens... but I know the table doesn't have any remote fields... what's interseting is that there's no error being made... and I am sooo bad at troubleshooting - like all this stuff you guys are saying - I have no idea how to check that out. On my end I just get a success message - actually I should post what happens on my side here soon.. I feel like I'm so close to a solution though (I even have a success page saying "38 contacts of 38 contacts have been imported" and stuff.

gcjbr · 2022-07-25T13:03:03Z

If you used my solution, though, it will import, but the fields on the Resource with the relationship won't show in the dropdown to map the fields for import. That's because I simply short circuited the mapping function when it throws any error.

…

On Sun, 24 Jul 2022 at 23:57, HeadStudios ***@***.***> wrote: Hmmmm.... interesting... because the resource I'm importing into - there's a chance that has a BelongsTo field to... or more so a BelongsTo function or something.. I will test without them and see what happens... but I know the table doesn't have any remote fields... what's interseting is that there's no error being made... and I am sooo bad at troubleshooting - like all this stuff you guys are saying - I have no idea how to check that out. On my end I just get a success message - actually I should post what happens on my side here soon.. I feel like I'm so close to a solution though (I even have a success page saying "38 contacts of 38 contacts have been imported" and stuff. — Reply to this email directly, view it on GitHub <#44 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6DCUWLGK5KEL33I4C5IZLVVX7BDANCNFSM525NRA2A> . You are receiving this because you commented.Message ID: ***@***.***>

HeadStudios · 2022-07-25T13:33:03Z

Yes I'll try and import to users or something with no relationships... the thing is the Resource I'm importing doesn't have any related id fields... like for example Contacts doesn't have any foreign id keys or anything fancy at the database level - https://share.getcloudapp.com/wbuXqE7e - ... so I'm just doing name, mobile, email. The thing is on the Model level I do have the following:

ublic function campaign_contacts() {
return $this->belongsToMany(CampaignContact::class);
}

So it does belongsTo... but it doesn't have to.. I don't know if I'm making sense - I'm wondering if your mapping short circuits if on the model it has belongsTo... because I can create contacts without associating them (in fact I can't associate them on the creation in nova level) to campaign contacts or anything.. not sure if I described it correctly.. I can try removing that belongs to or campaign_contacts() function too and see if it works - but thanks for clarifying that it short circuits - just trying to figure out this mystery - any input much appreciated!

petervandijck · 2022-07-25T19:15:10Z

Having the same issue, anyone working on this (aside from the above comments)?

HeadStudios · 2022-08-08T07:31:11Z

I might put this over to Fiverr and see if someone is willing to work and fix it... if I find a solution I'll come back here and share - you guys better throw me some pennies if I do though lol.

morcov · 2022-08-12T12:50:42Z

Problem in NovaRequest in method resource by call in BelongsTo::associatableQueryCallable

public function resource()
    {
        return tap(once(function () {
            return Nova::resourceForKey($this->route('resource'));
        }), function ($resource) {
            abort_if(is_null($resource), 404);
        });
    }

Request can't get value $this->route('resource') because there is none. For resolve can use custom request with replacement this method. Example

    public function resource()
    {
          return $this->importResource;
    }

I can't create a pull request right now, maybe later

HeadStudios · 2022-08-12T13:04:24Z

Problem in NovaRequest in method resource by call in BelongsTo::associatableQueryCallable
public function resource()
    {
        return tap(once(function () {
            return Nova::resourceForKey($this->route('resource'));
        }), function ($resource) {
            abort_if(is_null($resource), 404);
        });
    }
Request can't get value $this->route('resource') because there is none. For resolve can use custom request with replacement this method. Example
    public function resource()
    {
          return $this->importResource;
    }
I can't create a pull request right now, maybe later

Wait.. so I just... find and replace that code and (theoretically) it should work? I will try tomorrow!

pedami · 2022-08-13T02:39:37Z

Hola tengo el mismo problema.
Esperamos que mañana lo resuelva @HeadStudios

Gracias.

HeadStudios · 2022-08-13T07:32:27Z

Hola tengo el mismo problema. Esperamos que mañana lo resuelva @HeadStudios

Gracias.

Hello Spanish person. Had to translate what you said but yes excited about getting this fixed too.

HeadStudios · 2022-08-13T14:43:11Z

Problem in NovaRequest in method resource by call in BelongsTo::associatableQueryCallable
public function resource()
    {
        return tap(once(function () {
            return Nova::resourceForKey($this->route('resource'));
        }), function ($resource) {
            abort_if(is_null($resource), 404);
        });
    }
Request can't get value $this->route('resource') because there is none. For resolve can use custom request with replacement this method. Example
    public function resource()
    {
          return $this->importResource;
    }
I can't create a pull request right now, maybe later

This crashed for me when I replaced this function in Nova... or am I meant to make another function? I'm trying to comment the abort part out to see if this puts the CSV import through.. I have no idea what I'm doing lol.

HeadStudios · 2022-08-13T14:46:49Z

Problem in NovaRequest in method resource by call in BelongsTo::associatableQueryCallable
public function resource()
    {
        return tap(once(function () {
            return Nova::resourceForKey($this->route('resource'));
        }), function ($resource) {
            abort_if(is_null($resource), 404);
        });
    }
Request can't get value $this->route('resource') because there is none. For resolve can use custom request with replacement this method. Example
    public function resource()
    {
          return $this->importResource;
    }
I can't create a pull request right now, maybe later

This didn't help unfortunately :( any other input much appreciated - or if I'm doing something wrong. Chrs!

morcov · 2022-08-13T15:20:28Z

My PR #47

HeadStudios · 2022-08-13T15:47:43Z

My PR #47

Niiice! Just had a look - can't wait to try over on my side. Looking forward to it!

pedami · 2022-08-13T16:03:45Z

My PR #47

Niiice! Just had a look - can't wait to try over on my side. Looking forward to it!

Muchas gracias, esto funciona ;-)

HeadStudios · 2022-08-13T20:56:56Z

My PR #47

Sorry :( - just tried and it has not fixed my issue - I do import and just like before it says success records imported but when I go to look nothing has been imported :(

pedami · 2022-08-13T21:07:46Z

Hello, it worked for me the second time, because I wasn't passing all the mandatory fields, try to pass all the fields that are mandatory and it will work for you.

HeadStudios · 2022-08-14T06:19:16Z

Hello, it worked for me the second time, because I wasn't passing all the mandatory fields, try to pass all the fields that are mandatory and it will work for you.

Hey, I have a contacts with only 3 fields (name, email, phone) - I pass all fields and it says success but no records imported :(

HeadStudios · 2022-08-18T10:08:46Z

It says Imported but... not really - https://share.getcloudapp.com/kpuW9qp1 - btw that #47 pull request did help! But... there's just no import happening despite it saying that is so.. yeh.

Erkenz · 2023-01-26T11:14:16Z

@rafaelsmith no not for me but i could help you with the import you can contact me in discord if you want erkenzjordi#5675

simonhamp · 2023-01-26T16:09:02Z

Hey folks. Please if you can, share the relevant CSV import code, a sample of the CSV data you're trying to import and any relevant DB migrations and I will be more than happy to investigate and fix.

It will be great if you could also let me know what version(s) of Nova and this plugin you've got installed.

HeadStudios · 2023-01-26T20:26:27Z

Has anyone made it work?

Yeh I had to hack core but I got it working to what I need - I basically did a conditional and I even modified drop downs and everything - I'm on Discord if you want to jump in - I'm in the Laravel group and can share what I did. But it seems like hte guy who made is around now so perhaps he can assist.

rafaelsmith · 2023-01-26T20:40:02Z

Hey folks. Please if you can, share the relevant CSV import code, a sample of the CSV data you're trying to import and any relevant DB migrations and I will be more than happy to investigate and fix.

It will be great if you could also let me know what version(s) of Nova and this plugin you've got installed.

The file very simple you can see here: https://gist.github.com/rafaelsmith/ed22e90be4c74e7945d8be3390aece63
The Nova version is v4.21.0

Thanks in advance! :)

Stefan-Dressler · 2023-02-09T08:46:01Z

Hi @simonhamp.

Firstly, thanks for providing this package. Very usefully. I have tested it yesterday and ran into the issue described here. I tried all versions and 0.4.0 is the last working version for Nova 4. We are also running on Nova 4.21.0.

Maybe this is helpful for you.

torrancemiller · 2023-02-16T22:44:27Z

It would be really great if this package worked! Has anyone made a working fork of this?

HeadStudios · 2023-02-16T23:28:54Z

It would be really great if this package worked! Has anyone made a working fork of this?

I did get this working after modifying some stuff though I don't remember exactly what I did lol, I don't think I made a fork either. But I can confirm with some slight changes it does work.

chrillep · 2023-02-25T16:55:09Z

filter out supported fields from $fieldsCollection before getting fields?

        $fieldsCollection = $fieldsCollection->filter(fn (Field $field) => !($field instanceof BelongsTo));

excludeAttributesFromImport should do this?

rafaelsmith · 2023-03-08T15:02:02Z

Hey folks. Please if you can, share the relevant CSV import code, a sample of the CSV data you're trying to import and any relevant DB migrations and I will be more than happy to investigate and fix.

It will be great if you could also let me know what version(s) of Nova and this plugin you've got installed.

Hey mate any update for us? :)

simonhamp · 2023-03-08T15:14:08Z

@rafaelsmith your file isn't a CSV... it's using semicolons. That's why it won't work... I've not configured it to support all of the weird and wonderful ways CSVs might be written...

Can you change your data so that it does use commas?

rafaelsmith · 2023-03-08T15:26:13Z

@rafaelsmith your file isn't a CSV... it's using semicolons. That's why it won't work... I've not configured it to support all of the weird and wonderful ways CSVs might be written...

Can you change your data so that it does use commas?

Thank you for your reply, unfortunately also after changing it to commas I get the same 404 error.
Also the url after upload the file is nova/csv-import/configure/1828f0efd066b0f17ef30c9d446355ea.txt

simonhamp · 2023-03-08T17:06:59Z

@rafaelsmith why is the extension now .txt? Please make sure it's a .csv file with CSV data inside. The code that handles the files won't know how to treat it otherwise

rafaelsmith · 2023-03-08T17:12:09Z

@rafaelsmith why is the extension now .txt? Please make sure it's a .csv file with CSV data inside. The code that handles the files won't know how to treat it otherwise

I export CSV file directly from Google Sheets.

hamza-darvis · 2023-03-15T10:33:26Z

Not working for
nova/csv-import/configure/f8b142ec31a75df933caeed75c2f0495.csv
Sample csv from https://sample-videos.com/download-sample-csv.php#google_vignette

simonhamp · 2023-03-15T18:14:39Z

@hamza-darvis which file did you pick to test (how many rows)? And which version of CSV import are you running?

hamza-darvis · 2023-03-16T06:01:51Z

@simonhamp 5000 rows and I'm using CSV import version 0.6.4 with nova 4

kevin-dapps · 2023-04-12T16:35:19Z

I've having the same issue as @hamza-darvis on CSV import version 0.6.4 with Nova 4.0

kevin-dapps · 2023-04-12T16:54:20Z

~~Downgrading to v0.4.0 of this package as @Stefan-Dressler advised, resolved the issue. However I would like to use the latest version if possible~~

simonhamp · 2023-04-18T11:13:57Z

@simonhamp 5000 rows and I'm using CSV import version 0.6.4 with nova 4

@hamza-darvis Thanks. I will try to look at this soon

inkly · 2023-05-02T08:02:19Z

Hello here,

I have found this 404 come when I have BelongTo relation in one of my nova ressource

simonhamp · 2023-05-02T16:39:44Z

@inkly this package currently can't handle relationships for you. There's an issue open for this already (#5)

This thread seems to mostly be related to a slightly different issue.

philsturgeon · 2023-07-11T13:10:59Z

#47 fixes this problem perfectly.

Give it a go.

{
    "require": {
        "simonhamp/laravel-nova-csv-import": "dev-fixing-belong-to-relation",
    },

    "repositories": [
        {
            "type": "vcs",
            "url":  "[email protected]:morcov/laravel-nova-csv-import.git"
        }

simonhamp · 2023-08-15T01:09:19Z

#47 has been merged and released in v0.7.0

yunior22 · 2024-02-24T00:39:02Z

Hey guys, I had the same issue with getting a 404 error. Using the Nova Tag field or a third-party multi-select field for relationships will cause the error. A workaround I’m using is creating a clone of the resource. I called it Import[Resource] to differentiate the two. Remove the relationship fields from the clone.

Set the public static $canImportResource = true; on the clone resource and false on the actual resource.

This may only be useful for some.

gcjbr mentioned this issue Jul 20, 2022

Prevent configuration from breaking on problematic Resources #45

Open

alexWaterfront closed this as completed Jul 21, 2022

alexWaterfront reopened this Jul 21, 2022

chrisvasey mentioned this issue Feb 15, 2023

Error 404 after upload CSV File #53

Closed

simonhamp added the bug Something isn't working label Mar 5, 2023

simonhamp self-assigned this Jun 14, 2023

This was referenced Jul 4, 2023

404 in dev, not in production #69

Closed

404 Page after uploading CSV file #71

Closed

philsturgeon mentioned this issue Jul 11, 2023

Fixing belong to relation #47

Merged

404 Error after upload #44

404 Error after upload #44

Comments

alexWaterfront commented Jul 7, 2022

HeadStudios commented Jul 20, 2022

jigsawsoul commented Jul 21, 2022

HeadStudios commented Jul 21, 2022

alexWaterfront commented Jul 21, 2022

HeadStudios commented Jul 21, 2022

gcjbr commented Jul 23, 2022

HeadStudios commented Jul 24, 2022

archambaultalex commented Jul 25, 2022

gcjbr commented Jul 25, 2022

HeadStudios commented Jul 25, 2022

gcjbr commented Jul 25, 2022 via email

HeadStudios commented Jul 25, 2022

petervandijck commented Jul 25, 2022

HeadStudios commented Aug 8, 2022

morcov commented Aug 12, 2022 • edited Loading

HeadStudios commented Aug 12, 2022

pedami commented Aug 13, 2022

HeadStudios commented Aug 13, 2022

HeadStudios commented Aug 13, 2022

HeadStudios commented Aug 13, 2022

morcov commented Aug 13, 2022

HeadStudios commented Aug 13, 2022

pedami commented Aug 13, 2022

HeadStudios commented Aug 13, 2022

pedami commented Aug 13, 2022

HeadStudios commented Aug 14, 2022

HeadStudios commented Aug 18, 2022

Erkenz commented Jan 26, 2023 • edited Loading

simonhamp commented Jan 26, 2023

HeadStudios commented Jan 26, 2023

rafaelsmith commented Jan 26, 2023

Stefan-Dressler commented Feb 9, 2023

torrancemiller commented Feb 16, 2023

HeadStudios commented Feb 16, 2023

chrillep commented Feb 25, 2023 • edited Loading

rafaelsmith commented Mar 8, 2023

simonhamp commented Mar 8, 2023

rafaelsmith commented Mar 8, 2023 • edited Loading

simonhamp commented Mar 8, 2023

rafaelsmith commented Mar 8, 2023

hamza-darvis commented Mar 15, 2023 • edited Loading

simonhamp commented Mar 15, 2023

hamza-darvis commented Mar 16, 2023 • edited Loading

kevin-dapps commented Apr 12, 2023

kevin-dapps commented Apr 12, 2023 • edited Loading

simonhamp commented Apr 18, 2023

inkly commented May 2, 2023

simonhamp commented May 2, 2023

philsturgeon commented Jul 11, 2023

simonhamp commented Aug 15, 2023

yunior22 commented Feb 24, 2024

morcov commented Aug 12, 2022 •

edited

Loading

Erkenz commented Jan 26, 2023 •

edited

Loading

chrillep commented Feb 25, 2023 •

edited

Loading

rafaelsmith commented Mar 8, 2023 •

edited

Loading

hamza-darvis commented Mar 15, 2023 •

edited

Loading

hamza-darvis commented Mar 16, 2023 •

edited

Loading

kevin-dapps commented Apr 12, 2023 •

edited

Loading