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.
Gather All Pertinant Information
Research best way to perform Process
out of date, non functional code
History of request
Explanation of data formatting
Diagram of end result per vendors needs
With This Query:
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