Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Other / Misc.
-
Labels:None
-
Environment:
QA7
-
Sprint:Sprint 24
Description
Campaign report BA customization script is not generating report at reseller level. It collectively adding all the rows in a single file.
Log
[amlops@aml-qa7-monman1 reports]$ groovy campaign-report-BA-customization.groovy help
Enter the SMB database's host (default: aq-demo2-mysql1): aml-qa7-mysql1
Enter the SMB database's port (default: 3306): 3306
Enter the SMB database's username (default: spike): spike
Enter the SMB database's password for spike:
Enter the output directory for the CSV file (default: /var/local/tsa/reports)/home/amlops/opsMercury/
INFO - Starting Query
INFO - Query Complete, Processing Results
Snippet of the generated log
[amlops@aml-qa7-monman1 opsMercury]$ cat campaign-data-2016-05-13.csv
"Reseller","Merchant_UUID","Campaign ID","Campaign Status","Campaign Start Date","BA_ID","BA","Loc_ID","BL","OrderID","OrderState","Is BA Customized for Ads","Is BA Customized for Keywords"
"fuji","024438ca-8f4e-41f6-a9d1-d6826dc90ea1","024438ca-8f4e-41f6-a9d1-d6826dc90ea1_150915_400004_1412","Active","2014-12-05","150915","キャンピングカー","400004","03 岩手県","4938108c-d117-44cc-9a50-d10d3b51f543","PROCESSED","0","0"
"apollo","0249a8f2-09ca-4493-a332-2824f9314381","0249a8f2-09ca-4493-a332-2824f9314381_150370_400001_2290","Active","2016-03-04","150370","クラウドバックアップ","400001","日本","d41c557a-ce47-4b17-8804-8e5633f6cdaa","PROCESSED","0","0"
