Difference between revisions of "Data Migration"
(→Standard Migration) |
m (→Standard Migration) |
||
| Line 11: | Line 11: | ||
==Standard Migration== | ==Standard Migration== | ||
| − | A standard migration will import People/Organisation records into your system. You can download the migration spread sheet from the [[Data Migration Centre]]. The cost of this service is £150 (ex VAT) per spreadsheet, with no limit on the number of records you can add to the spreadsheet. The data is then reviewed by one of our migration specialists, who will then process the data. The data is always migrated to a test environment, so you can ensure that it is accurate. | + | A standard migration will import People/Organisation records into your system. You can download the migration spread sheet from the [[Data Migration Centre]]. The cost of this service is £150 (ex VAT) per spreadsheet, with no limit on the number of records you can add to the spreadsheet. The data is then reviewed by one of our migration specialists, who will then process the data. The data is always migrated to a test environment, so you can ensure that it is accurate. Once the data has been checked, your live system is backed up and the data is then migrated to the system. |
Example of record types; | Example of record types; | ||
| Line 18: | Line 18: | ||
===Fields Included=== | ===Fields Included=== | ||
| − | Accommodation Type, Address line 1, Address line 2, Address line 3, Address line 4 (Town), Address line 5 (County), Date of Birth, Email Address (Main), Emergency Telephone No., Employed?, Ethnic Group, First Referral Date, Forename, s), Gender, Is this a GP (Doctor)?, Is this a GP Surgery?, Is this a School?, Living Arrangements, Main Disability, Main Telephone No., Marital Status, Mobile Telephone No., Name, Notes / General, Description, Postal District, Postcode, Record Type, Religious Group, Sexual Orientation, Status, Title | + | Accommodation Type, Address line 1, Address line 2, Address line 3, Address line 4 (Town), Address line 5 (County), Date of Birth, Email Address (Main), Emergency Telephone No., Employed?, Ethnic Group, First Referral Date, Forename, s), Gender, Is this a GP (Doctor)?, Is this a GP Surgery?, Is this a School?, Living Arrangements, Main Disability, Main Telephone No., Marital Status, Mobile Telephone No., Name, Notes / General, Description, Postal District, Postcode, Record Type, Religious Group, Sexual Orientation, Status, Title. |
| + | |||
| + | You can also add a client to a project, this creates a referral at a specified date. | ||
===Fields Not Included=== | ===Fields Not Included=== | ||
| Line 27: | Line 29: | ||
====Other Fields/Data Not Included==== | ====Other Fields/Data Not Included==== | ||
| − | Any extension databases, Associated GP Surgeries, Associated GPs, Associated Organisations, Associated People, Audit Record, Benefits & Income, Client Assignments, Club & Clinic Attendances, Club & Clinic Membership, Contact & Consent Rules, Courses, Disabilities, Emergency Card, Equipment, EziTracker™ Details, Funder Details, Groups & Skills, Invoices, Job Cards (Assigned), Job Cards (Home from hospital), Job Cards (Vols), Letters & Communication, NoK & Contacts, Private Notes, Pro-Referrer User, Qualifications, Reported Disabilities, Supporting People, Uploaded Docs, Relationships. | + | Any extension databases, Associated GP Surgeries, Associated GPs, Associated Organisations, Associated People, Audit Record, Benefits & Income, Client Assignments, Club & Clinic Attendances, Club & Clinic Membership, Contact & Consent Rules, Courses, Disabilities, Emergency Card, Equipment, EziTracker™ Details, Funder Details, Groups & Skills, Invoices, Job Cards (Assigned), Job Cards (Home from hospital), Job Cards (Vols), Letters & Communication, NoK & Contacts, Private Notes, Pro-Referrer User, Qualifications, Reported Disabilities, Supporting People, Uploaded Docs, Relationships and any contact information. |
---- | ---- | ||
[[File:helpheader_small.png|right]] | [[File:helpheader_small.png|right]] | ||
Revision as of 16:33, 8 January 2018
There are a range of Data Migration, Import and maintenance services available, for Charitylog. These services can be purchased at any time, available for new and existing systems.
- Standard Migration
- Advanced Migration
- Merging of Charitylog Systems
- Local Super Output Area Migration
- Classification Code Migration
- Bulk Organisation/Person record merge
- Branch Deletion
Contents
Standard Migration
A standard migration will import People/Organisation records into your system. You can download the migration spread sheet from the Data Migration Centre. The cost of this service is £150 (ex VAT) per spreadsheet, with no limit on the number of records you can add to the spreadsheet. The data is then reviewed by one of our migration specialists, who will then process the data. The data is always migrated to a test environment, so you can ensure that it is accurate. Once the data has been checked, your live system is backed up and the data is then migrated to the system.
Example of record types;
Clients, Donors, Funders, Organisations, Others, Professionals, Referrers, Roster Workers, Staff, Suppliers, Trustees, Volunteers and other customisable records.
Fields Included
Accommodation Type, Address line 1, Address line 2, Address line 3, Address line 4 (Town), Address line 5 (County), Date of Birth, Email Address (Main), Emergency Telephone No., Employed?, Ethnic Group, First Referral Date, Forename, s), Gender, Is this a GP (Doctor)?, Is this a GP Surgery?, Is this a School?, Living Arrangements, Main Disability, Main Telephone No., Marital Status, Mobile Telephone No., Name, Notes / General, Description, Postal District, Postcode, Record Type, Religious Group, Sexual Orientation, Status, Title.
You can also add a client to a project, this creates a referral at a specified date.
Fields Not Included
Main Fields
Accounts Code, Active, Age Range, Alternative Identifier, Any Disabilities?, Blue Badge Holder?, Charitylog ID Number, Consent Given, Current School Year, DBS/PVG Certificate Number, DBS/PVG Checked?, DBS/PVG Expiry Date?, DBS/PVG Issued Date?, Deceased?, Department, Eligible For Gift Aid?, Email Address (Other), Fax/Other Telephone No., General Category of Need, GP Name, GP Surgery, ID Badge Number, Image or logo, Include in Info. Links, Induction Date, Initials, Is this an Org/Signpostee?, Job Title, Landline Telephone No., Main Language, Main Referrer/Contact, NHS Number, NI Number, PAYE Reference, Payment Method, People in Household, Person/Organisation Category, PIN (for CM System), Preferred Known As, Preferred Method of Communication, References Taken?, Registered Disabled?, Risk Assessment, Salutation, School, School Year Offset, Second Referrer/Contact, Service User Group, Social Media Link 1, Social Media Link 2, Social Media Link 3, Social Services ID No., UDPRN (Royal Mail), User Name, Usual Support Worker, UTR Number, Victim of Crime, Website.
Other Fields/Data Not Included
Any extension databases, Associated GP Surgeries, Associated GPs, Associated Organisations, Associated People, Audit Record, Benefits & Income, Client Assignments, Club & Clinic Attendances, Club & Clinic Membership, Contact & Consent Rules, Courses, Disabilities, Emergency Card, Equipment, EziTracker™ Details, Funder Details, Groups & Skills, Invoices, Job Cards (Assigned), Job Cards (Home from hospital), Job Cards (Vols), Letters & Communication, NoK & Contacts, Private Notes, Pro-Referrer User, Qualifications, Reported Disabilities, Supporting People, Uploaded Docs, Relationships and any contact information.
