Alpha Video Training
Results 1 to 6 of 6

Thread: Email attachment in subdir

  1. #1
    Guest
    Real Name
    Tassos Anastassopoulos
    Join Date
    Aug 2004
    Location
    Athens Greece
    Posts
    19

    Default Email attachment in subdir

    I want to send a table (car.dbf) as attachment. The table is in a subdirectory of the database (\to_send)
    This means that the table I want to send (car.dbf) is
    in folder "E:\Alpha5_appl\test\to_send" (a subfolder of the application)

    Results:

    1) with partial path:
    table.send("\to_send\test2","","CDP",.f.,.t.,.t.) gives-"
    ERROR: Cannot send table. Table 'E:\Alpha5_appl\test\car.DBF' not found.
    (there is no trace of the subdirectory 'to_send' in the error printed by A5)

    2) with full path:

    table.send("E:\Alpha5_appl\test\to_send\test2","","CDP",.f.,.t.,.t.) gives -"
    ERROR: Cannot send table. Table 'E:\Alpha5_appl\test\car.DBF' not found.
    (Here also, there is no trace of the subdirectory 'to_send' in the error printed by A5)

    In the Apha five xbasic manual I read: If the table specified by "tablename" is in the current database, it is not necessary to specify the full drive and path.
    So I suppose if I specify the full path it should work... ;(


    This happens in:

    Alpha Five V5.0 build 1506, system Addins build 1058 and
    Alpha Five V6.0 build 1532, system Addins build 2003 (not the latest one)

    Is this a program error or am I missing something?

    Tassos

  2. #2
    Guest
    Real Name
    Tassos Anastassopoulos
    Join Date
    Aug 2004
    Location
    Athens Greece
    Posts
    19

    Default RE: Email attachment in subdir

    There was a mistake in my transcript in the following lines:
    table.send("\to_send\test2","","CDP",.f.,.t.,.t.) gives-"

    the "test2" should of course be "car" as follows:
    table.send("\to_send\car","","CDP",.f.,.t.,.t.) gives-"

    Thank you
    Tassos

  3. #3
    Alpha Software Employee AaronBBrown's Avatar
    Real Name
    Aaron Brown
    Join Date
    Feb 2001
    Location
    Waltham, MA
    Posts
    2,836

    Default RE: Email attachment in subdir

    Try this....
    Code:
    table.send("E:\Alpha5_appl\test\to_send\test2.dbf","","CDP",.f.,.t.,.t.)
    There is no way that this would work, since you are telling A5 to look for a file called test2 in the ROOT of the current drive:
    Code:
    table.send("\test\to_send\test2","","CDP",.f.,.t.,.t.)

    For more information look at the help for Table.Send()

  4. #4
    Guest
    Real Name
    Tassos Anastassopoulos
    Join Date
    Aug 2004
    Location
    Athens Greece
    Posts
    19

    Default RE: Email attachment in subdir

    Aaron,

    I still can not figure out what I'm doing wrongly.
    if the table is in the same dir as the application, it is Ok
    but if I move the table in the subdir of the application then I get the error.
    I'm attaching you some screenshots of the directories involved and also the test appl.
    Of course I can always bypass this way and copy my file in the appl. dir, but I wonder what error I'm doing.

    The program runs under window 2000 (server edition)

    Thank you very much for your time.
    Tassos

  5. #5
    Alpha Software Employee AaronBBrown's Avatar
    Real Name
    Aaron Brown
    Join Date
    Feb 2001
    Location
    Waltham, MA
    Posts
    2,836

    Default RE: Email attachment in subdir

    How did you create the test table? I see you have

    test2.dbf
    test.ddd
    test.ddm
    test.ddx

    Where are test.dbf and test2.ddd, test2.ddm, test2.ddx? It appears that you tried to rename just the .dbf file through windows explorer or something.

    You cannot simply rename the dbf file by itself and expect everything to behave normally. To rename a table, right click on it in alpha five and choose 'rename.' Get rid of these garbage tables, create a new test table with alpha five and try again. If it still doesn't work, let me know.

  6. #6
    Guest
    Real Name
    Tassos Anastassopoulos
    Join Date
    Aug 2004
    Location
    Athens Greece
    Posts
    19

    Default RE: Email attachment in subdir

    Thank you very much for your guidance.
    I trace my error back to the following error:


    I use the a_tbl.copy() in xbasic to create a new table
    for selected records:

    copy.set = ""
    copy.db = weg+chr(92)+"to_office"+chr(92)+nom_file1
    copy.dd = .F.
    copy.delete_o_dd = .T.
    copy.records = .T.
    copy.fields = 138
    copy.field1 = "Trip_Code"
    copy.field2 = "Trip_Nr"
    copy.field3 = "Leg_Nr"
    ...

    copy.field138 = "L6"
    a_tbl.copy()


    Now, this creates the table correctly in the selected directory,
    BUT of course this will not load (or import the table in the database)
    (this means that it is not shown in the control panel under Tables/sets of this database)

    Therefore I should not use the table.send() command, unless I first add this new table to the database.

    Instead using the email_client() command will work.

    Am I correct to state that:
    An exported Table isn't anymore a table but just a file, as it doesn't belongs to the database anymore.

    thanks,
    Tassos

    PS. As you probably know, I am living in Athens(Greece) from where I write you all these emails. So If you or any of your staff ever happens to pass, pls let me know.





Similar Threads

  1. Create PDF / Email Attachment
    By graysarge in forum Web Application Server v6
    Replies: 1
    Last Post: 08-20-2005, 11:14 AM
  2. Email automation, process an attachment
    By Steve Wood in forum Alpha Five Version 6
    Replies: 3
    Last Post: 10-18-2004, 09:40 AM
  3. Email Attachment Issue
    By Kevin Anderson in forum Alpha Five Version 6
    Replies: 7
    Last Post: 10-04-2004, 03:27 PM
  4. Email send file as attachment
    By Mike O'Connor in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-25-2003, 11:44 AM
  5. Email Attachment Not Found
    By Gary Phillips in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-10-2003, 01:50 PM

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
  •