Excel Create Error - VisualCron - Forum

Community forum

Jamie Jensen
2017-06-01T15:04:38Z
Hello,

I have a csv which I wish to convert to excel before uploading to a processing service. When the trigger fires the Create Excel task gives the error below. Samle data is below that (fake names and SSN but real format.)

Exception in Task: System.ArgumentException: String cannot be of zero length.
Parameter name: oldValue
at System.String.ReplaceInternal(String oldValue, String newValue)
at System.String.Replace(String oldValue, String newValue)
at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.DBNBONJFFPFOGJGCIPLICBBABAKNDGOOHDAD.EODHLFEPCNAHHNFLLIMDMGKFIDJAJNFJDNME(String , String ) in C:\sourcefiles\code\VisualCronService\Jobs\TaskProcesses\Office\Excel\clsProcessTaskExcelCreate.vb:line 409
at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.DBNBONJFFPFOGJGCIPLICBBABAKNDGOOHDAD.Run() in C:\sourcefiles\code\VisualCronService\Jobs\TaskProcesses\Office\Excel\clsProcessTaskExcelCreate.vb:line 39

Contribution Processing Excel Spreadsheet,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Plan Name:,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Client ID:,558973,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Payroll Date:,5/16/2017,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,Totals,76221,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,,,,,,,,
Social Security,Last Name,First Name,Middle Initial,Division Code,Gross Compensation,Employee 401(k),Roth 401(k),Loan Repayments,Match,Profit Sharing,Safe Harbor Match,Safe Harbor NEC,Client Specific,Client Specific,Client Specific,Actual Hours,Address 1,Address 2,City,State,Zip,Date of Birth,Date of Hire,Employee Eligibility Date,Date of Termination,Prior Hire Date,Prior Term Date,Annual Comp Illustration,Employment Status,HCE Code,KEY EE Code,1000 Indicator,Union Status Code
321654987,mercury,Freddie,,,7300.21,1000,0,,,,292.01,,,,,86.67,390 E Madison Ave,,Milton,WI,53563,5/4/1961,1/1/2003,,,,,,,,,,
498465432,Mercury,Jane,,,1332.98,1000,0,,,,53.32,,,,,86.67,390 E Madison Ave,,Milton,WI,53563,6/26/1962,1/1/2003,,,,,,,,,,
489413213,Dixon,Cole,R,,3333.33,500,0,,,,133.33,,,,,86.67,305 College St,,Milton,WI,53563,12/13/1970,2/5/2003,,,,,,,,,,
449849846,Andrews,James,C,,5175.63,0,750,,,,207.03,,,,,125.2,390 E Madison Ave,,Milton,WI,53563,10/21/1988,4/1/2007,,,,,,,,,,
465132148,Fredrickson,diane,,,3915.63,0,750,,,,156.63,,,,,101.2,390 E Madison Ave,,Milton,WI,53563,7/4/1990,11/15/2009,,,,,,,,,,
658948965,Masters,Frank,A,,1896.25,0,0,,,,0,,,,,89.5,1602 BARHAM AVE,,Janesville,WI,53548,9/5/1965,10/13/2009,,,,,,,,,,
465487564,Germanic,Gustave,e,,2660,133,0,,,,106.4,,,,,130,1109 Jerome Ave,,Janesville,WI,53546,6/23/1978,9/27/2010,,,,,,,,,,
151987764,Andress,Gunter,E,,1771.38,0,750,,,,70.86,,,,,90.5,390 E Madison Ave,,Milton,WI,53563,4/11/1993,7/5/2011,,,,,,,,,,
165189789,Miniest,Dane,M,,1501.06,0,0,,,,0,,,,,82.25,1606 S Arch St,,Janesville,WI,53546,6/9/1992,12/12/2011,,,,,,,,,,
Support
2017-06-02T12:16:09Z
Please send a screenshot of your settings in the Task. It looks like, in the error, that the content is not specified correctly.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top