Skip to content

Instantly share code, notes, and snippets.

View DKRetzlaff's full-sized avatar

Daniel Retzlaff DKRetzlaff

  • Power Home Remodeling
  • Pelotas, RS, Brazil
  • X @dkretzlaff
View GitHub Profile
source "https://rubygems.org"
gem 'activerecord', '~> 5.1'
gem 'mysql2', '~> 0.4'
gem 'spreadsheet'
@DKRetzlaff
DKRetzlaff / integracao.md
Last active November 22, 2017 13:27
Integração com widget da Trustvox
@DKRetzlaff
DKRetzlaff / integracao.md
Last active November 22, 2017 13:30
Integração com widget de PDP Trustvox
!function(t){var e=function(){var t="base".split(","),e=n();return-1!==t.indexOf(e)?e:"base"},n=function(){for(var t,e="art,biz,blog,br,club,com,etc,far,ind,me,net,online,sexy,store,tk,vc",n=window.location.hostname.split("."),s=n.length,o=s,a=n[n.length-1].length;t=n[--o];)if(e.indexOf(t)<0||t.length<a||s-2>o||0===o)return t;return t},s=function(n){var s=t.document.getElementsByTagName("script")[0],o=t.document.createElement("script");return o.src="//s3-sa-east-1.amazonaws.com/trustvox-colt-js/"+e()+".min.js",o.async=!0,s.parentNode.insertBefore(o,s),n&&"function"==typeof n&&(o.onload=n),o},o=function(){tag=t.document.createElement("link"),tag.type="text/css",tag.rel="stylesheet",tag.href="//s3-sa-east-1.amazonaws.com/trustvox-colt-js/stylesheets/"+e()+".css",t.document.head.appendChild(tag)};t.tvjs=s,t.tvcss=o,t.tvjs(),t.tvcss()}(window);
# ruby 2.4.1
require 'csv'
url_of_src = '/path/to/opinioes_produtos_yourviews.csv'
url_of_dest = '/path/to/opinioes_produtos_trustvox.csv'
cont = 0 # Alterar para valor do último ThirdPartyId adicionado a loja
data_dest = []
data_dest << ['Nome', 'Sobrenome', 'Email', 'Id', 'Classificacao', 'Comentarios', 'CriadoEm', 'Modelo', 'Nome', 'IndicariaProduto', 'Url']
yourviews_csv_structure = ['Nota',