Fw: Importing
This is a multi-part message in MIME format. ------=_NextPart_000_019F_01C2C187.D2162E90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Does anybody have any ideea how to import a excel file (after i export = that file and make some modifications, many actually) back into a = specific table?? I start to believe that is imposible to do that in Informix. Only the = exports work?=20 Please let me know about that, so i will keep trying to find some = aplications, documents which maybe can help me with that. (maybe you can = help here also). Or, maybe you have another ideea how to make that export. The point is = to send the table to another person which make the modification but he = doesn't have the IDS, and after that i have to reimport that file. Any = format will do. Thanks ----- Original Message -----=20 From: Beniuga Cristian=20 To: ids@iiug.org=20 Sent: Tuesday, January 21, 2003 10:13 AM Subject: Importing Hi again, Yes, the export phase is working great. Thanks. But now how i can import back the file after i made the modifications. = It is a modification, i am not adding new rows. I have to modify a = couple of thousands of rows and after that i have to imported back. So = how can i do that? Sorry, i forgot to tell that i have IDS 7.31 TC5 running on NT. Best Regards, =20 Cristian Beniuga ------=_NextPart_000_019F_01C2C187.D2162E90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#c0c0c0> <DIV style=3D"FONT: 10pt arial">Hi,</DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">Does anybody have any ideea how to = import a excel=20 file (after i export that file and make some modifications, many = actually)=20 back into a specific table??</DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">I start to believe that is imposible to = do that in=20 Informix. Only the exports work? </DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">Please let me know about that, so = i will keep=20 trying to find some aplications, documents which maybe can help me = with=20 that. (maybe you can help here also).</DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">Or, maybe you have another ideea how to = make that=20 export. The point is to send the table to another person which make the=20 modification but he doesn't have the IDS, and after that i have to = reimport that=20 file. Any format will do.</DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">Thanks</DIV> <DIV style=3D"FONT: 10pt arial"> </DIV> <DIV style=3D"FONT: 10pt arial">----- Original Message -----=20 <DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20 title=3Dben@mindcti.com href=3D"mailto:ben@mindcti.com">Beniuga = Cristian</A> </DIV> <DIV><B>To:</B> <A title=3Dids@iiug.org=20 href=3D"mailto:ids@iiug.org">ids@iiug.org</A> </DIV> <DIV><B>Sent:</B> Tuesday, January 21, 2003 10:13 AM</DIV> <DIV><B>Subject:</B> Importing</DIV></DIV> <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT><FONT=20 face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT><BR></DIV> <DIV><FONT face=3DArial size=3D2>Hi again,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Yes, the export phase is working = great.=20 Thanks.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>But now how i can import back the file = after i made=20 the modifications. It is a modification, i am not adding new rows. I = have to=20 modify a couple of thousands of rows and after that i have to imported = back. So=20 how can i do that?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Sorry, i forgot to tell that i have IDS = 7.31 TC5=20 running on NT.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Best Regards,<BR> <BR>Cristian=20 Beniuga<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_019F_01C2C187.D2162E90--
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 Be
Related threads
- Conversion to differeent characters sets
- Problem in changing locale via dbexport/dbimport
- RE: openlink error "Unable to load locale categories"