LogoLogo
No Code Service CreationPowerful Integrated FormsGCloud Information
  • The OneVu Digital Platform
  • Features and Benefits
  • Core Functionality
    • Creating an account
    • Get Answers Fast
    • Submit a Request
    • Track My Requests
    • Profile
      • Changing Contact Details
        • Changing Email
        • Changing Mobile Number
        • Linking to Messenger
        • Linking to WhatsApp
      • Changing Address
      • Changing Name
      • Changing Date of Birth
      • Notification Preferences
      • Citizen Timeline
      • Family and Friends
      • Bookmarked Services
    • MyAccount
    • Two factor authentication
  • 🌩️Integrations
    • Introduction
    • Council Tax
      • Civica
      • Northgate
      • Capita
    • Payments
      • Capita Pay360
      • Civica Pay - eStore2
      • GOV.UK Pay
    • Waste
      • Bartec Collective
      • Whitespace Powersuite
      • Yotta Mayrise
      • Yotta Alloy
      • Civica APP (Flare)
    • Housing Rents/Repairs
      • Northgate
    • Benefits
      • Capita
      • Civica
      • Northgate
    • Landlords
      • Capita
      • Civica
      • Northgate
    • Business Rates
      • Capita
      • Civica
      • Northgate
    • Business Improvement Districts
      • Northgate
    • Licensing
      • IDOX Uniform
    • Environmental Health
      • Civica APP (Flare)
    • Concessionary Travel
      • IEG4 Blue Badge
    • Health
      • Digital CHC
    • Notifications
      • GOV.UK Notify
      • Facebook Messenger
      • WhatsApp
    • Fraud & Identity
      • Loqate - Bank validation
      • Xantura - RBV
      • Transunion - RBV
      • TransUnion - ID Verification
    • Maps / Assets
      • Bing Maps
      • Symology
    • Address Look Ups
      • Ordnance Survey - Places API
      • Loqate
    • Bookings
      • Microsoft Bookings
    • OAuth2 - Identity
    • DfE FSM Eligibility Checker
    • DfT Blue Badge
  • πŸ› οΈOneVu Control
    • Data Silos
      • The basics
      • Content Management - Simple
        • Adding static content
        • Settings
      • Dynamic Content Management
        • Registration
        • Connection Requirements
        • Using back-office data
          • Simple Data Items
          • Arrays of data
          • Data Item Collections
          • Nested Collections
          • Simple Item Formatting
          • Collection Item Formatting
          • Data item calculations
        • High Level Conditions
          • Simple true / false rules
          • Dynamic true/false rules
          • Deeper Dynamic rules
          • AND Conditions
          • OR Conditions
          • NOT Conditions
        • In Section Visibility/Rules
          • If True
          • If Not True
          • If Equal To (v1)
          • If Equal To (v2)
          • If Not Equal To
          • If Greater Than
          • If Less Than
          • If Last
          • If First
          • If Null
          • If Not Null
          • Collections & complex rules
        • Importing a silo
    • Groups
      • Permissions
    • Users
    • Settings - OneVu
    • Account Management
    • Portals
    • Banners
    • Privacy Statements
    • Audit Logs
    • Diagnostics
  • πŸ“žCustomer Service Vu
    • Introduction
    • Contact Logging
      • Notes
    • A Single Timeline
    • Set up
      • Service Areas
      • Locations
  • πŸ’¬Broadcast
    • Introduction
    • Generic notifications
      • Adding From Addresses
      • Adding Email Headers
      • Adding Email Footers
      • GOV.UK Notify Templates
      • Notification Frequency
      • Broadcast Topics
        • Linking - GOV.UK Notify Template
        • Linking - Email Header
        • Linking - Email Footer
        • Linking - SMS Template
      • Broadcast Articles
        • Web Content
        • Plain Text Emails
        • HTML based emails
        • Messages
      • Topic visibility in OneVu
      • Broadcast and CitizenVu
    • eNotifications/eBilling
      • Introduction
      • Functionality
        • Opt In functionality
        • Your Profile
      • Set up
        • Setting up notification types
        • Notification content
          • Notification placeholders
          • Email (Standard)
          • Email (GOV.UK Notify)
          • SMS (GOV.UK Notify)
          • Facebook Messenger
          • WhatsApp
        • Import notification files
          • File Column Mapping
          • Bulky File Import
        • Bulk Export File
      • Notification Audit
      • Contact Management
  • πŸ—ΊοΈYour Area
    • Introduction
    • Community Directory
    • Your Issues
  • ☁️OneVu API
    • Introduction
    • Methods
  • πŸ“˜My Area Directories
    • Presentation
    • Creating/editing a directory
    • Defining fields in an empty directory
    • Adding records to an empty directory
    • Adding a URL endpoint to an API Directory & Hybrid Directory
    • Importing a CSV file to a Hybrid Directory
    • Importing a CSV file to a Hybrid Directory
    • Configure My Area Directory Display Component
    • Configure My Area Directory Component
    • Configure My Area Directory Component
    • Configure My Area Directory Component
    • Configure My Area Directory Container/Directory Groups component
    • Configure My Area Directory Container/Directory Groups component
    • Configure My Area to display in OneVu
  • βœ…OpenProcess
    • Introduction
    • My tasks
    • Supervise Tasks
    • Search Processes
    • Start Process
    • Abandon a Process
    • Process Retention Periods
    • Building Processes
      • Your first process
      • Step Set Up
        • Standard Steps
        • Auto-completing steps
        • Branches
        • REST API Steps
          • Worked example
      • Actions
        • IEG4 Emails
        • GOV.UK Notify Emails
        • GOV.UK Notify SMS
        • WhatsApp Messages
        • Messenger Messages
    • Two-way Communication
    • πŸ› οΈSet Up
      • Fields
      • Categories
      • Groups
        • Permissions
      • Users
      • Organisations
    • πŸ’ΎExport to CSV
    • ⚑OpenProcess Flex
      • Cases Functionality
      • Process Branches
        • Nested Branches
        • Multiple Conditions
        • Advanced Conditions
      • Work allocation in branches
      • Choice Fields
      • Mandatory Fields
      • Branches - Search Processes
      • OneVu - Track my Requests
      • Dynamic Notifications
        • Worked Example
      • Worked Example - Simple
      • Worked Example - Advanced
    • πŸ”€OpenProcess EDMS
      • Document Indexing
        • Multiple Indexing Queues
      • Bulk Document Import
      • Create a Document
      • Set Up
        • Document Types
        • Document Templates
          • Headers
          • Footers
          • Stylesheets
          • Templates Admin/Use
        • Service Areas
        • Account Extracts
          • User Functionality
          • IT Facing Functionality
  • ☁️OpenProcess API
    • Introduction
    • Getting an API Key
    • Methods
    • Webhooks - REST API Steps
  • πŸ“ˆReporting
    • OneVu
    • CS Vu
    • OpenProcess
    • Reporting Database
  • πŸ’Community Content
    • OneVu
      • Council Tax
        • Capita Content
        • Civica Content
        • Northgate Content
        • Sample Demo Content
      • Benefits
        • Capita Content
        • Civica Content
        • Northgate Content
      • Business Rates
        • Capita Content
        • Civica Content
        • Northgate Content
      • Licensing
        • IDOX Uniform Content
      • Housing
        • Northgate Rents Content
        • Northgate Repairs Content
    • eDesigner
    • OpenProcess
      • Council Tax
      • Benefits
      • Business Rates
      • Building Control
      • Adult Social Care
      • Licensing
      • Planning
      • Street Name and Numbering
      • Complaints
      • Housing
      • Waste
      • Environmental Health
      • Streets and Parks
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. OpenProcess
  2. OpenProcess EDMS
  3. Set Up
  4. Account Extracts

IT Facing Functionality

Where a customer has the EDMS module of OpenProcess we provide a little app who’s job it is to import files. The process is very simple.

  1. Get the Bulk Upload Tool application (exe file) from IEG4

  2. Get the Import Claim Extract application (bat file) from IEG4

  3. Download its contents and place in a location which has access to your extracts i.e. it can import from a server location but it’s clearly best to place the application on the same server as where the extracts are saved to.

  4. Edit the Import Claim Extract.bat file (you can simply edit the file using notepad) to:

    1. Tell it the location of the exe file

    2. Tell it where to pull files from

To provide an example of 4) this is the configuration you might have for the license extract from earlier. The bits in bold relate to a) and b) above:

"C:\Users\johnmcmahon\Desktop\bulk-upload-tool-v1.0.0\bulk-upload-tool- v1.0.0\bulk-upload-tool.exe"

β€œC:\Users\johnmcmahon\Desktop\TestExtract\IDOXLicensingExtract.txt"

openprocesstestindexing ?sv=2017-11-09^&sr=c^&si=bulk-import- tool^&sig={key} extracts-for-processing Endpoint=sb:// openprocess-test- northeu.servicebus.windows.net/;SharedAccessKeyName=bulkuploader;SharedAcc essKey={securekey}

The bit above in italics should not be touched.

When the bat file is clicked the program will run. You can see a trace of the process with an example below:

"C:\Users\johnmcmahon\Desktop\bulk-upload-tool-v1.0.0\bulk-upload-tool-
v1.0.0\bulk-upload-tool.exe"
β€œC:\Users\johnmcmahon\Desktop\TestExtract\IDOXLicensingExtract.txt"
openprocesstestindexing ?sv=2017-11-09^&sr=c^&si=bulk-import-
tool^&sig=ZPe2ZpWE2nYIZzLT0gsEvKdjie7zoquT5Un6kYqP%%2FMM%%3D edf290f5-
fce6-43ff-8e62-acd48c7d1ffc extracts-for-processing Endpoint=sb://openprocess-
test-
northeu.servicebus.windows.net/;SharedAccessKeyName=bulkuploader;SharedAccessKey
={securekey}

Destinition location: https://openprocesstestindexing.blob.core.windows.net/ edf290f5-fce6-43ff-8e62-acd48c7d1ffc/IDOXLicensingExtract.txt? sv=2017-11-09&sr=c&si=bulk-import- tool&sig=ZPe2ZpWE2nYIZzLT0gsEvKdjie7zoquT5Un6kYqP%2FMM%3D

Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0
Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0
Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0
Bytes uploaded: 0, Files Transferred: 0, Files Skipped: 0, Files Failed 0
Bytes uploaded: 1151313, Files Transferred: 0, Files Skipped: 0, Files Failed 0
Bytes uploaded: 1151313, Files Transferred: 1, Files Skipped: 0, Files Failed 0
File transfer complete
Files transferred: 1
C:\Users\johnmcmahon\Desktop\TestExtract\IDOXLicensingExtract.txt
Files skipped: 0
Files failed: 0
Queue failures: 0
C:\Users\johnmcmahon\Desktop>PAUSE
Press any key to continue . . .

SIMPLES!

Also as the files are bat files you can run a windows script to automate this process to be in the middle of the night etc.


PreviousUser FunctionalityNextIntroduction

Last updated 3 years ago

Was this helpful?

βœ…
πŸ”€