Difference between revisions of "DOS"

From SPGC Document Wiki
Jump to: navigation, search
(→‎Cost Center Offsite)
 
(24 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''' ==
−
Download swiper data in payroll
+
1. Download swiper data in payroll
−
Upload to payroll(Pay>Utilities>Finger Print Scanner Unibio)
+
  
−
go to Weblink
+
2. Upload to payroll
−
input username:181-1
+
 
−
      password:181-1oa
+
3. (Pay>Utilities>Finger Print Scanner Unibio)
−
go to payroll Tab and look for utilities>reformat dat>enter password>
+
 
 +
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''' ==
 
== '''NO data found in NEWC00000.OUT''' ==
−
look for the file in c:/swiper/
+
1. Look for the file in c:/swiper/
  
−
not in c:/swiper/downloads
+
2. Not in c:/swiper/downloads
  
 
== '''Uploading shf''' ==
 
== '''Uploading shf''' ==
Line 17: Line 27:
  
 
1. Download the excel/csv file that they will send
 
1. Download the excel/csv file that they will send
 +
 
2. Change the field name to  
 
2. Change the field name to  
  
Line 29: Line 40:
  
 
3. Save as pmmshf2.dbf
 
3. Save as pmmshf2.dbf
 +
 
4. Back up the swiper folder and name it swipermmddyyyy
 
4. Back up the swiper folder and name it swipermmddyyyy
 +
 
5. Copy pmmshf2.dbf and go to c: Swiper>dbf  
 
5. Copy pmmshf2.dbf and go to c: Swiper>dbf  
−
6. Replace the existing pmmshf2.dbf
 
  
−
checking
+
6. Replace the existing pmmshf2.dbf checking
 +
 
 +
 
 
1. Delete the ntx
 
1. Delete the ntx
 
cmd>cd \swiper\ntx
 
cmd>cd \swiper\ntx
Line 42: Line 56:
 
username:AMY
 
username:AMY
 
Password: smile
 
Password: smile
 +
 
3. Go to time keeping and check if has a record
 
3. Go to time keeping and check if has a record
  
Line 62: Line 77:
  
 
== '''Mholi Problem''' ==
 
== '''Mholi Problem''' ==
−
updating holiday file. actions taken: 1.go to CMD/Command Prompt
+
Updating holiday file. actions taken:  
−
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
+
  
−
== '''Offsite Employee creation''' ==
+
1. Go to CMD/Command Prompt
−
pay>weblink>go to password textbox>press F3>go to pay/com/db2>copy the PMMDEPT.DBF>send the file to offsite
+
−
 
+
2. Type fb
−
put PMMDEPT.DBF in swiper/DBF
+
 +
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 Setup''' ==
 
!!!!BUDGET SET UP!!!!!
 
!!!!BUDGET SET UP!!!!!
−
 
  
 
in server 202.2.2.51
 
in server 202.2.2.51
Line 111: Line 128:
 
autoexec.nt
 
autoexec.nt
 
config.nt
 
config.nt
−
1. Back up the system folder(c:Swiper)
+
−
2. name the bckup folder Swiper_mmddyyyy
+
1. Back up the system folder(c:Swiper)
−
3. copy the file and replace the existing
+
−
 
+
2. Name the bckup folder Swiper_mmddyyyy
 +
 +
3. Copy the file and replace the existing
  
 
remarks:
 
remarks:
Line 126: Line 145:
  
 
== '''Migrating POS DBF''' ==
 
== '''Migrating POS DBF''' ==
−
/*Creating POS database*/
+
/*Creating POS database*/ at sql{
  
−
at sql{
 
 
1. Migrate the created xls file to db.
 
1. Migrate the created xls file to db.
−
open sql>import>
+
 +
2. Open sql>import>
 
202.2.2.89>baratillo DB
 
202.2.2.89>baratillo DB
−
2. Export the created db to dbf name it POS3112
+
 
 +
3. Export the created db to dbf name it POS3112
 
}
 
}
  
 
at DOS{
 
at DOS{
−
3. Backup the recent DBF
+
 
 +
4. Backup the recent DBF
 
DOS>c://copy posd0001.dbf p1053112
 
DOS>c://copy posd0001.dbf p1053112
−
2.go to foxbase type fb in DOS
+
 
 +
5. Go to foxbase type fb in DOS
 
use POSD0001.dbf
 
use POSD0001.dbf
 
modi stru
 
modi stru
−
ctrl W>enter(for saving)
+
ctrl W>
 +
 
 +
6. Enter(for saving)
 
append from POS3112
 
append from POS3112
  
 
}
 
}
  
−
copy and replace the dbf file in POS
+
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
+
If the printer is not available
  
−
copy the file that will be printed in c:pay/pay/tmp
+
1. Copy the file that will be printed in c:pay/pay/tmp
  
−
copy the file to usb
+
2. Copy the file to usb
  
−
open cmd/console
+
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

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)

Main Page > Application Development Team > System Support

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=DOS&oldid=3939"