John Deere PFP11260 INSTALLATION INSTRUCTIONS

AgLogic™SSIAdapter

INSTALLATIONINSTRUCTIONS

AgLogic™SSIAdapter

PFP1126008JUN11(ENGLISH)

JohnDeereAgManagementSolutions

PFP11260(08JUN11)

COPYRIGHT©2011

DEERE&COMPANY

AJohnDeereILLUSTRUCTION®Manual

Allrightsreserved.

PFP112601908JUN1 1

LITHOINU.S.A

Moline,Illinois

Overview

Thisdocumentisaninstallationinstructionforthe
AgLogic™SSIAdapterwhichallowsdatatocomeacross
fromtheAgvance®SystemfromSoftwareSolutions

Integrated,LLC(SSI)intotheAgLogic™System.Itis
tobeusedbyITpersonnelandNetworkAdministrators.
Ingeneral,thestepsdirectlyfollowingwillconfigurethe
SSIAdapter.

MM97743,000031B1913SEP101/1

DatabasePreparation

TheAgLogic™SSIAdapterrequiresMSSQLServer
2000orgreater.

Theusernameandpasswordofa“SQLServer
AuthenticationAccount”forthedatabasewillbeneeded
duringinstallation.Ifsuchauserdoesnotyetexist,anew
usershouldbecreatedthathasaccesstotheAgvance®
databaseandwillneeddb_datareaderanddb_datawriter
permissions.Additionallywheninstallingtheadapter

AgLogic™WebApplicationSetup

thisuserwillneedthedb_ddladimpersmission.This
additionalpermissioncanberemovedwhenthesetup
iscomplete.

The“SQLServerAuthenticationAccount”shouldbe
configuredsuchthatitspasswordneverexpiresandnever
needstobechanged.Servernameanddatabaseinstance
(ifused)oftheMicrosoftSQLServerusedtostorethe
Agvance®datawillbeneededduringinstallation.Please
havethisinformationreadilyavailable.

MM97743,000031C1908SEP101/1

EnsureyourOrganizationhasbeencreatedinthe
AgLogic™webapplication.Pleaserefertotheemailwith
subjectline“Y ourJohnDeereAgLogic™Order–Action
Required”forfurtherdetails.

Auniqueusernameandpassword(example:SSI_myOrg)
createdintheAgLogicwebapplicationwillbeneeded
duringtheinstallation.Ifsuchauserdoesnotyetexist,
pleasefollowtheseinstructions:

1.LogintotheAgLogic™Systemat
https://aglogic.deere.com

PC13099—UN—04MAR11

AddUser

2.Clickonthe“Management”tab

3.Clickonthe“Users”tab

4.Select“AddUser”

5.FillintheUsername,Password,FirstName,Last
Name

6.Checkthe“OrganizationAdmin”box

7.Click“Save”

ContinuedonnextpageCZ76372,00002A11904MAR111/3

PFP11260(08JUN11)

1

060811

PN=3

EditOrganizationDetail

PC13101—UN—06DEC10

TheOrganization’sBackOfficewillneedtobesetsothat
theAgvance/SSIadapterwillbeavailabletodownload.

1.Clickonthe“Management”tab

2.Clickonthe“Organization”tab

DownloadAgvance/SSIAdapter

3.Select“EditOrganizationDetails”

4.IntheBackOfficedropdownselect“Agvance/SSI”

5.Click“Save”

CZ76372,00002A11904MAR112/3

PC13100—UN—04MAR11

AnewlinkwillbecomeavailableontheOrganizationtab.
Thislinkwillbeusedinthenextsection.

PFP11260(08JUN11)

CZ76372,00002A11904MAR113/3

2

060811

PN=4

Installation

1.LogontotheServerwhichcontainstheAgvance®
ProgramFiles

2.Createa“SSI_Adapter”folderwhereazipfile
willbeplaced.Thisfolderwillbereferredtoas
<adapterFolder>inthisdocfromnowontoavoid
confusionwithanySSIinstallationfolders.

3.DownloadtheAgLogic™SSIAdapterfromthelink
shownintheprevioussection.

4.Unzipthe“AgLogic_SSIAdapter.zip”fileinto
<adapterFolder>whichwascreatedinstep2.

5.Oncethe“AgLogic_SSIAdapter.zip”filehasbeen
unzipped,openthe<adapterFolder>

6.IfyouplantoexportShapefilesfromAgvance®into
AgLogic™pleasefollowtheseadditionalsteps:(Ifyou
donotplantoexportshapefilesfromAgvance®then
pleaseproceedtotheConfigurationstep.)
a.CopyAgv2Shp.exe(thisfileislocatedinthe

<adapterFolder>)intotheProgramFiles\AgV ance
onthesameserver

b.OncetheAgv2Shp.exeisintheProgram

Files\AgVancefolder,rightclickthefileandselect:
createshortcut.Nametheshortcut:Agv2Shp.exe
andplacetheshortcutinsideofthe<adapterFolder>
createdinstep2.

c.RightclickthenewshortcutforAgv2Shp.exeand

selectProperties,changetheTarget:towhere
theAgv2Shpe.exewasplaced,intheProgram
FilesofAgvance®.(Example:“E:\Program
Files\AgVance\Agv2Shp.exe”)Alsochangethe
StartIn:towheretheAgVance®Databaseresides.

NOTE:ThiscouldbeaMappeddrive.

(Example:“I:\AvData”)

NOTE:Theinformationtosetuptheshortcutwill

matchthepropertiesoftheAgVance®
Iconproperties.

d.OncetheAgv2Shp.exeshortcuthasbeensetup,

savethechangesforthePropertiesoftheshortcut.

e.DoubleClicktheNewAgv2Shp.exeshortcut(the

shortcutwillbeinthe<adapterFolder>)anda“Map
ExportType”popupwillappear.

f.SelectthemapexporttypeforyourAgVance®

installationandclick"Save".

NOTE:IfyouareunawareoftheMapExportType

thattheshapefilesarecreatedin,please
contactAgvance®forassistance.

CZ76372,00002A21904MAR111/1

Configuration:

UsetheAgLogic™SSIAdapterWizardtocomplete
theinstallationandconfigurationoftheadapter.The
wizardcanbestartedbyclickingonSSIWizard.batinthe
<adapterFolder>.

Step1:Welcome

Thisdocument,andanyupdatesmadetoit,can

•

befoundbyclickingthe“SSIAdapterInstallation
Document”link.
ClickSave&Exitatanytimetosaveyourchangesand

•

exittheinstallationwizard.

PC12808—UN—24AUG10

Welcome

ContinuedonnextpageCZ76372,00002BE1905APR111/8

PFP11260(08JUN11)

3

060811

PN=5

Step2:ConnectingtoAgLogic™

EnterintheUsername/Passwordcreatedaboveunder

•

“AgLogic™WebApplicationSetup”
TheUsername/Passwordwillbevalidatedagainstthe

•

AgLogic™WebApplicationwhenthe‘Next’buttonis
clicked.Anerrorwillappearifthevalidationcouldnot
becompletedorinvaliddatahasbeenentered.
Bothfieldsarerequired

•

Step3:ConnectingtoyourDatabase

EnterintheinformationthatconnectstoyourMSSQL

•

ServerDatabase
TheConnectionURLwillautomaticallyupdateasyou

•

enterinyourinformation,butcanbemodified,ifneeded.
1433isthedefaultvalueforthePortinMSSQLServer.

•

NOTE:Instanceisoptionalandshouldbesuppliedonly

ifyourMSSQLServerconfigurationrequiresit.

PC12809—UN—24AUG10

CZ76372,00002BE1905APR112/8

Theadapterwillattempttoconnecttoyourdatabase

•

whenthe‘Next’buttonisclicked.Anerrorwillappearif
theadapterwasunabletoconnect.

Step4:IntegrationOptions

LoadAdditionalCommentsischeckedbydefault.This

•

optioninstructstheadaptertoloadanyadditionalWork
OrdercommentsfromAgvance®.
CommentDelimiterdefaultstoasemicolon(;).

•

ProcessLocationischeckedbydefault.Thisindicates

•

thattheadaptershouldcreateaLocationforaWork
OrderbasedondatainAgvance®.Ifyourorganization
doesnotuseLocationsinAgLogic™thisoptionshould
beunchecked.
IgnoreOrdersthathaveProductInventoryrelievedis

•

uncheckedbydefault.Thisoptionshouldbechecked
ifworkordersthathavebeendeliveredonshouldnot
appearinAgLogic™.

PC12810—UN—24AUG10

CZ76372,00002BE1905APR113/8

PC13094—UN—24JAN11

ContinuedonnextpageCZ76372,00002BE1905APR114/8

PFP11260(08JUN11)

4

060811

PN=6

Step5:FieldstoIgnore

Agvance®mayuseplaceholderfieldstoensuredata

•

integrity.Theseplaceholdersareunnecessaryin
AgLogic™.Ifyouwishtoignorethoseplaceholdersyou
canspecifytheirnameshere.Forexamplemanywork
ordersarecreatedwithFieldName“All”.Specifynames
ofanyFieldsthatyouwouldliketheadaptertoignore.
ToremoveafieldfromtheIgnoredFieldsList,highlight

•

thefieldandclick‘Remove’
Thesefieldsarenotrequired

•

Step6:UOMMappings

ConfiguretheUnitOfMeasureMappingsforDryand

•

LiquidWorkOrders
Allfieldshavedefaultvalues.Changethesevaluesto

•

matchtheUOMsyouwishtouseinAgLogic™.

Thesefieldsarenotrequired

PC12812—UN—24AUG10

CZ76372,00002BE1905APR115/8

ContinuedonnextpageCZ76372,00002BE1905APR116/8

PC12813—UN—24AUG10

PFP11260(08JUN11)

5

060811

PN=7

Step7:FieldBoundaryProcessing

IfyouplantoexportShapefilesfromAgvance®into
AgLogic™,check"ProcessFieldBoundaryInformation".

“AlwaysUploadBoundaries”ischeckedbydefault.Ifthe
boundaryisavailable,thisoptionwilluploadboundaries
intoAgLogicwhenanworkorderischangedforthe
associatedfield.

IntheAgvance®Versiondropdownselectyourcurrent

•

versionofAgvance®.
Ifversion5.0isselected,theDataPathentrybecomes

greyedout,becauseitisnotrequired.

However,ifversion4.Xisselected,theDataPathis

required.

EnterorbrowsetothelocationoftheAgvance®

•

Database.Thisshouldbethesamepathprovidedinthe
"StartIn"propertyoftheAgv2Shp.exe.lnk.
If"ProcessFieldBoundaryInformation"ischeckedthe

•

“Next”ButtonwillnotbeavailableuntilavalidData
Pathhasbeenentered.

NOTE:Ifneeded,referencestep6oftheInstallation

sectionearlierinthisinstruction.

PC13229—UN—30MAR11

CZ76372,00002BE1905APR117/8

Step8:CompleteInstallation

InstallT ablesandTriggerswillcreatethetablesand

•

triggersintheMSSQLServerdatabaseneededfor
integration.
ToassociateSSIinformationwithAgLogic,please

•

checkthesynchronizeboxalongwithCustomers,
Farms,andFields.
InstallServicewillcreatethewindowsservicethatruns

•

theadapter.
ClickFinish,tocompletetheinstallprocess.Apopup

•

windowwillappear,indicating“InstallSuccessful”.

StartingtheService

Tostarttheaglogicintegratorservice:

1.InwindowsclickStart>>Settings>>ControlPanel>>
AdministrativeT ools>>Services

PC12815—UN—24AUG10

CZ76372,00002BE1905APR118/8

2.Intheservicesdialogfindaglogicintegrator,rightclick
and“Start”theservice.

3.Theserviceshouldalreadybesettoautomaticto
ensuretheservicewillstillrunifthemachineis
restarted.

MM97743,00003201925AUG101/1

PFP11260(08JUN11)

6

060811

PN=8

Test

ToensurethattheinstallationoftheAgLogicSSIAdapter
wassuccessful,followthesesteps:

1.CreateordersinAgvance®.Theseordersneedtobe
markedas“CustomApply”inordertobedisplayed
inAgLogic™

2.ValidateontheAgLogic™SchedulePagethatopen
ordersweretransferredsuccessfully.

a.LogintoAgLogic™

b.ClickontheScheduletab

c.Verifythatthenewordersareavailableonthe

righthandpaneandonthemap

3.ReviewtheCustomer/Farm/FieldtabinAgLogic™to
ensurethatinformationcameinfromAgvance®.

a.LogintoAgLogic™

b.ClickontheCustomer/Farm/Fieldtab

c.SearchforaCustomer ,Farmand/orField

d.Viewresults

4.Viewthe“IntegrationErrors”boxtoseeifanyopen
ordershaderrorswhencomingintotheAgLogic™
System.

The“IntegrationErrors”boxcanbefoundonthe
AgLogic™Homepage.Ifthenumberinthisboxis“0,”
therearenoerrors.Ifthenumberisgreaterthan“0”
pleaseproceedthroughthefollowingsteps:

a.Clickonthehyperlinkednumberinthe“Integration

Errors”box.

b.Viewthereportdescribingtheerrorsand

troubleshootasneeded.

NOTE:Ifyouneedadditionalinformationorhelpplease

seetheAdditionalHelpsection

MM97743,00003211908SEP101/1

FAQ’s

Q:IfIhostmultiplelocationswithinmyorganizationon
oneserver,canIlimittheworkordersthatcomeintothe
AgLogic™System?

AdditionalHelp

Ifyouneedmorehelpincompletinganyofthesteps,
pleasecontactourCustomerContactCenterat
888GRN[e-mail]

UpgradeInstructions

UpgradestotheAgLogic™SSIAdapterwillbeautomatic
toyoursystem.NotificationsthattheAgLogic™SSI

A:Y es,anyworkordermarkedas“CustomApply”from
AgVance®willcomeintotheAgLogic™System.Marking
anyworkorderas“Loaded”willnotsendtheworkorder
intotheAgLogic™System.

MM97743,00003221925AUG101/1

ForgeneralusequestionsabouttheAgLogic™Mobile
andWebapplications,acompletehelplibrarycanbe
foundintheupperrighthandcornerofanypageinthe
AgLogic™webapplication.

MM97743,00003231925AUG101/1

Adapterhasbeenupdatedwilldisplayinthe“What’sNew”
ontheAgLogic™SystemHomescreen.

MM97743,00003241925AUG101/1

PFP11260(08JUN11)

7

060811

PN=9

PFP11260(08JUN11)

8

060811

PN=10

PFP11260(08JUN11)

9

060811

PN=11

PFP11260(08JUN11)

10

060811

PN=12