Skip to content

Pivotal.tools

Overview

SmartGrocer integrates with Pivotal.tools via daily exports to text files. The program is named ExportPivotal.exe.

Tlogs for the previous day must be proccess before exports will happen, so it's a good idea to schedule the program to run multiple times over a few hours. This will ensure data gets to Pivotal.tools as soon as possible. The basic processing flow is:

  • Check if tlogs for yesterday have been processed
    • if not, don't do anything
  • Export files
    • stores.txt
    • departments.txt
    • subdepartments.txt
    • items.txt
    • retails.txt
    • promotions.txt
    • storetotals.txt
    • departmenttotals.txt
    • subdepartmenttotals.txt
    • itemmovement.txt
  • Zip all .txt files to single zip file
  • Upload to Pivotal.tools SFTP site.

SFTP upload is performed by WinSCP.exe

Configuration Options

Option Purpose
ExportDir Directory to write export file before transmitting
FtpHost Hostname of the Piroval ftp server
FtpUser Provided by Pivotal for each customer
FtpPassword Provided by Pivotal for each customer
FtpProtocol Ftp or Sftp

Sample Configuration File

Filename

C:\Program Files (x86)\SmartGrocer[HQ|CS]ExportPivotal.exe.config

Content

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings file="global.config">
    <add key="ExportDir" value="D:\SmartGrocer\Pivotal"/>
    <add key="FtpHost" value="custname.ftp.pivotal.tools"/>
    <add key="FtpUser" value="user"/>
    <add key="FtpPass" value="pass"/>
    <add key="FtpProtocol" value="Ftp "/>
  </appSettings>
  <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
    </startup>
</configuration>