Verizon bill upload issue

  • ResolvedPlugin Author validas

    (@validas)


    3 years, 8 months ago

    Hello, this is Greg Urban, Validas admin for MCCa.

    Some clients are currently experiencing a problem with analyzing Verizon bills: Verizon’s RDD zip file and Device Report are uploaded, but the upload process gets “stuck” (spinning processing wheel), as a result the analysis or press Submit for help are not showing.

    Your MyPHP Admin will not show the analysis data, but will retain the bill and user data so you can follow up with that until we post an update.

    1) User data will still populate in the appropriate table. The analysis data will be shown as NULL.
    2) Bills they’ve uploaded will be in the appropriate tables: RDD + Device Report. You can export these tables with the headers and into Excel for manual review.

    Work Around: Run these queries manually from your PHP MyAdmin raw data table to create analysis results. Data usage is not included here.

    Total Bill: SELECT (SUM(ROUND(Total_Charge,2))) FROM `’wpvd_att_raw_data_report;
    Total Line Count: SELECT COUNT(DISTINCT phone_number_invoice) FROM wpvd_verizon_raw_data_report
    Total Savings: SELECT COUNT(DISTINCT phone_number_invoice) * 13 FROM wpvd_raw_data_report

    If you need anything else related to a Verizon upload issue, please respond to this thread or email me directly: [email protected]

    Thank you,
    Greg

Viewing 1 replies (of 1 total)
  • Plugin Author validas

    (@validas)

    Hello,

    • The Verizon “stuck” issue is fixed.?
    • Verizon and AT&T can now accept uploads of RDD file without the device report. This was done to help make the process easier for the user but you plugin clients should consider the value of requiring both the RDD and device report?before removing it from your messaging labels.?
    • Initially we required both because the device report is crucial?for how our consulting service sells savings to prospects. You may be selling mobile service or hardware, which is different from selling savings but, the device report has?valuable data if you’re looking to port in the?competition. For example, you can make better offers knowing how many of the lines are out of contract or knowing all their device models.

    Thank you,
    Greg & Asif

    • This reply was modified 3 years, 8 months ago by validas. Reason: added concluding salutations
Viewing 1 replies (of 1 total)
  • The topic ‘Verizon bill upload issue’ is closed to new replies.