Home  ›  How to Cancel a Bulk Upload on Discogs

How to Cancel a Bulk Upload on Discogs

Written By Tuesday, April 12, 2022 Add Comment Edit

  • Underafiver over 4 years agone

    Underafiver edited over 4 years ago

    Hi there fellow Oggers,
    I've merely downloaded my inventory and made some edits to the "comments" field inside the csv file but was wondering if I re-upload it, will it overwrite my existing inventory or duplicate everything?

    I'm also not sure if SOLD items volition be fabricated For Auction again?

    Anyone know how to overwrite it without duplicating? I don't want to mess this up. Also wondering if in that location are whatsoever pitfalls/snags that I need to know well-nigh? I unremarkably detect out these theings by trial & error but this is a bit daunting for me as I've never done it earlier. Is it really every bit simple as just pressing the upload button?

  • massenmedium over 4 years agone

    Accept you read this?

    https://support.discogs.com/hc/en-usa/articles/360001578574-Seller-FAQ#howbulkup

    I don't utilize it only I expect if the listing ID is the same it volition update it.

    Underafiver
    I'm as well non sure if SOLD items will exist made For Auction again?

    Important: All inventory items will default to "For Sale" status once your inventory has been uploaded. Make certain you delete all "Sold" items from your inventory earlier uploading the file.

  • Underafiver over 4 years agone

    OK thanks, I will delete sold items. Not entirely sure what you mean by "listing ID" though. Practice you lot mean the name of the file?

  • massenmedium over four years agone

    Doesn't each listing have an ID number?

  • massenmedium over 4 years ago

    If you rename the thread something to do with bulk uploading inventory you might go replies from people who apply that feature.

  • Underafiver over 4 years ago

    Yes but how practise you know it'due south non just the ID for the product & not my listing?

  • Underafiver over 4 years ago

    Good idea. I inverse it to "How practise I bulk upload my listings without duplicating data?" Do y'all reckon thats OK?

  • Underafiver over 4 years ago

    Hopefully this is a better mail service title....Can anyone help me with bulk uploading inventory without duplicating data?

  • BackBayRecords over iv years ago

    Have the download file and delete whatsoever items which are sold or draft. That should leave you with just for sale items.

    Change the comments field as you lot please and save the file as a new csv.

    Every item has a unique listing id (the first column of your download) as long as yous select "change listing details" in the majority upload and make sure that your listing id field is still in that location, then the upload will only overwrite annihilation you modify e.g. comments and will not create a indistinguishable.

    And don't forget , if you make a mistake you will nevertheless have your original download that you started with to put everything right.

  • Underafiver over 4 years ago

    Oh correct, yep I had already made a copy but forgot that if I spiral information technology up I can just upload the original file. Duh! Thanks for pointing that out.

  • Underafiver over 4 years ago

    Underafiver edited over 4 years ago

    Well I followed your instructions but it has not gone to program! Instead of replacing the text for all my 12" & LPs with.... UK mail service £iv.95 for two-7 LPs/12" or £v.95 for 1 LP/12" or Buy v and get the cheapest FREE it replaced it with two words "Great britain Post" and has removed everything else... all the comments about dissever covers, writing on label, with lyric sheet etc...... all gone. It's all there in the csv file but it does not show upwardly on the site.

  • Underafiver over 4 years ago

    I take had to remove my entire inventory from sale until Discogs or someone tin assistance. Comments for all LPs & 12" will not display properly. Why is this happening? Last fourth dimension I contacted Discogs about a problem it took them four days to answer so it looks like I'grand going to loose my sales for this weekend.

  • nerdfly over four years ago

    Underafiver
    it looks like I'thou going to loose my sales for this weekend.

    but replace with the original, untouched file again

  • Underafiver over iv years ago

    I accept already tried that. It doesnt piece of work. Still missing

  • Underafiver over 4 years agone

    Underafiver edited over 4 years ago

    This is what happens with my original file of which I deleted all SOLD items.....

    CSV file contains 749 records.
    Skipped row 2 considering ERROR: listing_id 642572943 was previously Deleted
    Skipped row 3 considering Fault: listing_id 643220972 was previously Deleted

    Skipped row 417 considering ERROR: listing_id 653450424 was previously Deleted
    Skipped row 418 because Fault: 673585366 is an invalid listing_id

    Skipped row 566 considering ERROR: 673778264 is an invalid listing_id
    Skipped row 567 because Fault: 680472619 is an invalid listing_id
    Skipped row 568 because Error: 680378109 is an invalid listing_id
    Skipped row 569 because ERROR: listing_id 680323002 was previously Deleted
    Skipped row 570 considering ERROR: 678566825 is an invalid listing_id
    Skipped row 571 because ERROR: listing_id 680365985 was previously Deleted
    Skipped row 572 because Error: 673773897 is an invalid listing_id
    Skipped row 573 because ERROR: 673778014 is an invalid listing_id
    Skipped row 574 because ERROR: listing_id 673634282 was previously Deleted

    Skipped row 579 because ERROR: 673777416 is an invalid listing_id
    Ski
    Skipped row 747 because Error: 737162686 is an invalid listing_id
    Skipped row 748 considering ERROR: 737163305 is an invalid listing_id
    Skipped row 749 because ERROR: listing_id 745917433 was previously Deleted
    Skipped row 750 because Fault: 673494598 is an invalid listing_id

  • 8892sales over 4 years ago

    Personally think editing via bulk uploading / downloading not simply is tedious, impractical and fourth dimension consuming simply there'due south always a chance of mistakes occuring etc Information technology would be so much more preferable if there was a fashion of multi edits without downloading anything and existence able to update alive in real time via discogs. Even profile/settings updating changes aren't viewable prior to hit the SAVE button.

  • nerdfly over 4 years ago

    Perhaps you lot could trim back some of the above? We get the message afterwards the kickoff couple of lines ;)

    Did you choose the "Change listing details" option in the bulk upload?

  • Underafiver over 4 years ago

    I wish someone had said that before I got into this mess. What is the signal of the bulk uploading feature if it doesn't actually work? It should come with a Warning Use at you own risk!

  • Underafiver over iv years ago

    Underafiver edited over 4 years agone

    nerdfly
    Did you choose the "Change listing details" option in the majority upload?

    Yep I used Change listing details as instructed I also used the Add option but that duplicated everything so I deleted my inventory & uploaded it again. At the moment it's in draft mode. Pitiful almost the long bulletin but I but wanted to show how much work is ruined. I deleted my entire inventory & uploaded it over again

  • Underafiver over 4 years agone

    Am I getting these errors because I've tried to "Change listings" while my inventory is in Typhoon mode?

  • Underafiver over four years ago

    I have just noticed the Upload Status study on Discogs is non the same as the report I received by email?

    Skipped row 749 considering ERROR: release_id is a required field and non in this row.

  • massenmedium over 4 years ago

    Underafiver
    Am I getting these errors because I've tried to "Change listings" while my inventory is in Draft manner?

    I would recall so. The errors suggest information technology considers the listings to be missing or "previously deleted", so they can't be "Inverse".

    Why don't y'all apply "Add", making sure to delete Sold listings before uploading the file.

  • massenmedium over four years ago

    Underafiver
    replaced it with two words "UK Post" and has removed everything else... all the comments virtually split up covers, writing on characterization, with lyric sail etc...... all gone.

    Tin you cut and paste an example list from your file that has both this standard text and some condition comments?

  • Underafiver over four years agone

    Underafiver edited over 4 years ago

    massenmedium
    I would call up so. The errors advise it considers the listings to be missing or "previously deleted", so they can't be " Inverse".

    Why don't you use "Add together", making sure to delete Sold listings before uploading them.

    The Previosly deleted flake is not the problem...

    This is the problem. Two different reasons given...one on site the other by e-mail

    Fault: 673778014 is an invalid listing_id

    Fault: release_id is a required field and not in this row.

  • massenmedium over iv years ago

    massenmedium edited over four years ago

    Underafiver
    The Previosly deleted chip is not the problem...

    Well the error indicates something.

    I saw the others that's why I said -

    massenmedium
    The errors propose it considers the listings to be missing or "previously deleted", so they can't be "Changed"

    Anyway, if yous use "Add" this shouldn't exist an consequence.

    Nevertheless, this -

    Underafiver
    ERROR: release_id is a required field and not in this row.

    Suggests there might be another problem. It might exist useful to come across an example listing row.

  • Underafiver over iv years ago

    massenmedium
    Suggests at that place might exist some other trouble. It might be useful to see an example list row.

    OK Here's an instance listing row from Excel

    651172595 Bob Dylan Hard Pelting CBS ASF 1908 LP, Album 10996398 For Sale 4 12/05/2018 05:thirty Volition post up to 7 LP's for £4.xc or up to 30 LP's for £eight.95 Looks a bit rough but plays well. Practiced Plus (1000+) Very Good Plus (VG+) Northward 230 1 0 AZ rack one

    massenmedium
    Suggests there might be another problem. It might be useful to see an instance listing row.

  • massenmedium over 4 years agone

    No, not from excel from the file.

    I'd need to see exactly what is being uploaded including the separators.

  • Underafiver over iv years ago

    Underafiver edited over 4 years ago

    massenmedium
    No, not from excel from the file.

    I'd need to see exactly what is being uploaded including the separators.

    I exercise appreciate your input. Thank you. Where practise I detect the seperators and how do I upload them here? I'm not very technical when it comes to databases...I don't fully understand what you mean when you say "non from the Excel file". I idea I was meant to exist working with the csv file using Excel. Am I using the wrong software? I have been using Microsoft Excel 2010

  • nerdfly over iv years agone

    listing id: 651172595
    release id: 10996398 = Hard Pelting

  • Underafiver over 4 years ago

    nerdfly
    listing id: 651172595
    release id: 10996398 = Hard Rain

    I understand the listing ID is 651172595 and that it relates to a product ID which is 10996398 and that production ID translates to Hard Rain but I don't understand what I am being asked to exercise when massenmedium said "I'd need to see exactly what is being uploaded including the separators" or "an example listing row."

  • massenmedium over 4 years ago

    Underafiver
    Where do I observe the seperators and how do I upload them here? I'1000 not very technical when it comes to databases...I don't fully understand what yous mean when you say "not from the Excel file". I

    I hateful merely copy and paste a row from the CSV file that Excel saves. It'due south just a text file so you can open it in Wordpad or something.

    The separators are the commas or semicolons; what I'm wondering is if y'all have some actress separators in the comments somewhere which is confusing the upload.

  • sublemon over four years ago

    what i do is download the file, open using the spreadsheet plan of your choice, sort by condition and remove anything that is not "for auction" or whatnot, make desired changes, resave in original file format, and upload. never had any issues doing this

  • EarDrops over four years ago

    nerdfly
    Perhaps you lot could trim back some of the to a higher place? We become the message after the first couple of lines ;)

    Yeah, but you don't understand. It's a Nightmare!

  • beatchapter over 4 years ago

    beatchapter edited over 4 years ago

    ??????????????????

  • beatchapter over 4 years ago

    beatchapter edited over 4 years ago

    Yes. That is exactly what I did.

  • massenmedium over 4 years ago

    beatchapter
    This is exactly what I did. I highlighted it & pasted here.

    OK. Shouldn't there be commas betwixt the values?

  • beatchapter over four years ago

    beatchapter edited over four years ago

    I don't encounter any in my database .

  • SchusterBach over iv years ago

    if you want to add this item for auction https://www.discogs.com/Cassie-Me-U-Remixes/release/7844050?ev=item-vc you should practice this
    release_id,price,media_condition,sleeve_condition,comments
    7844050,x.fifty,About Mint (NM or M-),Most Mint (NM or M-),"This is my comment"

    If you want to change the toll on information technology
    listing_id,price,accept_offer,comments
    751489714,30.50.N,"This is a summer sale"

    start with a text file with merely 2 rows for testing

  • massenmedium over 4 years ago

    beatchapter
    No. I don't run into any in my database .

    Y'all mean in the CSV file.when viewed in a text editor like Wordpad?

    OK, well there should be commas separating the values - if you look at the original CSV file y'all downloaded you should encounter that.

    So mayhap something is going incorrect with the export from Excell?

  • massenmedium over iv years ago

    SchusterBach
    commencement with a text file with but ii rows for testing

    They take nigh 1200 items previously listed that need updating.

    OK, for testing, I meet.

  • SchusterBach over iv years agone

    8892sales
    Personally think editing via majority uploading / downloading non only is irksome, impractical and fourth dimension consuming just there's ever a hazard of mistakes occuring etc

    I have created a access database, where i load the "downloaded" file into. I can do any alter (toll up/down, add/update/remove text etc) in seconds. The export it to a text file and uploaded information technology. This a now a daily routine for my mamagement of my inventory

  • SchusterBach over 4 years ago

    massenmedium
    They have about 1200 items previously listed that need updating.

    notwithstanding start with a few lines, until it's under control….
    So extend it to fifty lines... correct the mistakes
    Extend to 200 lines, right the mistakes

  • SchusterBach over 4 years ago

    massenmedium
    OK, for testing, I see

    Correct :-)

    I am update 24073 (and counting) that way

  • massenmedium over 4 years ago

    beatchapter
    651172595 Bob Dylan Hard Pelting CBS ASF 1908 LP, Anthology 10996398 For Auction iv 12/05/2018 05:30 Volition post up to 7 LP's for £iv.ninety or up to 30 LP'due south for £eight.95 Looks a bit rough but plays well. Good Plus (One thousand+) Very Good Plus (VG+) Due north 230 ane 0 AZ rack 1

    Also fields with things like descriptions should be enclosed in "" so this doesn't look correct at all.

  • massenmedium over iv years ago

    SchusterBach
    I am update 24073 (and counting) that manner

    I think it should be simple, though:

    i. Export the inventory.

    2. Import into Excel

    three. Sort past the status column.

    4. Delete rows with status SOLD, Draft, EXPIRED or VIOLATION.

    5. Make the changes to comments or whatever.

    6. Export every bit CSV file.

    7. Upload to Discogs using Change listing details.

    Does that sound right?

  • seveninch over four years ago

    massenmedium
    at that place should be commas separating the values

    ...unless it has been saved as tab-separated...

  • funprox over iv years ago

    The trouble seems to have occurred because of the pound sign in your descriptions (UK post £4.95).
    Maybe because the file didn't take UTF-eight as the character gear up.

  • massenmedium over 4 years ago

    seveninch
    ...unless information technology has been saved as tab-separated...

    Yes, and that would explain the problem uploading.

    funprox
    The problem seems to have occurred because of the pound sign in your descriptions

    Something funny at that place but I recollect the delimiters being wrong or missing is a bigger problem?

  • massenmedium over 4 years ago

    OK, beatchapter when you lot export the CSV file from Excel make sure it's in the original format and the separator / delimiter is commas and not tabs or something else.

  • SchusterBach over 4 years ago

    massenmedium
    Does that sound right?

    that is 100% correct.

    Stride two: It'southward important to import it into Excel. Recollect to fix the "separator" as ",". Also retrieve to set the decimal separator equally ".", otherwise will information technology be handle like a ",". and the volition f...upward the import

  • SchusterBach over 4 years ago

    y'all can utilize this guide http://blogmines.com/blog/how-to-import-text-file-in-excel-2013/
    Footstep 6: Select comma
    footstep 7: Press advance: Alter the decimal separator to "."

  • Underafiver over 4 years ago

    Underafiver edited over four years ago

    SchusterBach
    if you want to add this item for auction https://www.discogs.com/Cassie-Me-U-Remixes/release/7844050?ev=particular-vc you should exercise this
    release_id,price,media_condition,sleeve_condition,comments
    7844050,x.fifty,Near Mint (NM or 1000-),Virtually Mint (NM or Thousand-),"This is my comment"

    If you want to change the price on information technology
    listing_id,price,accept_offer,comments
    751489714,thirty.50.N,"This is a summer sale"

    start with a text file with only 2 rows for testing

    My probelm is non that I tin can not upload the file. The problem is that comments virtually dissever covers, writing on characterization, with lyric sail etc are all gone.

  • SchusterBach over four years ago

    Underafiver
    The problem is that comments about split covers, writing on characterization, with lyric sheet etc are all gone.

    Do like this
    listing_id;comments
    580175007;
    580175425;
    208043967;"The only reason for VG+ in sleeve condition, is a discount punch pigsty in the barcode"

    The text needs to between " and "

  • Underafiver over 4 years ago

    Underafiver edited over 4 years agone

    OK so expert news is that I've now somehow managed to upload the original file that you can see here https://www.discogs.com/seller/Underafiver/profile?format_desc=LP&page=1

    Lets go back to the beginning & I will try to explain the problem this a chip more clearly.

    My reason for editing is to detect & replace the following text in the comments fields for LP's & 12" single just.

    "Can post up to approx half-dozen LP'due south or 12" for £4.95 or up to 30 LP's for £9.95"
    "Will mail service upwards to 7 LP's for £4.xc or upwardly to 30 LP'south for £eight.95"

    with this text

    UK post £4.95 for 2-7 LPs/12" or £5.95 for 1 LP/12" or Buy v and get the cheapest ★★😃Costless😃★★

    I tin can re-create & paste information technology in on Discogs but it was taking forever so I tried to practice it with the csv file but for some reason it erases everything but the first two words & the original comment so I cease up with just "United kingdom of great britain and northern ireland Post"

  • SchusterBach over 4 years ago

    1. Does the supersede working in excel ?
    two. Tin can you encounter the "supplant" text in your save file (the one you want to upload"
    three. Are the text in " "

  • Underafiver over iv years ago

    Underafiver edited over four years ago

    SchusterBach
    ane. Does the replace working in excel ?
    2. Can yous see the "replace" text in your salve file (the one yous desire to upload"
    iii. Are the text in " "

    1. Yep
    ii. Yes
    3. No.....the original file is what I have uploaded to Discogs. None of the text in that file has commas and it displays fine. Hither'southward a screenshot of the file https://ibb.co/g1h8td

    Here is a screenshot of the edited file I'chiliad having problames with https://ibb.co/eXd9zJ

    Tty downloading your ain inventory & y'all will not come across any commas.

  • SchusterBach over 4 years ago

    Endeavor to open the file in notepad/notepad++, to meet how information technology looks. You tin't use excel for that (This are but for updating)

    you tin do this
    "listing_id","comments"
    751833462,Test text 1
    or
    "listing_id","comments"
    751833462,"Exam text "
    I am always using the " "
    tried to take for three rows and upload these. You don't need to have all fields in the upload. only listing_id is mandatory + at least one other field

  • Underafiver over 4 years ago

    SchusterBach
    Endeavour to open the file in notepad/notepad++, to run across how it looks. You can't utilize excel for that (This are only for updating)

    OK then I opened with notepad. So at present I can come across the commas but I don't understand how this is going to help my situation as it proves there is nothing wring with the CSV file.

    653283069,Ivan Neville,If My Ancestors Could See Me At present,Polydor,834 896-1,LP,6325149,For Sale,iii,12/05/2018 05:thirty,Volition post upwardly to seven LP'south for £4.ninety or up to 30 LP's for £8.95 Almost NM.,Very Good Plus (VG+),Very Skillful Plus (VG+),Y,,230,1,0,AZ rack one

  • SchusterBach over iv years ago

    Underafiver
    OK then I opened with notepad. And so at present I tin can come across the commas simply I don't sympathize how this is going to assistance my state of affairs as it proves at that place is zip wring with the CSV file.

    Exercise this

    massenmedium
    think it should be simple, though:
    1. Consign the inventory.
    two. Import into Excel
    3. Sort past the status cavalcade.
    4. Delete rows with status SOLD, DRAFT, EXPIRED or VIOLATION.
    v. Make the changes to comments or any.
    6. Consign as CSV file.
    seven. Upload to Discogs using Change listing details.

    4.1 Delete all cavalcade except for listing ID and comments (you don't need them in the file
    five. Skip information technology
    6.one.Open the file in Notepad
    6.2 Practise a search and replace
    6.three relieve it

  • massenmedium over iv years ago

    massenmedium edited over 4 years ago

    Underafiver
    there is naught wring with the CSV file.

    Is that the original file or the edited file exported from Excel? That looks like the original annotate text. Patently the original file will exist fine.

    Anyway - there ii of import things to pay attention to -

    First, when importing and exporting from Excel brand sure the separator is set every bit a , (comma) and the decimal separator equally . (menstruum.)

    Second, whatever comments should exist enclosed in " " (that's quotation marks.)

  • Underafiver over 4 years ago

    Deplorable I don't sympathize. Are you maxim I should upload a notebook file?

    SchusterBach
    6.i.Open up the file in Notepad
    half dozen.2 Do a search and replace
    6.iii save information technology

  • massenmedium over iv years ago

    massenmedium
    Second, any comments should be enclosed in " " (that's quotation marks.)

    Really this might not be straightforward to do.

    The reason is that if you have any commas in any of the comments it will mess up the upload unless the whole comment is in " ".

    So it might be easier to manually check for those commas. Not sure if in that location'due south an easier way brusque of writing a script in Excel.

  • SchusterBach over 4 years ago

    Underafiver
    Pitiful I don't sympathize. Are yous saying I should upload a notebook file?

    YES
    Excel tin be used for
    * Updating prices through calculations
    * Remove unwanted rows, columns
    * circuitous text updating

    Notepad can be used for
    * Validating the upload file
    * Simple editing (Replace standard text)

  • massenmedium over four years agone

    Or maybe just see how information technology goes (regarding placing quotation marks around comments), maybe that won't be an issue - simply can yous confirm that was the edited exported CSV file you were looking at in Notepad?

  • massenmedium over four years ago

    I don't know if that's too many posts but here's the thing

    If when exporting (or importing) the CSV file from Excel yous lose or change the comma separators Information technology WON'T WORK.

    If yous accept extra commas in the annotate fields and the comments are not in quotation marks Information technology WON'T WORK.

  • Underafiver over 4 years ago

    Underafiver edited over 4 years ago

    massenmedium
    Second, whatever comments should exist enclosed in " " (that's quotation marks.)

    I don't utilize quotation marks in my comments that oftentimes unless I mention 12". I utilize (.) a lot & very rarely (')

    This is from the live file....you can see in that location's extra quotation marks on 12" for some reason but note it shows up fine on Discogs. Y'all are correct nigh comments starting & ending with "quotation marks" but the repacement file looks the same earlier I upload it.

    673962887,10cc,10cc,United kingdom of great britain and northern ireland Records,UKAL 1005,"LP, Anthology",4807240,For Sale,1.9,12/05/2018 05:30,"UK post £four.95 for 2-seven LPs/12"" or £v.95 for one LP/12"" or Buy 5 and get the cheapest ★★😃Gratuitous😃★★ United kingdom of great britain and northern ireland pressing in Mercury cover. Needs a clean",Very Good (VG),Very Good (VG),Y,,230,1,0,A-Z Rack 1

    Search my shop for "10cc UKAL 1005" to find the listing.

  • SchusterBach over 4 years ago

    Underafiver
    This is from the live file....yous tin run into at that place's extra quotation marks on 12" for some reason but note it shows up fine on Discogs
    SchusterBach
    4.ane Delete all column except for listing ID and comments (you don't demand them in the file

    information technology's difficult to help if you are not post-obit the guide massenmedium and i accept provide to y'all

  • Underafiver over four years ago

    I don't know how to delete a column in Excel or Notepad. I deleted the SOLD items 1 by one.

  • massenmedium over 4 years ago

    Underafiver
    673962887,10cc,10cc,UK Records,UKAL 1005,"LP, Album",4807240,For Auction,i.nine,12/05/2018 05:xxx,"UK post £iv.95 for 2-7 LPs/12"" or £5.95 for one LP/12"" or Purchase 5 and get the cheapest ★★😃FREE😃★★ UK pressing in Mercury comprehend. Needs a clean",Very Skillful (VG),Very Good (VG),Y,,230,1,0,A-Z Rack 1

    Search my shop for "10cc UKAL 1005" to find the listing.

    Looks fine.

    So information technology'southward all OK now?

  • Underafiver over 4 years ago

    massenmedium
    If you have extra commas in the annotate fields and the comments are not in quotation marks Information technology WON'T WORK.

    How do yous explain the file that's on Discogs displaying fine so?

  • massenmedium over iv years ago

    Underafiver
    I don't know how to delete a cavalcade in Excel or Notepad.

    Don't worry, no demand if it's working now.

    In Excel I recollect you tin can just right click on the column heading and select delete?

  • Underafiver over four years ago

    massenmedium
    So it'south all OK now?

    No. Yous are looking at the original file. I sent screenshots of the original & the replacement files. The " marks are on both files exactly where they should be.

  • massenmedium over 4 years ago

    Underafiver
    How do you explicate the file that's on Discogs displaying fine then?

    Because at that place'south zilch wrong with it.

  • massenmedium over four years ago

    Underafiver
    No. Yous are looking at the original file.

    But doesn't it have what you've been telling us is the replacement comment text?

    "United kingdom of great britain and northern ireland post £4.95 for 2-7 LPs/12" or £v.95 for 1 LP/12" or Purchase 5 and get the cheapest ★★😃FREE😃★★ "

  • Underafiver over 4 years ago

    massenmedium
    Considering there's cipher wrong with it.

    You are looking at the original file. I sent screenshots of the original & the replacement files. The quotation marks are on both files exactly where they should be which makes me call up that quotation marks is non the problem.

    Here'due south a screenshot of the file https://ibb.co/g1h8td

    Here is a screenshot of the edited file I'yard having problames with https://ibb.co/eXd9zJ

  • massenmedium over iv years ago

    Y'all merely said "this is from the live file" - and I'm looking at that and your bodily sales listing. It has the updated comment text. I haven't seen whatever screenshots.

    673962887,10cc,10cc,U.k. Records,UKAL 1005,"LP, Album",4807240,For Sale,i.nine,12/05/2018 05:30,"Uk postal service £4.95 for two-vii LPs/12"" or £5.95 for 1 LP/12"" or Buy 5 and go the cheapest ★★😃Free😃★★ United kingdom of great britain and northern ireland pressing in Mercury cover. Needs a make clean",Very Good (VG),Very Proficient (VG),Y,,230,1,0,A-Z Rack one

    Search my shop for "10cc UKAL 1005" to observe the listing.

  • SchusterBach over 4 years agone

    Underafiver
    Here's a screenshot of the file https://ibb.co/g1h8td

    Here is a screenshot of the edited file I'm having problames with https://ibb.co/eXd9zJ

    You need to delete all the row and columns you don't need

    If yous "Simply" want to update the "comments", then delete everything, except for listing_id and comments

    Read here how to delete in excel
    https://support.role.com/en-united states of america/commodity/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246

  • massenmedium over 4 years ago

    So OK - if that's not the edited file you want to apply open the edited exported file in Notepad and bank check it has comma separators.

  • massenmedium over four years agone

    Underafiver
    The quotation marks are on both files exactly where they should be which makes me think that quotation marks is not the problem.

    Yes, that's skillful.

    When you posted this earlier there were no quotation marks as y'all can see - so something has changed or you're doing something differently.

    Underafiver
    OK and then I opened with notepad. So now I tin see the commas but I don't sympathise how this is going to help my state of affairs as it proves at that place is nothing wring with the CSV file.

    653283069,Ivan Neville,If My Ancestors Could See Me Now,Polydor,834 896-1,LP,6325149,For Sale,3,12/05/2018 05:xxx,Will post upward to 7 LP'south for £4.90 or up to thirty LP's for £8.95 Almost NM.,Very Good Plus (VG+),Very Expert Plus (VG+),Y,,230,1,0,AZ rack 1

  • dubfunkoustic over 4 years ago

    Accept you made sure y'all're exporting from the spreadsheet in UTF-8 format? The pound sign is where it's all starting to go wrong.

  • Underafiver over 4 years ago

    dubfunkoustic
    UTF-eight format?

    I take no thought, I've never heard of UTF-eight. What is it?

  • Underafiver over 4 years ago

    dubfunkoustic
    UTF-viii format?

    I have no idea, I've never heard of UTF-8. What is it?

  • Underafiver over 4 years agone

    massenmedium
    When you posted this earlier there were no quotation marks as you can see - so something has inverse or you lot're doing something differently.

    No, this is the original file opened with notepad and the replacement file looks the aforementioned---in notepad.

    653283069,Ivan Neville,If My Ancestors Could Meet Me Now,Polydor,834 896-1,LP,6325149,For Sale,iii,12/05/2018 05:30,Will postal service upward to 7 LP's for £4.90 or up to 30 LP's for £8.95 Almost NM.,Very Skillful Plus (VG+),Very Good Plus (VG+),Y,,230,1,0,AZ rack ane

  • dubfunkoustic over four years agone

    Underafiver
    dubfunkousticUTF-8 format?

    I accept no idea, I've never heard of UTF-8. What is it?

    https://cdn.ablebits.com/_img-blog/excel-csv/txt-to-csv.png

    Encounter where information technology says Encoding at the bottom? It'due south the encoding that will preserve special characters like £.

  • mcr1 over four years ago

    I'm seeing this: https://world wide web.discogs.com/seller/Underafiver/contour
    How many should you accept for sale?
    Do yous yet have missing text?

  • massenmedium over four years ago

    Underafiver
    No, this is the original file opened with notepad and the replacement file looks the same---in notepad

    I tin can't follow what yous are doing or maxim.

    Just check the exported edited file in Notepad at present y'all know what to look for. Paste a row from that here for clarity if you could.

  • massenmedium over 4 years ago

    I mean it doesn't really thing but first there was this without quotation marks (or indeed commas). I don't call back this was from the CSV file.

    beatchapter
    This is exactly what I did. I highlighted information technology & pasted here.

    651172595 Bob Dylan Difficult Pelting CBS ASF 1908 LP, Album 10996398 For Auction 4 12/05/2018 05:30 Will post up to vii LP's for £4.90 or up to thirty LP'southward for £8.95 Looks a bit rough simply plays well. Skillful Plus (One thousand+) Very Good Plus (VG+) N 230 1 0 AZ rack 1

    Then this, which tin't be right, there must have been commas.

    Underafiver
    the original file is what I have uploaded to Discogs. None of the text in that file has commas and it displays fine. Here's a screenshot of the file https://ibb.co/g1h8td

    Then this which does have commas only no quotation marks.

    Underafiver
    OK and then I opened with notepad. So now I can run into the commas only I don't understand how this is going to help my state of affairs as information technology proves in that location is nothing wring with the CSV file.

    653283069,Ivan Neville,If My Ancestors Could See Me Now,Polydor,834 896-1,LP,6325149,For Sale,3,12/05/2018 05:30,Volition post up to 7 LP'south for £iv.90 or upward to 30 LP's for £8.95 Well-nigh NM.,Very Good Plus (VG+),Very Good Plus (VG+),Y,,230,one,0,AZ rack ane

    Then this from the "live file" with what looks like edited comments and quotation marks.

    Underafiver
    This is from the live file....you tin encounter there'southward extra quotation marks on 12" for some reason but note it shows up fine on Discogs. You are right nigh comments starting & catastrophe with "quotation marks" but the repacement file looks the same before I upload it.

    673962887,10cc,10cc,UK Records,UKAL 1005,"LP, Anthology",4807240,For Sale,one.9,12/05/2018 05:30,"UK mail service £iv.95 for two-7 LPs/12"" or £5.95 for 1 LP/12"" or Buy v and get the cheapest ★★😃FREE😃★★ United kingdom pressing in Mercury cover. Needs a clean",Very Skillful (VG),Very Skillful (VG),Y,,230,1,0,A-Z Rack 1

    Then you lot say that's actually the "original file" and now they "both" take quotation marks ?

    Underafiver
    You are looking at the original file. I sent screenshots of the original & the replacement files. The quotation marks are on both files exactly where they should be which makes me retrieve that quotation marks is non the problem.

    Just and so now this is actually the original file and at present it doesn't have quotation marks ?

    Underafiver
    No, this is the original file opened with notepad and the replacement file looks the same---in notepad.

    653283069,Ivan Neville,If My Ancestors Could Encounter Me Now,Polydor,834 896-1,LP,6325149,For Sale,3,12/05/2018 05:thirty,Will postal service up to 7 LP'southward for £4.xc or up to 30 LP's for £8.95 Near NM.,Very Skillful Plus (VG+),Very Good Plus (VG+),Y,,230,one,0,AZ rack 1

  • massenmedium over 4 years agone

    dubfunkoustic
    Have you lot made sure yous're exporting from the spreadsheet in UTF-eight format? The pound sign is where it's all starting to go wrong.

    I think what you lot're looking at is a cut and paste off the Excel page

    I don't recollect that character is the main problem, if there still is i.

  • Underafiver over 4 years ago

    Underafiver edited over 4 years ago

    massenmedium
    But and then at present this is actually the original file and now it doesn't accept quotation marks ?
    Underafiver
    No, this is the original file opened with notepad and the replacement file looks the same---in notepad.

    653283069,Ivan Neville,If My Ancestors Could Run across Me Now,Polydor,834 896-1,LP,6325149,For Sale,3,12/05/2018 05:30,Will post up to 7 LP'due south for £4.90 or up to 30 LP's for £8.95 Almost NM.,Very Expert Plus (VG+),Very Good Plus (VG+),Y,,230,1,0,AZ rack i

    This is getting a flake tangled up....
    I was originally showing the files I copied from the CSVs simply and then I was asked to show a re-create of them using notepad. There are no quotation marks or commas in the CSV live file or the replacement CSV merely in that location are quotation marks & commas in the live & replacement files if I open them with notepad.

    Both screenshots are from CSV files which is why neither of them are showing quotation marks & commas.

  • dubfunkoustic over 4 years ago

    I lost it virtually 37 plot twists ago merely I however recall the UTF-viii is worth getting correct.

  • massenmedium over 4 years agone

    Underafiver
    Both screenshots are from CSV files which is why neither of themn are showing the " or ,

    No, they won't. The screenshots are of the Excel screen. That's not the CSV file.

    All that actually matters is the edited CSV file exported from Excel because that's what you volition be uploading. That'due south what I asked to see two days ago according to the time stamp ;-)

    Underafiver
    There are no quotation marks or commas in the CSV live file or the replacement CSV but there are quotation marks & commas in the alive & replacement files if I open them with notepad.

    It'due south not, or wasn't articulate what you hateful by "live file". Alive on Discogs? Which ane was final updated? But I think this doesn't matter at present.

    Opening the CSV files in a text editor like Notepad is the only manner to see them properly. What you run across on the Excel screen is not the CSV file, it'south an Excel spreadsheet.

  • massenmedium over 4 years agone

    dubfunkoustic
    UTF-8 is worth getting right.

    I know, but what is this, it looks fine, quotation marks and commas in identify, double quotes for 12", pound sign OK.

    It'due south not articulate where this row is from but if it's what Excel is putting out at that place shouldn't exist a trouble at present.

    https://www.discogs.com/sell/particular/751850423

    673962887,10cc,10cc,United kingdom of great britain and northern ireland Records,UKAL 1005,"LP, Anthology",4807240,For Sale,1.9,12/05/2018 05:30,"United kingdom of great britain and northern ireland postal service £iv.95 for ii-7 LPs/12"" or £5.95 for i LP/12"" or Buy five and get the cheapest ★★😃Complimentary😃★★ Uk pressing in Mercury cover. Needs a clean",Very Good (VG),Very Good (VG),Y,,230,i,0,A-Z Rack 1

  • dubfunkoustic over four years ago

    OP, did yous edit that new text in manually or upload it from a CSV?

  • massenmedium over 4 years ago

    dubfunkoustic
    UTF-8

    Past the fashion this is also why i was initially suggesting Wordpad rather than Notepad considering I'chiliad non sure about Notepad'southward character set support and wanted to know what was up with that character.

  • Underafiver over 4 years ago

    dubfunkoustic
    OP, did you edit that new text in manually or upload it from a CSV?

    Yes. The edited entries were washed manually. But I got fed up doing information technology manually so I tried to do it with Excel & then I ran into the problem.

  • SchusterBach over 4 years ago

    The biggest problem is not the char gear up. It is, at the OP is mixing everything up and are not flowing the guidelines he has been provided.

    From this image https://ibb.co/g1h8td is it clear, he has not deleted the columns, so there are are only 2 columns left.
    He besides needs to delete the row there har sold, etc.

  • dubfunkoustic over 4 years ago

    That'southward true, he'southward non very good at taking advice. Even so, if he can't consign in UTF-8 there's no signal trying anything further until he can.

  • dubfunkoustic over iv years ago

    massenmedium
    dubfunkousticUTF-8
    By the way this is also why i was initially suggesting Wordpad rather than Notepad considering I'm not certain about Notepad's character set support and wanted to know what was up with that character.

    Ah, the joys of beingness a Windows user eh. I forgot virtually that but I think you're right. Employ WordPad or Notepad++ or something.

  • SchusterBach over 4 years ago

    dubfunkoustic
    Still, if he can't consign in UTF-8 there's no point trying anything further until he can.

    Yep he can, because he needs to understand the process beginning. When the procedure are in place, and char ready errors be corrected

  • Underafiver over iv years agone

    I have not deleted any columns because I thought there was is no point all the same. We have not found out why it's removing instead of replacing. Y'all mean in Wordpad nptepad or Excel...then someone said that might not work if.....

    I am mighty confused by so many dissimilar points of view.

    Please tell me if I need to do this in notepad or wordpad & how or where do I change the files to UTF-eight format?

    • arnettbizin1998.blogspot.com

    Source: https://www.discogs.com/forum/thread/772425

    0 Response to "How to Cancel a Bulk Upload on Discogs"

    Post a Comment

    Subscribe to: Post Comments (Atom)

    Iklan Atas Artikel

    Iklan Tengah Artikel 1

    Iklan Tengah Artikel 2

    Iklan Bawah Artikel