DbfUpsize.dll documentation

Use this forum for questions and answers regarding PostGreSQL and the PGDBE.
Post Reply
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4804
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

DbfUpsize.dll documentation

#1 Post by rdonnay »

Does anyone have documentation for DbfUpsize.dll ?

I have seen references to functions in DbfUpsise.dll but cannot find any documentation.

I'm working on a new project for New York Courts, converting their old Xbase++ documentation to PostGresSql.

I understand how to use dbfupsize.exe to import from an .upsize file, but I'm hoping there is a tool that will help me create a new .upsize file from a set of DBFs and CDXs so I don't have to hand type a bunch of XML.

NEVERMIND:

I just recalled that I went thru this process several years ago with another customer but it was cancelled.
I created a program in Xbase++ that creates the upsize file from a directory of data files.
The eXpress train is coming - and it has more cars.

User avatar
Tom
Posts: 1230
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: DbfUpsize.dll documentation

#2 Post by Tom »

Hi, Roger.

There is no tool to create an upsize file from a folder or list of tables. We created our own tool (I wrote you an email about that).

The DbfUpsize-DLL publishes only one function "DbfUsize(<Name_of_upsize_file>,[<oLogger>])". The only difference to running it directly is the control about the logger output. There is a sample for that in the documentation.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
rdonnay
Site Admin
Posts: 4804
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: DbfUpsize.dll documentation

#3 Post by rdonnay »

The documentation for upsizing isn't clear whether or not a table is deleted in the database, if it already exists, before importing the data from the .DBF.

I expect that we will be upsizing data quite often during the development process.

Any info on this?
The eXpress train is coming - and it has more cars.

User avatar
Tom
Posts: 1230
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: DbfUpsize.dll documentation

#4 Post by Tom »

Existing tables are replaced by the upsizing process. It recreates all tables. Don't upsize into a working database.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
rdonnay
Site Admin
Posts: 4804
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: DbfUpsize.dll documentation

#5 Post by rdonnay »

Upsizing the data with 5 index files that contained UDF's went well.

I had to make some changes to my SqlQuery program to be able to load a UDF dll and developer license in SqlQuery.Ini.

I'll post an update soon after some more testing.
The eXpress train is coming - and it has more cars.

Post Reply