Date on XML

  • Resolved actomendos

    (@actomendos)


    6 years, 11 months ago

    Hi,

    On My Export i need date in this format d/m/Y but im having like this.

    <date>2019-05-23 11:32:47</date>

    I need it seperated.
    <date>13/12/2019</date>
    <time>12:25</time>

    how can i change it?

    • This topic was modified 6 years, 11 months ago by actomendos.
    • This topic was modified 6 years, 11 months ago by actomendos.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WP All Import

    (@wpallimport)

    6 years, 11 months ago

    Hi @actomendos

    Are you exporting the “Date” element from the “Standard” data section? If so, here’s how you can do it:

    • Drag in the date element -> click it -> type “date” as the column name -> type “d/m/Y” as the date format: https://d.pr/i/DNEShQ
    • Drag in the date element again -> click it -> type “time” as the column name -> type “H:i” as the date format: https://d.pr/i/qcS9lB
    Thread Starter actomendos

    (@actomendos)

    6 years, 11 months ago

    It’s Woocommerce Order Export in Custom XML

    <?xml version="1.0" encoding="UTF-8"?>
<SIPARISLER>
	<!-- BEGIN LOOP -->
	<SIPARIS>
		<SIPARIS_NO>{Order ID}</SIPARIS_NO>
		<PAZARYERI_KARGOKODU>{Shipping Method}</PAZARYERI_KARGOKODU>
		<CariHesapKodu>{Order Key}</CariHesapKodu>
		<CariHesapOzelKodu>{Order Key}</CariHesapOzelKodu>
		<POSTA>{Customer Account Email Address}</POSTA>
		<TARIH>2019-12-29</TARIH>
		<sipariszaman>12:00:00</sipariszaman>
		<ISKONTO>{Discount Amount (per coupon)}</ISKONTO>
		<NET_TOPLAM>{Order Total}</NET_TOPLAM>
		<TeslimAlici>{Shipping First Name}</TeslimAlici>
		<TeslimAdresi>{Shipping Address 1}</TeslimAdresi>
		<TeslimTelefon>{Billing Phone}</TeslimTelefon>
		<teslimsekli>{Shipping Method}</teslimsekli>
		<tasiyicifirma>{Shipping Method}</tasiyicifirma>
		<teslimkod1>{kargo_firmasi}</teslimkod1>
		<teslimkod4>{Shipping Postcode}</teslimkod4>
		<teslimil>{Shipping City}</teslimil>
		<teslimilce>{Shipping State}</teslimilce>
		<faturaalici>{Billing First Name}</faturaalici>
		<faturaAdresi>{Billing Address 1}</faturaAdresi>
		<faturaTelefon>{Billing Phone}</faturaTelefon>
		<faturavergino>{Billing Postcode}</faturavergino>
		<faturavergidairesi>{Note Date}</faturavergidairesi>
		<faturail>{Billing City}</faturail>
		<faturailce>{Billing State}</faturailce>
		<kargokodu>{kargo_takip_no}</kargokodu>
		<ODEME_SEKLI>{Payment Method}</ODEME_SEKLI>
		<kargo_odemesi>{Shipping Cost}</kargo_odemesi>
		<SATIRLAR>
			[my_output_items({SKU},{Quantity},{Item Total},{Item Tax})]
		</SATIRLAR>
	</SIPARIS>
	<!-- END LOOP -->
</SIPARISLER>

    <TARIH>XXXXX</TARIH> is date.
    <sipariszaman>XXXXX</sipariszaman> is time.

    • This reply was modified 6 years, 11 months ago by actomendos.
    • This reply was modified 6 years, 11 months ago by actomendos.
    Plugin Author WP All Import

    (@wpallimport)

    6 years, 11 months ago

    Hi @actomendos

    In that case, you’d need to use a PHP function: https://d.pr/TD4D5j. For example:

    <TARIH>[date("d/m/Y", strtotime({Order Date}))]</TARIH>
<sipariszaman>[date("H:i", strtotime({Order Date}))]</sipariszaman>

    You can learn more about the date function here: https://www.php.net/manual/en/function.date.php.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Date on XML’ is closed to new replies.