[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, 1 month 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.

[RRowley]

Enter your default message in the Signature field in the biller record.

[RRowley]

Let’s start with the locale. Currently there is no en_IN locale defined. But you can remedy that quite simply. In the lang directory, make an “en_IN” directory. Then copy into it the info.xml and lang.php file from whichever language directory most closely matches what you want. If that is the en_US directory, then in the copied lang.php file, delete the lines at the end following the $LANG[‘zip’]… line (the ones in the if statement for setting the user password help format).

Modify the information in the copied, info.xml file.

At this point you now have an “en_IN” locale set up. Of course the words in the lang.php file have not been translated. You can do that as necessary. Once you have your lang.php file set up, you can send me copies of both the xml and php file via an attached zip file containing them, via this forum. I’ll add them to the standard application for future users, etc.

With these files set up, there are two places where you set en_IN to use it in field formatting and language selection. First is in the config/custom.config.ini file “localLocale” setting. The next is in the Settings/Inv Prefs tabs records, set both the Language and Locale fields to en_IN.

As for the date. In the screens that display the date, the format is as it comes from the database. “yyyy-mm-dd” I believe. This is standard and yields a natural sorting order for the field if you order the management tables by it.

For the invoice templates, you get whatever they display. You can modify them and make your own invoice formatting for dates and other information however you please; but it isn’t necessarily controlled by the locale settings.

Hope this helps.

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

[RRowley]

I just uploaded a version 2020.3.03 that contains changes to address this issue. The change supports multiple, semi-colon separated email addresses in any of the email address fields. Let me know if this works for you.

[RRowley]

There is no restriction on having multiple preferences with different language and currency codes. The one thing that can cause a problem is if the currency sign is input as a character rather than an html code for the character. The US dollar sign is an exception. If you view the help on the Invoice Preferences Currency sign field, it explains this. I’ve include screen shots of test the I performed testing this.

Attachments:

1. 

   invMultiPrefTypes.png
   

2. 

   invMultiPrefTypes2.png
   

[Author]

Posts