We have installed TimeTrex community edition on-site v7.3.10-20140707, we had some trouble with the CSV files we created and the import wizard, so we decided to try a SQL insert directly to the users table via Postgre's Pgadmin tool.
Here is the SQL we constructed based off of the admin user and a test user :
Code: Select all
insert into users (
id,
company_id,
status_id,
user_name,
password,
phone_id,
phone_password,
first_name,
last_name,
city,
province,
country,
work_phone,
home_phone,
work_email,
birth_date,
hire_date,
sex_id,
created_date,
created_by,
updated_date,
updated_by,
deleted,
labor_standard_industry,
title_id,
default_branch_id,
default_department_id,
employee_number,
group_id,
currency_id,
second_last_name,
first_name_metaphone,
last_name_metaphone,
password_updated_date,
ethnic_group_id,
default_job_id,
default_job_item_id)
in bold red on the top of the screen. This does not occur with the other test users created via the front end.WARNING: TimeTrex was unable to set your time zone. Please contact your TimeTrex administrator immediately.
Our question is the following, a) Can you provide insight into whether or not another table exists that we need to insert to? Is our SQL OK? Or b) can you provide us with a sample CSV file that we can populate for the import Wizard to work correctly. We are unsure of what the file must look like.
Your help would be greatly appreciated
Kind regards,
Shaun