[RRowley]

Their are several settings that need to correspond. The Currency Sign recognizing that other than a $ sign needs to the html code for the currency. Then you have the Currency Code which for dollar is USD, England is GBP, euro is EUR, etc. Then you have the Locale which is en_US for the US, en_GB for Great Britain, etc.

Then you have the “locale” settings in the config/custom.config.ini file.

• This reply was modified 3 years ago by RRowley.
• This reply was modified 3 years ago by RRowley.

[RRowley]

I’m assuming you are referring to the printed invoice and not the invoice maintenance screens. You can modify the printed invoice template but not the maintenance screens. If this is the printed invoice, which template are you using? You can find this in the SI Defaults settings.

[RRowley]

Is there anything in the php.log file? Also, if you set the “loggerLevel” in the the config/custom_config.ini file to DEBUG and run the pdf generation again. Look in the si.log file (same directory as the php.log file). Search for ‘Pdf::generate() – pdfname’ and scroll down from there. You should see the actual pdf file generated as an html page. Scroll further down to the end of the html output and see where the PDF generation goes from there. You can zip the pdf part of the si.log file and attach it to a response to this message.

NOTE, be careful that you alter any passwords and personal information in this file before you copy to attach it here. The log contains security information and it is your responsibility to obscure it.

[RRowley]

I tried rewriting the default template to not use floats. The logic got significantly convoluted when dealing with optional fields like various phone numbers and custom fields. If you can eliminate the fields you really don’t use so the logic doesn’t have to test if the field is empty and such, then the logic should be more straight forward. Other than that, I don’t have a lot of suggestions. I did got back to the SI 2011 and 2013 libraries and I’m not sure they supported floating tables in PDF. I might try to install an old version just to test and see.

[RRowley]

As a matter of fact, I used this scenario to help document how to make an extension. I’ve attached a zip file that contains the files for the module.

Download the zip file and extract it into extensions directory. Next go to the Settings tab and select the Customize menu option. On the Customize screen, select the Extensions option. You should see the cronInvoiceTotal extension. Select the leaf on the left to register the module. Then select the light switch on the left to enable the module. Now if you access the Recurrence screen, the invoice total should be present.

Let me know how this works.

Attachments:

1. cronInvoiceTotal.zip

[RRowley]

No, there isn’t. Making an API would likely be the best approach.

[RRowley]

You would need to create an extension, probably best for the module/cron/manage.php and the templates/default/cron/manage.tpl. In the php file, take the table retrieved from the Cron::manageTable(), loop through it making a new table. For each record you would use the invoice number to get the invoice record, take the total from it and add it to the manageTable() row, creating a new array of records to then store in the DataTable. Now you would have the value to display on the screen by adding it the the table heading and DataTable info in tpl file.

You do this as an extension so the code can be preserved when new SI updates are loaded.

[RRowley]

If you were on master_2019.2 and had data in your database, loading master_2020 should not show these messages. Rather it would show you messages concerning the application of patches to the database.

Use phpMyAdmin (or other tool you use to access databases directly) and verify the you have data in your database. It sounds as though you don’t.

Note that the instructions given un Version Update Process say to backup up the database but not to erase it. Then the si2020Converter.php program simply converts your old custom.config.php file into the new custom.config.ini file used by the update. Verify that all the information for your database base that is now in the custom.config.ini file is correct (the same as it is in the custom.config.php except the field name on the left will have been updated.

If your database content was somehow lost, you can DROP all the tables and import the SQL file backup of your database you made in step 2 of the update instructions.

Now you can access the database and you should see a screen that says there are patches that need to be applied. And you go forward from there.

[RRowley]

Got a quick response on this issue. Turns out that floating tables is not supported in the MPDF library. That means the template has to be rewritten to merge the right float ant the left positioned tables as a single table. I’ll work on that and let you know when I have a solution.

[RRowley]

This appears to be a bug in the MPDF library used to generate the PDF from HTML code. I’ve documented and reported it to the site that maintains this code. Hopefully they can find and fix it quickly but until then, I have no solution.

[RRowley]

It looks fine to me using the settings you gave. There is a problem in the rendering of the amount fields in the first section not interpreting, £, as the British Pound sign. But otherwise, the rendering looks pretty much the same in the Export to PDF, and the Print options. I also checked the PDF attachment on the email. All looked fine. Here are the settings I used.

In config/custom.config.ini:

[exportWordProcessor] => doc
[exportPdfDefaultFontSize] => 7
[exportPdfPaperSize] => A4
[exportPdfLeftMargin] => 15
[exportPdfRightMargin] => 15
[exportPdfTopMargin] => 15
[exportPdfBottomMargin] => 15
[versionName] => 2020.3.11
[versionUpdateDate] => 20211016
[localLocale] => en_GB
[localCurrencyCode] => GBP
[localPrecision] => 2

In Inv Prefs:

Currency sign: £
Currency code: GBP
Invoice heading: Invoice
Invoice wording: Invoice
Invoice detail heading: Details
Language: en_GB
Locale: en_GB

I’ll work on the amount rendering issue but otherwise, looks fine to me. Make sure you are running the latest version and attach the PDF if it is still a problem. I’ve attached the PDF that I generated. The first with my standard settings and the second with your settings.

Attachments:

1. Invoice_555.pdf
2. Invoice_555-3.pdf

[RRowley]

Fixed issue. Uploaded in version 2020.3.09 – 20211011.

[RRowley]

First, you say that you imported MySQL tables from a 2009 version. Did you “import” them or “upgrade” your tables?

You should go through the upgrade processes. What version of SI where you running on?

There are two libraries for SI. On github you have simpleinvoices/simpleinvoices and fearless359/simpleinvoices. The first is the historic version that runs on php 5.6 and lower. For longtime users of SI, they are running the 2013.1.beta.8 (aka master) version on the simpleinvoices/simpleinvoices path.

This is great. If you are on this version, then you can install the fearless359/simpleinvoices master.2019.2 version and the database will be automatically updated for you when you run SI. One big change in this version is that it implements foreign key support at the database level. You might have some “orphan” records in your database which will be reported as part of the upgrade process and need to be fixed before you continue. Once you have these corrected (typically deleting the orphan records, or if you use multiple domains, creating the master records for the domains other than 1) the upgrade will fully complete.

After you have successfully upgraded to master_2019.2, you can then upgrade to master_2020.

If you didn’t follow this process, you probably need to backup and follow this upgrade path. There are some changes that occur in the upgrades that are meant to enhance performance.

My set up has 550 invoices and 60 customers. The time to load the invoices table is about 3 seconds and the customers is 1.5 seconds. This is true for my windows development environment and the linux based hosting service for my production environment.

I’m looking forward to your update on this.

• This reply was modified 3 years, 4 months ago by RRowley.

[RRowley]

What is slow and how slow is it? Typically, this is the invoices manage table screen. So how many records in the database table?

SI is using the DataTables. It uses ajax to supply the data. In my testing, it is not the server that is the issue. It is the client rendering the data. Also, the feature is set to present the table when the first page is formatted. That is, it doesn’t have to wait for all the data to be transferred and rendered before displaying the first page.

Let me know what you have and we’ll go from there.

[RRowley]

I think you need to make an extension where you modify the signature field from the biller to add tokens for the variable data you want to insert and then insert it yourself.

Signature Example: %custname% | %date% invoice from %billername% is attached.

You then parse this and replace the tokens with the needed values. You could do this in the modules/invoices/email.php file for the $biller['signature'] field.

Or you can do what I do. Use the signature field to say “Attached is your invoice for the current month.” The subject line already contains the invoice number and the biller name. And all the pertinent information is in the attached PDF.

[Author]

Posts