Can you copy and post lists on the forum?

[Geoff]

This one's been a question of mine since the new format and it's time I address it. When I copy and paste from a spreadsheet, it looks like this;

1    .    Ted Poley     -    Modern Art 2    .    Station     -    More Than The Moon 3    .    No Sleep for Lucy     -    Until the End 4    .    Nitrate     -    Real World 5    .    Don Vedda     -    Hell of a Night 6    .    Self Deception     -    Self Deception 7    .    Imperium     -    Beyond the stars 8    .    W.E.T.     -    Earthrage 9    .    Gioeli, Castronovo     -    Set the World on Fire 10    .    Sapphire Eyes     -    Breath Of Ages

But how do I get it to look like this (after a sit here for 48min pressing Enter before every number);

1    .    Ted Poley     -    Modern Art

2    .    Station     -    More Than The Moon

3    .    No Sleep for Lucy     -    Until the End

4    .    Nitrate     -    Real World

5    .    Don Vedda     -    Hell of a Night

6    .    Self Deception     -    Self Deception

7    .    Imperium     -    Beyond the stars

8    .    W.E.T.     -    Earthrage

9    .    Gioeli, Castronovo     -    Set the World on Fire

10    .    Sapphire Eyes     -    Breath Of Ages

[heavyharmonies]

Geoff,

What are you using for your spreadsheet? Excel, Google Docs, or something else?

Testing a copy and paste from Excel...

Enrolled	Room Capacity Day Quota
57	120
52	120
90	300
88	300
33	150
29	150
75	210
73	210
103	230
102	230
106	128
111	128
97	220
95	220
87	135

 

Seems to retain the table structure at my end.

 

[Geoff]

How do you do this?! I also use Excel. 

If I hit Cmd V (on the Mac) a pop up message comes up to tell me that what I am trying to copy is too large. 

So I opt for Shift/Cmd/V (paste and match style) where it pastes in that first way in my post. 

How did you do your one? Do you use a PC? Is it somehow a Mac thing? 

 

[heavyharmonies]

Ctrl+c, Ctrl+v on the PC, but Cmd+c, Cmd+v on the Mac should work the same. How large of a spreadsheet are you truing to copy and paste? There might be a byte limit on what the board will accept as a paste.

Try just copying and pasting the top 10 or 20 entries and see if that works. If it does, then you might have to copy and paste in batches.

[Geoff]

Yeah, so when I try the Cmd+v option I get the message 'You are only allowed to upload 10.24kb. And yep, just trying to copy and paste that top 10 list (for the sake of this experiment). So barely any more data than you copy and pasted above. Let me try just the top 5 entries. 

Okay, so that's how it looks when I just copy and paste the top 5, which is still far less than ideal. I am just hoping to have it look like you did above.

Stupid thing is, I think I somehow did it when I posted my "Best Of 2017" list last year, but I haven't been able to do it since and can't for the heck of me think how I might have done that?

[heavyharmonies]

Hmm... I can post much larger amounts than that, and I don't see anything in group settings that would limit you. The normal file upload limit is many multiples of 10K. Perhaps paste is handled different from file upload, but I can't find it.

What about doing a screenshot of the spreadsheet and uploading that as an image?

[Glen]

aside from the technical knowhow, the more pressing question is how that average as hell Station release is still residing at no 2

jeez 

[AlphaMale]

3 hours ago, Glen said:

aside from the technical knowhow, the more pressing question is how that average as hell Station release is still residing at no 2

jeez 

And how the hell is Ted Poley #1????

[Glen]

Just now, AlphaMale said:

And how the hell is Ted Poley #1????

different tastes I guess.

None of the songs do much me. Ted's voice does not fit Degreeds music in my opinion. 

[AlphaMale]

3 hours ago, Glen said:

different tastes I guess.

None of the songs do much me. Ted's voice does not fit Degreeds music in my opinion. 

I'm with you. It's not awful by any means, but as you said, Ted singing Degreed-type music just doesn't sound "right".

 

[Geoff]

12 hours ago, heavyharmonies said:

Hmm... I can post much larger amounts than that, and I don't see anything in group settings that would limit you. The normal file upload limit is many multiples of 10K. Perhaps paste is handled different from file upload, but I can't find it.

What about doing a screenshot of the spreadsheet and uploading that as an image?

Yeah, I could probably do that I guess... would love for it just to post like it did in your first post, lol.  Any other technically inclined folk have any reason why it's not working for me? Everyone else can posts lists normally?

Just even looking at my list compared to yours, Dan, when I entered after each line - is it even odd for me to have those spaces between each line like I do, when yours is just posted as a straight list with no spaces between lines? 

[Geoff]

Just did another test - posting list in Word and then trying from there - identical results. Could this be some cookie related thing or something?

[heavyharmonies]

30 minutes ago, Geoff said:

Yeah, I could probably do that I guess... would love for it just to post like it did in your first post, lol.  Any other technically inclined folk have any reason why it's not working for me? Everyone else can posts lists normally?

Just even looking at my list compared to yours, Dan, when I entered after each line - is it even odd for me to have those spaces between each line like I do, when yours is just posted as a straight list with no spaces between lines? 

When you manually add hard returns, it turns each line into a "paragraph" which adds extra space below the line.(s).

I'm afraid I'm not any help with respect to the differences between Mac and PC and the usage of clipboard data on one vs. the other. The last time I used a Mac was in 2005.

[Geoff]

Cool, no worries. Out of curiosity, does any use a Mac and have this issue too? I just logged onto Safari to see if it might be different - nope. Same. Grrr. Very frustrating. 

[Geoff]

Just tested posting a list on another forum I frequent (a photography one - not music related) and it worked perfect. As it did on the old HH website. Is there some little tweak that's changed that I can alter somehow from the last site to now?

[heavyharmonies]

What software and version is that board running? There are a myriad of forum software packages out there (phpbb, mybb, vbulletin, etc.) and they're all different on how they handle uploads and attachments, plus they can all be configured differently.

Unless it's Invision Power Board v4.3.x, you can't really draw any conclusions.

[Geoff]

Just now, heavyharmonies said:

What software and version is that board running? There are a myriad of forum software packages out there (phpbb, mybb, vbulletin, etc.) and they're all different on how they handle uploads and attachments, plus they can all be configured differently.

Unless it's Invision Power Board v4.3.x, you can't really draw any conclusions.

Oh shit, how do I find that out? The website is ausphotography.net.au - don't know if you can tell from that, but that's beyond my realm of understanding.

So when this board was updated to the new format, it was changed from the old one and now handles these lists differently? Or is it really somehow just me and something I'm doing here? 

[heavyharmonies]

It's in the footer of the board homepage. They're running vbulletin. Completely different software package.

[Geoff]

i	especially	hands
enjoy	if	and
sex	they	hair
with	have	and
men	nice	teeth

 

i    especially    hands
enjoy     if    and 
sex    they    hair
with     have    and 
men    nice    teeth
 

Okay, so it's definitely a Mac issue as I just jumped on my wife's PC and it works fine. Grrr. Why is Apple so f*cking difficult?!