MBS FileMaker Plugin Example Databases

magento older

All examples are included with download of MBS FileMaker Plugin.

magento older.fmp12

Overview
Tables1
Relationships3
Layouts1
Scripts10
Value Lists0
Custom Functions0
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layout<Missing Layout>
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
CURL
24 fields defined, 1 record
CURL

Fields

Table Name: CURL - 24 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
ResultNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      TextNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          SessionIDNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              debugNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  URLNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      UserNameNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          PasswordNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              All ProductsNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  Product ID_o_SKUNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      Product InfoNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          orderListNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              NewPriceNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                  HTTP ResponseNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                      customerIDNormal, TextAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Only during data entry
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: German
                                                          Customer InfoNormal, TextAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: None
                                                          • Automatically create indexes as needed
                                                          • Index Language: German
                                                              nameNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: None
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                    NewNameNormal, TextAuto-Enter:
                                                                    • Allow editing
                                                                    Validation:
                                                                    • Only during data entry
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                        orderIncrementIdNormal, TextAuto-Enter:
                                                                        • Allow editing
                                                                        Validation:
                                                                        • Only during data entry
                                                                        Storage:
                                                                        • Repetitions: 1
                                                                        • Indexing: None
                                                                        • Automatically create indexes as needed
                                                                        • Index Language: German
                                                                            orderDetailNormal, TextAuto-Enter:
                                                                            • Allow editing
                                                                            Validation:
                                                                            • Only during data entry
                                                                            Storage:
                                                                            • Repetitions: 1
                                                                            • Indexing: None
                                                                            • Automatically create indexes as needed
                                                                            • Index Language: German
                                                                                  orderItemSkuNormal, TextAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Repetitions: 1
                                                                                  • Indexing: None
                                                                                  • Automatically create indexes as needed
                                                                                  • Index Language: German
                                                                                          orderItemNameNormal, TextAuto-Enter:
                                                                                          • Allow editing
                                                                                          Validation:
                                                                                          • Only during data entry
                                                                                          Storage:
                                                                                          • Repetitions: 1
                                                                                          • Indexing: None
                                                                                          • Automatically create indexes as needed
                                                                                          • Index Language: German
                                                                                                  orderItemPriceNormal, TextAuto-Enter:
                                                                                                  • Allow editing
                                                                                                  Validation:
                                                                                                  • Only during data entry
                                                                                                  Storage:
                                                                                                  • Repetitions: 1
                                                                                                  • Indexing: None
                                                                                                  • Automatically create indexes as needed
                                                                                                  • Index Language: German
                                                                                                          __ID_orderItemNormal, TextAuto-Enter:
                                                                                                          • Allow editing
                                                                                                          Validation:
                                                                                                          • Only during data entry
                                                                                                          Storage:
                                                                                                          • Repetitions: 1
                                                                                                          • Indexing: None
                                                                                                          • Automatically create indexes as needed
                                                                                                          • Index Language: German
                                                                                                                customerNameNormal, TextAuto-Enter:
                                                                                                                • Allow editing
                                                                                                                Validation:
                                                                                                                • Only during data entry
                                                                                                                Storage:
                                                                                                                • Repetitions: 1
                                                                                                                • Indexing: None
                                                                                                                • Automatically create indexes as needed
                                                                                                                • Index Language: German

                                                                                                                        Relationship: CURL=Curl|orderitem

                                                                                                                        Table OccurrenceCURLCurl|orderitem
                                                                                                                        Field__ID_orderItem=<Missing Field>
                                                                                                                        Source TableCURL<Missing Base Table>
                                                                                                                        Source Filemagento older.fmp12magento older.fmp12
                                                                                                                        Allow creation of records via this relationshipOffOn
                                                                                                                        Delete related records in this table when a record is deleted in the other tableOffOff
                                                                                                                        Sort records

                                                                                                                        Off

                                                                                                                        Off

                                                                                                                        Relationship: Curl|order|orderitem=CURL|order

                                                                                                                        Table OccurrenceCurl|order|orderitemCURL|order
                                                                                                                        Field<Missing Field>=<Missing Field>
                                                                                                                        Source Table<Missing Base Table><Missing Base Table>
                                                                                                                        Source Filemagento older.fmp12magento older.fmp12
                                                                                                                        Allow creation of records via this relationshipOffOff
                                                                                                                        Delete related records in this table when a record is deleted in the other tableOffOff
                                                                                                                        Sort records

                                                                                                                        Off

                                                                                                                        Off

                                                                                                                        Layouts

                                                                                                                        Layout Hierarchy

                                                                                                                        CURL


                                                                                                                        Layout NameInclude In MenuQuick Find# of ObjectsShow Records FromSave record changes automaticallyShow field frames when record is activeShow field frames only on current recordShow current record indicator in List ViewUsed in ScriptsCustom Menu SetScript TriggersTheme ID
                                                                                                                        CURLYesYes CURLOnOnOffOn[File Default]01

                                                                                                                        Layout Objects: CURL

                                                                                                                        Regular Fields

                                                                                                                        Field Name: CURL::Result
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 29 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 43 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::Text
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 71 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 283 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::SessionID
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 292 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 306 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::URL
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 11 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 25 pt
                                                                                                                        • Right: 553 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::debug
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 24 pt
                                                                                                                        • Left: 570 pt
                                                                                                                        • Bottom: 476 pt
                                                                                                                        • Right: 925 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::UserName
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 311 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 325 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::Password
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 329 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 343 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::All Products
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 347 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 361 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::Product ID_o_SKU
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 365 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 379 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::Product Info
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 383 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 397 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::orderList
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 401 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 433 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::NewPrice
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 437 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 451 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::HTTP Response
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 48 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 62 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::customerID
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 456 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 470 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::Customer Info
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 474 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 488 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::name
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 491 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 505 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Field Name: CURL::NewName
                                                                                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                        • Top: 509 pt
                                                                                                                        • Left: 138 pt
                                                                                                                        • Bottom: 523 pt
                                                                                                                        • Right: 391 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Field Format:
                                                                                                                        • Edit Box
                                                                                                                        Field Behavior:
                                                                                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                                                                                        • Touch keyboard type: System Default
                                                                                                                        • Go to next field using: Tab key
                                                                                                                        Yes

                                                                                                                        Group Buttons

                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Login
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 292 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 317 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “Login” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Trace on
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 584 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 609 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Set Variable [ $result; Value:MBS("Trace") ]

                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: List all Products
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 340 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 365 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “ProductList” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Product Info
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 370 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 395 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “Product Info” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: List all Orders
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 400 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 425 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “OrderList” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Set New Price
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 457 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 482 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “SetNewPrice” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Clear
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 548 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 573 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “Clear” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: Set New Name and price
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 486 pt
                                                                                                                        • Left: 400 pt
                                                                                                                        • Bottom: 511 pt
                                                                                                                        • Right: 537 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “SetNewNameAndPrice” ]

                                                                                                                        Scripts:


                                                                                                                        Button PropertiesCoordinatesScript/Script Step
                                                                                                                          Type:
                                                                                                                        • Text: List pending Orders
                                                                                                                          Additional Properties:
                                                                                                                        • Change to hand cursor over button
                                                                                                                        • Rectangular
                                                                                                                        • Top: 428 pt
                                                                                                                        • Left: 402 pt
                                                                                                                        • Bottom: 453 pt
                                                                                                                        • Right: 535 pt
                                                                                                                        • Anchoring: Left, Top
                                                                                                                        Perform Script [ “OrderList Filter Status” ]

                                                                                                                        Scripts:


                                                                                                                        Script Hierarchy

                                                                                                                        simple
                                                                                                                        Login
                                                                                                                        ProductList
                                                                                                                        Product Info
                                                                                                                        Customer Info
                                                                                                                        Order Info
                                                                                                                        OrderList
                                                                                                                        OrderList Filter Status
                                                                                                                        SetNewPrice
                                                                                                                        SetNewNameAndPrice
                                                                                                                        Clear

                                                                                                                        simple

                                                                                                                        Parent Folder: [simple]Next Script: [ProductList]
                                                                                                                        Script NameLogin
                                                                                                                        Run script with full access privilegesOff
                                                                                                                        Include In MenuYes
                                                                                                                        Layouts that use this script
                                                                                                                        Scripts that use this script
                                                                                                                          Script Definition
                                                                                                                          Script Steps
                                                                                                                          • #Start new session
                                                                                                                          • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                          • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\"> <soapenv:Header/> <soapenv:Body> <urn:login soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <username xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::UserName ) & "</username> <apiKey xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Password ) & "</apiKey> </urn:login> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                          • #RUN now
                                                                                                                          • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                          • #Check result
                                                                                                                          • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                          • Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                          • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                          • Set Variable [ $xml; Value:MBS( "XML.SubTree"; CURL::Text; "Body¶loginResponse¶loginReturn" ) ]
                                                                                                                          • If [ MBS("IsError") ]
                                                                                                                          • Set Field [ CURL::SessionID; "" ]
                                                                                                                          • Else
                                                                                                                          • Set Field [ CURL::SessionID; MBS( "XML.ExtractText"; $xml) ]
                                                                                                                          • End If
                                                                                                                          • #Cleanup
                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                          Fields used in this script
                                                                                                                          Scripts used in this script
                                                                                                                            Layouts used in this script
                                                                                                                              Tables used in this script
                                                                                                                              Table occurrences used by this script
                                                                                                                              Custom Functions used by this script
                                                                                                                                Custom menu set used by this script

                                                                                                                                  Previous Script: [Login]Parent Folder: [simple]Next Script: [Product Info]
                                                                                                                                  Script NameProductList
                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                  Include In MenuYes
                                                                                                                                  Layouts that use this script
                                                                                                                                  Scripts that use this script
                                                                                                                                    Script Definition
                                                                                                                                    Script Steps
                                                                                                                                    • #Start new session
                                                                                                                                    • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                    • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> </urn:catalogProductList> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                    • #RUN now
                                                                                                                                    • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                    • #Check result
                                                                                                                                    • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                    • Set Field [ CURL::All Products; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                    • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                    • #Cleanup
                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                    Fields used in this script
                                                                                                                                    Scripts used in this script
                                                                                                                                      Layouts used in this script
                                                                                                                                        Tables used in this script
                                                                                                                                        Table occurrences used by this script
                                                                                                                                        Custom Functions used by this script
                                                                                                                                          Custom menu set used by this script

                                                                                                                                            Previous Script: [ProductList]Parent Folder: [simple]Next Script: [Customer Info]
                                                                                                                                            Script NameProduct Info
                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                            Include In MenuYes
                                                                                                                                            Layouts that use this script
                                                                                                                                            Scripts that use this script
                                                                                                                                              Script Definition
                                                                                                                                              Script Steps
                                                                                                                                              • #Start new session
                                                                                                                                              • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                              • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <productId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</productId> </urn:catalogProductInfo> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                              • #RUN now
                                                                                                                                              • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                              • #Check result
                                                                                                                                              • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                              • Set Field [ CURL::Product Info; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                              • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                              • #Cleanup
                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                              Fields used in this script
                                                                                                                                              Scripts used in this script
                                                                                                                                                Layouts used in this script
                                                                                                                                                  Tables used in this script
                                                                                                                                                  Table occurrences used by this script
                                                                                                                                                  Custom Functions used by this script
                                                                                                                                                    Custom menu set used by this script

                                                                                                                                                      Previous Script: [Product Info]Parent Folder: [simple]Next Script: [Order Info]
                                                                                                                                                      Script NameCustomer Info
                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                      Include In MenuYes
                                                                                                                                                      Layouts that use this script
                                                                                                                                                        Scripts that use this script
                                                                                                                                                          Script Definition
                                                                                                                                                          Script Steps
                                                                                                                                                          • #Start new session
                                                                                                                                                          • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                          • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:customerCustomerInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <customerId xsi:type=\"xsd:int\">" & MBS( "Text.EncodeToXML"; CURL::customerID) & "</customerId> </urn:customerCustomerInfo> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                          • #RUN now
                                                                                                                                                          • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                          • #Check result
                                                                                                                                                          • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                          • Set Field [ CURL::Customer Info; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                          • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                          • #Cleanup
                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                          Fields used in this script
                                                                                                                                                          Scripts used in this script
                                                                                                                                                            Layouts used in this script
                                                                                                                                                              Tables used in this script
                                                                                                                                                              Table occurrences used by this script
                                                                                                                                                              Custom Functions used by this script
                                                                                                                                                                Custom menu set used by this script

                                                                                                                                                                  Previous Script: [Customer Info]Parent Folder: [simple]Next Script: [OrderList]
                                                                                                                                                                  Script NameOrder Info
                                                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                                                  Include In MenuYes
                                                                                                                                                                  Layouts that use this script
                                                                                                                                                                    Scripts that use this script
                                                                                                                                                                      Script Definition
                                                                                                                                                                      Script Steps
                                                                                                                                                                      • #Start new session
                                                                                                                                                                      • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                                      • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                                      • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                                      • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <orderIncrementId xsi:type=\"xsd:int\">" & MBS( "Text.EncodeToXML"; CURL::orderIncrementId) & "</orderIncrementId> </urn:salesOrderInfo> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                                      • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                                      • #RUN now
                                                                                                                                                                      • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                                      • #Check result
                                                                                                                                                                      • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                                      • Set Field [ CURL::orderDetail; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                                      • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                                      • #Cleanup
                                                                                                                                                                      • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                                      Fields used in this script
                                                                                                                                                                      Scripts used in this script
                                                                                                                                                                        Layouts used in this script
                                                                                                                                                                          Tables used in this script
                                                                                                                                                                          Table occurrences used by this script
                                                                                                                                                                          Custom Functions used by this script
                                                                                                                                                                            Custom menu set used by this script

                                                                                                                                                                              Previous Script: [Order Info]Parent Folder: [simple]Next Script: [OrderList Filter Status]
                                                                                                                                                                              Script NameOrderList
                                                                                                                                                                              Run script with full access privilegesOff
                                                                                                                                                                              Include In MenuYes
                                                                                                                                                                              Layouts that use this script
                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                Script Definition
                                                                                                                                                                                Script Steps
                                                                                                                                                                                • #Start new session
                                                                                                                                                                                • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                                                • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                                                • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                                                • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> </urn:salesOrderList> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                                                • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                                                • #RUN now
                                                                                                                                                                                • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                                                • #Check result
                                                                                                                                                                                • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                                                • Set Field [ CURL::orderList; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                                                • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                                                • #Cleanup
                                                                                                                                                                                • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                                                Fields used in this script
                                                                                                                                                                                Scripts used in this script
                                                                                                                                                                                  Layouts used in this script
                                                                                                                                                                                    Tables used in this script
                                                                                                                                                                                    Table occurrences used by this script
                                                                                                                                                                                    Custom Functions used by this script
                                                                                                                                                                                      Custom menu set used by this script

                                                                                                                                                                                        Previous Script: [OrderList]Parent Folder: [simple]Next Script: [SetNewPrice]
                                                                                                                                                                                        Script NameOrderList Filter Status
                                                                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                                                                        Include In MenuYes
                                                                                                                                                                                        Layouts that use this script
                                                                                                                                                                                        Scripts that use this script
                                                                                                                                                                                          Script Definition
                                                                                                                                                                                          Script Steps
                                                                                                                                                                                          • #Start new session
                                                                                                                                                                                          • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                                                          • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <filters> <filter> <associativeEntity> <key>status</key> <value>pending</value> </associativeEntity> </filter> </filters> </urn:salesOrderList> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                                                          • #RUN now
                                                                                                                                                                                          • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                                                          • #Check result
                                                                                                                                                                                          • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                                                          • Set Field [ CURL::orderList; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                                                          • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                                                          • #Cleanup
                                                                                                                                                                                          • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                                                          Fields used in this script
                                                                                                                                                                                          Scripts used in this script
                                                                                                                                                                                            Layouts used in this script
                                                                                                                                                                                              Tables used in this script
                                                                                                                                                                                              Table occurrences used by this script
                                                                                                                                                                                              Custom Functions used by this script
                                                                                                                                                                                                Custom menu set used by this script

                                                                                                                                                                                                  Previous Script: [OrderList Filter Status]Parent Folder: [simple]Next Script: [SetNewNameAndPrice]
                                                                                                                                                                                                  Script NameSetNewPrice
                                                                                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                                                                                  Include In MenuYes
                                                                                                                                                                                                  Layouts that use this script
                                                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                                                    Script Definition
                                                                                                                                                                                                    Script Steps
                                                                                                                                                                                                    • #Start new session
                                                                                                                                                                                                    • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                                                                    • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductUpdate soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <product xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</product> <productData xsi:type=\"urn:catalogProductCreateEntity\"> <price xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewPrice ) & "</price> </productData> </urn:catalogProductUpdate> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                                                                    • #RUN now
                                                                                                                                                                                                    • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                                                                    • #Check result
                                                                                                                                                                                                    • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                                                                    • Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                                                                    • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                                                                    • #Cleanup
                                                                                                                                                                                                    • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                                                                    Fields used in this script
                                                                                                                                                                                                    Scripts used in this script
                                                                                                                                                                                                      Layouts used in this script
                                                                                                                                                                                                        Tables used in this script
                                                                                                                                                                                                        Table occurrences used by this script
                                                                                                                                                                                                        Custom Functions used by this script
                                                                                                                                                                                                          Custom menu set used by this script

                                                                                                                                                                                                            Previous Script: [SetNewPrice]Parent Folder: [simple]Next Script: [Clear]
                                                                                                                                                                                                            Script NameSetNewNameAndPrice
                                                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                                                            Include In MenuYes
                                                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                                                            Scripts that use this script
                                                                                                                                                                                                              Script Definition
                                                                                                                                                                                                              Script Steps
                                                                                                                                                                                                              • #Start new session
                                                                                                                                                                                                              • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                                                                                                                                                              • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                                                                                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ]
                                                                                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductUpdate soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <product xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</product> <productData xsi:type=\"urn:catalogProductCreateEntity\"> <name xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewName ) & "</name> <price xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewPrice ) & "</price> </productData> </urn:catalogProductUpdate> </soapenv:Body> </soapenv:Envelope>") ]
                                                                                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ]
                                                                                                                                                                                                              • #RUN now
                                                                                                                                                                                                              • Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ]
                                                                                                                                                                                                              • #Check result
                                                                                                                                                                                                              • Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ]
                                                                                                                                                                                                              • Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ]
                                                                                                                                                                                                              • Set Field [ CURL::debug; MBS("CURL.GetDebugAsText"; $curl) ]
                                                                                                                                                                                                              • #Cleanup
                                                                                                                                                                                                              • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                                                                                                                                                                              Fields used in this script
                                                                                                                                                                                                              Scripts used in this script
                                                                                                                                                                                                                Layouts used in this script
                                                                                                                                                                                                                  Tables used in this script
                                                                                                                                                                                                                  Table occurrences used by this script
                                                                                                                                                                                                                  Custom Functions used by this script
                                                                                                                                                                                                                    Custom menu set used by this script

                                                                                                                                                                                                                      Previous Script: [SetNewNameAndPrice]Parent Folder: [simple]
                                                                                                                                                                                                                      Script NameClear
                                                                                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                                                                                      Include In MenuYes
                                                                                                                                                                                                                      Layouts that use this script
                                                                                                                                                                                                                      Scripts that use this script
                                                                                                                                                                                                                        Script Definition
                                                                                                                                                                                                                        Script Steps
                                                                                                                                                                                                                        • Set Field [ CURL::SessionID; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::All Products; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::Product Info; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::orderList; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::debug; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::Text; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::Result; "" ]
                                                                                                                                                                                                                        • Set Field [ CURL::HTTP Response; "" ]
                                                                                                                                                                                                                        Fields used in this script
                                                                                                                                                                                                                        Scripts used in this script
                                                                                                                                                                                                                          Layouts used in this script
                                                                                                                                                                                                                            Tables used in this script
                                                                                                                                                                                                                            Table occurrences used by this script
                                                                                                                                                                                                                            Custom Functions used by this script
                                                                                                                                                                                                                              Custom menu set used by this script

                                                                                                                                                                                                                                Download example: magento older

                                                                                                                                                                                                                                Used functions:




                                                                                                                                                                                                                                Links
                                                                                                                                                                                                                                MBS FileMaker tutorial videos