Import problems

This topic contains 5 replies, has 3 voices, and was last updated by  Paolo 8 years, 5 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #59390

    Steve
    Full Member
    Post count: 1019

    I do not know why this will not import. http://whatshappeningtoday.com
    CSV file
    latest geodir update plugin
    file size 1.8mb (system did not fail on this size upload)
    error message “invalid address / city, state, region, country

    First upload worked just fine. I am stumped

    Ok, so after the first post it started to appear that I must delete any rows with missing information. I have cleaned up the file and will attempt the upload again.

    #59417

    Guust
    Moderator
    Post count: 29970

    Any more luck now?

    #59487

    Steve
    Full Member
    Post count: 1019

    I will begin from “the beginning” starting from the “unzip” of the zip file. Here is what I am going to “change” this time around. First, I right clicked the “Excel” file icon and did the following:

    I chose “open with”
    I chose to use Open Office and the “default” program to always open zip files. Thus, avoiding even having excel involved at any time.

    I will let you know how this works. Thank you.

    Also, when importing “the columns” Latitude and Longitude… does it make a difference if the data is “Centroid” or “long-poly?”

    #59501

    Paolo
    Site Admin
    Post count: 31206

    Lat and long must be in decimal format.

    Example for Los Angeles.

    Lat : 34.0522342
    Long: -118.2436849

    Thanks

    #60065

    Steve
    Full Member
    Post count: 1019

    No luck. I change the default .csv files to all open in open office. I “exported” the recent import because I forgot to put an expiration date on the uploads. This caused a back log of email expirations.

    Now, I cannot import the corrected .csv file.

    I am losing days on this aspect of not getting imports to work and it is becoming frustrating as I work on project primarily on the weekends. So now, weeks have passed with this same import problem.

    This is a major “not good” thing.

    #60078

    Paolo
    Site Admin
    Post count: 31206

    Please keep conversation about 1 problem in 1 topic.

    You already have another topic about import/export.

    Let’s continue there.

    I’ll close this one.

    Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

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

Open Support Ticket