Export timesheets with Project number

[GeertUH]

Hi
Can someone help me ? I want to export the activities/Timesheet entries with the project number;
actually i only see the Client number included for each entry when exporting...

[empx92]

Hi we are Using the "Ordernumber" which is filled in in the Projects. Therefor you have to edit the .pdf.twig export template.
we do it like that:

{% block description %}
   <b>{{ entry.project.customer.name }} - {{ entry.project.name }}</b>{% if entry.description is empty %}{% if entry.activity is not null %}       <br /><small>Tätigkeit: {{ entry.activity.name }}</small>{% endif %}{% endif %}
         {% if hasExternalOrder %} {# This is a Customfield because our Customers which use for example SAP have other ordernumbers than we #}
            <br /> <small class='ext_order'> Ihre Bestellnummer: {{ widgets.form_type_value(ext_bestellnummer.type, ext_bestellnummer.value, entry) }}</small>
         {% endif %}
         {% if entry.project.orderNumber is not null %}
            &bull; <small class='gfz'>Unsere GFZ: {{ entry.project.orderNumber }}</small>
         {% endif %}
         {% if entry.project.customer.number is not null %}
            <span class='kundennummer'>&bull;</span> <small class='kundennummer'>Ihre Kundennummer: {{ entry.project.customer.number }}</small>
      {% endif %}
                        
      {% if entry.description is not empty %}
         <br>
         <b>Tätigkeiten:</b>
      <i>{{ entry.description|desc2html }}</i>
    {% endif %}
{% endblock %}

so the code you are searching for is:

{% if entry.project.orderNumber is not null %}
	&bull; <small class='gfz'>Unsere GFZ: {{ entry.project.orderNumber }}</small>
{% endif %}

You can use it within the entries loop ;)

[GeertUH]

Thx!
This is only applicable for pdf, right?
We need to have it in csv/xlsx, is than the custom-fields plug-in a good/better option?

[empx92]

Sorry as we don't use the csv/xlsx export i may can not help you here