40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Data import /export issues

This topic contains 20 replies, has 4 voices, and was last updated by  Kiran 5 years, 5 months ago.

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

Open Support Ticket
  • Author
    Posts
  • May 29, 2019 at 1:55 am #489640

    Julian Howard
    Full Member
    Post count: 47

    Hi,
    re https://pokernearme.com.au/
    For some time I have been having issues with the import / export of data in that there seem to be random changes to the data, sometimes on the site without any activity by me. In particular dates and times of events. The dates are set up in the spreadsheet in the US date style, then imported into the site. Then if they are exported as part of a data update, they revert to UK time style, and then when re-imported change the event dates. Separately to that currently nearly all of the dates on the site, with no input from me to most of the game events, have changed to just two dates for no particular reason 21st and 28th May). What is happening for these changes to occur and what can I do to make sure it doesn’t happen in the future?
    See the attached export from today which shows all the dates as the 21st when in fact they should be many and varied.
    Thanks

    Julian

    May 29, 2019 at 8:14 am #489716

    Alex Rollin
    Moderator
    Post count: 27815

    Hi!

    We will need to look into that, could you share a CSV of your import data and access to the site?
    Thanks 🙂

    May 29, 2019 at 12:41 pm #489764

    Julian Howard
    Full Member
    Post count: 47
    This reply has been marked as private.
    May 29, 2019 at 12:50 pm #489765

    Julian Howard
    Full Member
    Post count: 47

    sorry forgot to attach the files

    May 29, 2019 at 12:52 pm #489766

    Julian Howard
    Full Member
    Post count: 47
    This reply has been marked as private.
    May 29, 2019 at 5:46 pm #489825

    Paolo
    Site Admin
    Post count: 31206

    can’t upload a CSV file, you must ZIP it first.

    Thanks

    May 30, 2019 at 12:08 pm #489984

    Julian Howard
    Full Member
    Post count: 47

    Hi,
    Zipped file attached. I tried again by deleting all the pokermania games off GD and then tried to reload the pokermania file and couldnt get it to load and display no matter what. So in addition to random date changes now the games will not load.

    Thanks
    Julian

    June 4, 2019 at 12:25 pm #490769

    Kiran
    Moderator
    Post count: 7069

    Hi Julian,

    Event dates should be in yyyy-mm-dd format, because sometimes system does not identify correct date format between mm/dd/yyyy and dd/mm/yyyy.
    I have made some changes to support mm/dd/yyyy date format in importing events. It will be in next release.
    Please provide FTP credentials if you want to apply patch from our side before next release.

    Let us know.

    Regards,
    Kiran

    June 5, 2019 at 11:08 am #490962

    Julian Howard
    Full Member
    Post count: 47

    Hi Kiran,

    Thanks but the problem seems to be much bigger than just the dates. I have attached a file I have tried to upload a number of times with the correct dates and it wont load. Can you check it and tell me what Im missing? Thanks
    Julian

    June 5, 2019 at 8:00 pm #491068

    Alex Rollin
    Moderator
    Post count: 27815

    The date format you are using is not supported.
    Please write back with FTP and we will patch that.

    You have an unnamed column with value APL for all listings?
    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    June 6, 2019 at 11:29 am #491226

    Julian Howard
    Full Member
    Post count: 47
    This reply has been marked as private.
    June 6, 2019 at 11:32 am #491230

    Julian Howard
    Full Member
    Post count: 47
    This reply has been marked as private.
    June 6, 2019 at 12:59 pm #491244

    Kiran
    Moderator
    Post count: 7069

    Hi Julian,

    I have applied patch on your site, now events dates will support mm/dd/yyyy format.

    In attached csv there 2nd column name is empty, please correct it.

    Let us know.

    Kiran

    June 10, 2019 at 1:47 am #491861

    Julian Howard
    Full Member
    Post count: 47

    Hi, thanks for doing that. Im not sure if its related but since then with the games i have loaded a default expiry date of 2002 or 2004 has applied itself so the games self delete. See pic, can you check whats happening thanks julian

    June 10, 2019 at 5:39 am #491883

    Kiran
    Moderator
    Post count: 7069

    Hello Julian,

    How that listing was added? It was added from admin or from frontend or via import process?

    Let us know so i can check more.

    Kiran

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 21 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount