It seems to be. I can only get it to work properly on Chrome (which is unfortunate, because I’m a Safari shop otherwise.)
Have you tried the roast analyser on Roast.world? Maybe that would be helpful.
I noticed there is an Export option on the MyRoast page which exports data in .json format - you may be able to run one of the “convert json to csv” web utilities to get what you want…
That won’t let me compare roasts with all the data I have from the Quest (I have a lot of those!)
If the option for not sharing things in the cloud is implemented then we might be able to get a local copy saved which could be put into the Roast Analyzer that someone wrote for v1
I’d like to keep this thread on topic, please. What I am asking for is the ability to export roast data (temperatures, fans speeds, etc) to a CSV file - not anything else. I am aware of the various tools offered by Roast.World but that is not what I am asking or looking for. I have a large database (over 3 years worth) and I would like very much to be able to import roast data from the Bullet into that.
Stuart, thank you for the suggestion about the Export to json, I will give that a try.
Will
@stuartmcknight, where exactly are you finding the .json export link? I’ve looked everywhere I can think of for this, whether online or on my locally installed application, and don’t see anything like that. I’d definitely be willing to try a JSON to CSV conversion if it were possible–that sounds a lot easier than trying to crack the encryption on the local database.
It’s in Roast World under My Roasts (well it is for me!)
/var/folders/1_/9wh665kn7_dc1r18lh9jwp0r0000gn/T/VoilaCopiedFiles1/Capto_Capture 2019-05-13_09-31-24_AM.jpgThanks! I don’t remember seeing that before, but it’s definitely there. Time to play a bit…
The roast analyzer was built as an online tool. Having an offline tool is not something we are working on at the moment. If enough people want it though we are happy to look into this in the future.
There was a Roast Profiler tool written by a third party for v1 of the Roast Time software - as long as raw data is made available from the “cloud” if someone wants to revisit that then it wouldn’t need to be something that Aillio need to spend dev resources on for a possible minority interest. Having the data available in a JSON file through the Export link I pointed out earlier may be enough for a coder looking for a coffee hobby project. It may be that the original coder of that profile tool did not realize the data was still available albeit with a couple of extra clicks and downloads rather than always on a local folder.
Agreed, whilst I like the overall concept of “sharing” we really need that switch that allows us to opt out of some/all roasting sessions…hopefully that’s an easy implement in a future release.
As to forum activity, there are always going to be chatty folks like us But like neighbours. sometimes you only see them when they want to borrow your lawnmower or tools, others are happy to shoot the breeze over the fence any time. I think I may be in the latter category.
Guys, the discussion about Artisan etc is interesting, but it needs its own thread please. This one is about requesting a feature to be able to export to CSV.
I’d be really happy if the “export to json” supported export to csv as well. I’m not asking for full on roast analysis tools or anything like that, I already have the tools in a spreadsheet to graph things. I just want to be able to import my roast data into a spreadsheet!
Thanks,
Will
I took a look at the exported JSON data. I found a very nice tool that will convert it to CSV or even XLSX (Excel). And I discovered a huge “problem” - no TIME data in the file!!! This bean temp and drum temp data, and “bean temp derivative” data, but the time of each entry is completely missing. If you could add that I’d have what I need.
From looking at the data and the elapsed time, it looks to me like the interval is 0.5 seconds, so I am going to use that as the time interval for now…
I wasn’t trying to control the thread, I was asking for reasonable consideration of what the thread’s subject is. I’ve been participating in open forums for many years, and I still think it’s a good idea to try to keep a thread on topic. Discussions about the roast profiler, using artisan, and whether or not roasts are private are all very interesting to me as well, but I think a new thread might be a better place for them. If that’s not how you folks roll around here, fine, I’ll try to adapt, but I’m not making any promises…
Sorry Will, I know where you’re coming from trying to keep a post “single threaded” as it makes for interesting rediscovery later. In my defence I was about to point you to some JSON->CSV converter sites that I had come across in my Googling after pulling down a JSON export of one of my roasts. I didn’t have a lot of time to review it and also came across a few Mac OS JSON tools that at least allow a reasonable view of the data. I did not discover the absence of time stamping but you’re right, if you figure each data point is sampled at specific intervals that may get you back to a timeline you can work with.
@PapasCup and I will go find someone else’s fence to hang over Well I’ll try…
We made the export json so that the data is available. Its the more or less raw data from the roaster. The CSV export is something we are working on, however its not as easy as it might sound because we need to format everything so that it makes sense.
Can someone start another thread about the ability to hide profiles?
That is correct, the interval is 0.5 seconds.
We are looking at doing the real csv download. Just have to finalize the format.
Is the real CSV file download ready to go?
Hi Rob,
Right now we have the export function on roast.world (look in the list of roasts there is a button on the right) but the export is a json file which is another way saving data.
If you want to convert it to CSV it is a little bit tricky but it can be done. I recommend making a macro in Excel to automate some of these steps.
I tested this using libreOffice but Excel should be very similar.
- I have used CSVJSON - CSVJSON to open the file once it is downloaded from roast.world
- Scroll to the bottom of the file and remove ,“roastNumber”: … and the rest of the file.
- Add a } at the end so the file look something like:
,6.1,5.9,5.5,5.5,5.2,4.8,4.6,4.2,4.2]} - Press the convert arrow, then press download and save the file
- Import in excel using comma as delimiter.
Your data should then look like:
- I would arrange the data a little different first.
- Next you need to convert the text to columns. Select the cell (in my case it was A5 for bean temp, A8 for IBTS and A11 for ROR), then choose Data->Text to Columns and use comma as delimiter. The data should then look like this.
That is basically it. If you want to rotate the data you can cut the whole row, then paste special ticking the box transpose.
Please note that there are no timestamps. The data is sampled two times per second.
Jacob