File Mover Blog

  • 21 Apr

    How to import data into a SQL table where a primary key as guid is needed

    How to import data into a SQL table where a primary key as guid is needed

    Q: I have a question about importing data into a SQL table where a primary key (guid/uniqueidentifier) needs to be generated. In a SQL command like the below, NEWID() will create the required id. Can this be achieved in Limagito?

    limagito file mover sql primary key as guid

    INSERT INTO dbo.testtable(intconID, caseID)

    VALUES (NEWID(), 1)

    Error received:

    8/04/2024 12:37:55 PM TFDPhysMSSQLCommand DB SQL Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘intconID’, table ‘dbo.TestTable’; column does not allow nulls. INSERT fails.

    8/04/2024 12:37:55 PM Batch Move Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘intconID’, table ‘ dbo.TestTable ‘; column does not allow nulls. INSERT fails.

    A: We added a new feature in version v2024.4.9.0 which replaces the NEWID() in the WriteSQL by a GUID when the Rule is triggered.

    If you need any help with this ‘primary key as guid’ request, please let us know.

    Best Regards,

    Limagito Team

    #sql #managedfiletransfer #FileManagement #filetransfer

    By Limagito-Team SQL , , ,
  • 21 Apr

    Generate Certificate Signing Request (CSR)

    Generate Key and Certificate Signing Request (CSR)

    In version v2024.4.21.0 we added an option to generate a CSR. This is possible using our free Lite+ version too.

    Generate Certificate Signing Request

    • After installation please open our Limagito File Mover Config Tool:

    limagito file mover config tool icon

    • Switch to ‘CSR’ tab
      • The (pre-existing) private key file is optional. If you don’t have this file, we’ll create one for you.
      • Add the necessary details and click Generate
    • You could test the result here: link or link

     

    If you need any help with our new ‘Generate Key and Certificate Signing Request’ option, please let us know.

    Best Regards,

    Limagito Team

    #csr #managedfiletransfer #FileManagement #filetransfer

    By Limagito-Team SIGN , ,
  • 20 Apr

    How to export all rules to CSV with column name, source and destination

    Is there a way to export all Limagito rules to CSV or Excel with the column of name, source and destination?

    In a recent version of Limagito File Mover we added the following Pascal Script function to achieve this:

    Function psExportRuleDataAsCSV(Const aFile, aData, aDelimiter: String): String;

    aFile = Output Csv file, e.g. ‘C:\Temp\RuleList.csv’
    aData = a ; seperated list of items you want to add ( When empty string we’ll use ‘1;2;3;4’ )
    1 = RuleID
    2 = DisplayName
    3 = Source
    4 = Destination
    7 = Information
    aDelimiter = csv delimiter used in the csv outputfile

     

    • Setup is easy, you’ll only need to add our ‘Pascal Script’ option as Source

    limagito file mover pascal script as source

    • Do not forget to adjust the ‘ctOutputCsv’ const:
      • Please add the following script: link

    limagito file mover export all rules to CSV

    • This is all you need to do, just enable and trigger the Rule now
    • Output Csv file content:

    RuleID,DisplayName,Source,Destination
    1,UNZIP Files Mike,[WIN]C:\Test\Out_Zip\,ID1[ZIP]C:\Test\Out_Zip\Out\
    2,WIN > Google Cloud Storage,[WIN]C:\Test\In\,ID2[GCLOUD]storage.googleapis.com/limagito/test
    3,GCloud > WIN,[GCLOUD]storage.googleapis.com/limagito/Test,ID1[WIN]C:\Test\Out\GCloud\

    If you need any help with our new ‘export all rules to CSV’ feature, please let us know. If you need more fields, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #FileManagement #filetransfer

1 2 3 4 136
SEARCH