IDS Forum

Re: Fw: Importing

Posted By: Beniuga Cristian
Date: Wednesday, 22 January 2003, at 9:11 a.m.

In Response To: Fw: Importing (Beniuga Cristian)

Hi Sushil,

Thanks to your advice the problem is solved quick and nice.

Good job.



----- Original Message -----
From: "Sushil Shirodkar" <sushilps@hotmail.com>
To: <ben@mindcti.com>
Sent: Wednesday, January 22, 2003 2:52 PM
Subject: Re: Fw: Importing [58]


> Hi,
>
> Take the changed excel file from him.
> Open it into Excel and save as text file with TAB or "," delimited.
> Open the file in unix editor "vi filename" and find and
> replace all the TAB or "," with "|" save it and load it into the
> table.
> This should be run from dbaccess.
>
> dbaccess "databasename"
> Query
> New
> Load from "filename" insert into "tablename";
>
> Sushil...
>
>
>
>
>
>
>
> >From: "Beniuga Cristian" <ben@mindcti.com>
> >To: "Sushil Shirodkar" <sushilps@hotmail.com>
> >Subject: Re: Fw: Importing [58]
> >Date: Wed, 22 Jan 2003 14:45:08 +0200
> >MIME-Version: 1.0
> >Received: from mind.iasi.rdsnet.ro ([62.231.101.29]) by
> >mc4-f41.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 22
> >Jan 2003 04:41:40 -0800
> >Received: from benpiv ([10.0.0.48])by mind.iasi.rdsnet.ro (8.12.5/8.12.5)
> >with SMTP id h0MFcQu9010345for <sushilps@hotmail.com>; Wed, 22 Jan 2003
> >17:38:27 +0200
> >Message-ID: <002c01c2c214$188db5f0$3000000a@benpiv>
> >References: <BAY2-F26OJXsNQptgFr00027b5d@hotmail.com>
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Mailer: Microsoft Outlook Express 6.00.2600.0000
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
> >Return-Path: ben@mindcti.com
> >X-OriginalArrivalTime: 22 Jan 2003 12:41:43.0656 (UTC)
> >FILETIME=[9E587680:01C2C213]
> >
> >Hi,
> >
> >Thanks for the advice. The document was saved perfect. I save that in
.txt
> >format and after that i made a Import text file, where i chose the
> >delimiter
> >and works perfect. I sent the file to my colegue, but until the file
> >arrives I want to try to import that back.
> >
> >Can you outline for me the command which does that? (and un example will
pe
> >perfect)
> >
> >Thanks
> >
> >
> >
> >Best Regards,
> >
> >Cristian Beniuga
> >Software Engineer
> >
> >MIND Software (Romania)
> >NextGen Billing Solutions
> >Direct: +40-232-258177
> >Mobile: +40-744-372794
> >E-mail: ben@mindcti.com
> >Web: www.mindcti.com
> >
> >Keep us in mind!
> >
> >NOTE:
> >"This e-mail and any files transmitted with it is confidential. If you
are
> >not the intended recipient, you should not use, copy or disclose its
> >contents, but should immediately notify the sender and delete the e-mail.
> >The statements and opinions expressed here may not represent those of the
> >company. Whilst we run anti-virus software on all e -mails we are not
> >liable for any loss or damage and the recipient is advised to run their
own
> >anti-virus software".
> >
> >----- Original Message -----
> >From: "Sushil Shirodkar" <sushilps@hotmail.com>
> >To: <ben@mindcti.com>
> >Sent: Wednesday, January 22, 2003 1:35 AM
> >Subject: Re: Fw: Importing [58]
> >
> >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi,
> > >
> > > First thing I noticed in your download is : you are using DELIMITER
> > > as "," don't use this it might give some problem if you have ","
> > > in the data, just run the command as below and take the
> > > default delimiter which is "|".
> > > When you open this file in Excel it will ask for various option,
> > > the first screen will have DELIMITED as checked box, go to the
> > > next box here you will select OTHER and put "|" into OTHER tab
> > > and go to NEXT and select FINISH.
> > > Save this file as Excel and send it to another person he can
> > > work on it and take the excel file back to you.
> > >
> > >
> > > UNLOAD TO "tablename.csv"
> > > SELECT * FROM tablename;
> > >
> > > Take the changed excel file from him, open it into Excel and
> > > save as text file with TAB or "," delimited.
> > > Open the file in unix editor "vi filename" and find and replace
> > > all the TAB or "," with "|" save it and load it into the table.
> > >
> > > Let me know how it works.
> > >
> > > Good luck.
> > > Sushil..
> > >
> > >
> > >
> > >
> > >
> > >
> > > >From: "Beniuga Cristian" <ben@mindcti.com>
> > > >To: "Sushil Shirodkar" <sushilps@hotmail.com>
> > > >Subject: Re: Fw: Importing [58]
> > > >Date: Tue, 21 Jan 2003 20:42:40 +0200
> > > >MIME-Version: 1.0
> > > >Received: from mind.iasi.rdsnet.ro ([62.231.101.29]) by
> > > >mc5-f9.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue,
21
> >Jan
> > > >2003 10:39:27 -0800
> > > >Received: from benpiv ([10.0.0.48])by mind.iasi.rdsnet.ro
> >(8.12.5/8.12.5)
> > > >with SMTP id h0LLa1u9009743for <sushilps@hotmail.com>; Tue, 21 Jan
2003
> > > >23:36:16 +0200
> > > >Message-ID: <01d901c2c17c$e92bea30$3000000a@benpiv>
> > > >References: <BAY2-F36bhsKd6QR7j10002cc1c@hotmail.com>
> > > >X-Priority: 3
> > > >X-MSMail-Priority: Normal
> > > >X-Mailer: Microsoft Outlook Express 6.00.2600.0000
> > > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
> > > >Return-Path: ben@mindcti.com
> > > >X-OriginalArrivalTime: 21 Jan 2003 18:39:29.0028 (UTC)
> > > >FILETIME=[6E4A8C40:01C2C17C]
> > > >
> > > >Hi Sushil....
> > > >
> > > >Thanks for your response.
> > > >
> > > >I don't know how to import back.
> > > >
> > > >Let me tell you the entire story.
> > > >
> > > >I have a table with 10000 records. 3 columns, index is on the first
> >one.
> > > >For
> > > >half of them i have to chage the 3-th column (a coment column). This
> > > >changes
> > > >are made by someone else which doesn't have the IDS. So, i think that
> >the
> > > >best solution is to export the file into a format where he can work
and
> > > >made
> > > >the changes. So, because he has the office pack (thank god for that)
i
> > > >think
> > > >is better for me to export that table into an excel format and after
> >that
> > > >to
> > > >import it with changes. Maybe you have another suggestion regarding
the
> > > >fact
> > > >that i have to send him a file with he can work.
> > > >
> > > >But, i don't know how to import back (and override also that table)
the
> > > >file. That is my issue.
> > > >
> > > >Can you help me?
> > > >
> > > >I have NT server with IDS 7.31 TD5. If you want, i can send you the
> >excel
> > > >file, but that tommorow because here is late and i have to go home
(21
> >00)
> > > >for now.
> > > >
> > > >For export i use that:
> > > >
> > > >UNLOAD TO "tablename.csv" DELIMITER ","
> > > >SELECT * FROM tablename;
> > > >
> > > >
> > > >If you want we can talk again tommorow. Anyway thanks for your time.
> > > >
> > > >
> > > >Best Regards,
> > > >
> > > >Cristian Beniuga
> > >
> > >
> > > _________________________________________________________________
> > > The new MSN 8: advanced junk mail protection and 2 months FREE*
> > > http://join.msn.com/?page=features/junkmail
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail

Messages In This Thread

• Fw: Importing
  Beniuga Cristian -- Tuesday, 21 January 2003, at 12:59 p.m.
  • Re: Fw: Importing
    Beniuga Cristian -- Wednesday, 22 January 2003, at 9:11 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.