Automate

 View Only

  • 1.  Script to pull files from a server and load to SFO

    Posted 02-14-2020 09:54
    I have in the past used Winshuttle to load files/documents to Services for Objects on various objects, like equipment, functional locations and work center headers.

    However in each case I already had the file and location mapped in the data and just needed to load them.  

    For this project however I want to go to a server, find a document(s) by date and then load.  So I wont have a spreadsheet of values, I'll have to build the values as I go.  I am only running Studio Transaction, so no other tools are available like query.

    Is this possible or should we try LSMW.

    ------------------------------
    Darrell Dorsey | SAP PM Specialist
    Ascend Performance Materials
    ------------------------------


  • 2.  RE: Script to pull files from a server and load to SFO

    Employee
    Posted 12-10-2020 12:16
    Hey Darrell,

    For Winshuttle Scripts, the file path will be required when uploading to SAP. There may be some functions in Excel itself that can help populate that file path based on creation / modified dates on files, but from what I have seen those functions themselves require the path to be provided as input, and will output the date / time.

    I'm not aware of a method in Excel that can query a location for files based on date off the top of my head, but I think that is what you would need in this case.

    You might be able to use an Excel Macro to loop through the files in a file location and utilize the FILEDATETIME property.

    https://docs.microsoft.com/en-us/dotnet/api/microsoft.visualbasic.filesystem.filedatetime?view=net-5.0

    ------------------------------
    James Lofgren | Solution Engineer
    Winshuttle North America | [City] |
    ------------------------------

    Original Message