Extracting filename from data loading activity | Community
Skip to main content
A
ankurm40172185
New Participant
March 13, 2018
Solved

Extracting filename from data loading activity

  • March 13, 2018
  • 5 replies
  • 5501 views

Hi

I know that we can refer to vars.filename in a data loading activity to find the file name. However; this is uploaded filename and not the one listed in the parameters, plus this is mf5 hashed. How can we find out the actual file name which was used; and record this?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by florentlb

    Hi Ankur,

    I'm not sure if there are ways to find back the original name. I'd recommend checking with support if there is a solution that can be put in place for that.

    Florent

    5 replies

    A
    ankurm40172185Author
    New Participant
    May 15, 2018

    Yes; we wrote a script on the ftp activity and the next activity to pick and then chop the filename

    S
    Shivam97
    New Participant
    February 3, 2024

    Can you please share the script and let me know how to fetch the original file name instead of server file name (Ex : my file name is file234.csv and after uploading to server it says 1dfghyh45jlkdhsa.csv?) but I need file234.csv as file name. When I'm getting file from server it works alright but with manual loading it changes the file name.

    florentlb
    florentlb
    New Participant
    May 9, 2018

    Hello Ankur,

    Were you able to get an answer?

    Florent

    florentlb
    florentlbAccepted solution
    New Participant
    April 18, 2018

    Hi Ankur,

    I'm not sure if there are ways to find back the original name. I'd recommend checking with support if there is a solution that can be put in place for that.

    Florent

    A
    ankurm40172185Author
    New Participant
    March 19, 2018

    Hi Amit

    I want to refer to the name of csv file being loaded in the data load activity; when i use vars.filename it refers to the name of the file after server upload (md5 hashed); is there a system variable which can be used to refer the actual csv file's name.

    Amit_Kumar
    Amit_Kumar
    New Participant
    March 14, 2018

    Hi Ankur,

    it's not very clear from your question what you want. can you share the workflow and highlight what you need?

    are you uploading file resources or some csv file?

    regards,

    Amit

      Terms & ConditionsAccessibility statement

      Loading footer...