CSV Export Script

Technical Information on OrangeHRM

Moderator: Admin

CSV Export Script

Postby alex weber » Sat Aug 14, 2010 4:53 pm

Until proper links are available, some people might find the following script useful for exporting OrangeHRM data to flat files.
kredit vergleich

It looks for a match of an Admin username and password before delivering back a .csv file.
تجارة الذهب

Be careful opening these directly into Excel though - צימרים למשפחות
it reformats the date string fields into its date format. great if you want it to, but if you don't, save it first then import into a table setting the column type to "Text" for the date fields.
online casinos

It's certainly not polished, but it seems to do the job. Maybe a cleaner version could be integrated with the main code? :wink:
giocare online casinò

csv_out.php

Code: Select all

<?php

//set these variables...
$hr_server='localhost'; //server IP or dns
$hr_database='hr_mysql'; //database name
$hr_table='hs_hr_employee'; //table name
$hr_username='orangehrm_read'; //suggest create a user with only Select access to the table
$hr_password='orangehrm'; //or something better!!
$hr_title='OrangeHRM Data Export'; //call it what you like

switch($_REQUEST['chrAction']){ kredit online


case 'doLogin':
alex weber
 
Posts: 2
Joined: Sun Jun 20, 2010 8:34 pm

Return to OrangeHRM

Who is online

Users browsing this forum: Google [Bot] and 0 guests