re-importing issues

This topic contains 25 replies, has 2 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

Tagged: 

  • Author
    Posts
  • #60033

    Steve
    Full Member
    Post count: 1019

    I made Open Office the default .csv file to use in our work station so excel is not in the picture.

    I uploaded “successfully” some 5000 plus listings. I forgot to update the expiration date and started to receive thousands of emails so I did the following:

    1. I exported (downloaded) the recently installed listing.
    2. I added in the expiration date field
    3. I saved as .csv with a revision date in the name so as to identify
    4. I selected “Update listing if post with post_id_already exists

    Results. “nothing” nothing… no error no nothing after selecting the file and clicking on “Select & Upload CSV” button.

    I really need to get a handle on how to import and export data. Seriously.

    #60076

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    please upload the file somewhere so that we can download it. It is too big to upload it here.

    Also we would your website credentials to test it and see what’s wrong.

    Let us know,

    Thanks

    #60082

    Steve
    Full Member
    Post count: 1019
    This reply has been marked as private.
    #60088

    Steve
    Full Member
    Post count: 1019
    This reply has been marked as private.
    #60282

    Steve
    Full Member
    Post count: 1019

    I set up the website credential and uploaded the file to Sharefile on Friday. If we cannot import/export large data then this is a “limitation” of the program. This “kind” of limitation is why I “switched” from the last directory plugin.

    When I read “easily” import large data I as sold. I would be willing to “invest” in a way that will allow me to import data file with up to a 100,00 to 300,000 records at once without losing several weekends and hours of time hunting for “instruction” and methods.

    I have nixed the excel and only use Open Office and still I cannot get this to work. Does anyone know how to make this work.

    I am on a dedicated linux server with 4 quad processors and 16 gb ram.
    This is not a VPM.

    I was successful on uploaded 4,000 records until it quit. Then, because I forgot to put an “expiration date” on the uploads I started getting thousands of expiration emails.

    So, I downloaded the “imported” file and added the “expiration date” to all the listing and tried to “update” the listings. No results at all..

    Is it true? Can we handle “import/export” large data easily?
    Kind regards,

    #60343

    Paolo
    Site Admin
    Post count: 31206

    HI,

    that email address doesn’t exist. Please only use the forum to send us information. Just copy the link here for us to download the file.

    We have users who uploaded up to hundreds of thousands of listings without problems. However you have to compile the CSV file with great attention. A single error can make your import fail.

    Let us know,

    Thanks

    #60346

    Steve
    Full Member
    Post count: 1019
    This reply has been marked as private.
    #60428

    Paolo
    Site Admin
    Post count: 31206

    The file is not formatted correctly. It is using Semicolon as separator instead of Comma.

    To correct this you can do the following:

    a Click on Save as
    b Enable “Edit filter settings”
    c Change separator from semicolon to comma

    Thanks

    #60511

    Steve
    Full Member
    Post count: 1019

    Great. Presto! ticked comma, ticked text delimeter ” Worked just fine. Thank you for your patience and support. Oh no! I spoke too soon. The file uploaded this time (6mb) but when I clicked on import data now “nothing” happened. No error message just.. nothing.

    #60515

    Steve
    Full Member
    Post count: 1019
    This reply has been marked as private.
    #60633

    Steve
    Full Member
    Post count: 1019
    This reply has been marked as private.
    #60647

    Paolo
    Site Admin
    Post count: 31206

    Something that is definitely wrong are regions.

    You can’t use codes. AL, CA must be Alabama and California.

    Another thing that you can try is to break down the file in smaller ones. It could be that your max upload file size is lower than 6mb?

    Thanks

    #60666

    Steve
    Full Member
    Post count: 1019

    Thank you.

    fyi.. max upload 100mb. Network multi-site network is equal to or more than 100mb.

    I will change the codes and try again.

    Thank you.

    In my manage locations I have both CA and California, thus the reason the download would not work. (This is because I uploaded CA, AZ correct?)

    Is there a way to bulk/batch correct CA to California in GD multi-locations and then I can re-download and correct the expiration dates and re-upload without errors?

    Or, will I have to manually go in and change them one at at time?

    #60668

    Steve
    Full Member
    Post count: 1019

    Picture of mulit locations list and SEO regions

    #60672

    Paolo
    Site Admin
    Post count: 31206

    that is a gigantic mess, you’ll probably clean it faster directly in the database.

    It could take days to clean up that by merging locations…

Viewing 15 posts - 1 through 15 (of 26 total)

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

Open Support Ticket