ReProRemit Database Tool for eProRemit SoftPro ProForm Users

What do you do when you need to resend items to your underwriter when using the SoftPro ProForm tool eProRemit? Do you create the file manually in Excel? Manual no more, ReProRemit takes a comma delimited list of ProForm Files, resetting the system so eProRemit will pickup the files and create the transmission file for the records you need.

(more…)

Continue ReadingReProRemit Database Tool for eProRemit SoftPro ProForm Users

SQL convert "yyyyMMdd" integer or string to a Date that works in SoftPro

The last few weeks I’ve been working with Web based Reporting for SoftPro ProForm.  It’s been fun creating management review pages with dials and lights.

image

I’ve enjoyed combining multiple report outputs on one concise easy to ready web page.  Along the way, it’s been necessary to display SoftPro Database formatted date fields in a grid.  They come through in 20130524 or “yyyyMMdd” format.  It was easy enough to format that in a grid as “yyyy-MM-dd” format which worked until I started exporting the grids to Excel, when the formatting failed.  So I began a search to fix it, at the SQL level.

(more…)

Continue ReadingSQL convert "yyyyMMdd" integer or string to a Date that works in SoftPro

ProForm Crystal Report, Print if No Tracking item

Today I needed a digression to give my brain a rest.  So I went looking for a decent blog post, and ran across this note, from something I was doing in March 2011.  The question that needs answered is how do I print only files that don’t have a specific tracking item.

(more…)

Continue ReadingProForm Crystal Report, Print if No Tracking item