Untitled Document
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26

Thread: Setting up SQL ODBC connection string

  1. #11
    Should they just show up under the shipments all or does it need to be scanned in with the handheld somewhere?

  2. #12

    Join Date
    Apr 2004
    Posts
    17,033
    SYSOPS is offline
    You will now see a new entry on the left hand side, for your SQL Webstore. Click on that and using either a barcode scanner or the search window upper left, search for the order # you're looking to ship

    HTH,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  3. #13
    Showing no orders. So something is not working. Devs say the select statements work on this side with the mappings correct. Do I need to enter mappings in the site?
    Could not insert pic
    https://www.dropbox.com/s/tab2ukcjit...51645.png?dl=0
    Attached Images  

  4. #14

    Join Date
    Apr 2004
    Posts
    17,033
    SYSOPS is offline
    You need to use the search box at the top or have a barcode scanner configured. We will not import orders en masse from a SQL connection. It's based on a search for order function.

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  5. #15
    I am having Dev's recheck the sql select query but wanted to check with you as well on this error.
    https://www.dropbox.com/s/69wr4kjciw...44526.png?dl=0
    Attached Images  

  6. #16

    Join Date
    Apr 2004
    Posts
    17,033
    SYSOPS is offline
    You get this when you search? Don't know if it's related to all the phone field filters you have setup in the query. That's the only place I see 10 being called out. I cannot tell what the invalid syntax is, based on the query.

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  7. #17
    It seems that some parts of the select query are being changed once I hit save
    Works fine in our SQL server
    Copy and paste is correct
    Hit save and things are changed

  8. #18
    It is removing
    < or > from our queries.
    Working on other ways

  9. #19

    Join Date
    Apr 2004
    Posts
    17,033
    SYSOPS is offline
    Please send an email to info at shiprush dot com with your query before, and the resulting change to the query after you hit save (screenshots will work). I will need to ask development why the query is being stripped of certain data.

    Thank you,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  10. #20
    Sent

    Devs found work arounds to remove them for now. Waiting to test on shipping PC

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •