IPN Admin

IPN Provider Update

To update the providers (that can be found in the search) upload or FTP the csv file to the following directory location:
/var/www/html/wp-content/ipncsv/

The file must be called “lookup.csv”
Use this example when setting up the file.

NOTES:

A cron job is scheduled to run at 9:00 AM every morning to import the data of the file with this name that is located in the ipncsv directory. There is a Run Now option from the WordPress backend, Tools>>Cron Events.
Although, there are some built-in features with the WordPress (WP) theme to update individual provider information. It was decided that all data should come from one source (IPN’s databases), and that it would get confusing if the WP data would be needed to reverse-populate back into IPN’s db. Therefore, profiles are not to be directly updated on the website, and only updated via CSV import.

Other – Import CSV Reports

Centivo Eligibility (sample csv)
Humana Eligibility (sample csv)
MyChoice Eligibility (sample csv)
Network Health Plan Eligibility (sample csv)
UHC Community Plan Eligibility (sample csv)
UHC Medicare Advantage (sample csv)

In Office Services

Open FileZilla and connect to the IPNWEBSERVER “/var/www/html/wp-content/ipncsv” directory
Delete the “Hold_IOLookup.csv” file and rename the “IOLookup.csv” file to “Hold_IOLookup.csv”
Upload the “IOLookup.csv” file from “R:\\Trivera-In-Office Service” to the IPNWEBSERVER “/var/www/html/wp-content/ipncsv” directory
The PHP Cron (IPN IO Service Loader) cron runs daily at 8:45 am and will import the IOLookup.csv

Members Only section

Adding new providers:
1. Download the “jos_users.csv” file from the IPNWEBSERVER directory “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv”
2. Open the “jos_users.csv”
3. Scroll down to the last provider at the bottom
3. Enter the new providers information (Copying the same format at previous providers)
4. In the first cell for the ID, enter the next number in order from the previous providers. Example if the last provider added was 5737 then the new providers ID would be 5738
5. Go back to “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv” and delete the “Hold_jos_users.csv”
6. Rename “jos_users.csv” to “Hold_jos_users.csv”
7. Upload the “jos_users.csv” file that you made changes to from your desktop (or wherever you saved it to) and upload it to “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv”

Upload CSV files to:
/wp-content/plugins/website-custom-plugin/WCP/Reports/csv/practitioner_managers.csv
/wp-content/plugins/website-custom-plugin/WCP/Reports/csv/jos_users.csv

Sample CSV files
practitioner_managers.csv
jos_users.csv

Note: The last column of physician/provider file (jos_users.csv) is to indicate the manager’s ID. This allows a manager to have access to multiple provider accounts.

A cron job will be run so these scripts can import managers and physicians from their respective csv files:
https://ipn-wi.com/wp-content/plugins/website-custom-plugin/cron_import_managers.php
https://ipn-wi.com/wp-content/plugins/website-custom-plugin/cron_import_physicians.php

The settings for cron jobs can be changed from the WordPress backend – Tools>>Cron Events

Removing Termed Providers

1. Open the excel document “Website_Provider_Removal.xlsx” located “W:\IT Maintenance Log”
2. Add the providers you will be removing to the “Website_Provider_Removal.xlsx”
3. Download the “jos_users.csv” file from the IPNWEBSERVER directory “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv”
4. Copy the providers information from the “jos_users.csv” to the “Website_Provider_Removal.xlsx” file
5. Delete the providers information from the “jos_users.csv”
6. Go back to “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv” and delete the “Hold_jos_users.csv”
7. Rename “jos_users.csv” to “Hold_jos_users.csv”
8. Upload the “jos_users.csv” file that you made changes to from your desktop (or wherever you saved it to) and upload it to “/var/www/html/wp-content/plugins/website-custom-plugin/WCP/Reports/csv”
9. Go to phpMyAdmin and open “service_finder_providers”
10. Search and delete the providers in the “service_finder_providers” table

PHP Cron (IPN Avatar Update) Provider Avatar Import

1. Go to “https://ipn-wi.com/wp-admin” and select Media > Add New
2. Select the provider picture you would like to add
3. Go to phpMyAdmin
4. Open the “wp_posts” table
5. Search by “post_name” and note the ID
6. Open the table “service_finder_provider”
7. Search by “full_name”
8. Edit the provider and enter the ID you got from the “wp_posts” table into the “avatar_id” field

Importing Avatar with “ipn_providers_avatar_ids.csv”

1. Open Filezilla and connect to “IPNWEBSERVER”
2. Go to “/var/www/html/wp-content/ipncsv”
3. Download “ipn_providers_avatar_ids.csv”
4. Open “ipn_providers_avatar_ids.csv”
5. Go to “https://ipn-wi.com/wp-admin” and select Media > Add New
6. Select the provider picture you would like to add
7. Go to phpMyAdmin
8. Open the “wp_posts” table
9. Search by “post_name” and note the ID
10. Open “service_finder_providers” table. Search by “full_name” and note “wp_user_id”.
11. Find the provider in “ipn_providers_avatar_ids.csv” or insert new provider alphabetically.
12. Update the “wp_user_id” and “avatar_id” fields with the ID’s you noted from the “wp_posts” and “service_finder_providers” tables.
13. Save “ipn_providers_avatar_ids.csv”
14. Upload “ipn_providers_avatar_ids.csv” to “/var/www/html/wp-content/ipncsv”
15. Run the cron job “PHP Cron (IPN Avatar Import)” or go to the web address “https://ipn-wi.com/ipn-avatar-manual.php” to run import. Results will be displayed if you run it using the web address.

Provider Specialty Import

1. Open category import spreadsheet (\WSSETUP\Website\provider-categories-import.csv).
2. Remove old data except for headers. Enter new category (specialty) in cell A2 and any additional in cell A3, A4 and so on. When finished, save spreadsheet.
3. Log into WordPress admin, click on the Service Finder menu and select Provider/Category Import.
4. Go to the Category Import section and click on the “Update existing category?” drop-down and select No.
5. Click on Upload Your File and select the \WSSETUP\Website\provider-catergories-import.csv file. Click on Start importing.
6. After import is complete, log into phpMyAdmin and confirm new specialty(ies) import in the wp_terms table.
7. Access the website and confirm new specialty(ies) is/are available in the provider search specialty selection list.