Jump to content

Himax

Members
  • Posts

    8
  • Joined

  • Last visited

Everything posted by Himax

  1. So, this fixed the immediate problem and the import was able to be completed. I'll check now the imported data for other issues. On the issue of multiple invoiceid-relid pairs, I can confirm that I have a lot of these invoices. The duplicated invoiceid-relid pairs are on multiple levels, and here's the list: Setup charges of the same type of service when multiple services of the same type are grouped in the same invoice. Multiple (monthly) periods of the same recurring service chargned on the same invoice Multiple occurrences of a recurring billing item billed on the same invoice In general, when multiple periods of the same service are grouped in the same invoice you'll get a duplicate invoiceid-relid pair in table tblinvoiceitems. Are you confident that the fix above and the import in general will deal with these occurrences appropriately? Thank you.
  2. To generate a generic recurring billing item for a customer (client) in WHMCS, that will be billed multiple times on multiple invoices you follow this procedure: In the client profile page, you go to the "Billable Items" tab. Click on the "+ Add billable Item" link (on the right) and put a generic description, amount etc. In the "invoice action "select "Recur every <N> <days/weeks/months etc> for <Y> times". Leave "invoice count" to 0 (this is the counter for WHMCS to keep track of the number of invoices generated already. Save changes. WHMCS will generate multiple invoices for this billing item, up to the selected number of times. This happens on the cron run, once per day at the predefined schedule. It might be possible to select the item and click to "invoice now". It works for single-shot billable items. I have not tested if it works on items invoiced multiple times. As invoices are generated, this billing item will move to the "Invoiced Items" list on the same page. This is a table that contains links to the invoice numbers. A multiple invoiced item will have multiple invoice links to each invoice. Background: I use this whmcs feature to invoice customer-specific jobs without the need to create a package, create an order etc. Mostly useful for ad-hoc consultancy work where I bill the customer a fixed amount per month on a regular basis, for work that does not apply to other customers. Or, when I need the customer to pay a bigger amount in multiple installments (i.e. say 1000 USD, 250 USD/month in 4 months). This way they get a single invoice, reminders, overdue notices on each installment. Le me know if you need more info. Thank you.
  3. it looks like the issue happens on a customer with "billable items" that were invoiced on multiple invoices, please see the attached image That is, WHMCS allows you to create a generic billable item and to specify that it has to be billed multiple times. So WHMCS will bill the item on multiple invoices at the predefined schedule. Then you can see on which invoices it was billed. So you have a back-reference or link from the invoices to the billable item. My guess is that the import module is trying to create this recurring billable item multiple times. Perhaps it's enough to "ignore" the error or to check if the recurring item is already present and act accordingly. Let me know, as this is blocking for me. I'd like to proceed with a paid license.
  4. Hi Paul, I'll try to reply, in hope of an anwer. All invoices seem to have been imported, including their detail lines. I traced the mysql statements issued by the migration tool. It tries to insert twice the same row in the "invoices_recur_created" table (here is invoice id 521 while in the previous example it was 519). 637226 Query INSERT INTO `invoices_recur_created` (`invoice_recur_id`, `invoice_id`) VALUES ('1', '521') 637226 Query INSERT INTO `invoices_recur_created` (`invoice_recur_id`, `invoice_id`) VALUES ('1', '521') Here the invoices_recurcreated table has an unique primary index over "invoice_recur_id+invoice_id". Investigating further, it looks like the issue happens on a customer with "billable items" that were invoiced on multiple invoices, please see the attached image That is, WHMCS allows you to create a generic billable item and to specify that it has to be billed multiple times. So WHMCS will bill the item on multiple invoices at the predefined schedule. Then you can see on which invoices it was billed. So you have a back-reference or link from the invoices to the billable item. My guess is that the import module is trying to create this recurring billable item multiple times. Perhaps it's enough to "ignore" the error or to check if the recurring item is already present and act accordingly. Let me know, as this is blocking for me. I'd like to proceed with a paid license. Thanks.
  5. Hello, I'm trying to import my WHMCS data into Blesta (trial) but the process is stopping early during import of the invoices. There's a duplicate primary key in one of the blesta tables. Everything after fails. I was unable to find the duplicate key in my whmcs dump (grepped, searched ... nothing!). Below is a debug log from the frontend. What do you suggest me to do? importStaff ----------------- importStaff took: 2.2723 seconds ----------------- importClients ----------------- importClients took: 18.2174 seconds ----------------- importContacts ----------------- importContacts took: 0.3054 seconds ----------------- importTaxes ----------------- importTaxes took: 0.035 seconds ----------------- importCurrencies ----------------- importCurrencies took: 0.0249 seconds ----------------- importInvoices ----------------- SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-519' for key 'PRIMARY' importTransactions ----------------- There is already an active transaction importPackages ----------------- There is already an active transaction importPackageOptions ----------------- importPackageOptions took: 0.1337 seconds ----------------- importServices ----------------- There is already an active transaction importSupportDepartments ----------------- There is already an active transaction importSupportTickets ----------------- There is already an active transaction importAffiliates ----------------- There is already an active transaction importMisc ----------------- There is already an active transaction decrypted 17 values using WHMCS' custom algorithm decrypt took: 0.0003 seconds total time took: 71.6811 seconds Array ( [error] => Array ( [0] => The import completed but the following errors ocurred: [1] => importInvoices: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-519' for key 'PRIMARY' on line 196 [2] => importTransactions: There is already an active transaction on line 231 [3] => importPackages: There is already an active transaction on line 231 [4] => importServices: There is already an active transaction on line 231 [5] => importSupportDepartments: There is already an active transaction on line 231 [6] => importSupportTickets: There is already an active transaction on line 231 [7] => importAffiliates: There is already an active transaction on line 231 [8] => importMisc: There is already an active transaction on line 231 ) )
  6. Hello, I'm wishing to dump my lifetime license of WHMCS (I own 2 of them, if anybody is interested). But would like to check if some features I need are implemented in Blesta, mainly to comply with EU rules and taxes and our special requirements. Here's a list: Proforma invoicing and separate invoice numbering for proforma and invoices. Perhaps proforma invoice only for selected customers (or invoice only for selected customers). EU vat rules, VAT and personal fiscal codes for physical persons. Bonus would be vies check on national VAT numbers to enable/disable VAT on each invoice. Freezing of the invoice once committed, including the header, address etc, while allowing proforma invoices to be amended until transformed into real invoices. Domain registrars: Enom, ResellerClub. Billing of full month on prorata services for the first month, even if the service starts during the month One invoice per month per customer, on a given day (1st of the month for example) which includes all the services accrued during a month, even if their start day differs. Pre or Post billing: Bill one month in advance or at the end of the month based on customer and/or service. Prepaid / refill accounts Thank you
  7. No answers since november 2021? It's April 2022 today. I'm also stuck in a pre-flight test of WHMCS to Blesta. May issue is a duplicate entry for a primary key importing transactions. Anything below that fails because of the failed transaction above: ``` importInvoices ----------------- SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-519' for key 'PRIMARY' importTransactions ----------------- There is already an active transaction importPackages ----------------- There is already an active transaction importPackageOptions ----------------- importPackageOptions took: 0.1337 seconds ----------------- .... Array ( [error] => Array ( [0] => The import completed but the following errors ocurred: [1] => importInvoices: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-519' for key 'PRIMARY' on line 196 [2] => importTransactions: There is already an active transaction on line 231 [3] => importPackages: There is already an active transaction on line 231 [4] => importServices: There is already an active transaction on line 231 [5] => importSupportDepartments: There is already an active transaction on line 231 [6] => importSupportTickets: There is already an active transaction on line 231 [7] => importAffiliates: There is already an active transaction on line 231 [8] => importMisc: There is already an active transaction on line 231 ) ) ``` Now I can't find this 1-519 key in my whmcs dump. Is there a better log/debug or shall I enable the mysql detailed log here? Thanks.
×
×
  • Create New...