Páginas filhas
  • Convert files DBF format to DTC

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Product:

Microsiga Protheus

Versions:

11 and 12

Step by Step:

First, backup folders System (or Sigaadv) and Profile. Copy the services stopped to avoid to corrupt files.
1. Delete all files *.cdx, sigamat.ind and sigaadv.bmi(if any) of folder System, and files *.cdx of folder Profile


2. In the folder System, rename file sigamat.emp to sigamat.dbf and the file sigaadv.bmd (if any) to sigaadv.dbf. In the folder Profile rename file profile.usr to profile.dbf.


3) Access APSDU and follow procedure below:

- Click File / Import


  • In Origin Rdd, select DBF -
  • In Enter directory, select folder System
  • - In Mask, enter *.DBF -

  • Click Next





  • On the following screen, select All, then click Next.

    Image Modified
In


  • - In Destination Rdd, select Ctree
    - In Enter directory, select folder System
    - Click Finalize


Image Modified

A window with the following message is displayed "Do you want to use multi-process import?" Select Yes or No as needed.

-

Wait import process. Process may take a while depending on the number of companies and server.


Aviso
 
title
Notice
Notification:

Messages about lack of exclusive access to any table may be displayed, according to the images of the example below. In case it is a relevant table, as this backup table, you may proceed. Otherwise, quit process and grant exclusive access to the tables.

Image Modified

 
Informações
 
titleInformation:

Repeat the procedure above to Profile folder.


4. In the System folder:

- Rename file sigamat.dtc to sigamat.emp

- Rename file sigaadv.dtc to sigaadv.bmd

- Remove files *.dbf


In the Profile folder:

- Rename file profile.dtc to profile.usr



5. Follow an example of file configuration appserver.ini for base in Ctree:

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="041565fc-a107-456e-a366-2cee92a4e2d3"><ac:plain-text-body><!


[

CDATA[[

ENVIRONMENT]
SourcePath=C:\TOTVS 11\apo
RootPath=C:\TOTVS 11\Protheus_Data
StartPath=\system\
RpoDb=top
RpoLanguage=Portuguese
RpoVersion=110
LocalFiles=CTREE
localdbextension=.dtc

 

]]></ac:plain-text-body></ac:structured-macro>

Notes: