CSV still not working properly

  • Resolved ncsuguy77

    (@ncsuguy77)


    8 years, 10 months ago

    When I upload a CSV, comma delimited, it is uploading the first row into the fields table, but it is not uploading any data into the inputs table. When I manually enter in data into each field via the plugin they show up in the table for inputs. I am unsure if this is a bug or if there is some type of work-around where I can manually update this via mysql. The files are showing up correctly in the uploads portion of the plugins folder as well.

    All settings inside Mysql and PHPmyAdmin for local-infile show as ON. I would be happy to pay for this being fixed as this is a critical tool for my sales team once completed.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter ncsuguy77

    (@ncsuguy77)

    8 years, 10 months ago

    I spent the weekend working on this– I did manage to figure out the problem, and hopefully this will help others. At first I thought it was a local-infile issue, but was an actual issue with the CSV. The original CSV had 9 columns and 20,000 rows with a file size around 1500K. I ran a special program through to replace all of the commas, and I was able to load the first 1500 lines. When I try to upload 1750 lines, t I get the same error showing the form with categories, but no data. I viewed these suspect 250 rows using a simple text viewer instead of excel, and managed to see there were about 10-15 “spaces” after the text in 4 fields. Once I removed these spaces, the CSV was able to load. The new issue I am having is that the upload is stalling or erroring out which I think is due to the number of rows in the CSV. My first guess will be that its a setting in mysql. I will follow up when this is complete, so other people aren’t searching for a problem in wrong place.

    Thread Starter ncsuguy77

    (@ncsuguy77)

    8 years, 10 months ago

    I had to upload it a couple of times, but eventually it loaded!

    wilburlikesmith

    (@wilburlikesmith)

    8 years, 8 months ago

    When I upload CSV in the backend, it creates a new table each time with no entries.

    I’ve manually created enteries via the form and downloaded that CSV to see the difference and I’m at a complete loss :/

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘CSV still not working properly’ is closed to new replies.

Tags