40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Category post's

This topic contains 20 replies, has 3 voices, and was last updated by  Dotty Directory 7 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • May 25, 2016 at 1:13 pm #197933

    Dotty Directory
    Full Member
    Post count: 254

    Okay, my data is exported from Access, to a text file CSV, imported to openoffice, then the data is copied over to the sample (also open in openoffice) i have tried removing n t

    The coloumns are all present and match, I’m going to attempt another upload now.

    May 25, 2016 at 2:10 pm #197947

    Dotty Directory
    Full Member
    Post count: 254

    Is there a list of the invalid characters ?

    Like unsupported characters

    May 25, 2016 at 5:31 pm #198078

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    it depends on the collation of your database. Normally it is utf-8.

    This would be the list: http://www.fileformat.info/info/charset/UTF-8/list.htm

    When you insert an unsupported characters, it will show a black triangle sign with a question mark in it.

    You can check what that character was supposed to be by checking the word or by opening the file with notepad.

    At that point you can do a find and replace using the correct character.

    Let us know how you went.

    Thanks

    May 26, 2016 at 11:32 am #198495

    Dotty Directory
    Full Member
    Post count: 254

    Okay, turns out i had a problem with double quotations.

    To fix this, I first saved the export as a .csv “comma delimited” but typed the extension .txt on the end. then opened the file using open office “sheet from file” and saved as a Text CSV

    All the entries are now uploading. And bar a few i missed the addresses off. They all worked.

    Hope this helps if you ever have an issue with “double quotations”.

    Thanks

    May 26, 2016 at 3:19 pm #198675

    Paolo
    Site Admin
    Post count: 31206

    Thanks for sharing 🙂

    May 26, 2016 at 3:24 pm #198688

    Dotty Directory
    Full Member
    Post count: 254

    No problem!

  • Author
    Posts
Viewing 6 posts - 16 through 21 (of 21 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket