Results 1 to 11 of 11
April 19th, 2004, 02:50 PM #1
I am trying to convert data feeds from .txt files to readable files (using ooo1.4.1).
I thought I could just change the ext from .txt to .csv, but "renaming" it didn't work.
Can Anybody toss this dog a bone.
I found some stuff in this post:
Leader had the same problem, but the suggestion offered in that threat was change the ext.
Uh...am I just not doing that right? Maybe...
Thanks for taking the time to explain,
April 19th, 2004, 04:04 PM #2
If your file has less than 65,000 records, you can open the file in MS Excel and then save as .CSV, or .txt Tab delimited.
The CSV format is comma delimited, but there's some extra junk in it (as I recall).
MS Access, and Open Office have a little more horsepower if you're looking to handle very large files.
April 19th, 2004, 04:32 PM #3
Thanks for your reply Fred.
(kudos on your WM tutorial also very nice, your hard work is appreiciated and I'll be using as soon as I can get my feeds prepped)
BACK on Topic: I no longer have MS office or works. I have gone the open source route.
How does one make use of the feeds w/o M$?
That is where I am stuck.
all feeds open in the ooo Word program.
I tried to Cut and paste from text doc to Calc doc but it ends up all in the "A" colum.
Anybody who has done datafeed cleaning using Open Office only around?
This must be possible.
p.s. I'm keeping at it and crusing the web for answers. I'll post it here once I know.
April 19th, 2004, 05:10 PM #4
First, thanks for the compliment.
I'm a little confused.
Are you running Linux? If so, you can try KSpread. I don't use Open Office on my Windows machine, so I'm not sure about that configuration.
If you have decided to get away from MS, and are still using a windows OS, you might try Linux. Only problem there is some things like Dreamweaver don't run on it without Wine.
April 19th, 2004, 05:35 PM #5
I am still using a Windows OS (XP)
I found a way to convert to csv
Link found here:
But that makes the file usesless by adding many many many extra symbols and "code". So that path isn't the one for me. Wonder why it does that?
I might try the paste option again and then split the one colum in as many as the feed (or I ) need to run WM with it. (probably not as easy as it sounds)
So looks like I learned something. OOo is going to be a learnng "work in/during progress."
Thank you again for input.
I see you mention DW...I was also looking into learning to set up a db using DW and php and My SQL. Have any links that may help get me going in direction. I have ordered "php and My SQL for dummies" as my starting point.
April 19th, 2004, 06:01 PM #6
April 19th, 2004, 06:03 PM #7
<BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Cursal:
Ok, looks like this may be a trial and error lesson .
The feed I had trouble with at first (before I found out how to change file formats) was the FTC which is Tab delimited.
Now I have tried the STP feed which is Pipe delimited and it saved fine in .csv
Then I opened the spreadsheet program in OOo
Then it asked what I was hoping for.
What delimiter to use.
I chose other and then typed in the | where needed, clicked ok/next and it cam up looking just like the Excel files I have used in the past.
So I will spend time working with that feed.
I'll get back to Tab Delimited at a later date,(sorry FTC) maybe next week when I have this part up and running
Cool to be making progress.
April 19th, 2004, 06:41 PM #8
- Join Date
- January 18th, 2005
How is oo more powerful? I can only get it to open 30,000 or so rows in it's spreadsheet and I get 65,000 in excel.Deborah Carney
TeamLoxly.com BookGoodies.com ABCsPlus.com
April 19th, 2004, 10:37 PM #9
The oo spreadsheet has a known limit of 32,000 rows. People have been complaining about that limitation for years, but it's still there.
-- MikeA joy shared is a joy doubled.
A burden shared is a burden lightened.
April 20th, 2004, 12:08 PM #10
Yes OOo has its limitations, but for free software I (or the public) really has some powerful tools to work with. With little to gripe about considering the price tag.
Breaking up large feeds to work with OOo would be the way to handle feeds with more than 32,000 records.
August 3rd, 2006, 12:10 AM #11
- Join Date
- August 2nd, 2006
we break up large feeds with textpipe
By mayfly in forum Programming / Datafeeds / ToolsReplies: 19Last Post: March 17th, 2012, 03:06 PM
By flamingoworld in forum Virtual Family and Off-TopicReplies: 19Last Post: June 1st, 2007, 09:17 AM
By dreamerscove in forum WebMerge (Fourthworld.com)Replies: 7Last Post: December 10th, 2005, 04:58 PM
By SSanf in forum ShareASale - SASReplies: 1Last Post: July 13th, 2003, 11:50 AM