export/import

[kaufmac]

Hi,
i need some useful Documentation about export/import Progress 8.3b DBs. Couldn't find something woth google.

thanks

 

[ron]

Can you give me a better idea of exactly what you want to do?

Do you just want to export data in your DB as text files ... to be imported somewhere else?

Importing data into a database needs careful thought. If you don't do it properly you'll ruin the referential integrity.

Ron.

 

[erick.rosales]

Hi... Only a simple question....

How do you import a file with TAB delimiter... Could anyone post an example...

Thanks..

I got this... but doesn't work...

def var c-linea as char format "x(50)" extent 10.
input from value(c-archivo-quoter).
repeat:
import delimiter "~009" c-linea.
display
c-linea
with frame carga
1 column.

end.
input close.

 

[ron]

Hello, Erick.

I created this file with vi:

# cat /tmp/test
a b c d
p q r s
1 2 3 4

The first record has a single space as a field delimiter -- but the second and third records use a TAB as a delimiter.

I modified your code just a little, like this:

def var c-linea as char format "x(9)" extent 5.
input through 'cat /tmp/test'.
repeat:
import delimiter "~009" c-linea.
display
c-linea
with frame carga
1 column.

end.
input close.

It now works.

Good luck!
Ron.

 

[erick.rosales]

Nice... Is working... thanks mate.

So "~009" is the delimiter TAB.