Exporting timesheet data (billable time) into other database in billing system

%3CLINGO-SUB%20id%3D%22lingo-sub-1061243%22%20slang%3D%22en-US%22%3EExporting%20timesheet%20data%20(billable%20time)%20into%20other%20database%20in%20billing%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1061243%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20to%20export%20timesheet%20data%20for%20billable%20time%20from%20Project%20Online%20into%20a%203rd%20party%20database%20for%20to%20provide%20billing%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhats%20the%20best%20way%20%3F%26nbsp%3B%20%26nbsp%3B3rd%20party%20connector%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20see%20any%20inbuilt%20tools%20to%20simply%20export%20timesheet%20data%20into%20a%20billing%20system%20automatically%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1062000%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20timesheet%20data%20(billable%20time)%20into%20other%20database%20in%20billing%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1062000%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F485861%22%20target%3D%22_blank%22%3E%40SimonLewis%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EIt%20will%20depend%20on%20the%203rd%20party%20billing%20system%20APIs%2C%20we%20can%20help%20you%20get%20the%20data%20out%20of%20Project%20Online%20with%20some%20examples%20but%20transforming%20the%20data%20into%20the%20correct%20format%20for%20the%203rd%20party%20billing%20system%20and%20them%20importing%20into%20that%20system%20will%20all%20depend%20on%20the%20API's%20that%20system%20has.%20Here%20is%20a%20simple%20PowerShell%20example%20for%20extracting%20Project%20Online%20timesheet%20data%20to%20CSV%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2016%2F05%2F17%2Fextract-projectonline-or-projectserver-2013-2016-timesheet-data-powershell-office365%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2016%2F05%2F17%2Fextract-projectonline-or-projectserver-2013-2016-timesheet-data-powershell-office365%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20was%20written%20a%20few%20years%20ago%20now%20but%20should%20give%20you%20a%20good%20starting%20point%20if%20you%20wanted%20to%20go%20down%20the%20PowerShell%20option%20or%20C%23%20option%20as%20the%20Project%20Online%20API%20would%20be%20used%20with%20any%20approach.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063287%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20timesheet%20data%20(billable%20time)%20into%20other%20database%20in%20billing%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063287%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyup%20would%20need%20to%20be%20the%20API%20so%20the%20devs%20here%20can%20write%20the%20interface%20into%20our%20other%20system%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20you%20have%20examples%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESimon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063857%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20timesheet%20data%20(billable%20time)%20into%20other%20database%20in%20billing%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063857%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F485861%22%20target%3D%22_blank%22%3E%40SimonLewis%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EThe%20linked%20provided%20would%20give%20the%20devs%20an%20example%20of%20how%20to%20get%20started%20extracting%20the%20timesheet%20data%20out%20of%20Project%20Online.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Need to export timesheet data for billable time from Project Online into a 3rd party database for to provide billing data. 

 

Whats the best way ?   3rd party connector? 

 

I don't see any inbuilt tools to simply export timesheet data into a billing system automatically ?

3 Replies
Highlighted

Hello @SimonLewis,

It will depend on the 3rd party billing system APIs, we can help you get the data out of Project Online with some examples but transforming the data into the correct format for the 3rd party billing system and them importing into that system will all depend on the API's that system has. Here is a simple PowerShell example for extracting Project Online timesheet data to CSV: https://pwmather.wordpress.com/2016/05/17/extract-projectonline-or-projectserver-2013-2016-timesheet... 

It was written a few years ago now but should give you a good starting point if you wanted to go down the PowerShell option or C# option as the Project Online API would be used with any approach.

Paul

Highlighted

@Paul Mather 

 

yup would need to be the API so the devs here can write the interface into our other system 

 

do you have examples?

 

thanks


Simon

 

 

Highlighted

Hi @SimonLewis,

The linked provided would give the devs an example of how to get started extracting the timesheet data out of Project Online.


Paul