Manual import of Data

Technical Information on MySQL database

Moderator: Admin

Manual import of Data

Postby harryo@nissetowa.com » Thu Nov 18, 2010 7:38 pm

I have successfully imported some job title data directly into the SQL table: hs_hr_job_title. It now has 155 records. However, I can no longer add job title records through OrangeHRM directly. I suspect that there is some stored value for the next key "JOB###" that didn't get updated. Any help to identify what other supporting record, key value or lookup table needs to be updated would be appreciated greatly!
harryo@nissetowa.com
 
Posts: 4
Joined: Wed Oct 27, 2010 9:26 am

Re: Manual import of Data

Postby harryo@nissetowa.com » Thu Nov 18, 2010 7:40 pm

I directly imported the data using PHPMyAdmin.
harryo@nissetowa.com
 
Posts: 4
Joined: Wed Oct 27, 2010 9:26 am

Re: Manual import of Data

Postby fostermutizwa » Thu Apr 14, 2011 9:39 am

The Playing Audit they provide through the lobby comes in CSV format and should be importable directly into PT3 at this point in time.One caveat make sure not to open it and save it in Excel that can change the formatting of the CSV file and cause PT3 to be unable to read it.When you manually import the data,you're given the option of selecting a row of data to import.
fostermutizwa
 
Posts: 5
Joined: Wed Apr 13, 2011 4:58 pm


Return to MySQL

Who is online

Users browsing this forum: No registered users and 1 guest

cron