Closed
Issue #26 · created by Didier BARRET (Edited )


Failed to get it to work with this csv file.

Antoine,

I have tried the csv import. It failed when the file is not at exactly the right format or also when the file is at the right format, and the message is quite opaque actually.

Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

In all cases, you should provide a template csv file for upload so that people can see what they have to provide.


2 participants
  • Goutte a white 256x256
    Antoine Goutenoir @agoutenoir

    Hello !

    I have to choose a format ; I picked the default format when exporting using Excel, as is recommended by the library.

    Can you provide the CSV file you mention that breaks the form ?


    This may be unsolvable, since there are so many ways to describe a CSV file.

    The best course of action is probably to provide a template as you suggest.

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • Goutte a white 256x256
    Antoine Goutenoir @agoutenoir

    I tried with as many broken CSV files as I could, I could not reproduce that error.

    Perhaps it was too big ? There may be server limitations on file size. I think the default limit is 2Mio. I can bump it on my server, but I'm not sure it'll be as easy when we're in prod on IRAP's servers.

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • 1127e5563faaae39931e60e85fb9f7c4?s=40&d=identicon
    Didier BARRET @dbarret

    Have you tried with the one I sent you? it breaks the tool.

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • Goutte a white 256x256
    Antoine Goutenoir @agoutenoir

    Thanks ! It's all about exotic character encodings:

    You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.
    

    I've added the file here for future reference.


    I'm on it !

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • Goutte a white 256x256
    Antoine Goutenoir @agoutenoir

    Pfew ! The patch needs further testing, but the provided CSV file now works.

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • Goutte a white 256x256
    Antoine Goutenoir @agoutenoir

    Closing this, don't hesitate to re-open it if the issue arises again.

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.
  • Goutte a white 256x256 Antoine Goutenoir @agoutenoir

    Status changed to closed

    Edit in fullscreen
    Comments are parsed with GitLab Flavored Markdown
    Attach images (JPG, PNG, GIF) by dragging & dropping or selecting them.