• 05 May

    XLS as Destination, Part 2

    Dear users,

    v2019.5.5.0

    If you missed the first parts: https://limagito.com/xls-as-destination/

    We’ve add the following new options to the XLS(X)/CSV as Destination option.

    Sheets, delete options:

    With this option you can select which sheets you want to delete using index or name of the sheet(s). Remember, the sheet index starts at 1.

    With the setup in the screenshot below we are going to delete the sheet with index 5 AND the sheet with name ‘SheetNameToDelete’.

    Colums, delete options:

    With this option you can select which columns you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, column and sheet indexes start at 1.

    With the setup in the screenshot below we are going to delete column with index 2 on sheet with index 1.

    Rows, delete options:

    With this option you can select which rowss you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row and sheet indexes start at 1.

    With the setup in the screenshot below we are going to delete row with index 1 on sheet with index 1.

    Cell Values, rename options:

    With this option you can rename cell values in rows and colmuns on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row , column and sheet indexes start at 1 (value = 0 = all rows/columns).

    With the setup in the screenshot below we are going to rename all columns of the first row on sheet with index 1. The text part ‘Before’ will be replaced by ‘After’ if the cell type is ‘Text’ (String).

    Please let us know if you have any question or need help with the setup

    Regards,

    Lilmagito Team,

    Pascal

    By Limagito-Team XLS/CSV ,
  • 01 May

    How-To Delete old records from the Logging Database

    Dear users,

    Version v2019.5.1.0

    We got a request to delete old records from the File Mover Logging Database. We added ‘Qry Type’ as option to the existing ‘SQL as Source’ to achieve this.

    • Add SQL as Source

    • Set Database Vendor to ‘Use MSSQL Database’

    • Set the MSSQL Server settings of the Logging Database

    • Set Qry Type option to ‘Qry will NOT return data’. Adjust the amount of days you want to keep. At the example below it is set to delete records older than 100 days (adjust the -100 part).

    • Add a ‘dummy’ Pascal Script’ as Destination

    • Set a schedule so trigger this Rule

     

    Best regards,

    Limagito Team

    By Limagito-Team Logging , , , ,
  • 28 Apr

    XLS as Destination

    Dear Users,

    Version v2019.4.27.0

    On user request we’ve added an option to convert xls files. At the moment the setup is only available from the Remote Setup tool (WebRemote will follow soon).

    The request we got was to convert xls(x) to csv (txt based) without Excel being installed but also other conversions are possible (xls tot xlsx, xlsx to xls, …).

    File Format possibilities:

    • Automatic, Automatically detect the type of the file when opening files.
    • Xls, Excel 97-2000-XP-2003
    • Text, Delimiter separated values. Depending on the delimiter, this can be csv, tab delimited text, etc.
    • Pxl, Pocket Excel 1.0 or 2.0
    • Xlsx, Excel 2007 standard file format. Note that this is *not* a macro enabled file format. If you want to save a file with macros, you need to use Xlsm instead.
    • Xlsm, Excel 2007 macro enabled file format.

    Sheet Name = Name of the sheet that needs to be converted

    Encoding = Encoding for the generated file, when writing a Text-delimited file (csv or txt). This parameter has no effect on xls/x files.

    • UTF8
    • UTF7
    • Unicode
    • Default
    • BigEndianUnicode
    • ASCII
    • ANSI

    Delimiter = Delimiter Char to use if Format Text ( #09 = Tab )

    Don’t forget to set the Filename filter to include the file types you want to convert.

    Further options like delete sheet(s), delete column(s),  renaming of cell values, .. are on our todo list.

    Regards,

    Limagito Team

    By Limagito-Team XLS/CSV ,
1 5 6 7 8 9 10 11
SEARCH