Difference between revisions of "DOS"
(→Mholi Problem) |
|||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Support | System Support]] | ||
| + | |||
== '''Downloading in swiper''' == | == '''Downloading in swiper''' == | ||
1. Download swiper data in payroll | 1. Download swiper data in payroll | ||
| Line 75: | Line 77: | ||
== '''Mholi Problem''' == | == '''Mholi Problem''' == | ||
| − | + | Updating holiday file. actions taken: | |
| − | 1. | + | 1. Go to CMD/Command Prompt |
| − | 2. | + | 2. Type fb |
| − | 3. | + | 3. Put the Holiday file(MHOLI.dbf) c:\ |
| − | 4. | + | 4. In cmd type use c:\MHOLI.dbf |
| − | 5. | + | 5. Type brow |
6. Update the HOLTYPE(L- Legal, S- Special) HOLCCD = "",HOLDAYS = "1.00" | 6. Update the HOLTYPE(L- Legal, S- Special) HOLCCD = "",HOLDAYS = "1.00" | ||
| − | 7. | + | 7. Ctrl + W to save |
== '''Budget Setup''' == | == '''Budget Setup''' == | ||
!!!!BUDGET SET UP!!!!! | !!!!BUDGET SET UP!!!!! | ||
| − | |||
in server 202.2.2.51 | in server 202.2.2.51 | ||
| Line 127: | Line 128: | ||
autoexec.nt | autoexec.nt | ||
config.nt | config.nt | ||
| − | 1. Back up the system folder(c:Swiper) | + | |
| − | 2. | + | 1. Back up the system folder(c:Swiper) |
| − | 3. | + | |
| − | + | 2. Name the bckup folder Swiper_mmddyyyy | |
| + | |||
| + | 3. Copy the file and replace the existing | ||
remarks: | remarks: | ||
| Line 142: | Line 145: | ||
== '''Migrating POS DBF''' == | == '''Migrating POS DBF''' == | ||
| − | /*Creating POS database*/ | + | /*Creating POS database*/ at sql{ |
| − | |||
1. Migrate the created xls file to db. | 1. Migrate the created xls file to db. | ||
| − | + | ||
| + | 2. Open sql>import> | ||
202.2.2.89>baratillo DB | 202.2.2.89>baratillo DB | ||
| − | + | ||
| + | 3. Export the created db to dbf name it POS3112 | ||
} | } | ||
at DOS{ | at DOS{ | ||
| − | + | ||
| + | 4. Backup the recent DBF | ||
DOS>c://copy posd0001.dbf p1053112 | DOS>c://copy posd0001.dbf p1053112 | ||
| − | + | ||
| + | 5. Go to foxbase type fb in DOS | ||
use POSD0001.dbf | use POSD0001.dbf | ||
modi stru | modi stru | ||
| − | ctrl W> | + | ctrl W> |
| + | |||
| + | 6. Enter(for saving) | ||
append from POS3112 | append from POS3112 | ||
} | } | ||
| − | + | 7. Copy and replace the dbf file in POS | |
c:POS>DBF | c:POS>DBF | ||
== '''Printing of Accounting Reports in CMD''' == | == '''Printing of Accounting Reports in CMD''' == | ||
| − | + | If the printer is not available | |
| − | + | 1. Copy the file that will be printed in c:pay/pay/tmp | |
| − | + | 2. Copy the file to usb | |
| − | + | 3. Open cmd/console | |
E: /*address of the usb*/ | E: /*address of the usb*/ | ||
| − | E:type filename.ext > prn | + | E:type filename.ext > |
| + | |||
| + | prn | ||
example:(E:type SLACGL20.txt > prn) | example:(E:type SLACGL20.txt > prn) | ||
| + | |||
| + | [[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Support | System Support]] | ||
Latest revision as of 09:13, 1 September 2016
Main Page > Application Development Team > System Support
Contents
Downloading in swiper
1. Download swiper data in payroll
2. Upload to payroll
3. (Pay>Utilities>Finger Print Scanner Unibio)
4. Go to Weblink
5. Input username:181- password:181-1oa
6. Go to payroll Tab
7. Look for utilities>reformat dat>
8. Enter password>
NO data found in NEWC00000.OUT
1. Look for the file in c:/swiper/
2. Not in c:/swiper/downloads
Uploading shf
AUploading Shift Code
1. Download the excel/csv file that they will send
2. Change the field name to
SHFSFCD SHFRDCD SHFAMIN SHFAMOT SHFPMIN SHFPMOT SHFGPRD SHFSTAG
3. Save as pmmshf2.dbf
4. Back up the swiper folder and name it swipermmddyyyy
5. Copy pmmshf2.dbf and go to c: Swiper>dbf
6. Replace the existing pmmshf2.dbf checking
1. Delete the ntx
cmd>cd \swiper\ntx
del *.ntx
2. Go to DTR cmd>cd \swiper>dtr username:AMY Password: smile
3. Go to time keeping and check if has a record
Cost Center Offsite
1. Open Pay
2. Next click Weblink
3. Go to password textbox
4. Press F3
5. Go to this path: pay/com/db2
6. Copy PMMDEPT.DBF file.
7. Send the file to offsite
8. Paste PMMDEPT.DBF in swiper/DBF (Offsite side)
Mholi Problem
Updating holiday file. actions taken:
1. Go to CMD/Command Prompt
2. Type fb
3. Put the Holiday file(MHOLI.dbf) c:\
4. In cmd type use c:\MHOLI.dbf
5. Type brow
6. Update the HOLTYPE(L- Legal, S- Special) HOLCCD = "",HOLDAYS = "1.00"
7. Ctrl + W to save
Budget Setup
!!!!BUDGET SET UP!!!!!
in server 202.2.2.51 username: budget password: budget333
in DOS cd \budget set me *to copy the autoconfig* bs *to open the budget application*
go to c;budget\dbf
edit me
after editing
go to fb or foxbase
type: do me
DOS Error
Problem: DOS Error 4 Open Error Database Corruption Detected Argrument Error Reason\s Data Corruption Virus
Solution need to change the ff files bz.bat autoexec.nt config.nt
1. Back up the system folder(c:Swiper)
2. Name the bckup folder Swiper_mmddyyyy
3. Copy the file and replace the existing
remarks:
Important folder that you should see in swiper folder dbf download ntx tmp upload
Migrating POS DBF
/*Creating POS database*/ at sql{
1. Migrate the created xls file to db.
2. Open sql>import> 202.2.2.89>baratillo DB
3. Export the created db to dbf name it POS3112 }
at DOS{
4. Backup the recent DBF DOS>c://copy posd0001.dbf p1053112
5. Go to foxbase type fb in DOS use POSD0001.dbf modi stru ctrl W>
6. Enter(for saving) append from POS3112
}
7. Copy and replace the dbf file in POS
c:POS>DBF
Printing of Accounting Reports in CMD
If the printer is not available
1. Copy the file that will be printed in c:pay/pay/tmp
2. Copy the file to usb
3. Open cmd/console
E: /*address of the usb*/ E:type filename.ext >
prn example:(E:type SLACGL20.txt > prn)
