magento2 – Removing or disabling checkout component from the layout xml issue in M2

I have a module called Parcelpro with this piece of code in the view/frontend/layout/checkout_index_index.xml :

<referenceBlock name="checkout.root">
    <arguments>
        <argument name="jsLayout" xsi:type="array">
            <item name="components" xsi:type="array">
                <item name="checkout" xsi:type="array">
                    <item name="children" xsi:type="array">
                        <item name="steps" xsi:type="array">
                            <item name="children" xsi:type="array">
                                <item name="shipping-step" xsi:type="array">
                                    <item name="children" xsi:type="array">
                                        <item name="step-config" xsi:type="array">
                                            <item name="children" xsi:type="array">
                                                <item name="shipping-rates-validation" xsi:type="array">
                                                    <item name="children" xsi:type="array">
                                                        <item name="parcelpro-rates-validation" xsi:type="array">
                                                            <item name="component" xsi:type="string">Parcelpro_Shipment/js/view/shipping-rates-validation</item>
                                                        </item>
                                                    </item>
                                                </item>
                                            </item>
                                        </item>
                                        <item name="shippingAddress" xsi:type="array">
                                            <item name="component" xsi:type="string">Parcelpro_Shipment/js/view/shipping</item>
                                        </item>
                                    </item>
                                </item>
                            </item>
                        </item>
                    </item>
                </item>
            </item>
        </argument>
    </arguments>
</referenceBlock>

and I would like to remove or disable this piece from it:

<item name="parcelpro-rates-validation" xsi:type="array">
    <item name="component" xsi:type="string">Parcelpro_Shipment/js/view/shipping-rates-validation</item>
</item>

In my “Rewrite Module” , in the checkout_index_index.xml file, I tried this option, according to https://devdocs.magento.com/guides/v2.3/howdoi/checkout/checkout_customize.html#disable :

<referenceBlock name="checkout.root">
    <arguments>
        <argument name="jsLayout" xsi:type="array">
            <item name="components" xsi:type="array">
                <item name="checkout" xsi:type="array">
                    <item name="children" xsi:type="array">
                        <item name="steps" xsi:type="array">
                            <item name="children" xsi:type="array">
                                <item name="shipping-step" xsi:type="array">
                                    <item name="children" xsi:type="array">
                                        <item name="step-config" xsi:type="array">
                                            <item name="children" xsi:type="array">
                                                <item name="shipping-rates-validation" xsi:type="array">
                                                    <item name="children" xsi:type="array">
                                                        <item name="parcelpro-rates-validation" xsi:type="array">
                                                            <item name="config" xsi:type="array">
                                                                <item name="componentDisabled" xsi:type="boolean">true</item>
                                                            </item>
                                                        </item>
                                                    </item>
                                                </item>
                                            </item>
                                        </item>
                                        <item name="shippingAddress" xsi:type="array">
                                            <item name="component" xsi:type="string">Parcelpro_Shipment/js/view/shipping</item>
                                        </item>
                                    </item>
                                </item>
                            </item>
                        </item>
                    </item>
                </item>
            </item>
        </argument>
    </arguments>
</referenceBlock>

After cleaning the cache, I can notice that part is still loaded in my checkout. Do you know what am I doing wrong here ? Thank you

magento 1.9 – Creating XML RPC method in customer module

I am creating a rpc method in the local customer module. But I am getting invalid path error. After hours of debugging also I am not able to figure out the missing portion. I was able to create in my local sales module but somehow its failing here.

In local/Mycompany/Customer/etc/api.xml :

<config>
<api>
    <resources>
        <customer translate="title" module="mycompany_customer">
            <model>mycompany_customer/customer_api</model>
            <title>Customer API</title>
            <acl>customer</acl>
            <methods>
                <setCustomerWhatsappStatus translate="title" module="customer">
                    <title>Set whatsapp status for customer</title>
                    <acl>customer/setCustomerWhatsappStatus</acl>
                </setCustomerWhatsappStatus> 
            </methods>
            <faults module="mycompany_sales">
                <data_invalid>
                    <code>103</code>
                    <message>Invalid data given. Details in error message.</message>
                </data_invalid>
            </faults>
        </customer>
    </resources>
    <acl>
        <resources>
            <customer translate="title" module="mycompany_customer">
                <title>Customer</title>
                <sort_order>1</sort_order>
                <setCustomerWhatsappStatus translate="title" module="mycompany_customer">
                    <title>Set whatsapp status for customer</title>
                 </setCustomerWhatsappStatus>
            </customer>
        </resources>
    </acl>
</api>

And in my local/Mycompany/Customer/Model/Customer/Api.php :

<?php

class Mycompany_Customer_Model_Customer_Api extends Mage_Customer_Model_Customer_Api
{
    public function setMethod($phone) {
       Mage::log($phone);
    }
}

And I am calling this method with dbaux_customer_customer.setCustomerWhatsappStatus but get Invalid Path error meaning that its not able to reach the method mentioned.

Please let me know if I missed something.

terminology – HTML elements in XML documents

I’ve been reading the HTML specifciation and I am confused with this line:

The nodes representing HTML elements in the DOM must implement, and
expose to scripts, the interfaces listed for them in the relevant
sections of this specification. This includes HTML elements in XML
documents

What HTML elements have to do with xml documents? Somewhat vague description makes things even more complicated:

To ease migration from HTML to XML, UAs conforming to this
specification will place elements in HTML in the
http://www.w3.org/1999/xhtml namespace, at least for the purposes of
the DOM and CSS. The term “HTML elements” refers to any element in
that namespace, even in XML documents.

What kind of migration? Who is UA? What is this http://www.w3.org/1999/xhtml namespace? How can URL be a namespace? And again, what HTML elements have to do with XML document?

python – Creating database and reporting tool out of xml files sourced from FTP

I have few questions regarding a reporting tool that I am trying to create. For better understanding let me describe the scenario first.

I am trying to create an automated reporting tool, which would allow me to bulk query a database of inputs which are sourced from the xml files sitting on an FTP server. I am looking at annual data stored in a zip archive containing multiple xml files with incremental updates issued almost everyday. In the first part of my project, I would like to create an automated download and schedule tool which would fetch the smls from the FTP and update the existent inputs depending on the key (e.g. user ID).

Here are the questions that I am struggling to address:

1) As these are separate files, what would be the best way to compile all this in one single file?
(I wanted to do this via SSIS and SQL, however, since SQL can not accommodate database that is bigger than 10 Gb (the current set of files amounts to 15+Gb), I am looking for the best alternative solution.

2) Is there any solution/software that would be able to create a read-only database straight off the XML files? I.e. without having to convert it in any other format? Also (if there is none) what would be the best alternative to SQL, given its limitations?

Many thanks, keep well!

Design inputs for XML based java application

I have a java application which basically has to do 1 thing.
Read a large xml, extract information from it, and send the information to another system but in a different xml format.

Earlier we were using jaxb to convert it to a relational database and then use jaxb again to convert it to the desired xml, but given the increasing size of the XMLs, we have to implement a fragmented reading approach using a combination of sax parsing and jaxb so that the memory usage stays within the accepted limits.
But this has slowed down the application considerably. I know there are always tradeoffs, but could anyone please provide any design inputs on the below:

Would it make sense to

  • use something like an XML database instead of the relational one
  • store the xml as is and instead use apache Lucene or Solr to index it and make it searchable

Any other recommendations are welcome. Please let me know if any more information is needed.

Override xml files

Is it possible to override etc/import/block.xml ?
I have modified it and works fine for now but if I update 3rd party extension … my modifications will be overwritten .
I am trying to override module is Sm_Bestshop

Generate XML from an SQL query

I need to generate XML from SQL code, I saw that it can be done and I can generate XML, but they do not have the format that interests me.
The XML must be in a format such as:

enter description of image here

The request is as follows:

SELECT 
@vax_FPROD as FPROD, @vax_HROD as HPROD, @v_turov as TUROV, 
 M_CalidadesLaminacion.CalidadSAP as MATNR, Coladas.CalidadAceriaSAP as MATNP,
  (select replace( (select concat(M_Codigos.Descripcion,Coladas.NColada)),' ','')) as CASTN ,         
  (select concat(        
    (SELECT     COUNT(*) AS Expr1         FROM          PalanquillasEntrantes        
    WHERE      (IdGrupo = Grupo_Colada_Turno.IdGrupo) AND (IdColada = Grupo_Colada_Turno.IdColada) AND (IdTurno = Grupo_Colada_Turno.IdTurno))
    ,',000'))  AS MENGE,               
   'PZA' as MEINS,     
   case when Grupo_Colada_Turno.ColadaFinalizada= 1 then 'F' else ''end as CTEND,          
   substring((select convert(varchar, DATEADD(hour,2,Pedidos.FH_Pedido_UTC), 127)),1,2) + 
   substring((select convert(varchar, DATEADD(hour,2,Pedidos.FH_Pedido_UTC), 127)),6,2) + 
   substring((select convert(varchar, DATEADD(hour,2,Pedidos.FH_Pedido_UTC), 127)),9,2) +
   (select replace(M_Codigos.Descripcion, ' ', '' )) +
   (SELECT RIGHT('000'+CAST(TextoValor AS VARCHAR(3)),3))
    as PONUM,               
    (select replace(M_TipoPalanquillaLaminacion.LongitudPalanquilla,'.',',')) as LONGT, 
    M_Secciones.IdSeccion as SECTI,
    (SELECT OrdenFabricacion AS AUFNR From Grupos g where g.IdGrupo = grupo_colada_turno.idgrupo) as AUFNR  
    FROM Grupo_Colada_Turno INNER JOIN   Coladas ON Grupo_Colada_Turno.IdColada = Coladas.IdColada INNER JOIN   Grupos 
    ON Grupo_Colada_Turno.IdGrupo = Grupos.IdGrupo INNER JOIN   Pedidos ON Grupos.IdPedido = Pedidos.IdPedido INNER JOIN   M_CalidadesLaminacion
     ON Grupos.IdCalidadLaminacion = M_CalidadesLaminacion.IdCalidadLaminacion INNER JOIN   M_Diametros ON Pedidos.IdDiametro = M_Diametros.IdDiametro INNER JOIN   M_Codigos 
     ON M_CalidadesLaminacion.IdCodigo = M_Codigos.IdCodigo AND M_Diametros.IdCodigo = M_Codigos.IdCodigo INNER JOIN   M_TipoPalanquillaLaminacion 
     ON M_TipoPalanquillaLaminacion.IdTipoPalanquilla = Coladas.IdTipoPalanquilla INNER JOIN   M_Secciones 
     ON M_Secciones.IdSeccion = M_TipoPalanquillaLaminacion.IdSeccion WHERE (Grupo_Colada_Turno.IdTurno = @v_idTurno)

I played by grouping the query to try to get the XML to generate as an example that I put but I can't,
I would appreciate help.
The FPROD, HPROD and TUROV fields are fields calculated before the query itself.

Should I organize the links under XML Sitemap?

We use Yoast on the WordPress website and it generates an https://www.website.com/page-sitemap.xml, database organized on the last modification date.

Do we need to have it organized based on our navigation menu?

basic xml source migration problem

I'm trying to figure out how to write a simple migration from an XML source located on a separate URL.

I have tried a number of different configurations for the selector and so far nothing has worked. The migration and source example is below.

migration:

id: xml_test
label: xml test importer
migration_group: p_migrate
dependencies:
  enforced:
    # List here the name of the module that provided this migration if you want
    # this config to be removed when that module is uninstalled.
    module:
      - p_migrate
source:
  plugin: url
  data_fetcher_plugin: http
  data_parser_plugin: simple_xml
  urls:
    - 'http://localhost:8888/test/source.xml'
  item_selector: /root/row
  fields:
    -
      name: title
      label: title
      selector: root/row/title
process:
  #  nid and vid commented out will allow them to autoincrement. Safe as long
  #    as nothing else is referencing them.
  #  nid: nid
  #  vid: vid
  #  type: type
  title: title

destination:
  plugin: 'entity:node'
  default_bundle: article

Source:



  
    Lorem ipsum
  
  
    Feeds Migrate is awesome!
  

Here is the error I am currently getting:
Invalid argument supplied for foreach () SimpleXml.php: 79
Invalid argument supplied for foreach () SimpleXml.php: 79

xml – How to add the spatial reference ID 28992 to the MSSQL server?

I want to use the spatial reference ID 28992, as found on EPSG, in MS SQL Server. How can I add this to MS SQL Server?

My final goal is to get this dataset in MS SQL Server, GML (Geography Markup Language) elements being stored in the geographic data type of MS SQL Server. After that, I want to establish a connection to MS SQL Server from QGIS, so that I can do some nice data analysis.

My idea was to analyze GML elements (contained in an XML) using the GEOMFROMGML analyzer from MS SQL Server. I have tried:

SELECT geography::GeomFromGml (
'


78988.952 384548.144 78992.462 384549.74 78998.712 384555.12


'
, 28992 )

However, the above code gives the following error:
"The spatial reference identifier (SRID) is not valid. The specified SRID must match one of the supported SRIDs displayed in the catalog view sys.spatial_reference_systems."

So I tried to add the SRID to the sys.spatial_reference_systems catalog view, using:

INSERT INTO (DataAnalyse).(sys).(spatial_reference_systems) ((spatial_reference_id)
      ,(authority_name)
      ,(authorized_spatial_reference_id)
      ,(well_known_text)
      ,(unit_of_measure)
      ,(unit_conversion_factor))
VALUES(
    28992,
    'EPSG',
    28992,
    'GEOGCS("Amersfoort", DATUM("Amersfoort", SPHEROID("Bessel 1841", 6377397.155,299.1528128)), PRIMEM("Greenwich", 0), UNIT("Degree", 0.0174532925199433))',
    'metre',
    1
)

This gave another error: "Msg 259, level 16, state 1, line 13
Ad hoc updates to system catalogs are not allowed. "

So I looked for how to update a system catalog. DBA explained how to do this. But it has been stated that there is a serious risk of your MS SQL Server installation breaking and that the warranty would cease. So it seems that direct updating of the system catalog is not really an option.

I first asked this question on Microsoft Docs, but I was told to ask my question here.

In addition, people seem to have asked similar questions:

If you have an answer to my question or if you have a different idea to allow me to reach my final goal (shown above), please let me know.