CSV file import not valid – wont load your own sample either

This topic contains 18 replies, has 3 voices, and was last updated by  Stiofan O’Connor 6 years, 2 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • March 4, 2018 at 3:55 am #420167

    tina mangan
    Expired Member
    Post count: 7

    Despite all efforts…will not import anything
    Uodated licenses updates activated
    Wordpress v 4.9.4
    EG. Listings Import (sample file attached) Steps
    1. added a entries few manually
    2. added new field and data successfully
    2. downloaded sample file that included data
    3. opened in libreoffice, comma delimiter ”
    4. added data without changing column headings or position
    5. saved data CSV UTF-8
    6. FAILED over and over and over

    Even your own sample data downloaded and then imported without even opening 0- FAILS
    LOST LOST LOST

    March 4, 2018 at 4:44 am #420175

    Guust
    Moderator
    Post count: 29970

    Have the categories already been created?

    Have you added custom fields? In that case you may need to export any listings to get the right CSV format.

    Most of your listings do not have a “city”, that is required.
    https://wpgeodirectory.com/docs/core-export/#mandatory

    You should use full names of states, or you may get duplicate locations later.
    https://wpgeodirectory.com/docs/definitions/#location

    Thanks

    March 4, 2018 at 4:52 am #420178

    tina mangan
    Expired Member
    Post count: 7

    Thanks for pointing out error re city

    I did export file to cover off custom field

    I did try to import the exported file first – without changing anything to check import working but it too failed

    So cannot import at all it seems

    March 4, 2018 at 5:01 am #420179

    Guust
    Moderator
    Post count: 29970

    Please post your URL and WP admin details in a private reply, and we will check your settings.
    Thanks

    March 4, 2018 at 5:05 am #420181

    tina mangan
    Expired Member
    Post count: 7
    This reply has been marked as private.
    March 4, 2018 at 5:29 am #420186

    Guust
    Moderator
    Post count: 29970

    There are a few more problems:
    1. the date formats you use are not valid formats, check with the exported file.
    2. No need to enter post date and time
    3. The option you are using for rebate is not a valid option.

    But all that aside, there seems to be another problem, I will get the developers to have a look after the weekend. Is this the error you are getting, see image?

    We will need your FTP details too to investigate.

    March 4, 2018 at 5:33 am #420189

    tina mangan
    Expired Member
    Post count: 7
    This reply has been marked as private.
    March 4, 2018 at 5:40 am #420192

    Guust
    Moderator
    Post count: 29970

    We will need your FTP details too to investigate.
    This is most likely a server setting that we need to check.
    Thanks

    March 4, 2018 at 5:53 am #420197

    tina mangan
    Expired Member
    Post count: 7
    This reply has been marked as private.
    March 7, 2018 at 2:58 am #420594

    tina mangan
    Expired Member
    Post count: 7

    Any news on this issue – have amended all aspects with csv file you recommended, still no import capability
    Help

    March 7, 2018 at 4:32 am #420600

    Guust
    Moderator
    Post count: 29970

    I alerted the developers for you. Sorry for the delay.

    March 7, 2018 at 8:00 pm #420671

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Sorry, i replied here but i guess i was logged out and it never saved.

    The problem is strange and server related
    this on your server 

    mb_convert_case('something', MB_CASE_LOWER, $charset)

    is outputing “Something” (capital) when it should output “something”
    It should not be able to do that, please contact your hosting/server admin and ask them to fix it.

    Thanks,

    Stiofan

    March 8, 2018 at 2:24 am #420722

    tina mangan
    Expired Member
    Post count: 7

    Thanks, but can you tell me where on my server you see that ?
    Need a clue
    Tina

    March 8, 2018 at 12:26 pm #420753

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    our script uses that function, its a server function “mb_convert_case()” but your server is outputting it wrong. U can add the follwoing PHP line to any PHP file to test.

    echo mb_convert_case('something', MB_CASE_LOWER, 'UTF-8');

    Stiofan

    March 8, 2018 at 12:43 pm #420756

    Stiofan O’Connor
    Site Admin
    Post count: 22956
    This reply has been marked as private.
  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 19 total)

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

Open Support Ticket