dropbox

  • 27 Jan

    Move data to Dropbox project folder based on filename information

    Q: Move data to Dropbox project folder based on filename information

    Objective: Move data from server to Dropbox project folder based on filename information.

    Example of such a filename: P9876543210_122123_EI0001_BIA1234C.zip

    The Project Number is the first part until the underscore > P9876543210 This Project Number should be available in one of the Dropbox subfolders, so you’ll need to scan the subfolders of the Dropbox as Destination Root folder. There may be cases where the Project Number cannot be found in the Dropbox. This could be due to a typo or incorrect formatting by the scientist when setting up the experiment. In this case the .zip should be moved to the Dropbox …\Clients\Unknown\ directory.

    A: We added a new option in version v2024.1.20.0 to achieve this.

    • We used a Windows folder as Source. In this folder we’re going to search for the project zip files.

    limagito file mover windows folder as source

    • Added the following include filename filter because we are only interested in .zip files:

    limagito file mover filename filter setup

    • Next, please open our Pascal Script option:

    limagito file mover pascal script option

    • Enable and Add the following ‘On Destination’ Pascal Script:
      • Please add the following script: link
      • This script will:
        • strip the project number from the filename into variable %VSA
          • P9876543210_122123_EI0001_BIA1234C.zip > P9876543210 > %VSA
        • remove the project number from the filename into variable %VSB
          • P9876543210_122123_EI0001_BIA1234C.zip > 122123_EI0001_BIA1234C.zip > %VSB
        • Both variables will be used in the Dropbox as Destination setup

    Move data to Dropbox project folder based on filename information

    • We added our Dropbox as Destination option and adjusted the Directory option > ‘/Clients’:

    limagito file mover dropbox as destination

    • Dropbox OAuth2 setup:

    limagito file mover oauth2 setup

    • Now the important part. We added our new ‘Search for Subdir Options’ under the ‘File & Directory’ Tab. So in our setup we will be looking for a subdirectory through all existing subfolders of the Dropbox Destination Directory with the name ‘%VSA/Data’ which converts using our example filename to ‘P9876543210/Data’. The variable %VSA is determined by the previous Pascal Script. The reason we added the /Data part is because the customer requested to store the files within a Data subfolder of the corresponding Project directory.
    • If we don’t find this subdirectory then Clients/Unknown will be used. This ‘Search and replace Directory default full path’ must be a full path meaning starting from the home folder.

    limagito fil emover search for subdir option

    • We also added file renaming because the customer wanted to strip the Project number from the original Source filename.
      • The complete filename will be replaces with the content of variable %VSB

    limagito file mover dropbox file rename setup

    #dropbox #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘Dropbox project folder’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Dropbox ,
  • 31 Jul

    How to upload large files to Dropbox using Limagito File Mover

    Uploading large files to Dropbox

    limagito filemover dropbox

    The default Dropbox upload API endpoint allows us to upload files up to 150MB. In version v2023.7.31.0 we optimized our code to automatically switch to a another API endpoint which allows us to upload larger files. This is all done automatically.

    When ‘Large File Mode’ is used (files > 150MB):

    • We will upload the file in blocks of 32MB
    • For each of these 32MB blocks, we will calculate and send the SHA-256 hash code
      • This hash code will be used by Dropbox to check if the received block is OK.
      • If something goes wrong during the upload of a block, we’ll retry this block up to 3 times
    • At the end we’ll receive the total hash of the uploaded file from Dropbox which we’ll compare to be 100% sure

    #dropbox #mft #filetransfer #filemanagement

    If you need any info about this new ‘Dropbox as Source and Destination’ option, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Dropbox
  • 30 Jul

    Dropbox as Source and Destination in Limagito File Mover

    Dropbox as Source and Destination was added to Limagito File Mover on request. First release candidate available in version v2023.7.30.0

    limagito filemover dropbox

    Some screenshot of Dropbox as Source:

    Dropbox as Source and Destination

    Dropbox as Source and Destination

    Information about Dropbox OAuth2 Authentication: link

    If you haven’t created an App in Dropbox you’ll need to do this first:

    • Open your Dropbox account (free account type available) and select ‘App Center’:

    dropbox app center

    • Search for ‘Build an app’:

    dropbox create apps

    • Select ‘Create apps’:

    dropbox create apps

    • Create a new app on the DBX platform:

    create a new app on the dbx platform

    • Dropbox new App ‘Settings’:
      • Do not forget to click the <Show> App secret and write it down (we need this in the Limagito OAuth2 setup)
      • Same counts for the App Key, also needed in the Limagito OAuth2 setup

    dropbox new app settings

    • Dropbox new App ‘Permissions’:

    dropbox new app permissions

    • We’ll use the previous settings in the Dropbox OAuth2 Setup of Limagito File Mover:
      • As scope we used:
        • files.metadata.read files.metadata.write files.content.read files.content.write
      • Type was set to:
        • code
      • Do not forget to set the Redirect URI (must be exact)

    Dropbox as Source and Destination

    Dropbox as Source and Destination

    • RunTime Log Result:

    RunTime Log result

    #dropbox #mft #filetransfer #filemanagement

    If you need any info about this new ‘Dropbox as Source and Destination’ option, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Dropbox
SEARCH