1 require "csv" 2 3 csv_path = Rails.root.join("db", "data", "dolibarr_measurements.csv") 4 abort "CSV not found: #{csv_path}" unless File.exist?(csv_path) 5 6 CSV.foreach(csv_path, headers: true) do |row| 7 NutrientMeasurement.find_or_create_by!(measured_on: Date.parse(row["date"])) do |m| 8 m.nno3 = row["nno3"] 9 m.p = row["p"] 10 m.k = row["k"] 11 m.ca = row["ca"] 12 m.mg = row["mg"] 13 m.s = row["s"] 14 m.na = row["na"] 15 m.cl = row["cl"] 16 m.si = row["si"] 17 m.fe = row["fe"] 18 m.zn = row["zn"] 19 m.b = row["b"] 20 m.mn = row["mn"] 21 m.cu = row["cu"] 22 m.mo = row["mo"] 23 m.nnh4 = row["nnh4"] 24 end 25 end 26