Ricerca
Chiudere
  1. Benvenuto
  2. I Forum
  3. The Delcampe Website
  4. Lister, import from CSV - delimiter problem.
Elenco dei foro Elenco dei messaggi

Lister, import from CSV - delimiter problem.

  • montcau
    montcau 100% (56403x)
    standard

    14 messaggi

    Spagna

    Hello there.

    I started to use Lister but I got problems with CSV delimiter.

    I have item descriptions in an external database that includes some HTML formated text. Some HTML tags include semicolon this is a problem with CSV format.

    I guess that in this case I should enclose all text with quotes but I got no succes with that.

    Someone can haelp me in one of this ways
    1 - change CSV delimiter to other character (p.e. pipe)
    2 - how to do to include delimiter character inide a text field

    Thanks in advance
    Montcau
  • montcau
    montcau 100% (56403x)
    standard

    14 messaggi

    Spagna

    Hello there.

    I started to use Lister but I got problems with CSV delimiter.

    I have item descriptions in an external database that includes some HTML formated text. Some HTML tags include semicolon this is a problem with CSV format.

    I guess that in this case I should enclose all text with quotes but I got no succes with that.

    Someone can haelp me in one of this ways
    1 - change CSV delimiter to other character (p.e. pipe)
    2 - how to do to include delimiter character inide a text field

    Thanks in advance
    Montcau
    • Creato 26 ago 2009 a 09:57
    • #251676
    Hi. I still have this problem and I'm looking for a correct
    solution, meanwhile I bypassed this problem with a small program
    that changes semicolon character (;) after import (I know that is a
    dangerous and not polite way to solve it). It seems that Lister
    don't follow CSV file especifications (or perhaps it could be a
    national character problem) because in a CSV file any character can
    appear if all field is surrounded by quotes. I started a new item
    from scratch and I wrote semicolon characters in description field.
    Afterwards I exported it to a CSV and .... surprise!, Lister
    changed semicolon characters to commas (??). Lister recognices this
    character in export function but I couldn't find the way to do it
    in an import function. I still waiting for help. Montcau
  • Account eliminato
    Account eliminato

    0 messaggi

    Stati Uniti

    Hi. I still have this problem and I'm looking for a correct
    solution, meanwhile I bypassed this problem with a small program
    that changes semicolon character (;) after import (I know that is a
    dangerous and not polite way to solve it). It seems that Lister
    don't follow CSV file especifications (or perhaps it could be a
    national character problem) because in a CSV file any character can
    appear if all field is surrounded by quotes. I started a new item
    from scratch and I wrote semicolon characters in description field.
    Afterwards I exported it to a CSV and .... surprise!, Lister
    changed semicolon characters to commas (??). Lister recognices this
    character in export function but I couldn't find the way to do it
    in an import function. I still waiting for help. Montcau
    • Creato 29 ago 2009 a 03:59
    • #251956
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
  • Account eliminato
    Account eliminato

    0 messaggi

    Stati Uniti

    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
    • Creato 2 apr 2011 a 10:03
    • #329506
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
  • Account eliminato
    Account eliminato

    0 messaggi

    Stati Uniti

    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
    • Creato 2 apr 2011 a 10:37
    • #329508
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
  • mainlypostcards
    Conto chiuso
    free

    3540 messaggi

    Regno Unito

    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
    • Creato 2 apr 2011 a 14:36
    • #329539
    Do they show in your "My Delcampe"?
    There has been a delay these last few days with items appearing in your store.
    If they are visible in your control panel, they will appear in your store withing the next hour or so.
  • Account eliminato
    Account eliminato

    0 messaggi

    Stati Uniti

    Do they show in your "My Delcampe"?
    There has been a delay these last few days with items appearing in your store.
    If they are visible in your control panel, they will appear in your store withing the next hour or so.
    • Creato 2 apr 2011 a 15:54
    • #329556
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
  • montcau
    montcau 100% (56403x)
    standard

    14 messaggi

    Spagna

    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
    • Creato 2 apr 2011 a 10:37
    • #329508
    Hello Noernberg.
    Thanks for information included, unfortunately I still have this problem active. "List separator" is set to semicolon. With your response you have opened a new point of view that I can explore, just a question.

    Does your source data contains semicolons? (your data on Excel). My source data does.

    Thanks
    Montcau
  • Account eliminato
    Account eliminato

    0 messaggi

    Stati Uniti

    Hello Noernberg.
    Thanks for information included, unfortunately I still have this problem active. "List separator" is set to semicolon. With your response you have opened a new point of view that I can explore, just a question.

    Does your source data contains semicolons? (your data on Excel). My source data does.

    Thanks
    Montcau
    • Creato 4 apr 2011 a 17:48
    • #329919
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
  • montcau
    montcau 100% (56403x)
    standard

    14 messaggi

    Spagna

    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).
    • Creato 5 apr 2011 a 06:07
    • #330000
    Hi noernberg.

    In my text I have (a few) formated html tags that need semicolons. I haven't do the execise of remove them because my first option is to keep the text as is (suitable for other uses). I use an 'had oc' program to convert Delcampe repository before send it.

    In Lister version 2, repository is an XML Document and correction is quite easy, in current version repository is a tiny SQL database and it will requiere another solution.

    Looking forward your solution (simplyfiing text) is the most stable and valuable.

    Thansk again
    Montcau