I used the DBFUPSIZE tool to import some databases into a PostGreSql table.

The data imported ok, but I have no indexes.

I can connect to the database with DacSession() and open the table with USE 
but I get none of my indexes.  What am I doing wrong?

Mr. Donnay , indexes@(%SQL) do not work that way. You design at database side
all indexes and constraints, and let database decide what it will use,
depending on use of ORDER BY, GROUP BY, WHERE in SELECT,UPDATE,etc criterias

I do not know particularities of Alaska conversion tool, but I believe you are
required to check tables and add apropriate indexes manually after import of
DBF's.

There is another post in this NG (few weeks back) that could shed some info on
it. Unfortunately, Alaska is not that open on documentation.

Roger Donnay wrote in message
news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>I used the DBFUPSIZE tool to import some databases into a PostGreSql table.
>
>The data imported ok, but I have no indexes.
>
>I can connect to the database with DacSession() and open the table with USE 
>but I get none of my indexes.  What am I doing wrong?

Roger,
you must define explicite index files in upsize file. Look at my upsize 
file.
Regards
Piotr


Uytkownik <Roger Donnay> napisa w wiadomoci 
news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>I used the DBFUPSIZE tool to import some databases into a PostGreSql table.
>
> The data imported ok, but I have no indexes.
>
> I can connect to the database with DacSession() and open the table with 
> USE
> but I get none of my indexes.  What am I doing wrong? 




---
Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania, poniewaz ochrona avast! Antivirus jest aktywna.
http://www.avast.com

I have defined my indexes in the upsize tool.  I don't know why, but 
suddenly it started working.   The performance, however is unacceptable.
I'm going to stay with Advantage Server.


"Piotr Dziurla" <dpiotr@interia.pl> wrote in message 
news:7f29a703$5d286f8$1ad180@news.alaska-software.com...
>Roger,
>you must define explicite index files in upsize file. Look at my upsize 
>file.
>Regards
>Piotr
>
>
>Uytkownik <Roger Donnay> napisa w wiadomoci 
>news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>>I used the DBFUPSIZE tool to import some databases into a PostGreSql 
table.
>>
>> The data imported ok, but I have no indexes.
>>
>> I can connect to the database with DacSession() and open the table with 
>> USE
>> but I get none of my indexes.  What am I doing wrong? 
>
>
>
>
>---
>Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania, 
poniewaz ochrona avast! Antivirus jest aktywna.
>http://www.avast.com
>

Hi Roger,

Dietmar Schnitzer has posted his experience using the PGDBE. It is the
posting from 26.11.2014 in this newsgroup.

He also suffert from speed penalties and overcame the situation by
creating some SQL indexes on the ISAM indexes.

With my best regards,

  Andreas Herdt
  Alaska Software

--------------------------------------------------------------------

Technical Support:      support@alaska-software.com

News Server:            news.alaska-software.com
Homepage:               http://www.alaska-software.com
WebKnowledgeBase:       http://www.alaska-software.com/kbase.shtm

Fax European Office:    +49 (0) 61 96 - 77 99 99 23
Fax US Office:          +1 (646) 218 1281
--------------------------------------------------------------------

"Roger Donnay" wrote in message 
news:393f232b$784e9f9d$20188a@news.alaska-software.com...
>I have defined my indexes in the upsize tool.  I don't know why, but
> suddenly it started working.   The performance, however is unacceptable.
> I'm going to stay with Advantage Server.
>
>
> "Piotr Dziurla" <dpiotr@interia.pl> wrote in message
> news:7f29a703$5d286f8$1ad180@news.alaska-software.com...
>>Roger,
>>you must define explicite index files in upsize file. Look at my upsize
>>file.
>>Regards
>>Piotr
>>
>>
>>Uytkownik <Roger Donnay> napisa w wiadomoci
>>news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>>>I used the DBFUPSIZE tool to import some databases into a PostGreSql
> table.
>>>
>>> The data imported ok, but I have no indexes.
>>>
>>> I can connect to the database with DacSession() and open the table with
>>> USE
>>> but I get none of my indexes.  What am I doing wrong?
>>
>>
>>
>>
>>---
>>Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania,
> poniewaz ochrona avast! Antivirus jest aktywna.
>>http://www.avast.com
>>

I am also having issues with the upsize tool and index files.
The index file is a simple CDX with 3 orders:
Tag:    Index Expression:
ARCUS01 FCUSTNO+FACCT
CUSNAME UPPER(FCOMPANY)
ADDRESS FADDRBOOK

Here is the upsize file:
<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>

<config>

<database_engines>
  <dbebuild name="DBFNTX">
     <storage name="DBFDBE"/>
     <order   name="NTXDBE"/>
  </dbebuild>
  <dbebuild name="DBFCDX">
     <storage name="DBFDBE"/>
     <order   name="CDXDBE"/>
  </dbebuild>
  <dbebuild name="FOXCDX">
     <storage name="FOXDBE"/>
     <order   name="CDXDBE"/>
  </dbebuild>
  <dbeload name="pgdbe"/>
  <dbeload name="ADSDBE">
     <storage name="DBFDBE"/>
     <order   name="CDXDBE"/>
  </dbeload>
</database_engines>

<connection name="test"
            dbe="pgdbe"
            srv="localhost"
            uid="postgres"
            pwd="Descartes1231!"
            database="ShipAPI"/>

<!-- data\customer files -->

<table name = "testpg"
       dbe  = "dbfcdx"
       dbf  = "testpg.dbf">
      <order>"testpg.cdx"</order>
</table>

<upsize table="testpg" connection="test" mode="isam"/>

</config>

and the log which is not very helpful:

>>> start upsize
>>> start configuration
>>> start load configuration file
<<< done load configuration file
>>> start validate configuration
<<< done validate configuration
>>> start load database engine(s)
<<< done load database engine(s)
<<< done configuration
>>> start verify upsize target connections
<<< done verify upsize target connections
>>> start prepare upsize process
--- Error: not able to open order file:"testpg.cdx"
+++ some data files are not accessible, please correct this and try again
<<< prepare upsize process failed!
Prepare upsize process failed, for details see log!


Help!
Thanks, 
pete