[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4694: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4696: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4697: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4698: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
 ClinicOffice Support Forum • View topic - FAQ 302: Can I import data into my database?

FAQ 302: Can I import data into my database?

Frequently Asked Questions relating to ClinicOffice v4 and v5
Forum rules
*** NOTE: This is our OLD FORUM WEBSITE *** Please go to https://pioneersoftware.co.uk/forums

FAQ 302: Can I import data into my database?

Postby Support » November 3rd, 2008, 9:23 am

ClinicOffice Support Team
User avatar
Support
Site Admin
 
Posts: 888
Joined: August 25th, 2005, 6:37 pm

Re: #12 Can I import data into my database?

Postby longbo » January 5th, 2009, 1:14 pm

Hi

I'm currently contemplating changing to Clinic Office :mrgreen: and I'm looking at importing patient data.

In the sample files, patients have a listed GP for example. Is this field not linked to a list of GPs? How is this linking accomplished? [The database I am currently using has a numeric reference in this column, which is linked to the database of GPs.]

Regards

John
longbo
 
Posts: 25
Joined: January 5th, 2009, 1:05 pm

Re: #12 Can I import data into my database?

Postby Support » January 6th, 2009, 11:06 am

Hi John,

You should specify the GPs name in the import file (e.g. Dr Phillip Jones) and then ClinicOffice will search your Contacts Database to match the name to an existing Contact record. If it can't find a matching record, it will create a new contact record for the GP.
ClinicOffice Support Team
User avatar
Support
Site Admin
 
Posts: 888
Joined: August 25th, 2005, 6:37 pm

Re: #12 Can I import data into my database?

Postby longbo » January 7th, 2009, 10:48 am

longbo
 
Posts: 25
Joined: January 5th, 2009, 1:05 pm

Re: #12 Can I import data into my database?

Postby Support » January 9th, 2009, 4:33 am

ClinicOffice Support Team
User avatar
Support
Site Admin
 
Posts: 888
Joined: August 25th, 2005, 6:37 pm

Re: FAQ 302: Can I import data into my database?

Postby eniola231 » May 22nd, 2018, 12:41 pm

Hello support team, I tried to import appointment into my database using csv file but I got validation failed message with error “one or more records contain invalid data in the field ‘start’
Also on attempt to import staff, validation also failed with message “ Required field ‘lastname’ Is missing from import file. Even when I can see lastname in the spreadsheet when opened.

Thanks
eniola231
 
Posts: 42
Joined: February 26th, 2013, 6:57 pm
Location: Lagos

Re: FAQ 302: Can I import data into my database?

Postby Josh Barrs » May 23rd, 2018, 2:11 pm

Hi Eniola231,

Sorry to hear you are having problems with this. The most likely cause is that the data hasn't quite been formatted correctly for ClinicOffice to recognise it. Please use this link to view some demonstrations of how the data needs to be formatted:
ClinicOffice Support Team
User avatar
Josh Barrs
 
Posts: 43
Joined: August 25th, 2016, 2:26 pm


Return to FAQ Articles (START HERE if looking for help!)

Who is online

Users browsing this forum: No registered users and 0 guests

cron