Zip code table is available from USPS here is the link

ZIP Codes by Area and District codes | PostalPro

It is propabley more up to date than the one you have and has more information that you can pick & choose what ypu need.

Hi Alberto,

I import IP address data (multiple text files) to D3 using a super Q-pointer in D3 Windows to access the files.

If the data is in a fixed width text or CSV file, then it's easy to write a program to import the data to D3.

Most spreadsheet programs will read 2 dimensional database files, with the limitation of the number of lines allowed in the spreadsheet. LibreOffice has about 1M lines.

You can then save it as a CSV file for import to D3.

During the late 1990's, I transferred data between the client's old and new systems via serial cable when doing a system install / upgrade of his old non-Pick (pre D3) computer system.

Best wishes and regards,

Warwick

I would second the use of CSV files here. QM will even create the transfer file for you:

LIST ZIPCODES field1 field2 etc CSV TO C:\\Temp\\zipcodes.csv HDR.SUP COUNT.SUP

Then it is simply a matter of importing that file into D3 - which I assume is easy.

Cheers,

Brian

Thanks for the zip codes, but i'm at Brazil, our zip codes are diferent format 

i'm my case i cant use super q points, beause the qm data base is on my laptop, and d3 in on my linux server
at my case using as tape to transfer data was the best way, just 
t-dump  and t-load and all done 

i never used the serial cable, i'm curios about this

i'm my case the data was in CSV  then i imported to qm to create MV files, the i created the tape to load in D3
i used this method to test and learn how to use CSV and OpenSeq ( instead of open )
and was really fast !

Hi Alberto,

serial connections are an "ancient" technology. Most people have stopped using it as TCP/IP networking with a terminal emulator program (like PuTTy or Wintegrate) has become much simpler to use and implement. Additionally, as computers became cheaper and their use became more flexible and widespread, they replaced dumb terminals as the choice of connecting to multi user systems (like D3).

Serial is a 3 wire connection between the systems (crossing the data lines with the ground line straight through, no shield/case ground) using either a DB9 or DB25 (male on the computer, female on the cable). You then had to match the baud rates (or speed) between the computers. 

You will need to allocate a D3 port to that serial line within the D3 setup and do the required setup under Linux.

This method can be fiddly and frustrating today as most people probably haven't used it for decades.

When I was using serial ports, Pick (prior to D3) was running native on the server computer and we were using multiple serial port cards. 

A simpler method would be to create a network/shared directory on the Linux server (I use Samba) and have a Super Q-pointer to that directory or one in that tree. You can then do a normal copy to the Linux server and D3 will be able to access the files.

I use this method to import files and data to my D3/Windows system. My Super Q-pointer is : 

Attrib 1 :  QS

Attrib 2 : <blank>

Attrib 3 : D:\\Datain

I simply copy the files required to D:\\Datain for D3 to access them. It would be similar in Linux, it's just a matter of finding it in the manual to see exactly what attribute 3 needs to be.

I hope this helps.

Regards and best wishes,

Warwick