Results 1 to 11 of 11
  1. #1
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    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:

    http://abw.infopop.cc/eve/ubb.x?q=Y&...6076056665&p=1

    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,
    --Brian
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  2. #2
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    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.

    Fred

  3. #3
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    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.
    --Brian

    p.s. I'm keeping at it and crusing the web for answers. I'll post it here once I know.
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  4. #4
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    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.

    Fred

  5. #5
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    Fred,

    I am still using a Windows OS (XP)

    I found a way to convert to csv

    Link found here:
    http://www.oooforum.org/forum/viewto...t+spreedsheets

    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.

    Kind Regards,
    --Brian
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  6. #6
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    oops, double post... see below
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  7. #7
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    <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

    from there:

    File--&gt;Open--&gt;my_new.cvs file

    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.

    --Brian <HR></BLOCKQUOTE>
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  8. #8
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    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

  9. #9
    ABW Ambassador Mike O's Avatar
    Join Date
    January 18th, 2005
    Location
    Los Angeles area
    Posts
    843
    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.

    -- Mike
    A joy shared is a joy doubled.
    A burden shared is a burden lightened.

  10. #10
    All Around Web Guy Cursal's Avatar
    Join Date
    January 18th, 2005
    Posts
    829
    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.

    --Brian
    Oregon Publishing: Web Development, Graphic Design, Domains & Marketing
    Deluxe Banners Bartender's Guide Cooking Jobs

  11. #11
    Newbie
    Join Date
    August 2nd, 2006
    Posts
    6
    we break up large feeds with textpipe

  12. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Programs to Open Very Large Feeds?
    By mayfly in forum Programming / Datafeeds / Tools
    Replies: 19
    Last Post: March 17th, 2012, 03:06 PM
  2. The Summer Office is Open!
    By flamingoworld in forum Virtual Family and Off-Topic
    Replies: 19
    Last Post: June 1st, 2007, 09:17 AM
  3. Suggestions? Cleaning up feeds for WM?
    By dreamerscove in forum WebMerge (Fourthworld.com)
    Replies: 7
    Last Post: December 10th, 2005, 04:58 PM
  4. Open data feeds in spreadsheet?
    By SSanf in forum ShareASale - SAS
    Replies: 1
    Last Post: July 13th, 2003, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •