Skip to main content

Di Network Import

Overview

The DI Network is a specialized type of network within our system designed to serve specific customer based on their rate card types. This documentation provides details on DI Network functionality, criteria for customer inclusion, and the steps for importing a DI Network.

What is a DI Network?

A DI Network is a network that serves customers with unique rate card types. The rate card types associated with DI Network include

  1. ViSN with DI Network
  2. ViSN with DI Network and Paybill

In addition to supporting these specialized rate cards, the DI Network can also handle customers with one-to-one relationships, similar to a traditional network setup. This flexibility allows it to serve both individual customers and customers with specialized rate cards.

download sample DI Network import file.

DI Network

Column PositionHeader NameDescriptionDatatypeValidationMax lengthMandatoryDefault ValueExample
ADI Group IDId of the GroupstringA-Z, 0-9 and all special characters30NoymaA5vcxNWOwzKOdvIMA
BDI Supplier IDId of the SupplierstringA-Z and 0-920NolpEfZekDPAabVoyzcFxM
CERP Garage IDExternal Rate Provider Garage IDNumber0-9-No1900
DERP Garage Group IDExternal Rate Provider Garage Group IDNumber0-9-No768
ELocaleLocale of the supplierstringen_GB(The string should be en_GB for uk supplier) or en_IE(The string should be en_IE for Ireland supplier)-Yesen_GB
FGroup IDGroup ID of the supplierstringA-Z and 0-920YesDIVSN10024
Ghas FNPFNB Availability StatusstringY or N1NoNY
HFNP BandFNP band valueString

Band 1 LA1, Band 2 LA1, Band 3 LA1, Band 5 (M25) LA1, Band 1 LA2, Band 2 LA2, Band 3 LA2, Band 5 (M25) LA2, Band 1 LA3, Band 2 LA3, Band 3 LA3, Band 5 (M25) LA3, NONE

20YesBand 1 LA1
ISupplier Group NameGroup Name of the supplierstringA-Z ,0-9 and all special characters250YesBellinger & Sons Vauxhall Wantage
JSupplier IDId of the supplierstringA-Z ,0-920NoAD13HBG
KSupplier NameName of the supplierstringA-Z ,0-9 and all special characters250NoAncaster Dartford Renault
LPaybill

Determines how the suppliers are paid.

  1. ViSN Hybrid - Customer's Network and DI Network with Paybill.
    VISN - Digital INNK will pay the supplier for this customer
    DIRECT - Customer will pay the supplier directly
  2. ViSN with DI Network and Paybill- Digital INNK will pay the suppliers
  3. External Rate Provider Paybill - External Rate Provider will pay the suppliers

stringVISN or DIRECT-YesVISN
MVAT Registration NumberVAT Registration NumberstringA-Z ,0-920NoVAT1234
NCompany NumberCompany NumberstringA-Z ,0-920NoCMP1234
ONominated Dealer ManagerNominated Dealer ManagerstringA-Z ,0-9, hyphen and space20YesSteve Philips
PAddress 1Building NumberstringA-Z ,0-9 and all special characters20No88
QAddress 2Address 2stringA-Z ,0-9 and all special characters50NoPlaistow Lane
RAddress 3Address 3stringA-Z ,0-9 and all special characters50NoBromley
SAddress 4Address 4stringA-Z ,0-9 and all special characters50NoKent
TAddress 5Address 5stringA-Z ,0-9 and all special characters50NoMiddlesex
UPostcodePostcodestringStandard UK and Ireland postcode validation-YesSE20 7TF
VCustom weekday opening hoursOpening Time (weekday)string24hr time format5No09:00
WCustom Weekday closing hoursClosing Time (weekday)string24hr time format5No17:30
XCustom Sat opening hoursSaturday opening timestring24hr time format5No09:30
YCustom Sat closing hoursSaturday closing timestring24hr time format5No12:30
ZOpen on SundayIs opening on sunday?stringY or N1NoNY
AACustom Sun Opening hoursSunday opening timestring24hr time format5No09:30
ABCustom Sun Closing hoursSunday closing timestring24hr time format5No11:30
ACRegion 1Region 1stringA-Z ,0-9, hyphen and space50NoEvans Halshaw
ADRegion 2Region 2stringA-Z ,0-9, hyphen and space50NoEast Sussex
AERegion 3Region 3stringA-Z ,0-9, hyphen and space50NoBrightonCCC
AFPrimary Phone NumberPrimary Phone NumberstringA-Z ,0-9 and all special characters20Yes02082 908700
AGBooking Phone NumberBooking Phone NumberstringA-Z ,0-9 and all special characters20No02082 908700
AHFax NumberFax NumberstringA-Z ,0-9 and all special characters20No02087 689200
AIemailemail of the supplierstringA-Z ,0-9 and all special characters100Novishwa@digitalinnk.com
AJdescriptiondescriptionstringA-Z ,0-9 and all special characters50Nosupplier from Chelmsford
AKnotesnotesstringA-Z ,0-9 and all special characters20NoNotes
ALMax HeightMax HeightstringA-Z ,0-9,underscore,hyphen and plus sign20No+123
AMMax LengthMax LengthstringA-Z ,0-9,underscore,hyphen and plus sign20No-58
ANMax WeightMax WeightstringA-Z ,0-9,underscore,hyphen and plus sign20No77
AOLast Physical AuditLast Physical Audit-No Validation available for this field-No-
APLast Desktop AuditLast Desktop Audit-No Validation available for this field-No-
AQAncillary equipment servicing & repairsAncillary equipment servicing & repairs (tail lift, flashing beacon, refrigeration units)stringY or N1NoNY
AREngine RebuildEngine RebuildstringY or N1NoNY
ASDPF filtersDPF filtersstringY or N1NoNY
ATLOLER (Weight testing)LOLER (Weight testing)stringY or N1NoNY
AUMis-fuelingMis-fuelingstringY or N1NoNY
AVReplacement keys & door locksReplacement keys & door locksstringY or N1NoNY
AWSmart repairs (to bodywork)Smart repairs (to bodywork)stringY or N1NoNY
AXCollection DelCollection DelstringY or N1NoNY
AYCollection NTDCollection NTDstringY or N1NoNY
AZCollection Lead TimeCollection Lead TimeNumber0-92No44
BACollection RadiusCollection RadiusNumber0-92No22
BBCollection NotesCollection NotesstringA-Z ,0-9 and all special characters30NoCollection Notes
BCCourtesy CarCourtesy CarstringY or N1NoY
BDCourtesy Car NtdCourtesy Car NtdstringY or N1NoNY
BECourtesy Car Lead TimeCourtesy Car Lead TimeNumber0-92No22
BFCourtesy Car NotesCourtesy Car NotesstringA-Z ,0-9 and all special characters30NoNotes about courtesy car service
BGWhile You WaitWhile You WaitstringY or N1NoNY
BHWhile You Wait NTDWhile You Wait NTDstringY or N1NoNY
BIWhile You Wait Lead TimeWhile You Wait Lead TimeNumber0-92No22
BJWhile You Wait NotesWhile You Wait NotesstringA-Z ,0-9 and all special characters30NoNotes about while you wait service
BKDrop OffDrop OffstringY or N1NoNY
BLDrop Off NTDDrop Off NTDstringY or N1NoNY
BMDrop Off Lead TimeDrop Off Lead TimeNumber0-92No43
BNOut Of HoursOut Of HoursstringY or N1NoNY
BOMobileMobilestringY or N1NoNY
BPMobile Lead TimeMobile Off Lead TimeNumber0-92No43
BQMobile RadiusMobile RadiusNumber0-93No43
BRFranchiseFranchisestringA-Z ,0-9 and all special characters30YesAll
BSIndependentIndependentstringY or N1NoNY
BTIs On ViSNIs On ViSNstringY or N1NoNY
BUBosch StatusBosch StatusstringA-Z ,0-98No-
BVNetworkNetworkstringA-Z ,0-98No-
BWNetwork LevelNetwork LevelstringA-Z ,0-98No-
BXLabour CarLabour Carstring0-9 and .(decimal number)6No4.5
BYLabour Rate LCVLabour Rate LCVstring0-9 and .(decimal number)6No4.5
BZLabour Rate EVLabour Rate EVstring0-9 and .(decimal number)6No4.5
CAParts DiscountParts Discountstring0-9 and .(decimal number)5No94.5
CBMOT Class1MOT Class1string0-9, .(three digit decimal number)6No941.5
CCMOT Class2MOT Class2string0-9, .(three digit decimal number)6No941.5
CDMOT Class3MOT Class3string0-9, .(three digit decimal number)6No941.5
CEMOT Class4MOT Class4string0-9, .(three digit decimal number)6No941.5
CFMOT Class5MOT Class5string0-9, .(three digit decimal number)6No941.5
CGMOT Class7MOT Class7string0-9, .(three digit decimal number)6No941.5
CHSemi Synthetic1Semi Synthetic1string0-9 and .(decimal number)6No4.5
CISemi Synthetic2Semi Synthetic2string0-9 and .(decimal number)6No4.5
CJSynthetic1Synthetic1string0-9 and .(decimal number)6No4.5
CKSynthetic2Synthetic2string0-9 and .(decimal number)6No4.5
CLSynthetic3Synthetic3string0-9 and .(decimal number)6No4.5
CMAd BlueAd Bluestring0-9 and .(decimal number)6No4.5
CNBrake FluidBrake Fluidstring0-9 and .(decimal number)6No4.5
COAir Conditioning CoolantAir Conditioning Coolantstring0-9 and .(decimal number)6No4.5
CPAnti FreezeAnti Freezestring0-9 and .(decimal number)6No4.5
CQAutomatic Transmission FluidAutomatic Transmission Fluidstring0-9 and .(decimal number)6No4.5
CRAxle OilAxle Oilstring0-9 and .(decimal number)6No4.5
CSGearbox Oil MineralGearbox Oil Mineralstring0-9 and .(decimal number)6No4.5
CTGearbox Oil SyntheticGearbox Oil Syntheticstring0-9 and .(decimal number)6No4.5
CUHydraulic FluidHydraulic Fluidstring0-9 and .(decimal number)6No4.5
CVLong Life OilLong Life Oilstring0-9 and .(decimal number)6No4.5
CWMineral OilMineral Oilstring0-9 and .(decimal number)6No4.5
CXOther FluidOther Fluidstring0-9 and .(decimal number)6No4.5
CYPower Steering FluidPower Steering Fluidstring0-9 and .(decimal number)6No4.5
CZRefrigerator CoolantRefrigerator Coolantstring0-9 and .(decimal number)6No4.5
DASuspension FluidSuspension Fluidstring0-9 and .(decimal number)6No4.5
DBMerchant FeeMerchant FeestringNo validation present-No-
DCAccount System ReferenceAccount System ReferencestringA-Z,0-98NoABC123
DDService And Maintenance RepairService And Maintenance RepairstringY or N1NoNY
DEAccident Management Body ShopAccident Management Body ShopstringY or N1NoNY
DFTyresTyresstringY or N1NoNY
DGGlassGlassstringY or N1NoNY
DHMOTMOTstringY or N1NoNY
DIBreakdownBreakdownstringY or N1NoNY
DJCarCarstringY or N1NoNY
DKCommercial Under 3_5 tonneCommercial Under 3_5 tonnestringY or N1NoNY
DLCommercial Over 3_5 tonneCommercial Over 3_5 tonnestringY or N1NoNY
DMHGVHGVstringY or N1NoNY
DNMotorBikesMotorBikesstringY or N1NoNY
DOElectric vehicles CarElectric vehicles CarstringY or N1NoNY
DPElectric vehicles LCVElectric vehicles LCVstringY or N1NoNY
DQWash and VacWash and VacstringY or N1NoNY
DRComplimentary RefreshmentsComplimentary RefreshmentsstringY or N1NoNY
DSWiFiWifistringY or N1NoNY
DTParkingParkingstringY or N1NoNY
DUDisposal ChargesDisposal ChargesstringDecimal Number(format should be 00.00)-No99.47
DVValveValvestringDecimal Number(format should be 00.00)-No99.47
DWWheel BalanceWheel BalancestringDecimal Number(format should be 00.00)-No99.47
DXServing ProximityServing Proximitystring

should be a number between '0' and '999' (if serving proximity is not added, then 50 miles will be used as default)

3No955
DYWheel Alignment2Wheel Alignment2stringDecimal Number(format should be 00.00)-No99.47
DZWheel Alignment4Wheel Alignment4stringDecimal Number(format should be 00.00)-No99.47
EARebate AmountRebate AmountstringDecimal Number(format should be 00.00)-No99.47
EBRebate PercentageRebate PercentagestringDecimal Number(format should be 00.00)-No99.47

Importing a Di Network

Preparation

  1. Create a new branch with Jira task number in the branch name

  2. Delete all the files within the importFiles folder to prevent accidental import of incorrect files

  3. Create a folder with the current sprint number

  4. Copy the file that needs to be imported

  5. Go to package.json , find the line validate:diNetworkImport

  6. Modify --file with the relative path of the file

  7. Save the package.json

Validating locally

  1. in a terminal run npm run build

  2. in a terminal run npm run validate:diNetworkImport

  3. If there are no errors, push the code

Validating in workflow

  1. Go to Action of Import-manger

  2. Find <Environment> - on-demand-import

  3. Select the branch that was created for this import

  4. Enter script name as validate:diNetworkImport

  5. Leave Overrides empty

Importing the file

  1. If the validation has passed

  2. Go to Action of Import-manger

  3. Find <Environment> - on-demand-import

  4. Select the branch that was created for this import

  5. Enter script name as validate:diNetworkImport

  6. Enter --persist in Overrides field

Importing and Validating the file via cloud run

Creating Schedulers for validating the di network file

  1. Go to Cloud Scheduler and select the CREATE JOB

Setup Required

A Scheduler should be created cloud scheduler with the following parameters

  • Name: di_network_validation
  • Region: europe-west2
  • Frequency: 0 0 31 12 1
  • TimeZone: GMT London
  • Target type: HTTP
  • URL: https://import-manager-36r2bu4izq-uc.a.run.app/di-network-import
  • HTTP method: POST
  • Auth header: select OIDC token
  • Service account: cloud-run-import-customer-contract
  • body: a JSON object including the following parameters

JSON object for di_network_validation scheduler

{
"persist": "false",
"bucket": "biddirect-2.appspot.com",
"appDirectory": "/usr/src/app/",
"importPath": "imports/fileDrop/",
"importFileDropPath": "imports/fileDrop/",
"importFileName": "diNetworkImport.csv",
"email": "mailgun@digitalinnk.com",
"fatalErrorEmailToAddress": "mailgun@digitalinnk.com"
}

Create scheduler for validating di network

Creating Schedulers for importing the di network file

  1. Go to Cloud Scheduler and select the CREATE JOB

Setup Required

A Scheduler should be created cloud scheduler with the following parameters

  • Name: di_network_import
  • Region: europe-west2
  • Frequency: 0 0 31 12 1
  • TimeZone: GMT London
  • Target type: HTTP
  • URL: https://import-manager-36r2bu4izq-uc.a.run.app/di-network-import
  • HTTP method: POST
  • Auth header: select OIDC token
  • Service account: cloud-run-import-customer-contract
  • body: a JSON object including the following parameters

JSON object for di_network_import scheduler

{
"persist": "true",
"bucket": "biddirect-2.appspot.com",
"appDirectory": "/usr/src/app/",
"importPath": "imports/fileDrop/",
"importFileDropPath": "imports/fileDrop/",
"importFileName": "diNetworkImport.csv",
"email": "mailgun@digitalinnk.com",
"fatalErrorEmailToAddress": "mailgun@digitalinnk.com"
}

Create scheduler for validating di network

Preparation:

  1. Bucket name is biddirect-2.appspot.com and it will vary for higher envs and the file path should be imports/fileDrop, where you can drop the CSV file named "diNetworkImport". This action will place the file in the specified location within the designated bucket.

Validation:

  1. Go to Cloud Scheduler
  2. Run di_network_validation job (job name could be different on other env)
logs in cloud

Importing:

  1. Go to Cloud Scheduler
  2. Run di_network_import job (job name could be different on other env)
logs in cloud

Testing

  1. Suppliers will be created under the specified group Id. This can be checked in the list of suppliers which belong to the group in DI Admin
Status: Approved
Category: Protected
Authored By: Hadley on May 30, 2024
Revisions
03 Apr, 2025 - Removed a few fields, VN-17246
11 Apr, 2025 - Added specialist services and opening hours, VN-17292 - Hadley