John Deere PFP11260 is an AgLogic™ SSI Adapter that allows data to come across from the Agvance® System from Software Solutions Integrated, LLC (SSI) into the AgLogic™ System. It supports integration with MS SQL Server 2000 or greater, and enables the creation of a Location for a Work Order based on data in Agvance®. The adapter can be configured to ignore certain fields and process field boundary information. It also provides Unit Of Measure Mappings for Dry and Liquid Work Orders.
John Deere PFP11260 is an AgLogic™ SSI Adapter that allows data to come across from the Agvance® System from Software Solutions Integrated, LLC (SSI) into the AgLogic™ System. It supports integration with MS SQL Server 2000 or greater, and enables the creation of a Location for a Work Order based on data in Agvance®. The adapter can be configured to ignore certain fields and process field boundary information. It also provides Unit Of Measure Mappings for Dry and Liquid Work Orders.
AgLogic™SSIAdapter
INSTALLATIONINSTRUCTIONS
AgLogic™SSIAdapter
PFP1126008JUN11(ENGLISH)
JohnDeereAgManagementSolutions
PFP11260(08JUN11)
LITHOINU.S.A
COPYRIGHT©2011
DEERE&COMPANY
Moline,Illinois
Allrightsreserved.
AJohnDeereILLUSTRUCTION®Manual
PFP112601908JUN11
MM97743,000031B1913SEP101/1
MM97743,000031C1908SEP101/1
ContinuedonnextpageCZ76372,00002A11904MAR111/3
Overview
Thisdocumentisaninstallationinstructionforthe
AgLogic™SSIAdapterwhichallowsdatatocomeacross
fromtheAgvance®SystemfromSoftwareSolutions
Integrated,LLC(SSI)intotheAgLogic™System.Itis
tobeusedbyITpersonnelandNetworkAdministrators.
Ingeneral,thestepsdirectlyfollowingwillconfigurethe
SSIAdapter.
DatabasePreparation
TheAgLogic™SSIAdapterrequiresMSSQLServer
2000orgreater.
Theusernameandpasswordofa“SQLServer
AuthenticationAccount”forthedatabasewillbeneeded
duringinstallation.Ifsuchauserdoesnotyetexist,anew
usershouldbecreatedthathasaccesstotheAgvance®
databaseandwillneeddb_datareaderanddb_datawriter
permissions.Additionallywheninstallingtheadapter
thisuserwillneedthedb_ddladimpersmission.This
additionalpermissioncanberemovedwhenthesetup
iscomplete.
The“SQLServerAuthenticationAccount”shouldbe
configuredsuchthatitspasswordneverexpiresandnever
needstobechanged.Servernameanddatabaseinstance
(ifused)oftheMicrosoftSQLServerusedtostorethe
Agvance®datawillbeneededduringinstallation.Please
havethisinformationreadilyavailable.
AgLogic™WebApplicationSetup
PC13099—UN—04MAR11
AddUser
EnsureyourOrganizationhasbeencreatedinthe
AgLogic™webapplication.Pleaserefertotheemailwith
subjectline“YourJohnDeereAgLogic™Order–Action
Required”forfurtherdetails.
Auniqueusernameandpassword(example:SSI_myOrg)
createdintheAgLogicwebapplicationwillbeneeded
duringtheinstallation.Ifsuchauserdoesnotyetexist,
pleasefollowtheseinstructions:
1.LogintotheAgLogic™Systemat
https://aglogic.deere.com
2.Clickonthe“Management”tab
3.Clickonthe“Users”tab
4.Select“AddUser”
5.FillintheUsername,Password,FirstName,Last
Name
6.Checkthe“OrganizationAdmin”box
7.Click“Save”
PFP11260(08JUN11)
1
060811
PN=3
CZ76372,00002A11904MAR112/3
CZ76372,00002A11904MAR113/3
PC13101—UN—06DEC10
EditOrganizationDetail
TheOrganization’sBackOfficewillneedtobesetsothat
theAgvance/SSIadapterwillbeavailabletodownload.
1.Clickonthe“Management”tab
2.Clickonthe“Organization”tab
3.Select“EditOrganizationDetails”
4.IntheBackOfficedropdownselect“Agvance/SSI”
5.Click“Save”
PC13100—UN—04MAR11
DownloadAgvance/SSIAdapter
AnewlinkwillbecomeavailableontheOrganizationtab.
Thislinkwillbeusedinthenextsection.
PFP11260(08JUN11)
2
060811
PN=4
CZ76372,00002A21904MAR111/1
ContinuedonnextpageCZ76372,00002BE1905APR111/8
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\AgVance
onthesameserver
b.OncetheAgv2Shp.exeisintheProgram
Files\AgVancefolder,rightclickthefileandselect:
createshortcut.Nametheshortcut:Agv2Shp.exe
andplacetheshortcutinsideofthe<adapterFolder>
createdinstep2.
c.RightclickthenewshortcutforAgv2Shp.exeand
selectProperties,changetheT arget: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”popupwillappear.
f.SelectthemapexporttypeforyourAgVance®
installationandclick"Save".
NOTE:IfyouareunawareoftheMapExportType
thattheshapefilesarecreatedin,please
contactAgvance®forassistance.
Configuration:
UsetheAgLogic™SSIAdapterWizardtocomplete
theinstallationandconfigurationoftheadapter.The
wizardcanbestartedbyclickingonSSIWizard.batinthe
<adapterFolder>.
Step1:Welcome
•
Thisdocument,andanyupdatesmadetoit,can
befoundbyclickingthe“SSIAdapterInstallation
Document”link.
•
ClickSave&Exitatanytimetosaveyourchangesand
exittheinstallationwizard.
PC12808—UN—24AUG10
Welcome
PFP11260(08JUN11)
3
060811
PN=5
CZ76372,00002BE1905APR112/8
CZ76372,00002BE1905APR113/8
ContinuedonnextpageCZ76372,00002BE1905APR114/8
Step2:ConnectingtoAgLogic™
•
EnterintheUsername/Passwordcreatedaboveunder
“AgLogic™WebApplicationSetup”
•
TheUsername/Passwordwillbevalidatedagainstthe
AgLogic™WebApplicationwhenthe‘Next’buttonis
clicked.Anerrorwillappearifthevalidationcouldnot
becompletedorinvaliddatahasbeenentered.
•
Bothfieldsarerequired
PC12809—UN—24AUG10
Step3:ConnectingtoyourDatabase
•
EnterintheinformationthatconnectstoyourMSSQL
ServerDatabase
•
TheConnectionURLwillautomaticallyupdateasyou
enterinyourinformation,butcanbemodified,ifneeded.
•
1433isthedefaultvalueforthePortinMSSQLServer.
NOTE:Instanceisoptionalandshouldbesuppliedonly
ifyourMSSQLServerconfigurationrequiresit.
•
Theadapterwillattempttoconnecttoyourdatabase
whenthe‘Next’buttonisclicked.Anerrorwillappearif
theadapterwasunabletoconnect.
PC12810—UN—24AUG10
Step4:IntegrationOptions
•
LoadAdditionalCommentsischeckedbydefault.This
optioninstructstheadaptertoloadanyadditionalWork
OrdercommentsfromAgvance®.
•
CommentDelimiterdefaultstoasemicolon(;).
•
ProcessLocationischeckedbydefault.Thisindicates
thattheadaptershouldcreateaLocationforaWork
OrderbasedondatainAgvance®.Ifyourorganization
doesnotuseLocationsinAgLogic™thisoptionshould
beunchecked.
•
IgnoreOrdersthathaveProductInventoryrelievedis
uncheckedbydefault.Thisoptionshouldbechecked
ifworkordersthathavebeendeliveredonshouldnot
appearinAgLogic™.
PC13094—UN—24JAN11
PFP11260(08JUN11)
4
060811
PN=6
CZ76372,00002BE1905APR115/8
ContinuedonnextpageCZ76372,00002BE1905APR116/8
Step5:FieldstoIgnore
•
Agvance®mayuseplaceholderfieldstoensuredata
integrity.Theseplaceholdersareunnecessaryin
AgLogic™.Ifyouwishtoignorethoseplaceholdersyou
canspecifytheirnameshere.Forexamplemanywork
ordersarecreatedwithFieldName“All”.Specifynames
ofanyFieldsthatyouwouldliketheadaptertoignore.
•
ToremoveafieldfromtheIgnoredFieldsList,highlight
thefieldandclick‘Remove’
•
Thesefieldsarenotrequired
PC12812—UN—24AUG10
Step6:UOMMappings
•
ConfiguretheUnitOfMeasureMappingsforDryand
LiquidWorkOrders
•
Allfieldshavedefaultvalues.Changethesevaluesto
matchtheUOMsyouwishtouseinAgLogic™.
Thesefieldsarenotrequired
PC12813—UN—24AUG10
PFP11260(08JUN11)
5
060811
PN=7
CZ76372,00002BE1905APR117/8
CZ76372,00002BE1905APR118/8
MM97743,00003201925AUG101/1
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
Step8:CompleteInstallation
•
InstallTablesandTriggerswillcreatethetablesand
triggersintheMSSQLServerdatabaseneededfor
integration.
•
ToassociateSSIinformationwithAgLogic,please
checkthesynchronizeboxalongwithCustomers,
Farms,andFields.
•
InstallServicewillcreatethewindowsservicethatruns
theadapter.
•
ClickFinish,tocompletetheinstallprocess.Apopup
windowwillappear,indicating“InstallSuccessful”.
PC12815—UN—24AUG10
StartingtheService
Tostarttheaglogicintegratorservice:
1.InwindowsclickStart>>Settings>>ControlPanel>>
AdministrativeT ools>>Services
2.Intheservicesdialogfindaglogicintegrator,rightclick
and“Start”theservice.
3.Theserviceshouldalreadybesettoautomaticto
ensuretheservicewillstillrunifthemachineis
restarted.
PFP11260(08JUN11)
6
060811
PN=8
MM97743,00003211908SEP101/1
MM97743,00003221925AUG101/1
MM97743,00003231925AUG101/1
MM97743,00003241925AUG101/1
Test
ToensurethattheinstallationoftheAgLogicSSIAdapter
wassuccessful,followthesesteps:
1.CreateordersinAgvance®.Theseordersneedtobe
markedas“CustomApply”inordertobedisplayed
inAgLogic™
2.ValidateontheAgLogic™SchedulePagethatopen
ordersweretransferredsuccessfully.
a.LogintoAgLogic™
b.ClickontheScheduletab
c.Verifythatthenewordersareavailableonthe
righthandpaneandonthemap
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
FAQ’s
Q:IfIhostmultiplelocationswithinmyorganizationon
oneserver,canIlimittheworkordersthatcomeintothe
AgLogic™System?
A:Yes,anyworkordermarkedas“CustomApply”from
AgVance®willcomeintotheAgLogic™System.Marking
anyworkorderas“Loaded”willnotsendtheworkorder
intotheAgLogic™System.
AdditionalHelp
Ifyouneedmorehelpincompletinganyofthesteps,
pleasecontactourCustomerContactCenterat
888GRNSTARor[email protected]
ForgeneralusequestionsabouttheAgLogic™Mobile
andWebapplications,acompletehelplibrarycanbe
foundintheupperrighthandcornerofanypageinthe
AgLogic™webapplication.
UpgradeInstructions
UpgradestotheAgLogic™SSIAdapterwillbeautomatic
toyoursystem.NotificationsthattheAgLogic™SSI
Adapterhasbeenupdatedwilldisplayinthe“What’sNew”
ontheAgLogic™SystemHomescreen.
PFP11260(08JUN11)
7
060811
PN=9
PFP11260(08JUN11)
8
060811
PN=10
PFP11260(08JUN11)
9
060811
PN=11
PFP11260(08JUN11)
10
060811
PN=12
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
John Deere PFP11260 is an AgLogic™ SSI Adapter that allows data to come across from the Agvance® System from Software Solutions Integrated, LLC (SSI) into the AgLogic™ System. It supports integration with MS SQL Server 2000 or greater, and enables the creation of a Location for a Work Order based on data in Agvance®. The adapter can be configured to ignore certain fields and process field boundary information. It also provides Unit Of Measure Mappings for Dry and Liquid Work Orders.
Ask a question and I''ll find the answer in the document
Finding information in a document is now easier with AI
Related papers
Other documents
-
Wiley 978-0-470-24795-2 Datasheet
-
Kofax MarkView 10.2.0 Upgrade Guide
-
-
-
Dell Wyse V50LE Installation guide
-
Novell ZENworks Endpoint Security Management 3.5 Installation guide
-
-
Wiley 978-0-470-13411-5 Datasheet
-
-
