Alpha Video Training
Results 1 to 12 of 12

Thread: Export to text file

  1. #1
    Guest
    Real Name
    John Mays
    Join Date
    Apr 2004
    Posts
    199

    Default Export to text file

    Hi all

    I am trying to export data in a text file.

    I have so far had a few problems and was wondering if anyone could give me some advice.

    1. The program that I am exporting the data to requires that the date field be mm-dd-yyyy but my program requires that it stay in the dd-mm-yyyy format, any ideas how to get around this?

    2. Once again the program I am exporting to requires a number format of 010 but when exporting the data it gets exported as 10, I need the zero at the front to stay there.

    3. And again the program I am exporting to requires two rows of data, how can I go about splitting my data into two rows instead of one long one.

    Any help regarding this would be greatly appreciated.

    Thanks in advance

    John

  2. #2
    Member
    Real Name
    Bill Warner
    Join Date
    Apr 2000
    Posts
    905

    Default RE: Export to text file

    First of all, exporting data to a text file means that everything you export will be text - not date or numeric.

    I'd suggest that you first convert the values in the table from which you are exporting to the format required. You could do this by adding extra character fields, and then running an update to give you the format you want.

    For example, you could have a new field for the date that is character. If your current date field is in date format, you can use DTOC() to convert the date to a character value. Then you can rearrange the order of the month and day values as necessary.

    For your numeric field, you can use PADL() to add as many zeros as necessary to the left of the actual value.

    To split one field into two, create two new character fields. In your update, you can use a number of different functions to split the data.

    For example, WORD() will read the first word of the value:

    WORD("UNITED STATES",1) = "UNITED"

    or, you can use LEFT() to get the first x characters:

    LEFT("UNITED STATES",9) = "UNITED ST"

  3. #3
    Guest
    Real Name
    John Mays
    Join Date
    Apr 2004
    Posts
    199

    Default RE: Export to text file

    Thanks Bill

    I will try 1+2 as soon as get back to work tomorrow, but on 3, maybe I did not explain properly.

    When exporting to the text file each row has a new records data on it, I need to have two rows per record eg.

    inv no,date,amount
    inv no,customer,ref no

    Hope that makes sense

    Thanks

    John

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Export to text file

    Another possibility is to use the file methods like (well documented in the webhelp)

    Example

    This script retrieves the names of customers from the customer table and writes them to an output file.

    dim tbl as P
    tbl = table.open("c:\a5\a_sports\customer.dbf")
    file_pointer = file.create("c:\a5\output.txt", FILE_RW_EXCLUSIVE)
    tbl.fetch_first()
    while .NOT. tbl.fetch_eof()
    file_pointer.write_line(tbl.first_name - " " + tbl.last_name)
    tbl.fetch_next()
    end while



    file_pointer.flush()

    file_pointer.close()

  5. #5
    Guest
    Real Name
    John Mays
    Join Date
    Apr 2004
    Posts
    199

    Default RE: Export to text file

    Ok Thanks everyone so far, I have sucessfully solved problems 1+2, the date and the zero in fron of the number, using the advice given above.

    Problem 3 is still getting me stuck.

    This is the text file that the program requires to be imported :

    *,SAU,5182,5/20/2005,10010,0505OI000605087
    SAU,5182,010,482.46,550

    I have so far got all the details needed to create this except I am unable to break it into two lines as required by the program.

    Here is my code what I have:

    a_tbl = table.current()
    export.type = 0
    export.names = .F.
    export.file = "invoice.txt"
    export.options = "LTSN"
    export.field_sep = ","
    export.record_sep = ""CR""LF""
    export.fields =11
    export.field1 = "asterisk"
    export.field2 = "inv_header-"account"
    export.field3 = "inv_header-"invoice_number"
    export.field4 = "amerdate"
    export.field5 = "default1"
    export.field6 = "your_reference"
    export.field7 = "account"
    export.field8 = "invoice_number"
    export.field9 = "default2"
    export.field10 = "amount_excl_tax"
    export.field11 = "total"
    a_tbl.export()

    I need the export to create a new line after export.field6 so that the remaining data jumps to the next line.

    Hope I am making sense.

    Thanks

    John

  6. #6
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Export to text file

    John,

    I think you're going to have to create a custom script that writes the desired text strings to separate lines. The technique mentioned by Stan will do this handily (using "file" methods), but it will require some programming on your part in order to populate each string before it's written to disk.

    -- tom

  7. #7
    Guest
    Real Name
    John Mays
    Join Date
    Apr 2004
    Posts
    199

    Default RE: Export to text file

    Thanks Tom

    But I think that is a bit way over my head.

    Thanks Anyway

    John

  8. #8
    Member Elke's Avatar
    Real Name
    Elke Barghoorn
    Join Date
    Sep 2000
    Location
    New York
    Posts
    350

    Default RE: Export to text file

    John,

    Have you tried saving a report to a text file. I have a report with multiple lines that creates a batch file and it works great.

  9. #9
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Export to text file

    Custom requirements require custom solutions. If you will attach a small sample of the table, say 4-5 records, I'll write the export using file methods and attach it here for you to use.

  10. #10
    Guest
    Real Name
    John Mays
    Join Date
    Apr 2004
    Posts
    199

    Default RE: Export to text file

    Thanks Stan I would reaaly appreciate it.

    Sorry to be a fool but what files should I send you?

    Thanks Again

    John

  11. #11
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Export to text file

    From the script you posted you seem to have two tables related in a set. One of the tables is "inv_header" and the other is the parent of the set, un-named in the script because it is accessed by "table.current()".

    Will need all the files with those two names (any file type extension like .cdx. etc) and the set files (file types .set, .sem, etc).

    Also see

    What files must I send?

  12. #12
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Export to text file

    From the script you posted you seem to have two tables related in a set. One of the tables is "inv_header" and the other is the parent of the set, un-named in the script because it is accessed by "table.current()".

    Will need all the files with those two names (any file type extension like .cdx. etc) and the set files (file types .set, .sem, etc).

    Also see

    What files must I send?

Similar Threads

  1. Export to a text file
    By Garry Flanigan in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-13-2004, 04:19 AM
  2. Saving Report as text file or excel file
    By Michael Hadjimichael in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-02-2004, 05:46 AM
  3. Export as a CSV file
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 5
    Last Post: 05-02-2003, 06:46 AM
  4. Rich Text Import Export
    By John Hertzler in forum Alpha Five Version 5
    Replies: 4
    Last Post: 07-24-2002, 08:42 AM
  5. Export to a dat file
    By fgpylant in forum Alpha Five Version 4
    Replies: 1
    Last Post: 01-14-2002, 05:04 AM

Bookmarks

Posting Permissions

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