nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can ArcGIS Pro ModelBuilder append today's date to output table filename?

BenVan_Kesteren1

I have created a simple tool which finds all properties that lay within a polygon feature (select layer by location), and then exports to a filegeodatabase (Feature class to feature class).

I am wondering if I can get the output filename to be dynamic, and include today's date in the feature class filename each time it is run?

Currently it exports LandParcelRateParking, if I run it each week it simply overwrites last weeks table. Can I get it to append to the filename to be something like:

LandParcelRateParking05042019

LandParcelRateParking09042019

etc

The model is as per below screenshot:

I am guessing there is something I can do to append the date, but I am missing it....

Cheers

Trouver plus de publications taguées avec

Accepted answers

rachelg_esri

Hello Ben!

I believe you can use Calculate Value and some Python code to get what you're looking for. I made the following test model and it appears to have done what you're looking for:

Model showing Calculate Value and Table to Table using Inline Variables

In Calculate Value, I have the following:

Expression:

gettime()

Code Block:

def gettime():
   from datetime import datetime
   now = datetime.now()
   forFile = now.strftime("%m%d%Y")
   return forFile

This uses the Python "DateTime" module that allows you to grab your machine's current time and modify the output structure using various abbreviations (ex. %m for month, %d for day, %Y for four-number year).

I then set the output of the Calculate Value to a specific name (Value in this case), and then called upon that value within the output name of the table.

The resulting table was called "AfterTable_04092019".

For more information, I'd recommend reviewing the following:

Inline variable substitution
Basic date and time types (namely the strftime() section).
Calculate Value

Enjoy!

Best regards,

Rachel

Esri Support Services

KyleConboy

Thanks for the help. This thread provided the needed solution. The inline variable referencing the calculated variable was what i wasn't getting before.

Thanks again:)

All comments

rachelg_esri

Hello Ben!

I believe you can use Calculate Value and some Python code to get what you're looking for. I made the following test model and it appears to have done what you're looking for:

Model showing Calculate Value and Table to Table using Inline Variables

In Calculate Value, I have the following:

Expression:

gettime()

Code Block:

def gettime():
   from datetime import datetime
   now = datetime.now()
   forFile = now.strftime("%m%d%Y")
   return forFile

I then set the output of the Calculate Value to a specific name (Value in this case), and then called upon that value within the output name of the table.

The resulting table was called "AfterTable_04092019".

For more information, I'd recommend reviewing the following:

Inline variable substitution
Basic date and time types (namely the strftime() section).
Calculate Value

Enjoy!

Best regards,

Rachel

Esri Support Services

KyleConboy

I'm trying to do something similar, I'm looking to copy a file geodatabase on a quarterly basis and have it saved with the same name and the date on the end of the geodatabase name. 'Table to table' will not work in this workflow and it does not look like copy will either. Any ideas?

rachelg_esri

Hello Kyle,

Can you clarify on "'Table to table' will not work in this workflow and it does not look like copy will either". The Copy tool does copy geodatabases, and the above workflow should work with this tool. Are you receiving an error? What's the issue on your end? Thanks!

Best regards,

Rachel

Esri Support Services

KyleConboy

Hi Rachel. It doesn't look like table to table will let me input a file geodatabase and copy doesn't have anywhere to load in Python code.

curtvprice

Table To Table takes a specific table input not a geodatabase input. You can batch copy a bunch of tables with this tool though: Table to Geodatabase

Copy is accessible in python as arcpy.Copy_management.

Hope this is helpful.

Tim-Woodfield

Hi Rachel,

I used your code above but my value isn't coming back as a date. It is coming back as just the number 1. Does the Data type need to be set to something specific? I'm doing this in ArcMap and not Pro also. Would this cause the problem?

Thanks!

EDIT: Just realized that the value being returned is 1 no matter what the expression is. I can set it to 1+1 and it still returns 1.

curtvprice

When you right click Calculate Value what is the message (Value = ?)

I would set the data type to string, and then connect this as a precondition to the tool where you are going to use the string in the output name.

JasminePrater

This worked well for me when trying to add the date to the end of a file name after a reconcile log was created. I calculated the date value using your script, renamed the log file using %Value% at the end, and set a precondition of Value having been calculated. Thank you!

anonymous55

Hello All

I am trying to create zip file with name and current date.

example: Land_01242022.zip

I created shapefile with current date like this Land_todayDate.shp.
But I am having problem to have same format for zip file with all shapefile on it.

I want something like this :

Land_todaydate.zip

I have this code but this just create zip file with name and not adding date to it.

Expression:

zipshape(r"Path","Name")

this function requires the two inputs folder (path to the shapefile) and name (shapefilename, for example if your shapefile is foo.shp, the name should be foo (without the extension). it doesn't work with one input.

code Block:

import os
import glob
import zipfile
def zipshape(folder, name):
    os.chdir(folder)
    zipname = name + ".zip"
    flist = glob.glob(name + "*")
    with zipfile.ZipFile(zipname, "w") as newzip:
        for ff in flist:
            if ff[-4:] != "lock" and ff != zipname: 
                newzip.write(ff)
    return os.path.join(folder, zipname)

Date Type
File

I need to run this everyday because I need to add date or maybe just overwrite pervious zip file with new date.

WindsorConnecticut

This is great! Thank you for this!!

One thing I ran into which is strange... the output is writing "unknown" after the date. Do you know what I might be doing wrong? I copied your exact code.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.