Problem in uploading reports in FTP server.

Discussion in 'Tally Developer' started by Kirubakaran, Mar 26, 2019.

    
  1. Kirubakaran

    Kirubakaran New Member


    Hi Sir,
    I am new to TDL. Please help me out.
    I create a TDL file to upload reports to my own server via FTP. I got error "Report does not exists".
    How can i define the path of xml file.?

    Code :

    [Button: Upload Reports]
    Key : Alt+U
    Title : "Upload Reports"
    Action: Call: Upload

    [System : Formulae]
    REExportPath : $$ApplicationPath + "\REExport\"

    [Function : Upload]
    Local Formula : ExpFilePath : @@REExportPath + "BSheet.xml"
    02 : SET : SVExportFormat: $$SysName:XML
    03 : SET : SVOpenFileAfterExport : Yes
    04 : SET : SVPrintFileName : $$MakeFTPName:"ftp://localhost/":"testuser":"*****": @ExpFilePath
    05 : EXPORT : UploadedFile : TRUE

    Thanks
    Kiruba
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    refer uploadconfig.tdl in TDE...........
     


  3. Kirubakaran

    Kirubakaran New Member


    Thank you sir,

    I tried lot more. but i cannot make it work.

    If it possible to upload xml file via Http?

    Please help out.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Wish I could....unfortunately I am DUMBO in Import/Export. :(
     


  5. Kirubakaran

    Kirubakaran New Member


    Hello Sir,

    I am exporting cash flow and fund flow reports using TDL.

    Please check below code is correct. Empty file only creating.


    [Function : TE CashFlow Master]
    Variable : DSPShowClosing : Logical
    Variable : SVExportLanguage : String

    Local Formula : ExpFilePath : $$ApplicationPath + "\Export\CashFlow Excel.xlsx"
    01 : SET : DSPShowClosing : Yes
    02 : SET : SVExportLanguage : "Default (All Languages)"
    04 : SET : SVEXPORTFORMAT : $$SysName:Excel
    05 : SET : SVOpenFileAfterExport : NO
    06 : SET : SVExportLocation : No
    07 : SET : SVPRINTFILENAME : $$MakeExportName:mad:ExpFilePath:##SVExportFormat
    08 : Export : Cash Flow : True
    10 : Return

    Thanks,
    Kiruba
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Simply by copy/pasting is not the solution. Every report has its own variables.

    Here for Cash Flow it is SVPeriodicity on which the report hinges. DSPShowClosing is not required here.

    Also the report name is "Cash Flow Breakup". "Cash Flow" is just a monthly report of Inflows/Outflows.

    As a learning measure, you must study the reports in TDE, for better knowledge and control during coding.
     


Share This Page