Thread

1. HELP: m$ access -> psql howto ?

   Jaume Teixi <teixi@6tems.com> — 2001-02-23T11:04:30Z

   Hi,
   I cannot use any kind of odbc because my customers have his local m$
   access db's locally then export them on .txt with tab or | separated, then
   put on my server trought ftp.
   
   and is working ok except that the customers are on spanish databases then
   a data like:
   --DATE-----NAME---------LANG------
     1/6/2000|Ferran Adrià|Castellano|
   
   when sended trought ftp on my server is converted to:
   --DATE-----NAME------------LANG------
     1/6/2000|Ferran Adri\xe0|Castellano|
   
   so when imported on Postgresql with:
   COPY products FROM '/var/lib/postgres/iii2.txt' USING DELIMITERS '|' \g
   --DATE-----NAME-----------------------LANG------
     1/6/2000|Ferran Adri\xe0|Castellano|NULL
   
   on the same cell, ignoring the '|' completelly
   
   on 'postmaster.init' I have: LANG=es_ES but doesnt' works...
   using tabulators as a separators also causes same problem...
   
   any pointers to solve this will be really apreciated
   
   the other problem is that if a m$ access database has a return carraige on
   a text cell the import also fails.
   
   
   bests from barcelona,
   teixi.
   
   

2. Re: NOSUCCESS: m$ access -> psql howto ?

   Jaume Teixi <teixi@6tems.com> — 2001-02-26T10:48:12Z

   On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino"
   <rickspam@wavedivision.com> wrote:
   > Use binary type for transferring files via FTP.
   it's the same
   
   On Sat, 24 Feb 2001 09:27:43 +0100 Stefan Huber
   <schweinsaug@crosswinds.net> wrote:
   > wild guess: maybe you must escape the pipe-symbol: ...USING DELIMITERS
   '\|'
   the same :(
   
   finally I managed to export LANG=es_ES on system then on postmaster.ini I
   also have LANG=es_ES but when I do:
   
   COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g
   
   it causes:
   
   SELECT edicion FROM products;
        edicion     
   -----------------
    España|Nacional <-------puts on the same cell either there's an '|' in
   the middle!!!
   
   SELECT protagonista FROM products;
            protagonista         
   ------------------------------
    Ferran Adrià|Castellano <-------puts on the same cell
    el Bulli taller
    ICC
    Ferran Adrià|Francés|Francia <-------puts on the same cell 2 '|'
   
   Also have tried with @ or tabs as delimiters with any result at all!!
   
   why this only occurs on some cells? what more could I check?
   
   best regards,
   jaume.
   
   
   
   
   > On 2/23/01 3:04 AM, "Jaume Teixi" <teixi@6tems.com> wrote:
   > 
   > > Hi,
   > > I cannot use any kind of odbc because my customers have his local m$
   > > access db's locally then export them on .txt with tab or | separated,
   then
   > > put on my server trought ftp.
   > > 
   > > and is working ok except that the customers are on spanish databases
   then
   > > a data like:
   > > --DATE-----NAME---------LANG------
   > > 1/6/2000|Ferran Adrià|Castellano|
   > > 
   > > when sended trought ftp on my server is converted to:
   > > --DATE-----NAME------------LANG------
   > > 1/6/2000|Ferran Adri\xe0|Castellano|
   > > 
   > > so when imported on Postgresql with:
   > > COPY products FROM '/var/lib/postgres/iii2.txt' USING DELIMITERS '|'
   \g
   > > --DATE-----NAME-----------------------LANG------
   > > 1/6/2000|Ferran Adri\xe0|Castellano|NULL
   > > 
   > > on the same cell, ignoring the '|' completelly
   > > 
   > > on 'postmaster.init' I have: LANG=es_ES but doesnt' works...
   > > using tabulators as a separators also causes same problem...
   > > 
   > > any pointers to solve this will be really apreciated
   > > 
   > > the other problem is that if a m$ access database has a return
   carraige on
   > > a text cell the import also fails.
   > > 
   > > 
   > > bests from barcelona,
   > > teixi.
   > >