Rank: Newbie
Groups: Registered
Joined: 9/29/2020(UTC) Posts: 2  Location: Nashville, TN Thanks: 1 times
|
Attempting to build a file that needs to contain certain employee information such as ID, pay rate, etc. so that the employee can be paid pay advances through our company. The file needs to be able to be set up on a scheduled run and then set to auto-export to an email address or SFTP once per week. Can anyone help with that?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/28/2018(UTC) Posts: 65 Location: Pennsylvani mostly Was thanked: 9 time(s) in 9 post(s)
|
I'd suggest the Data Browser which allows you create a command line that will output the data from any report in CenterPoint in an XML or CSV file. The first step would be to identify the report in Payroll that has all the information you need. It looks to me like Payroll Setup -> Employees -> Employees would do the trick. The ID would be the CenterPoint employee abbreviation. The Pay Rate might be trickier because each earning can have it's own rate. However, the employee has three base rates (an hourly rate, a piece rate, and a base salary.) I'd guess you'd be after Base Hourly Rate. The Data Browser has a UI that you can use to create the XML file that the command line operation uses to generate the output. The executable is CenterPointDataBrowserConsole so you'd run it as a command line of CenterPointDataBrowserConsole [settings file path] [database user] [user password]. The user and password are optional. The settings file is an XML file that identifies the report you want to run, the database you want to run it in, and any filtering/options you want applied. This is the general format of the XML file (I've set the RpeortKey to the Employee report): Code:
<Settings>
<Database>PayrollSample</Database>
<ReportKey>968465a0-1b3c-47b8-9b80-915ad2888037</ReportKey>
<OutputFile>D:\Development\CenterPoint\Source\CenterPoint\bin\Debug\test.xml</OutputFile>
<ClearFilters>false</ClearFilters>
<Filters />
<ClearOptions>false</ClearOptions>
<Options />
</Settings>
|
 1 user thanked tony for this useful post.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The Red Wing Software Developer Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
