csv File
Moderators: chulett, rschirm, roy
csv File
Hi,
Can I save an excel file as a csv file and use it from Sequential file..? I tried to do so..but the job failed... Pls tell me if there is any way that i can save this file as a Sequential file stage readable..?
Thanks
Can I save an excel file as a csv file and use it from Sequential file..? I tried to do so..but the job failed... Pls tell me if there is any way that i can save this file as a Sequential file stage readable..?
Thanks
Thanks
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
If you can open the csv file in any editor such as notepad and if it is a csv file, you must be able to access it in DataStage.
Points to note are
1.) Properties to be set a 'comma delimited'
2.) Provide enough columns as in the file.
If you still have problems, please indicate the steps and the problem for more useful comments.
Points to note are
1.) Properties to be set a 'comma delimited'
2.) Provide enough columns as in the file.
If you still have problems, please indicate the steps and the problem for more useful comments.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Kab123,
In the Sequential File Stage, can you use the ellipse (...) symbol (for the file name) to browse through the file system and locate the file you wish to view?
Also can you please cut-and-paste couple of lines from the top of the csv file to give us an idea of its layout. Maybe you can change the data - if it is protected outside your org.
In the Sequential File Stage, can you use the ellipse (...) symbol (for the file name) to browse through the file system and locate the file you wish to view?
Also can you please cut-and-paste couple of lines from the top of the csv file to give us an idea of its layout. Maybe you can change the data - if it is protected outside your org.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you saved as CSV why are you trying to open a TXT file?
If you saved as CSV from Excel giving the name CORAM.TXT Excel would have created CORAM.TXT.CSV
Error code 2 means "file not found". That means that CORAM.TXT is not in the directory. Look there to see whether CORAM.TXT.CSV or CORAM.CSV is there. Then, if so, adjust your job design to use the correct file name. If not, check your "save as" procedure in Excel to make sure you're saving into the directory you intend.
If you saved as CSV from Excel giving the name CORAM.TXT Excel would have created CORAM.TXT.CSV
Error code 2 means "file not found". That means that CORAM.TXT is not in the directory. Look there to see whether CORAM.TXT.CSV or CORAM.CSV is there. Then, if so, adjust your job design to use the correct file name. If not, check your "save as" procedure in Excel to make sure you're saving into the directory you intend.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Also, it's not advised to just save as from Excell to .csv and then expect the file to be processed correctly.
Problems found in the past:
- People with different regional settings which affect save as
- Excell skips outputting cells at the end of a row if they don't contain data
- People filling in data where they should not be putting data in Excell
I always suggest to put a macro in the Excell sheet that explicitly outputs the correct .csv format.
Ogmios
Problems found in the past:
- People with different regional settings which affect save as
- Excell skips outputting cells at the end of a row if they don't contain data
- People filling in data where they should not be putting data in Excell
I always suggest to put a macro in the Excell sheet that explicitly outputs the correct .csv format.
Ogmios
In theory there's no difference between theory and practice. In practice there is.
I have found the most common error cause is having Windows Explorer to have the setting "hide known file extensions" set. So you think you have called a file ABC.TXT but in reality Excel has saved it as ABC.TXT.csv and when you try to access it via DS it won't find the file. I've done this, to my embarassment, several times and still haven't completely learned my lesson. I would suggest going into a CMD shell and doing a DIR or changing the explorer value.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>