• 01 Sep

    Count the number of occurrences of an xml field

    Q: We would like to count the number of occurrences of point X in a xml file and update the file name with that value. Kindly refer the code and validate with sample file attached . Let us know if any details required from us.

    • Input file Name: 12345678.3959-2024.04.25-08.20.30-WIT-signed.xml
    • Generated Output file Name : 12345678.3959-2024.04.25-08.20.30-WIT-signed.79.xml

    Content example xml file:

    limagito file mover C:\Users\coene\Downloads\Count the number of occurrences\count the number of occurrences

    A: Please have a look at the following screenshots:

    • We added the floowing WIN as Source:

    limagito file mover windows folder as source

    • Please open our Pascal Script option:

    limagito file mover pascal script option

    • Enable and Add the following On Destination Pascal Script:

    Link to Script, we are using the psVIA (Pascal Script Variable Integer A, = %VIA parameter):

    limagito file mover count the number of occurrences

    • Destination Setup, we added an Windows Folder as Destination:

    limagito file mover destination setup

    • Destination File Rename Setup:

    limagito file mover file rename setup

    As replacement parameter we’ll use the value of %VIA (= psVIA which we obtained previously in our Pascal Script):

    RegEx: (.*)\.(.*)
    Replacement:  \1.%VIA.\2
    limagito file mover file renaming setup
    – RunTime Log Result:
    limagito file mover runtime log result

    If you need any help with this ‘count the number of occurrences of a xml field’ request, please let us know.

    Best Regards,

    Limagito Team

    #xml #managedfiletransfer #filetransfer #filemanagement

  • 27 Jul

    Google Shared Drive setup in Limagito File Mover

    Google Shared Drive setup in Limagito File Mover

    In version v2024.7.27.0 we added support for Google Shared Drive:

    Collection Type (Corpora):

    • User (searches user’s My Drive and all files shared with the user)
    • Domain (searches all files shared to the user’s domain)
    • Drive (searches files in a specific shared drive, Drive ID must be specified)
    • All Drives (searches all shared drives accessible by the user)

    limagito file mover google shared drive setup

    If you need any help with this ‘Google Shared Drive setup’ option, please let us know.

    Best Regards,

    Limagito Team

    #googledrive #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Google
  • 23 Jul

    How to access Google Drive using a JSON or PKCS12 Private Key

    How to access Google Drive using a JSON or PKCS12 Private Key

    In version v2024.7.23.0 we add the following Google Drive options:

    • Access using a JSON Private Key file
    • Access using a .p12 Private Key file
    • Delegated Access option

    In your Google Drive setup:

    • API must be Vendor 2 – CK
    • Auth Type > Private Key File (JSON or .12)

    limagito file mover google drive setup

    Switch to Security Tab:

    • Select the “Key” button to import the Private Key File
      • The content of the file is imported to our settings database (AES256 encrypted)
    • On this Security Tab you can enable Delegated Access

    limagito file mover google drive delegated access setup

    Select the Private Key file you want to use. We downloaded these files from the Google Cloud Console after adding a service account.

    limagito filemover google drive private key file import

    Google Cloud Console ‘Service Accounts’ setup:

    limagito file mover google cloud console

    Double click on your Service Account and switch to KEYS tab:

    limagito file mover cloud console

    Result:

    limagito file mover google drive setup

    Delegated Access:

    To use delegated access you’ll need to:

    • Add the email address of your  service account to the ‘Email Address field’
      • not needed with JSON because this address is in the JSON file
    • Add the email address of the user for which the application is requesting delegated access to the ‘Sub Email Address’ field.
    • Enable domain-wide authority to the service account: link

    If you need any help with this ‘JSON or PKCS12 Private Key’ option, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Google , ,
1 5 6 7 8 9 10 11 18
SEARCH