Build a SQL SP/Job that builds the comma delimited file needed by ARELLO from ARECDATA.
Once the file is built, it should be FTP to ARELLO from within the SQL database. Advised to perform testing in production environment.
Task List
Gather All Pertinant Information
Research best way to perform Process
Develop Process
Test Process
Demo Process
Publish Process
Resources
Will
Eric
Steve
out of date, non functional code
Arello Contact
Denied Access
History of request
None given
Explanation of data formatting
None given
Diagram of end result per vendors needs
None given
Get Data
With This Query:
SELECT
Sent test data through production as told
response to this: Arello contacted executive staff and said they recieved data in the wrong format
I was yelled at and was told data is not in the right format and is not acceptable.
Never heard of an FTP text CSV file needing a required format. That's why I asked to speak with a represenative, as I've done a million times before.
final results csv file
response is this: no formatting - and remove L from column names.
CSV file approved and ready for transmission. Awaiting response to request about transmission and verify data was recieved.
updated csv file and return for approval and proof of completion
response is this: file has been approved by arello(2022-01-10).
Ask to verify test results with arello
response to Steve is this: for permanet schedule of job, pick a day later in the week and advise arello when we start.
nothing about confirmation of test results