Forum Replies Created
I have update the Version Update Process instructions on the left, menu to explain the update process from old SI version such as 2011.1 to the current version. This needs to be done by first updating to the master_2019.2 version and then to the current master_2020 version. Let me know if you have questions about these instructions.
The logic uses DataTables ajax with deferred rendering to make initial display as fast as possible. On my windows development system I get about a 3 second lapse to display the first page of invoices from a 550 total table. I don’t have a larger table to work with. On my production system that is hosted for me on a shared Linux server, there is about 1 second added to the display time. In either case, if after displaying the first page, I select the option to display the last page, there is no latency in the display on either system.
This is what I would expect give that the ajax display copies all the invoice data from the server to the browser when the initial page is displayed. The deferred rendering simply allows the first page of the data to be rendered and displayed while the logic continues to render the rest of the data in preparation for display.
Without more data to test with, I can’t give you comparative results. You might look at increasing your cache size. Also having an SSD rather than HDD can speed things up also.
The bottom line is that the bulk of the processing time for you page is on the client, not the server. Speed up the client and you should have better results.
I haven’t needed to do this, but it seems that you can make your own invoice template folder and in the css file, specify the fonts you want to use. Possible using the the @font-face declaration.
I think you need to contact your shared hosting support. If you have access to cpanel for your site, you might look to see if you have a program to specify the version of php. Check it and their might be a list of checkbox items that you can enable and intl should be in there.
There is not practical was to replace the NumberFormatter class. It is standard PHP and should be something your hosting service supports.
For some reason, this text box didn’t like my long instructions. So I put them in the attached file. Download the attached zip file, and read the FixInstructsions.txt file in it.
Attachments:January 9, 2021 at 5:44 am in reply to: How to keep/save bill type as Invoice and qoute seperately #1300
It works if your set up is correct. You need to have an Inv Prefs record set up and enabled with a description set to the invoice type (aka Quote) that you want to set up. I’ve attached images to show set up and help info.
The inv_number_starting_point shows the setup instructions in the How To… section on the left.
The inv_pregs (should be inv_prefs) the invoice preference set up I have on my test system.
The inv_pref_quote_edit shows the edit screen for the Quote type preference I have set up on my test system.
The inv_pref_numbering_group shows the help information on the Invoice numbering group field of the Inv Prefs record.
The inv_edit shows the edit screen for an invoice of type Quote on my test system. Note the drop down and how it shows the enabled Inv Prefs to select from.
By far the most complex part of the set up is if you want quotes (or other invoice types) numbered in a different sequence than the standard Invoice types. The set up for this is manual and uses the si_index table in the database.
Please provide a screen shot of this. I can’t seem to recreate it.
In the si_system_defaults table, what is the value of the record with name “payment_type”?
Is there a record in the si_payment_types table with a “pt_id” value equal to the “value” of the record in the si_system_defaults table?June 4, 2020 at 8:50 am in reply to: Fatal Error when using multiple emails in To field (when sending invoice) #902
I don’t have a PHP v7.1 environment to test master_2019.1 in. My recommendation is that you upgrade to PHP v7.2x or later and then use master_2019.2. I test this and it handles the multiple emails with semi-colon seperator just fine.June 3, 2020 at 8:17 am in reply to: Fatal Error when using multiple emails in To field (when sending invoice) #899
Extract the Email.php file from the attached zip archive into the Inc/Claz directory replacing the version you currently have. See if this helps.
Attachments:June 3, 2020 at 6:53 am in reply to: Fatal Error when using multiple emails in To field (when sending invoice) #895
How are you entering two emails. I just tried it for the “Email To” line and it worked fine. Entry form is first email address, a semi-colon, second email address. Example:
No. You can put it in a zip file and submit it here. I’ll check it out at that point.
I’ve made changes to a couple of files that I would like you to test and report on their performance. They are in the attached zip file. Extract the manage.tpl file into the templates/default/invoices directory, and the Invoice.php file in the Inc/Claz directory. The changes in these files affect the display of invoices on the primary screen. They remove the formatting of the Date column and move the formatting of the Total and Owing columns to the display script. Please give them a try and let me know what if any performance changes you see.
- This reply was modified 2 years ago by fearless359.
Attachments:May 21, 2020 at 11:19 am in reply to: three sql errors when upgrading from 2013.1.beta.8 #888
I just performed a fresh install of the simpleinvoices 2013 beta 8 version and then performed an update to the current version of fearless359 master_2019.2 version.
The only issue I ran into is that an error was thrown for an invalid default value for the ‘date’ field. The ‘date’ field is an existing field and defaults to, 0000-00-00 00:00:00. The fix was to change the sql_mode setting in the my.ini file and restarting the mysql service to implement the change. After this, the update process ran without incident.
I updated the Requirements documentation on the left menu to explain how to make this change.
While zero dates are generally frowned upon (hence the default to disallow them), they are ingrained in SI and so for now it makes sense to allow them.
Ok, I believe you must be overriding the default template. This means your template is in the custom/default_template directory. If this is the case, you can move the files out of this directory (saving them). You will then be using the standard SI default template. Test that. Then you can move your files back to the custom/default_template directory and start fixing them to work how you want.
Let me know what your find.