Views for "Write Report to CSV" *Need Help Please*

[brewertoby]

I've searched everywhere (I think) and I don't think this exists and I'm rather shocked that it doesn't. If I am wrong, I'm begging for help on where to find it.

I know that i can customize the views for the stats and can write to CSV, but the one column I feel I need most is one that doesn't seem to exist anywhere and it's not even in the title of the export. Shouldn't there be a column for what kind of tournament it was? A column that says "Daily Bronze Cap" or "Tuesday Time Machine Cap" or (for drafts) "Daily All-Silver All The Time".

I can't be the only one who wants this and it seems like a lot of manual labor to add it into every export. How are people getting around this?

[rburgh]

CSV is a Microsoft format, primarily used for excel. You can also read .csv files by importing them to google sheets if you choose to not feed the Microsoft bulldog. And when you download information from BBREF it also goes to a .csv file.

If you don't know how to do this, whatever AI app you have on your computer can unpack it quickly into neat columns.

[rburgh]

Just identify the league for the download by the file title. You can keep appending new data for the same league type by going to the first vacant row and telling your worksheet app to import the data to there. And you probably want to have different worksheets in your workbook for hitting and pitching. Fielding too if you're gung-ho.

[cwhitman]

i use a watcher script in r studio that i name the group of tournaments i am exporting and it automatically renames and relocates a new file going to the location the exports go to.

[brewertoby]

Originally Posted by rburgh

Just identify the league for the download by the file title. You can keep appending new data for the same league type by going to the first vacant row and telling your worksheet app to import the data to there. And you probably want to have different worksheets in your workbook for hitting and pitching. Fielding too if you're gung-ho.

I appreciate your response here, but I find that the reports are automatically named unless i am missing something?

[brewertoby]

Originally Posted by cwhitman

i use a watcher script in r studio that i name the group of tournaments i am exporting and it automatically renames and relocates a new file going to the location the exports go to.

This may be promising for what I'd like to accomplish, but how is it differentiating between tournaments? For example, you export the stats from a Gold and Under tournament, and you also export the stats from a Gold cap tournament. How does it know what to rename each set of stats?

[cwhitman]

Originally Posted by brewertoby

This may be promising for what I'd like to accomplish, but how is it differentiating between tournaments? For example, you export the stats from a Gold and Under tournament, and you also export the stats from a Gold cap tournament. How does it know what to rename each set of stats?

I set a name before exporting. for example, i run the script, it asks for the tournament type, i say something like "goldcapdaily". then i export 8 tournaments that are all gold cap, and it labels them the same. I just go by batches of the same tournament