How to Upload CSV data

This topic contains 6 replies, has 2 voices, and was last updated by  pdqdigitalmedia 10 years, 2 months ago.

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

Open Support Ticket
  • Author
    Posts
  • February 19, 2015 at 11:42 pm #31488

    pdqdigitalmedia
    Buyer
    Post count: 57

    Hello,

    I need a little help with CSV uploads. My challenge is two fold. First we want to use SIC codes and the categories for Places (Business Listings) and need to upload those via CSV. Next challenge is that we have a database of over 75K entries. None of the instructions or methods described in the documentation fits our situation. Please advise.

    February 20, 2015 at 12:22 am #31492

    Guust
    Moderator
    Post count: 29970

    Can you explain what SIC codes are?

    You should create the categories first, and then you can upload the listings into the correct categories using the CSV file.

    Can you explain why that would not work for you?

    http://docs.wpgeodirectory.com/core-general/#csv

    February 20, 2015 at 12:27 am #31494

    pdqdigitalmedia
    Buyer
    Post count: 57

    Hello,
    Standard Industrial Classification (SIC) codes given to business types/categories in the US. We want to classify business listings according to that standard. However, the list is quite long. The issue that I am an running into with GEO Directory and its plugins has to do with “seeding” our database. You guys certainly do not intend for us to manually input thousands of records — categories, latitudes, longitudes, listings, etc. Should we be looking for another solution?

    Getting really frustrated …

    February 20, 2015 at 12:55 am #31498

    Guust
    Moderator
    Post count: 29970

    See my answer in the other post.
    Once you set up the basics, you can import thousands of records at the push of a button. But you have to set up the basics, and your records have to be able to be processed so they need to be in a certain format. There is no way round that.
    It might just be a matter of moving columns and renaming etc, and making the most of tools out there to convert addresses into lats and lng.

    February 20, 2015 at 1:21 am #31500

    pdqdigitalmedia
    Buyer
    Post count: 57

    Guust,

    You have answered everything except the main issue — the categories. NO ONE in their right mind is going to manually input thousands of line items. Not in today’s day and age. If there is not a way to upload the list via some automated process then please just kindly tell me that so that I may find a more robust solution. It been almost a month since we’ve been trying to get this thing up and running. I personally am beyond frustrated with the entire process. The GEO Directory method of getting information into the database needs to be addressed — it is weak! I chose this product because it appeared to be well documented, actively supported and aesthetically functional. However, after looking under the hood, I’m started to get buyer’s remorse. If we don’t have a solution today — like right now — I’m moving on.

    February 20, 2015 at 2:16 am #31502

    Guust
    Moderator
    Post count: 29970

    How many categories are your listings in? How many categories do you want? Thousands?
    There might be a possibility to import them straight into the database using phpMyAdmin but they are not just simply into the one table, you also need to establish the structure.
    I cannot think of any tool that imports categories directly into WP, and GD uses the same WP functions.
    You might have some luck searching at https://wordpress.org/ and I’ll alert the others too, maybe they have brighter ideas how you can import categories.

    February 20, 2015 at 4:12 am #31515

    pdqdigitalmedia
    Buyer
    Post count: 57

    Thank you for taking the time to work with me towards a solution. For other struggling with datafeed imports, I recommend https://www.smackcoders.com/store/wp-ultimate-csv-importer-pro.html

    It is well worth the investment consider the amount time it saves in the long run.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 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