Difference between revisions of "DOS"

From SPGC Document Wiki
Jump to: navigation, search
(Printing of Accounting Reports in CMD)
(Migrating POS DBF)
Line 147: Line 147:
  
 
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 posd000
+
DOS>c://copy posd0001.dbf p1053112
 
+
1. 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

Revision as of 09:38, 17 June 2016

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>enter(for saving) append from POS3112

}

3. 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)