Script to Automate Current Date Import

I have a client that would like to automate the process of updating the current date in their Date Attribute module.

Are their any scripts available to auto-generate the current date to load into their module? Ideally, we would install and use Anaplan Connect.

Thanks,

Tony

Accepted answers

tonybomm

Mike/Rob,

Thanks a lot for the reply. I don't believe they are currently importing any other data from a RDMS, but i will double check and present them with both options.

Mosty likely go with the Anaplan Connect option.

Thanks!

Tony

All comments

hendersonmj

I find the simplest way is to get the date from a relational database by jdbc SQL query. Each database engine has its own way of giving the current date, here are a few of the more common ones:

Oracle PL/SQL:

SELECT TO_CHAR(SYSDATE, 'mm/dd/yyyy') FROM DUAL

SQL Server:

SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]

IBM Netezza:

select TO_CHAR(current_timestamp,'MM/DD/YYYY')

MySQL:

select CURDATE()

returns YYYY-MM-DD (text) or YYYYMMDD (number) format

"Simple" is a relative term. This does require getting a server to run AC upon, getting database access, downloading the jdbc driver for the relational database from that vendor, installing Java and Anaplan Connect, setting up the AC script, and scheduling the job to run daily. If you are importing other data using SQL, then adding a "get today's date" job is trivial.

rob_marshall

If you don't have access to a RDMS like Mike referred to in the above, this is a way to do it through Anaplan Connect (shell script style).

#Variable for file that gets updated with today's date and time
DateAndTimeFileNm=${DATA_DIR}/System_Date.csv
DateAndTimeFileName="System_Date.csv"

#These are your Anaplan Commands
Operation="-certificate ${Cert} -file ${DateAndTimeFileName} -put ${DateAndTimeFileNm} -import 'Load System Date from System_Date.csv' -execute"
#Operation="-certificate ${Cert} -A"

#Variable to designate folder path for Anaplan CLeint
#AnaplanClientLocation="../../AnaplanClient.sh" #Add '../' before AnaplanClinet.sh to put you in the right folder based on where this script lives

#____________________________ Do not edit below this line ______________________________
#This Variable pulls current date from computer and converts it into Anaplan Date Format
mydate=$(date +"%Y-%m-%d %T")
# These lines write the current date and a header to the filename specified
touch ${DateAndTimeFileNm}
echo "Date and Time"> ${DateAndTimeFileNm}
echo "${mydate}">> ${DateAndTimeFileNm}

Hope this helps,

Rob

tonybomm

Mike/Rob,

Thanks a lot for the reply. I don't believe they are currently importing any other data from a RDMS, but i will double check and present them with both options.

Mosty likely go with the Anaplan Connect option.

Thanks!

Tony

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…