OBJECT XMLport 50001 Magento Item Export { OBJECT-PROPERTIES { Date=05-03-14; Time=18:44:51; Modified=Yes; Version List=; } PROPERTIES { DefaultNamespace=; UseDefaultNamespace=Yes; } ELEMENTS { { [{03AEDF86-1BC2-4049-A4E5-6B7B6602A30F}]; ;Root ;Element ;Text } { [{60E928EA-86CE-4C27-989F-5DBEB21913A1}];1 ;Item ;Element ;Table ; SourceTable=Table27 } { [{13D61929-0EC5-40AC-8877-50F0D2FA5C39}];2 ;No ;Element ;Field ; DataType=Code; SourceField=Item::No. } { [{F4AE5EF3-83B4-482D-8013-A543F1F48BA9}];2 ;Description ;Element ;Field ; DataType=Text; SourceField=Item::Description } { [{507CC21B-667B-4147-8B16-BCE06781E97D}];2 ;Price ;Element ;Field ; DataType=Decimal; SourceField=Item::Unit Price } { [{7AF77553-D6C3-4031-9F20-2E472C5AE136}];2 ;Type ;Element ;Text ; DataType=Option; Export::OnBeforePassVariable=BEGIN IF ( ItemCategory.GET(Item."Item Category Code") ) THEN Type := ItemCategory.Code ELSE Type := '' END; } { [{3F105AEE-060E-4863-B3EF-C1F9F276BA62}];2 ;Inventory ;Element ;Field ; DataType=Decimal; SourceField=Item::Inventory } { [{D1326B93-1111-4332-B917-91088F8C92EE}];2 ;Brand_ID ;Element ;Field ; DataType=Code; SourceField=Item::Brand ID } { [{F969F0A0-A5B6-4BE5-A427-C10A2C465F3D}];2 ;TypeDescription ;Element ;Text ; Export::OnBeforePassVariable=BEGIN IF ( ItemCategory.GET(Item."Item Category Code") ) THEN TypeDescription := ItemCategory.Description ELSE TypeDescription := '' END; } } EVENTS { } REQUESTPAGE { PROPERTIES { } CONTROLS { } } CODE { VAR ItemCategory@1000000000 : Record 5722; BEGIN END. } } OBJECT XMLport 50002 Magento Order Import { OBJECT-PROPERTIES { Date=09-05-14; Time=13:33:35; Modified=Yes; Version List=Magento; } PROPERTIES { Permissions=TableData 36=rimd, TableData 37=rimd; Direction=Both; Encoding=UTF-8; Format/Evaluate=C/SIDE Format/Evaluate; UseDefaultNamespace=Yes; } ELEMENTS { { [{3E5C2D4F-071E-4A46-819E-5E693EA9CC13}]; ;Order ;Element ;Text } { [{3734D84D-971C-48A8-B3FD-328D114E8A42}];1 ;SalesHeader ;Element ;Table ; VariableName=; SourceTable=Table36; Import::OnAfterInitRecord=BEGIN "".SetHideValidationDialog(TRUE); END; Import::OnBeforeInsertRecord=BEGIN ""."Bill-to Name" := data[1]; ""."Bill-to Contact" := data[2]; ""."Bill-to Address" := data[3]; ""."Bill-to Address 2" := data[4]; ""."Bill-to City" := data[5]; ""."Bill-to Post Code" := data[6]; ""."Bill-to Country/Region Code" := data[7]; ""."Sell-to Customer Name" := data[8]; ""."Sell-to Contact" := data[9]; ""."Sell-to Address" := data[10]; ""."Sell-to Address 2" := data[11]; ""."Sell-to City" := data[12]; ""."Sell-to Post Code" := data[13]; ""."Sell-to Country/Region Code" := data[14]; ""."Ship-to Name" := data[15]; ""."Ship-to Contact" := data[16]; ""."Ship-to Address" := data[17]; ""."Ship-to Address 2" := data[18]; ""."Ship-to City" := data[19]; ""."Ship-to Post Code" := data[20]; ""."Ship-to Country/Region Code" := data[21]; END; } { [{6AEAF0A4-E019-4486-BD26-734B585C2977}];2 ;Bill_to_Customer_Name;Element;Field ; DataType=Text; SourceField=::Bill-to Name; Import::OnAfterAssignField=BEGIN data[1] := ""."Bill-to Name"; END; } { [{9C043DB5-74F7-47C9-8E66-221E07C2CCAF}];2 ;Bill_to_Contact ;Element ;Field ; DataType=Text; SourceField=::Bill-to Contact; Import::OnAfterAssignField=BEGIN data[2] := ""."Bill-to Contact"; END; } { [{6FC4324E-D822-42F5-986E-2942A056EB02}];2 ;Bill_to_Address ;Element ;Field ; DataType=Text; SourceField=::Bill-to Address; Import::OnAfterAssignField=BEGIN data[3] := ""."Bill-to Address"; END; } { [{7E6A5158-CA26-4511-A7F8-6406B1398238}];2 ;Bill_to_Address_2 ;Element ;Field ; DataType=Text; SourceField=::Bill-to Address 2; Import::OnAfterAssignField=BEGIN data[4] := ""."Bill-to Address 2"; END; } { [{BFE4398B-372C-4817-BDB8-694BADA37F9B}];2 ;Bill_to_City ;Element ;Field ; DataType=Text; SourceField=::Bill-to City; Import::OnAfterAssignField=BEGIN data[5] := ""."Bill-to City"; END; } { [{C8E485B2-D521-4267-B40F-E2B0325A6AA9}];2 ;Bill_to_Post_Code ;Element ;Field ; DataType=Code; SourceField=::Bill-to Post Code; Import::OnAfterAssignField=BEGIN data[6] := ""."Bill-to Post Code"; END; } { [{BF1C43C5-B89C-44E2-8B64-291A91DF5587}];2 ;Bill_to_Country_Region_Code;Element;Field; DataType=Code; SourceField=::Bill-to Country/Region Code; Import::OnAfterAssignField=BEGIN data[7] := ""."Bill-to Country/Region Code"; END; } { [{1EC0BC17-D213-4864-B96F-CCCAA693160A}];2 ;Sell_to_Customer_Name;Element;Field ; DataType=Text; SourceField=::Sell-to Customer Name; Import::OnAfterAssignField=BEGIN data[8] := ""."Sell-to Customer Name"; END; } { [{35DF0C05-463E-4119-8540-DC28A4DA360D}];2 ;Sell_to_Contact ;Element ;Field ; DataType=Text; SourceField=::Sell-to Contact; Import::OnAfterAssignField=BEGIN data[9] := ""."Sell-to Contact"; END; } { [{D0125D6E-8684-46A2-B210-87EFAD924971}];2 ;Sell_to_Address ;Element ;Field ; DataType=Text; SourceField=::Sell-to Address; Import::OnAfterAssignField=BEGIN data[10] := ""."Sell-to Address"; END; } { [{8BD9401E-C8B1-4620-AF83-A3E27F1DCB68}];2 ;Sell_to_Address_2 ;Element ;Field ; DataType=Text; SourceField=::Sell-to Address 2; Import::OnAfterAssignField=BEGIN data[11] := ""."Sell-to Address 2"; END; } { [{7DFD038E-F621-4E43-B5BA-44788EB1D89C}];2 ;Sell_to_City ;Element ;Field ; DataType=Text; SourceField=::Sell-to City; Import::OnAfterAssignField=BEGIN data[12] := ""."Sell-to City"; END; } { [{65FBDACF-5A41-4C77-B1DD-CCD022E22538}];2 ;Sell_to_Post_Code ;Element ;Field ; DataType=Code; SourceField=::Sell-to Post Code; Import::OnAfterAssignField=BEGIN data[13] := ""."Sell-to Post Code"; END; } { [{1DA8EC97-B94A-4BDA-B973-0033C1EE0CBC}];2 ;Sell_to_Country_Region_Code;Element;Field; DataType=Code; SourceField=::Sell-to Country/Region Code; Import::OnAfterAssignField=BEGIN data[14] := ""."Sell-to Country/Region Code"; END; } { [{11DC0A52-50FC-4334-80D8-520B7867E69F}];2 ;Ship_to_Name ;Element ;Field ; DataType=Text; SourceField=::Ship-to Name; Import::OnAfterAssignField=BEGIN data[15] := ""."Ship-to Name"; END; } { [{C88C4B06-AF96-44BE-85F5-52F641E6A407}];2 ;Ship_to_Contact ;Element ;Field ; DataType=Text; SourceField=::Ship-to Contact; Import::OnAfterAssignField=BEGIN data[16] := ""."Ship-to Contact"; END; } { [{A558E227-86DE-4ECA-BB17-531B9E72DCAA}];2 ;Ship_to_Address ;Element ;Field ; DataType=Text; SourceField=::Ship-to Address; Import::OnAfterAssignField=BEGIN data[17] := ""."Ship-to Address"; END; } { [{74DB5AAC-3D74-4A6A-9150-2AAB22A41490}];2 ;Ship_to_Address_2 ;Element ;Field ; DataType=Text; SourceField=::Ship-to Address 2; Import::OnAfterAssignField=BEGIN data[18] := ""."Ship-to Address 2"; END; } { [{22432F88-8C9B-4B98-A040-AF2F4C779EA3}];2 ;Ship_to_City ;Element ;Field ; DataType=Text; SourceField=::Ship-to City; Import::OnAfterAssignField=BEGIN data[19] := ""."Ship-to City"; END; } { [{EC746DF3-E19E-4371-B3EB-5CC98C1AAA79}];2 ;Ship_to_Post_Code ;Element ;Field ; DataType=Code; SourceField=::Ship-to Post Code; Import::OnAfterAssignField=BEGIN data[20] := ""."Ship-to Post Code"; END; } { [{5C1B792D-2165-4DBB-8286-F7A3CB176AC5}];2 ;Ship_to_Country_Region_Code;Element;Field; DataType=Code; SourceField=::Ship-to Country/Region Code; Import::OnAfterAssignField=BEGIN data[21] := ""."Ship-to Country/Region Code"; END; } { [{D0E8DD32-75A5-460A-A9F8-4A770426F698}];2 ;Order_Amount_Excl_VAT;Element;Field ; DataType=Decimal; SourceField=::Amount } { [{ADF178C4-09C7-4997-8218-9AA8AC5A9174}];2 ;Order_Amount_Incl_VAT;Element;Field ; DataType=Decimal; SourceField=::Amount Including VAT } { [{2B4392DA-F01A-49B7-9E12-4C08C9FEBDB7}];2 ;PostingDate ;Element ;Field ; DataType=Date; SourceField=::Posting Date } { [{9253CB22-0BEE-4FDA-8CBD-67D612F35254}];2 ;OrderDate ;Element ;Field ; DataType=Date; SourceField=::Order Date } { [{BB1BBE29-792E-4F71-B6FA-27749E456132}];2 ;BillToContactNo ;Element ;Field ; DataType=Code; FieldValidate=Yes; SourceField=::Bill-to Contact No. } { [{920F6A96-CA54-4311-9970-7B0BF3888AF0}];2 ;SellToContactNo ;Element ;Field ; DataType=Code; FieldValidate=Yes; SourceField=::Sell-to Contact No. } { [{BDD4808D-A3D7-4530-94C1-94A76406D0A8}];2 ;BillToCustomerNo ;Element ;Field ; DataType=Code; FieldValidate=Yes; SourceField=::Bill-to Customer No. } { [{870B28DE-6EA3-4E64-97B2-27E60FEA4AB7}];2 ;SellToCustomerNo ;Element ;Field ; DataType=Code; FieldValidate=Yes; AutoCalcField=No; SourceField=::Sell-to Customer No. } { [{6F6121B2-D127-44E0-B34C-E622FB268155}];2 ;DocumentType ;Element ;Field ; DataType=Option; SourceField=::Document Type } { [{1E33AF3F-A470-4917-A98B-D72912DA4BCC}];2 ;No ;Element ;Field ; DataType=Code; SourceField=::No. } { [{AFB27989-1518-4B07-9204-8DB625F82A6A}];2 ;SalesLine ;Element ;Text } { [{CE546A14-1692-49F7-8B43-E035030655BD}];3 ;Line ;Element ;Table ; VariableName=; SourceTable=Table37; LinkFields=Field3=FIELD(Field3); LinkTable= } { [{268B06A7-60D1-498C-BCFD-C94C37220260}];4 ;DocumentType ;Element ;Field ; DataType=Option; AutoCalcField=No; SourceField=::Document Type } { [{69A5173A-DC42-40FD-96D2-BADA56D03866}];4 ;LineNo ;Element ;Field ; DataType=Integer; AutoCalcField=No; SourceField=::Line No. } { [{A2A19F0B-6899-4005-A6E3-F4111BB41299}];4 ;Type ;Element ;Field ; DataType=Option; AutoCalcField=No; SourceField=::Type } { [{AF104E84-12D3-4C0E-B7B7-6F1C283B7948}];4 ;ItemNo ;Element ;Field ; DataType=Code; AutoCalcField=No; SourceField=::No. } { [{ACECA638-8D9E-4ED7-A1B7-2B2BD99563C2}];4 ;Quantity ;Element ;Field ; DataType=Decimal; AutoCalcField=No; SourceField=::Quantity } { [{DF32C70D-CE27-4D79-8013-311D8A31D1EB}];4 ;Unit_Price ;Element ;Field ; DataType=Decimal; SourceField=::Unit Price } { [{2FCFC1A7-5976-42F1-9FD7-FEA0D4D78137}];4 ;Amount ;Element ;Field ; DataType=Decimal; SourceField=::Amount } { [{4309E738-8765-435C-951D-FB0EF05A697C}];4 ;Amount_Including_VAT;Element ;Field ; DataType=Decimal; SourceField=::Amount Including VAT } { [{BC71CE42-9D80-4270-A260-5D37ED88F842}];4 ;VAT_Percent ;Element ;Field ; DataType=Decimal; SourceField=::VAT % } { [{B10368BE-D1F5-4EAA-8BA0-320F564E0533}];4 ;Line_Discount_Amount;Element ;Field ; DataType=Decimal; SourceField=::Line Discount Amount } { [{9B6559D5-F0DA-4ADA-965C-C34C45C8DCF8}];2 ;Comments ;Element ;Text ; MinOccurs=Zero } { [{95E9388F-E851-4445-B4FB-94DD37E7F6DF}];3 ;Comment ;Element ;Table ; VariableName=; SourceTable=Table44; LinkFields=Field2=FIELD(Field3); LinkTable= } { [{F3AC86AC-4797-4571-B6DE-1E63ED17B4E9}];4 ;DocumentNo ;Element ;Field ; DataType=Code; SourceField=::No. } { [{65EDA8C8-F41F-470E-896E-FA1829D4F3AF}];4 ;LineNo ;Element ;Field ; DataType=Integer; SourceField=::Line No. } { [{FE3543FD-45B9-40E4-8B96-C9B4AC71E536}];4 ;DocumentType ;Element ;Field ; DataType=Option; SourceField=::Document Type } { [{25D118F0-16C5-43E2-945C-A0B0B33F8B05}];4 ;Date ;Element ;Field ; DataType=Date; SourceField=::Date } { [{4743C0CA-B404-48BD-BA22-5BF01706EA78}];4 ;Comment ;Element ;Field ; DataType=Text; SourceField=::Comment } { [{93F57E77-B047-4B9B-8B58-6AA2D36D78FF}];4 ;DocumentLine ;Element ;Field ; DataType=Integer; SourceField=::Document Line No. } } EVENTS { } REQUESTPAGE { PROPERTIES { } CONTROLS { } } CODE { VAR data@1000000000 : ARRAY [30] OF Text[30]; BEGIN END. } } OBJECT XMLport 50003 Magento Customers { OBJECT-PROPERTIES { Date=06-04-14; Time=17:18:04; Modified=Yes; Version List=; } PROPERTIES { UseDefaultNamespace=Yes; } ELEMENTS { { [{A4074CE1-457D-4BA0-91F1-480588429B8E}]; ;Root ;Element ;Text } { [{36383FFE-D9A8-486C-B8C1-446E6E904CD5}];1 ;Customer ;Element ;Table ; SourceTable=Table18; Import::OnBeforeInsertRecord=BEGIN IF NOT (NoSeries = '' ) THEN Customer."No." := NoSeriesMgt.GetNextNo(NoSeries,0D,TRUE); END; Export::OnPreXMLItem=BEGIN Customer.SETFILTER("E-Mail", CustomerEmail); END; } { [{121D91E0-EE62-4F8A-8BDA-62C68FEF7582}];2 ;Email ;Element ;Field ; DataType=Text; SourceField=Customer::E-Mail } { [{1075856D-7E5D-4F76-85D4-DB2480B91069}];2 ;Name ;Element ;Field ; DataType=Text; SourceField=Customer::Name } { [{C322D79A-28CA-4A54-BE84-FB3DD94ECA7D}];2 ;Name_2 ;Element ;Field ; DataType=Text; SourceField=Customer::Name 2 } { [{02E71D78-0AE5-4758-AAE1-CEB9B54BE91E}];2 ;Address ;Element ;Field ; DataType=Text; SourceField=Customer::Address } { [{37F79DD8-36C8-4078-B3A4-A62C503EC053}];2 ;Address_2 ;Element ;Field ; DataType=Text; SourceField=Customer::Address 2 } { [{94E95023-577D-4388-87D7-450EEC8F7D05}];2 ;City ;Element ;Field ; DataType=Text; SourceField=Customer::City } { [{AAB066DB-6B82-4E32-B9AB-49C8C18CA9EC}];2 ;Phone_No ;Element ;Field ; DataType=Text; SourceField=Customer::Phone No. } { [{92B6D63C-5240-4F5A-B4E5-6F932E2247DE}];2 ;No. ;Element ;Field ; DataType=Code; SourceField=Customer::No. } { [{9A6AF7C5-A85D-472A-9B66-07DEF4EA4130}];2 ;Customer_Posting_Group;Element;Field ; DataType=Code; SourceField=Customer::Customer Posting Group } { [{52C019EA-FE97-4C75-B6CA-736F3EE192B7}];2 ;Gen_Bus_Posting_Group;Element;Field ; DataType=Code; SourceField=Customer::Gen. Bus. Posting Group } { [{B631C783-DB7B-494C-B71B-2EBF7E6C9C47}];2 ;VAT_Bus_Posting_Group;Element;Field ; DataType=Code; SourceField=Customer::VAT Bus. Posting Group } { [{DA8C8C63-DFFD-41F8-BD5A-1AE1E6290684}];2 ;NoSeries ;Element ;Text ; VariableName=NoSeries } } EVENTS { } REQUESTPAGE { PROPERTIES { } CONTROLS { } } CODE { VAR CustomerEmail@1000000000 : Text[64]; PROCEDURE SetCustomerFilter@1000000001(CustomerFilter@1000000000 : Text[64]); BEGIN CustomerEmail := CustomerFilter; END; BEGIN END. } } OBJECT XMLport 50005 Magento Invoiced Orders { OBJECT-PROPERTIES { Date=20-05-14; Time=11:00:52; Modified=Yes; Version List=; } PROPERTIES { UseDefaultNamespace=Yes; } ELEMENTS { { [{7794C1F7-1A3E-4A1A-BEF1-E39C0BA06313}];0 ;Orders ;Element ;Text } { [{64EA5C6D-643E-4A34-856F-14DCECE286E2}];1 ;OrdersStatus ;Element ;Table ; SourceTable=Table112; Export::OnPreXMLItem=BEGIN "Sales Invoice Header".SETRANGE("Posting Date",DateFrom,31122099D); END; } { [{977C01EE-B471-4CF8-8CE9-19142510F72A}];2 ;OrderId ;Element ;Field ; DataType=Code; SourceField=Sales Invoice Header::External Document No. } } EVENTS { } REQUESTPAGE { PROPERTIES { } CONTROLS { } } CODE { VAR DateFrom@6150613 : Date; PROCEDURE SetDateFrom@6150613(DateFromFilter@6150613 : Date); BEGIN DateFrom := DateFromFilter; END; BEGIN END. } }