Contributions de Liam

15 janvier 2025

• 14:5815 janvier 2025 à 14:58 diff hist +36‎ N Translations:MyList/61/en ‎ Page créée avec « 600px »
• 14:5715 janvier 2025 à 14:57 diff hist −56‎ MyList/en ‎ Page créée avec « The content of the message will help you identify the error with the lines '''Return code last access to database in error and Information on last access to database in error'''. |} »
• 14:5715 janvier 2025 à 14:57 diff hist +45‎ N Translations:MyList/19/en ‎ Page créée avec « 600px »
• 14:5715 janvier 2025 à 14:57 diff hist −56‎ MyList/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Change one of the fields to save it as checkable. The list will then become as shown opposite. The checkboxes will be used to select the results of the list to which to apply the treatment indicated in the query. In our example, the selected contacts will be deleted from the database. |} »
• 14:5715 janvier 2025 à 14:57 diff hist +42‎ N Translations:MyList/4/en ‎ Page créée avec « 600px »
• 14:5715 janvier 2025 à 14:57 diff hist −56‎ MyList/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Once the list is activated, it will appear from the links defined on its creation page. The '''Export to CSV''' button allows you to export the results of the list in CSV format for external processing. It is necessary to have activated the export functionality in the "Configuration" and in the settings saved during the "Fields on the list creation page". |} »
• 14:5615 janvier 2025 à 14:56 diff hist +40‎ N Translations:MyList/2/en ‎ Page créée avec « 600px »
• 14:5615 janvier 2025 à 14:56 diff hist −166‎ MyList/en ‎ Page créée avec « ===List results are not what you expected=== :The best way to ensure the quality of your SQL query is to query your database directly via phpmyadmin or equivalent software. Adapt the list query to paste it into the phpmyadmin SQL area. If the results are the same as the list, review your query. Otherwise, myList may have a bug. Contact us! (docs.patas-monkey.com/support). ===Your lists do not appear/no longer appear in your menus=== »
• 14:5615 janvier 2025 à 14:56 diff hist +6‎ N Translations:MyList/Page display title/en ‎ Page créée avec « MyList » actuelle
• 14:5615 janvier 2025 à 14:56 diff hist +546‎ N Translations:MyList/81/en ‎ Page créée avec « ===Deleted List Still Present=== You deleted the list without disabling it first. Mylist can no longer delete the list: you will need to clean your database by deleting the list from the llx_mylist table from phpmyadmin. ===Error Message When Creating the List=== If you have upgraded MyList from an older version, you may encounter an error message when creating a list. To fix it, you will need to perform the following query on your database: <code>ALTER TABLE `ll... » actuelle
• 14:5615 janvier 2025 à 14:56 diff hist −238‎ MyList/en ‎ Page créée avec « ==Frequently Asked Questions== ===General Issues=== This chapter lists the difficulties encountered with the module. You will therefore find some answers there regarding its use. If you encounter an error other than those described below when using this module: #Disable and reactivate the module, #Check on the ChangeLog if a new version has been published, #Re-install/update the module, #Check that replacing native Dolibarr files is not necessary for the module t... »
• 14:5615 janvier 2025 à 14:56 diff hist +181‎ N Translations:MyList/80/en ‎ Page créée avec « The content of the message will help you identify the error with the lines '''Return code last access to database in error and Information on last access to database in error'''. |} » actuelle
• 14:5615 janvier 2025 à 14:56 diff hist +73‎ N Translations:MyList/79/en ‎ Page créée avec « Review your SQL query. This is often a typo or bad linking in your query. » actuelle
• 14:5515 janvier 2025 à 14:55 diff hist +313‎ N Translations:MyList/78/en ‎ Page créée avec « ===Error message when launching myList === {| class="wikitable" | Error message '''DB_ERROR_NOSUCHFIELD or DB_ERROR_NOSUCHTABLE''' 600px | style="vertical-align:top;" | You have indicated in your query a field or a table that does not exist in your database or that is not identifiable. » actuelle
• 14:5515 janvier 2025 à 14:55 diff hist −299‎ MyList/en ‎ Page créée avec « If, despite these manipulations, the error persists, contact us using the dedicated form (http://docs.patas-monkey.com/support/). »
• 14:5515 janvier 2025 à 14:55 diff hist +393‎ N Translations:MyList/77/en ‎ Page créée avec « Following an update of the module or the lists themselves, even if your lists indicate that they are activated, you will have to reactivate them by entering the Active field in edit mode and saving again. {| class="wikitable" | 400px | style="vertical-align:top;" | It is also possible to reload all the lists from the list of lists with the following button |} »
• 14:5515 janvier 2025 à 14:55 diff hist +436‎ N Translations:MyList/76/en ‎ Page créée avec « ===List results are not what you expected=== :The best way to ensure the quality of your SQL query is to query your database directly via phpmyadmin or equivalent software. Adapt the list query to paste it into the phpmyadmin SQL area. If the results are the same as the list, review your query. Otherwise, myList may have a bug. Contact us! (docs.patas-monkey.com/support). ===Your lists do not appear/no longer appear in your menus=== » actuelle
• 14:5515 janvier 2025 à 14:55 diff hist +129‎ N Translations:MyList/75/en ‎ Page créée avec « If, despite these manipulations, the error persists, contact us using the dedicated form (http://docs.patas-monkey.com/support/). » actuelle
• 14:5515 janvier 2025 à 14:55 diff hist −332‎ MyList/en ‎ Page créée avec « === Tab in the element === It is possible to display a myList as a tab of an element for this it is necessary to use in the SQL query a particular alias for the table associated with the element {| class="wikitable" |- style="background-color:orange; font-weight:bold;" | prefix | Element |- | s | Third party (company) |- | p | Product |- | e | Stock (warehouse) |- | p | Project |- |p | Propal |- |c | order |- | f | Invoice |- |pf | Price request |- | cf | supplie... »
• 14:5515 janvier 2025 à 14:55 diff hist +594‎ N Translations:MyList/74/en ‎ Page créée avec « ==Frequently Asked Questions== ===General Issues=== This chapter lists the difficulties encountered with the module. You will therefore find some answers there regarding its use. If you encounter an error other than those described below when using this module: #Disable and reactivate the module, #Check on the ChangeLog if a new version has been published, #Re-install/update the module, #Check that replacing native Dolibarr files is not necessary for the module t... » actuelle
• 14:5515 janvier 2025 à 14:55 diff hist +295‎ N Translations:MyList/73/en ‎ Page créée avec « ===Selecting fields when displaying lists=== {| class="wikitable" | 600px | style="vertical-align:top;" | By activating DataTables in the "Configuration", you can choose the columns of the list to display or not by checkboxes from the button '''Other columns''' |} »
• 14:5515 janvier 2025 à 14:55 diff hist +386‎ N Translations:MyList/72/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Change one of the fields to save it as checkable. The list will then become as shown opposite. The checkboxes will be used to select the results of the list to which to apply the treatment indicated in the query. In our example, the selected contacts will be deleted from the database. |} »
• 14:5515 janvier 2025 à 14:55 diff hist −169‎ MyList/en ‎ Page créée avec « for category type fields, the following settings must be made: »
• 14:5415 janvier 2025 à 14:54 diff hist +282‎ N Translations:MyList/71/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Let's start with a list of contacts and add in the field '''Processing request'' the line <code>DELETE FROM 'llx_socpeople' WHERE rowid=#ROWID#</code> allowing their deletion. |} »
• 14:5415 janvier 2025 à 14:54 diff hist +162‎ N Translations:MyList/70/en ‎ Page créée avec « ===Processing queries=== In addition to the list display query, a processing query can provide the possibility of performing new actions, always from SQL queries. » actuelle
• 14:5415 janvier 2025 à 14:54 diff hist −222‎ MyList/en ‎ Page créée avec « ====Calculated Fields==== It is possible to display a calculated field in the list from php code entered in the additional parameters. »
• 14:5415 janvier 2025 à 14:54 diff hist +83‎ N Translations:MyList/69/en ‎ Page créée avec « Activate the list from its file and it will be accessible from your Dolibarr menus. » actuelle
• 14:5415 janvier 2025 à 14:54 diff hist +314‎ N Translations:MyList/68/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | From the page '''Patas-M Tools > MyList > Import a list''', paste the XML file in the input area and click on the button '''Start import'''. Activate the list from its file and it will be accessible from your Dolibarr menus |} »
• 14:5415 janvier 2025 à 14:54 diff hist +175‎ N Translations:MyList/67/en ‎ Page créée avec « It is possible to save a list and the settings of its fields by importing an '''XML''' file. {{Note|List examples are provided with the MyList module in the XMLsample folder}} » actuelle
• 14:5415 janvier 2025 à 14:54 diff hist −226‎ MyList/en ‎ Page créée avec « |- style="vertical-align:top;" | 600px | It is then possible to select several categories for filtering. If you use the check mark, filtering several categories will be done by OR instead of AND »
• 14:5415 janvier 2025 à 14:54 diff hist +22‎ N Translations:MyList/66/en ‎ Page créée avec « ===Importing a list=== » actuelle
• 14:5415 janvier 2025 à 14:54 diff hist +504‎ N Translations:MyList/65/en ‎ Page créée avec « === Tab in the element === It is possible to display a myList as a tab of an element for this it is necessary to use in the SQL query a particular alias for the table associated with the element {| class="wikitable" |- style="background-color:orange; font-weight:bold;" | prefix | Element |- | s | Third party (company) |- | p | Product |- | e | Stock (warehouse) |- | p | Project |- |p | Propal |- |c | order |- | f | Invoice |- |pf | Price request |- | cf | supplie... »
• 14:5315 janvier 2025 à 14:53 diff hist +18‎ N Translations:MyList/64/en ‎ Page créée avec « ==Other Features== » actuelle
• 14:5315 janvier 2025 à 14:53 diff hist +382‎ N Translations:MyList/63/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | If you have set the list to display it in the tab of a card, the results will be filtered according to the element. {{Note|Filtering the display of the list results requires the presence of a condition in its SQL query. If none is present, add for example WHERE <nowiki>1 = 1</nowiki> }} |} » actuelle
• 14:5315 janvier 2025 à 14:53 diff hist −103‎ MyList/en ‎ Page créée avec « ====Field filtering ==== :Filtering options on field values. :{| class="wikitable" |- style="background-color:orange; font-weight:bold;" | Duration, Number, Sum, Price | Result |- | < 20000 | numbers < and = to 200000 |- | 200000-300000 | numbers from 200000 to 300000 inclusive |- style="background-color: orange; font-weight:bold;" | Date | |- |2008 | all dates of 2008 from 01/01 to 31/12 inclusive |- | 2006-2009 | all dates from 01/01/2006 to 31/12/2009 inclusiv... »
• 14:5315 janvier 2025 à 14:53 diff hist +456‎ N Translations:MyList/62/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Once the list is activated, it will appear from the links defined on its creation page. The '''Export to CSV''' button allows you to export the results of the list in CSV format for external processing. It is necessary to have activated the export functionality in the "Configuration" and in the settings saved during the "Fields on the list creation page". |} »
• 14:5315 janvier 2025 à 14:53 diff hist −399‎ MyList/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Finish creating the fields on the model opposite |} »
• 14:5315 janvier 2025 à 14:53 diff hist +287‎ N Translations:MyList/60/en ‎ Page créée avec « To make the list accessible from the Dolibarr menus, you just need to modify the list to make it active. {{Note|Before making the list active, you can display it with its query using the menu link '''Patas-M Tools > MyList'''. This trick only works on lists that are not yet activated.}} » actuelle
• 14:5315 janvier 2025 à 14:53 diff hist +147‎ N Translations:MyList/59/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | Finish creating the fields on the model opposite |} »
• 14:5215 janvier 2025 à 14:52 diff hist +1 447‎ N Translations:MyList/58/en ‎ Page créée avec « ===Management of specific keys (<code>rowid</code>, <code>fk_statut</code>)=== * Rowid fields: rowid fields have a particular operation in myList, associated with parameters, they allow to create a link to the element of which they are the key. :Making a field clickable is probably the most complex problem of myList because it involves understanding a little of the Dolibarr architecture. :First of all, it is necessary to locate in the Dolibarr directories where t... » actuelle
• 14:5215 janvier 2025 à 14:52 diff hist +213‎ N Translations:MyList/57/en ‎ Page créée avec « {| class="wikitable" | 600px | style="vertical-align:top;" | this type of fields uses the native operation of additional attributes (extrafields) and the dol_eval() function. |} »
• 14:5215 janvier 2025 à 14:52 diff hist −472‎ MyList/en ‎ Page créée avec « It allows you to make it clickable and/or filterable by drop-down list. »
• 14:5215 janvier 2025 à 14:52 diff hist +134‎ N Translations:MyList/56/en ‎ Page créée avec « ====Calculated Fields==== It is possible to display a calculated field in the list from php code entered in the additional parameters. » actuelle
• 14:5215 janvier 2025 à 14:52 diff hist +315‎ N Translations:MyList/55/en ‎ Page créée avec « * In the case of filtering by a user's company (for example to filter a list on invoices) you must use the #SOCID# value as the default value on a field containing the company key * In the case of filtering by the default user, you must use the #USERID# value as the default value on a field containing the user key » actuelle
• 14:5215 janvier 2025 à 14:52 diff hist +1 008‎ N Translations:MyList/54/en ‎ Page créée avec « ====Field filtering ==== :Filtering options on field values. :{| class="wikitable" |- style="background-color:orange; font-weight:bold;" | Duration, Number, Sum, Price | Result |- | < 20000 | numbers < and = to 200000 |- | 200000-300000 | numbers from 200000 to 300000 inclusive |- style="background-color: orange; font-weight:bold;" | Date | |- |2008 | all dates of 2008 from 01/01 to 31/12 inclusive |- | 2006-2009 | all dates from 01/01/2006 to 31/12/2009 inclusiv... » actuelle
• 14:5115 janvier 2025 à 14:51 diff hist +2‎ N Translations:MyList/53/en ‎ Page créée avec « |} » actuelle
• 14:5115 janvier 2025 à 14:51 diff hist +231‎ N Translations:MyList/52/en ‎ Page créée avec « |- style="vertical-align:top;" | 600px | It is then possible to select several categories for filtering. If you use the check mark, filtering several categories will be done by OR instead of AND »
• 14:5115 janvier 2025 à 14:51 diff hist −131‎ MyList/en ‎ Page créée avec « Here are some other examples of category parameters: * supplier:fk_soc * company:fk_soc * contact:fk_socpeople »
• 14:5115 janvier 2025 à 14:51 diff hist +110‎ N Translations:MyList/51/en ‎ Page créée avec « Here are some other examples of category parameters: * supplier:fk_soc * company:fk_soc * contact:fk_socpeople »
• 14:5115 janvier 2025 à 14:51 diff hist +398‎ N Translations:MyList/50/en ‎ Page créée avec « {| class="wikitable" |- style="vertical-align:top;" | 600px | * field name: the field that links the list to the category * Field parameter: the value before the separation corresponds to the name of the category table (in the example llx_categorie_member) the second value corresponds to the link to the field entered in the field name (here fk_element) »