028 How to change exported values and setup custom import options

HOW TO CHANGE EXPORT VALUES AND SETUP CUSTOM IMPORT OPTIONS

00:00:00 (Click on these time links to see Youtube video)

• Example Components

This is a short explanation on how to change the values being exported and to have a Custom Import option with an import of the data. Component Builder allows you to have an Import and Export function by default in all the List Views of the components. 00:00:35 The component called IP Data is used to take an IP address and translate it to determine from which country it came. Then a costing update is performed on your website based on that IP Data.

• Example IP Tables

Select IP Tables. (It is on the IP Table Dashboard.) 00:01:07 The 'CNTRY' value may be seen: the country and the 'REGISTRY' which indicates to whom the IP table belongs, and the range, 'IP from'/'IP to' is reflected.

Export Feature

00:01:26

If 'Export Data' had been clicked without selecting any values it will give a warning. ('Please first make a selection from the list'.) 00:01:35 Only values selected may be exported. If all have to be exported change the value to 'all'. In some instances, if the table is too long, it might not possible to export all the values at once.

Exporting data in large quantities is not advisable in Joomla. If quantities exceeds 3000 items, go to MySQL instead and get a dump file. 00:02:16 Although it is often seen that the Listview is used for up to 10000 items complex inheritance in structure is involved. But in this instance it is different, having the import and export in mind. If, for example, this must to be exported but for some reason this 'ZZZ' or 'AUS' value must instead be replaced by the country name, the following would be a simple implementation of how to perform it.

Exported Example In XLS Format

00:02:51

Click 'Export' and save this. (Opening Ip_tables). It has been exported, all these AUS values are displayed, as are some other values from the database as expected. But if it is supposed to be a different value than when it is exported, take the next step.

Export Data In Code

00:03:26

Component Builder has the 'getExportdata' method in the model. This method has an extra value called '$_export' which is set to 'true'.00:03:52 Targeting this method with custom scripting is one reason why this had been added. But the difficulty is that this part ($group to $query) is custom scripting and has also been added into the actual 'getlistquery'. 00:04:21 It is the same custom scripting. In the compiler the same custom script is added into the 'getlistquery' as into 'getExportdata. The way to know where it gets executed is through the value, '$_export'. 00:04:49 This value is not set in the 'listquery' only in the Export Data.

Admin View - PHP - (GetListQuery)

00:04:54

The custom scripting is done in the 'Editing the Admin View' area. With the Admin View open, go to PHP and then scroll down until the method 'Add PHP (getListQuery - JModellist)' can be seen. It should be set to 'Yes'. 00:05:43 The code placed there is added to both 'getListQuery' and 'exportquery'. If the values that had already been exported must be changed, not the values being shown in the component, it must be done in the same area. Notice that the same code appears in two distinct places. (See video.) 00:06:22 If some value must be changed, it can be done by adding another 'lookup' and this '$_export=true'. To see where all this '$_export=true' appears go to any List model, search, and it may be seen in various places. (See video.) 00:06:55

Go to the 'getExportdata' area. In the previous tutorial it had been explained how to add some customization to the values in the 'listview', some HTML. Here it should be determined whether the 'export' is 'set' or whether it is 'true'?

NB. Don't add this feature here. 00:07:25

Adding this customization of coloring is avoided because it should not be running during the export process. Only the values are needed. Again, see that the export values are used. 00:07:53 Those are the places where the export function is involved. By using '$_export' it is possible to identify whether it's an export or not. If it is, changes to the values can be made as necessary. Going back to the back end to show that this PHP area is the place where the query had been done.00:08:30

It can be verified whether an export had been done in the area: 'Add PHP(getitems Method-before the translation fix & decryption)'. This can be taken instead of the exclamation. (See video.) If export is '(isset($_export)' and 'true''(isset($_export)&&$_export)', then, in the area below what is necessary may be done if the values must be changed before translation or decryption. Otherwise it may be made after. 00:09:18 After all is done and the values must be changed on an export, it may be added.

Import Features Explained

00:09:32

If a different import type than usual is needed, go to import values, where these figures in the assign column must be updated. 00:09:40 If the ID is left in, it updates; if the ID is removed, it creates. If, for instance, the IDs are not used but these values instead, a custom import concept must be created. Although an attempt had been made to make it simple it still turned out to be complex.

Custom Import Tab(default import code)

00:10:13

Go to Custom Import in the Editing Admin View. There is a warning. Below it'yes' should be selected in the Custom Import option and it will load the actual script into these areas that are used by default in these various concepts. (See video.) 00:10:38 If this does not make sense, do not attempt to do it but do a search on courses like lynda.com and Udome etc instead. 00:11:09 Changes may be made to this, for example: take out a portion, then do a search, put something in like 'your name'. Save and compile it. Do a search to see where it appears. 00:11:31

The Default Import method is not completely removed when this kind of changes is performed. There is a way that these changes can be done, and have two Import Methods next to each other. It is not that easy but it is possible and it all depends on what is being done in this HTML and PHP view area. 00:11:59 So it depends on what is done in the view. Currently this is set up to do a normal import as is usually done. Changing this will also change the normal Import concept. That is how to change the Custom Import concept. Please read through the code. Maybe compile it. 00:12:33 See how the default import and concepts work and make changes accordingly.

I have used this area quite a lot for various applications, because occasionally there is a user that requires of you or a client to import these sets of CSV files , which may consists of 4000 or 40000 lines and only specific values need to be selected. 00:13:06 In that case this area is definitely what you looking for as it will make it possible to adapt the Import Concept to accommodate those kind of complexity. That is how to change Export values and create Custom Import values for any field view in the back end of your component.