Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Miscellaneous

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st December 2017, 08:41
ytofrance ytofrance is offline
Newbie
 
Join Date: Dec 2012
Posts: 1
ytofrance is on a distinguished road
Baan: ERP LN - DB: SQL 2008 SERVER R2 - OS: WINDOWS SERVER 2008 R2
Import XML file to load sales quotation from another software
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: None/Unknown

Hello,

We have a part catalogue with a shop that permit our customer to buy spare parts from a website.
Our shop application generate an XML file for each order that is sent by email.

We are able to retrieve this file and put it automatically on ERP server but I don't know how to load it in ERP.

I would like to load this XML file directly in sales quotation table in order to automatically create a quotation for each web order.

Is there anybody that have an idea how to do it ?

Our XML file is build like below:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<OrderOverview translation="Vue ensemble devis">
  <AddressOverview alias="livraison" translation="Livraison">
    <Address translation="Adresse" type="SHIPPING" typeTranslation="Livraison">
      <Field alias="NAME" plainValue="Company" translation="Nom">Company</Field>
      <Field alias="STREET" plainValue="Company street" translation="Voie">Company street</Field>
      <Field alias="ZIP" plainValue="Post code" translation="Code postal">Post code</Field>
      <Field alias="CITY" plainValue="City of company" translation="Ville">City of company</Field>
      <Field alias="COUNTRY" plainValue="FRANCE" translation="Pays">FRANCE</Field>
    </Address>
  </AddressOverview>
  <BasketOverview alias="overview" translation="Vérification">
    <Basket id="201712-12" locale="fr_FR" translation="Panier">
      <BasketHeader translation="En-tête panier">
        <Field alias="ORDER_NO" plainValue="customer order reference" translation="Numéro de devis">customer order reference</Field>
        <Field alias="URGENT" plainValue="1" translation="Urgence">No</Field>
        <Field alias="ORDERDATE" plainValue="2017-12-05T09:43:56.012+0100" translation="Date">5 décembre 2017 09:43</Field>
        <Field alias="DESCRIPTION" plainValue="another test " translation="Description">another test</Field>
        <Field alias="TYPE" plainValue="1" translation="Type de panier">Devis standard</Field>
      </BasketHeader>
      <BasketPositions translation="Positions de panier">
        <BasketPosition translation="Position de panier">
          <Field alias="BEST_NR" plainValue="part_number" translation="Code Article">part_number</Field>
          <Field alias="DESCRIPTION" plainValue="part description" translation="Designation">part description</Field>
          <Field alias="QUANTITY" plainValue="1.000" translation="Qté">1,00</Field>
          <Field alias="AVAILABILITY" plainValue="" translation="Disponibilité" />
          <Field alias="PRICE" plainValue="1.51" translation="Prix Unitaire €">1,51</Field>
          <Field alias="UNIT" plainValue="pcs" translation="Unité">pcs</Field>
          <Field alias="CATEGORIE" plainValue="" translation="Catégorie" />
          <Field alias="DISCOUNTCODE" plainValue="2" translation="Code remise">2</Field>
          <Field alias="DISCOUNT" plainValue="25.00" translation="Remise (%)">25.00</Field>
          <Field alias="COMMENT" plainValue="" translation="Commentaire" />
          <Field alias="DISCOUNTED_PRICE" plainValue="1.13" translation="Prix remisé €">1,13</Field>
          <Field alias="OLD" plainValue="" translation="Ancien Code" />
          <Field alias="REPLACED" plainValue="" translation="Remplacé avec" />
          <Field alias="GESAMTPEIS" plainValue="1.13" translation="Total Ligne">1,13</Field>
        </BasketPosition>
      </BasketPositions>
    </Basket>
  </BasketOverview>
</OrderOverview>
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert Table Data to XML file ashitkamani Blogs and Web links 2 15th September 2010 17:24
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
copy sales order to sales quotation werni48 Distribution, Transportation & Warehousing 1 10th May 2004 16:23
Is Invensys really planning to sell Baan? baanassist General Discussion & Chat 10 3rd September 2002 18:29
What setup is needed in for creating Sales Quotation text from Product Configurator jaymukh Distribution, Transportation & Warehousing 1 27th April 2002 10:13


All times are GMT +2. The time now is 08:38.


©2001-2018 - Baanboard.com - Baanforums.com