Author Topic: Tilt CSV Format  (Read 192 times)

Offline duncan.brown

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Tilt CSV Format
« on: July 27, 2020, 05:00:27 PM »
Hi,

I have some Tilt data that I'd like to import into BeerSmith 3.1. Does anyone know what the format of the Tilt CSV data should be? The regular CSV file looks like Date,Temp,Gravity,Days, but I'm looking for the Tilt format so I can use the filtering option to limit the number of points read in.

Thanks!

Offline BeerSmith

  • Brewer, Author, Patriot
  • BeerSmith Administrator
  • BeerSmith Grandmaster Brewer
  • *****
  • Posts: 5370
  • BeerSmith - take the guesswork out of brewing!
    • BeerSmith
Re: Tilt CSV Format
« Reply #1 on: July 27, 2020, 07:05:41 PM »
I believe the program will pick up the relevant columns in Tilt format - Date, gravity and temp.

Brad
Get a free trial of BeerSmith 3 here

Offline duncan.brown

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Re: Tilt CSV Format
« Reply #2 on: July 29, 2020, 07:58:21 AM »
Hi Brad,

Thanks, but I think I'm still doing something wrong. My Tilt CSV data looks like this:

,,3/31/2019 10:32:27,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 10:17:27,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 10:02:26,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 9:47:27,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 9:32:27,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 9:17:27,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 9:02:26,1.016,71.0,RED,Pliny the Elder,
,,3/31/2019 8:47:27,1.016,71.0,RED,Pliny the Elder,

and so on. When I try and read it in, nothing happens. Reading in BeerSmith CSV data in the format below works fine

"06 Apr 2019 07:33:44 AM","68.0","-","23.3",
"31 Mar 2019 02:02:34 PM","71.0","1.016","17.6",
"24 Mar 2019 01:32:03 PM","71.0","1.028","10.6",
"21 Mar 2019 09:02:30 PM","67.0","1.036","7.9",
"16 Mar 2019 01:24:46 PM","65.0","1.053","2.6",
"14 Mar 2019 09:49:14 PM","67.0","1.069","0.9",
"14 Mar 2019 05:49:00 PM","66.0","1.074","0.7",


Any ideas? Is the format of my Tilt CSV data correct?

Offline beerprof

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 19
  • Chemistry not just my job, it's a way of life...
Re: Tilt CSV Format
« Reply #3 on: July 29, 2020, 03:29:15 PM »
Duncan, a quick look at a downloaded Tilt csv file of mine shows that you have the correct format... is it possible that BS3 is looking for some kind of header info before all that?

Offline duncan.brown

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Re: Tilt CSV Format
« Reply #4 on: July 31, 2020, 12:18:16 PM »
Thanks for checking it. I'm completely failing to upload this. Brad, any tips on the correct format?