1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Import-Export CSV File-- why first element have --> i>>¿"codigo_oferta"

Discussion in 'Community' started by javier94, Jul 13, 2019.

  1. javier94

    javier94 Member

    Level: Community
    i have to export a list in archive Excel in format Csv.. and once exported.. filled with some datas and try to import...

    when i export.. in the first element selected.. appears ï>>¿" codigo_oferta" --> when the element name is only codigo_oferta .. the rest of elements exported are perfect...

    How can i do to delete the extra characters appears in the first element.. i have not try.. but i think that if the first element have this special character when i try to import.. will not run.. because the element in the import list and the excel element dont have the same name...

    or.. i can add this extra characters to the element placed in the import list??

    thanks in advance!!

    Javier
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    I can't replicate. It's looking like BOM which is needed for Excel with UTF8.

    Check your export settings (CSV/ExcelCSV, file format, file encoding) and your import settings.
     
  3. javier94

    javier94 Member

    Level: Community
    ok i checked in file encoding and change from default --> to UTF 8.. but the first element exported.. have same .. special characters..
    should be other thing.. i'll investigate.
    many thanks!
     
  4. troester

    troester Well-Known Member Staff Member

    Level: Community
    Where do you see these characters: in Excel, in Notepad...?
     
  5. javier94

    javier94 Member

    Level: Community
    IN EXCEL
    As you can see always in 1st element.. have the same special characters

    Captura de pantalla 2019-07-15 a las 17.19.52.png
     
  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    Strange.
    What are your export settings?
    Which version of Excel, which OS?
     
  7. javier94

    javier94 Member

    Level: Community
    Exports setting

    whats-19.PNG whats-20.PNG

    excel version . 14.0.0
    ios Mojave version 10.14.5
     
  8. troester

    troester Well-Known Member Staff Member

    Level: Community
    So this is IOS-Excel?
    Try with other file encodings (e.g. Mac Roman) and/or with CSV instead of ExcelCSV.
    Excel is :eek:... It would be to easy to support UFT8 out-of-the-box

    upload_2019-7-15_19-8-43.png which is thought for Windows, I don't know what is best for IOS
     
  9. javier94

    javier94 Member

    Level: Community
    the special characters appears with Mac.. with pc.. is perfect!!

    thanks!
     

Share This Page