Korenmolen
Korenmolen
Offline
0
Hi i want to change the csv layout.

i want to change company into "kostenplaats" and remove email,linked_to_joomla_user and status.

i know it can be changed in :
/public_html/administrator/components/com_invoices/views/invoices/tmpl/default_csv.php

<?php echo JText::_('INVOICE_NUM'); ?><?php echo $separator; ?><?php echo JText::_('RECIPIENT_NAME'); ?><?php echo $separator; ?><?php echo JText::_('COMPANY'); ?><?php echo $separator; ?><?php echo JText::_('EMAIL'); ?><?php echo $separator; ?><?php echo JText::_('LINKED_TO_JOOMLA_USER'); ?><?php echo $separator; ?><?php echo JText::_('INVOICE_DATE'); ?><?php echo $separator; ?><?php echo JText::_('SUBTOTAL'); ?><?php echo $separator; ?><?php foreach($this->taxes as $tax){ ?><?php echo $tax->name; ?><?php echo $separator; ?><?php } ?><?php echo JText::_('TOTAL'); ?><?php echo $separator; ?><?php echo JText::_('STATUS'); ?><?php echo $separator; ?><?php echo "\n"; ?><?php


The remove would be to do for myself but the namechange i realy dont know...
can you point me in the right direction?

grtz Edwin

Accepted Answer

Tuesday, May 10 2016, 03:34 PM - #Permalink
0
this is the file. if it's not there it means you somehow deleted it...
The reply is currently minimized Show
Responses (16)
  • Accepted Answer

    Monday, June 08 2015, 10:14 AM - #Permalink
    0
    just put the name you want instead of the current one.
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Monday, June 08 2015, 10:19 AM - #Permalink
    0
    hi,
    still not clear like this?

    to

    gr Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Monday, June 08 2015, 10:20 AM - #Permalink
    0
    yes
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Monday, June 08 2015, 10:30 AM - #Permalink
    0
    Okay.. thy
    And how do i remove the email row?

    i just did removed only the titles.. lol

    grtz Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Monday, June 08 2015, 10:31 AM - #Permalink
    0
    remove the title and remove the CONTENT too, of course..!
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Monday, June 08 2015, 10:50 AM - #Permalink
    0
    Thx!!
    its all done now!!

    ready to rock and roll...

    Thx!
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Tuesday, May 10 2016, 02:00 PM - #Permalink
    0
    Where can i change the csv output?
    i did look for:
    /public_html/administrator/components/com_invoices/views/invoices/tmpl/default_csv.php but it isnt there annymore..
    i wanna change this bcs i think my bookkeeping software can import this csv.

    greetz Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Tuesday, May 10 2016, 04:43 PM - #Permalink
    0
    okay..
    i dont see how to change rows in csv

    but i need the following rows :

    INVOICEDATE
    BIGBOOKNR (static number)
    DESCRIPTION (static text)
    INVOICETOTAL
    PAYMENTCONDITIONS (static number)
    TAXCODE (static number)
    CUSTOMMERNUMBER
    INVOICENUMBER

    the text in previous post is gone so i cant see how i did it the last time.. :(

    greetz Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 10 2016, 04:55 PM - #Permalink
    0
    I'm not sure to understand what you're asking.
    this is an invoice export CSV, it will export data on the invoice (not on "payments" for example)
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Tuesday, May 10 2016, 06:46 PM - #Permalink
    0
    the static numbers are steady sollid as a rock never ever change

    eg:

    bigbooknr is 712 (never change ) but it is nessecery for every row (booking)

    so all the static numbers have to go on each row

    hope its bit more clear..

    grtz Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 12 2016, 10:36 AM - #Permalink
    0
    then add it to the file...
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Thursday, May 12 2016, 03:13 PM - #Permalink
    0
    can you give me a example how?

    <?php echo JText::"BIGBOOK"; ?><?php echo $separator; ?><?php echo JText::"levering brood"; ?>


    like this?

    grtz Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Thursday, May 12 2016, 03:51 PM - #Permalink
    0
    got it:

    echo "bigbook"
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Thursday, May 12 2016, 04:07 PM - #Permalink
    0
    how do i echo the :

    VAT id: ?

    and where can i change the text "VAT id:" to "Relatienummer"

    gr Edwin
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 13 2016, 11:12 AM - #Permalink
    0
    you can change it in the file you told me..! I'm getting a bit confused.. you already know the file, it's right there, just find the VAT id part and change it to the name you want...
    The reply is currently minimized Show
  • Accepted Answer

    Korenmolen
    Korenmolen
    Offline
    Saturday, May 14 2016, 03:50 PM - #Permalink
    0
    found it!

    to_vatid (found in templates editor)

    other question:

    i want to make a ";" sepperated invoice?
    sku desc value etc etc..

    is it possible?

    grtz Edwin
    The reply is currently minimized Show
Your Reply