Workamajig has the ability to export a copy of your custom made reports, that can then be used to import back into your instance, or others.
For example, if you have a test server, or access to multiple instances, then exporting and importing custom reports is a great way to save time in recreating these reports. Especially if you have calculated columns.
- If you use Custom Fields as part of your Custom Report. Then you will need to be sure those Custom Fields are setup EXACTLY as they are from the instance you exported the report. If not, then the imported report will skip the missing CF_ references for compatibility, but could generate errors when running the report.
- Do not use commas in the Reports Description field, as they do not work with the import function in this way.
From any Custom Report or View you can export the report to save a copy of that report. This allows you to import it back in in case the report gets deleted or modified. Or share it with others to import on another instance.
Open the Custom Report or View and then click on Edit.
Next go to More > Export View.
You should then be prompted to save this CSV file to your computer for safe keeping.
NOTE: Do not edit this file outside of Workamajig as this could cause the file to not import later.
If you have a custom report file already exported, then from the Import Data screen you can choose View as the type of import. This will import either a Custom Report of View. Depending on the location of the source report.
Navigate to Menu > Admin / Manager > Import Data.
In the Type Of Import drop-down, choose View.
Next, click Select A File To Import.
This will bring open your file finder/explorer. Locate and Select your file. You will see the filename appear in grey text.
Then click Display File.
Ignore the columns that are displayed and click Import Selected.
From the Report Center, you can do a search by the name of the report.
If you don't see it in the Report Center, then you will want to check the Views from your toolbar to see if it appears here.
NOTE: Its up to the user to recall where this report was made. So if you cannot locate your report in the Report Center after importing. Its most likely somewhere in the Views.
Premade Custom Reports
Here are some popular custom reports that you can download and import into your instance.
Post Mortem Report - Post+Mortem+Report+(Schedule+Detail)+v7.csv
- This is a project performance based report to see how your projects did after completion. It tracks Budget Hours Vs Actual Hours, along with Baseline (or Plan) Dates vs Actual Complete Dates.
Client Billing By Month - Client+Billings+by+Month.csv
- This report has hard coded calculated columns for each month. Which shows the Total Invoice Amount per client and month.
Client Billing By Month (Pivot) - Client+Billings+by+Month+Pivot.csv
- This report is meant to be used in Pivot mode. This can dynamically show Total Invoice Amount per client and month.
Time By Week Mon-Sun - Time+By+Week+Mon-Sun.csv
- This report has hard coded calculated columns for each day of the week. Then one row per employee in each week of their total Actual Hours Worked.
NOTE: These custom reports are offered "As Is". There is no support if these reports do not work. They are examples for you to try.
Sharing Custom Reports
You can export your own custom reports and share them with your peers.
Feel free to join/use our Community forums and share with other Workamajig users what you have created.
Additionally, do you have a custom report that you think would be great to share with others and have it added to the Premade Custom Reports section above? If so, please send it to email@example.com for review.