In a Nutshell

A FOLDER containing any number of 835 file is Split and written to multiple <Practice Names>:
C:\<Server>\<PRACTICE NAME>\Download\1790812147_261386891_ERA_835_5010_20150629.835
where the NPI = 1790812147
and the 835 Split File Name =1790812147_261386891_ERA_835_5010_20150629.835

The detailed results of the program execution are saved to a log file. More later on the log file.

835 Split By NPI MultiFiles.vbs

Drag and drop a folder on the program icon.



 

 

 

 

 

 

 

 

 

 

The first time the program runs, if no configuration file is found "835 Split By
NPI MultiFiles Config.txt", a "SAMPLE" configuration file is created
in the same folder. This dialog box will appear.



 

 

 

 

 

 

 

 

 

 

This configuration files needs to be modified for your environment before the
program will successfully run.

Program Configuration File

A file named "835 Split By NPI MultiFiles Config.txt" which identifies the configuration
of the program is created the first time the program is run. The user will need to modify
the configuration file to fit their specific environment.

This is an example of the configuration file.

'Configuration
'
'PRACTICE MANAGEMENT PATH DO NOT DELETE OR CHANGE THIS LINE, MODIFY AS REQUIRED THE NEXT LINE
E:\<SERVER>\RMDATA\
'
'PATH WITHIN PRACTICE DO NOT DELETE OR CHANGE THIS LINE, MODIFY AS REQUIRED THE NEXT LINE
Download
'
'VERBOSE = RUN PROVIDING THE MOST DETAIL DATA VIA DIALOG BOXES
'STEALTH = RUN QUIETLY PRODUCING ONLY A DIALOG BOX WHEN COMPLETED
'RUN MODE DO NOT DELETE OR CHANGE THIS LINE, MODIFY AS REQUIRED THE NEXT LINE
STEALTH
'
'The split file is saved in:
'C:\<server>\<practice>\<PATH WITHIN PRACTICE TO SAVE THE SPLIT 835>\<nip>_<835 file name>_ERA_835_5010_20150629.835
'
'NIP TO PRACTICE MANAGEMENT RELATIONSHIP ADD/MODIFY AS REQUIRED <NPI>,<PRACTICE FOLDER> DO NOT DELETE OR CHANGE THIS LINE
1234567890,Practice 1 Name
987653421,Practice 2 Name

On and on for all NPI's


Where E:\<SERVER>\RMDATA\ is the path to the Practice Management Database,
Download is the location within the Practice to save the split file(s). STEALTH is the
Run Mode; in this case run with minimal dialog, in all cases the results of the run are saved
in a log file. 1234567890,Practice 1 Name and 987653421,Practice 2 Name are NIP to
Practice Folders relationships. There can be any number of these relationships and there
can be multiple NIP's related to a single practice.

Successful Run

After the Configuration file is updated and the Folder to Split is dragged and dropped
on the program this is the result.



 

 

 

 

 

 

 

 

 

 

 

 

At this point a new folder "835 Logfiles" has been created, if none exists,
and a logfile has been written to this new folder.

The logfile name format is:

YYYY-MM-DD_HH.MM.SS.AM/PM.835.<Folder of Program>\<Folder with multiple NIP's>.LogFile.txt

The log file format is:

Notice 76 Files are processed (split) into 223 files and saved to the practice is less than
ONE (1) second in "STEALTH" run mode.

Start 7/20/2015 10:53:36 PM

Program Path: C:\Users\<User Name>\<Program Folder>\835 Split By NPI MultiFiles.vbs

Folder Processed: C:\Users\\<User Name>\<Folder Path>\<Folder being processed>

76 Files Processed.

Logfile: 835 Logfiles\2015-07-20_10.53.36.PM.835.<Folder Path>.<Folder being processed>.LogFile.txt

NPI to Practice Management Relationships - Total = 37

1234567890,Practice 1 ** 1234567890, Practice 2 **
09876543211, Practice 3 ** 111111111, Practice 4
...
222222222, Practice 36 ** 33333333, Practice 37

835 File Processing


E:\<SERVER>\RMDATA\Practice 1\Download\1234567890_261804213_ERA_835_5010_20150630.835 has been written. (1)
E:\<SERVER>\RMDATA\835 Error\Download\888888888_261804213_ERA_835_5010_20150630.835 has been written. (2).
...

E:\<SERVER>\RMDATA\Practice 3\Download\0987654321_263258070_ERA_835_5010_20150707.835 has been written. (222)
E:\<SERVER>\RMDATA\Practice 37\Download\33333333_263258070_ERA_835_5010_20150707.835 has been written. (223)

223 Split files processed to Practice Folders.

Unknown NPI's:
666666666 FilePath=E:\<SERVER>\RMDATA\835 Error\Download\666666666_261804213_ERA_835_5010_20150630.835
555555555 FilePath=E:\<SERVER>\RMDATA\835 Error\Download\555555555_261804213_ERA_835_5010_20150630.835
...
999999999 FilePath=E:\<SERVER>\RMDATA\835 Error\Download\999999999_261870334_ERA_835_5010_20150630.835


End 7/20/2015 10:53:37 PM

The unknown NPI to Practice Relationships are written to an error Folder "835 Error". You can correct
these missing NPI's in the "835 Split By NPI MultiFiles Config.txt" file and rerun the folder. The log file will show:

E:\<SERVER>\RMDATA\1234567890\Download\1234567890_261804213_ERA_835_5010_20150630.835 is already present. (1)
E:\<SERVER>\RMDATA\66666666\Download\66666666_261804213_ERA_835_5010_20150630.835 has been written. (2)


The logfile will show that the previously written split files are "already present" and the corrected NPI's "has been written".
A folder containing multiple 835 original files can be run multiple times as the NPI's are updated. The "835 Error"
folder is cleared each run of the program.

Side Note

Although this program was initially written for the Lytec Practice Management Software
package, this program can solve many other issues on any Practice Management Software
package where the 835 files need to be split and saved to specific folders for processing.