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.

Convert files DBF format to DTC

How to convert files of an ADS base (.dbf) to Ctree (.dtc)

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
Image Added

  • In Origin Rdd, select DBF - In Enter directory, select folder System - In Mask, enter *.DBF - Click Next Image Added
  • On the following screen, select All, then click Next. Image Added
  • In Destination Rdd, select Ctree - In Enter directory, select folder System - Click Finalize Image Added
  • 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.
     
    Notice:
    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 Added
     
     
    Information:
    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: