sallen@redwoodlogistics.com |
Newbie |
|
Chicago, IL |
|
|
None Specified |
|
Friday, December 1, 2017 |
Wednesday, February 21, 2024 3:21:09 PM |
4 [0.02% of all post / 0.00 posts per day] |
|
OH MY G*D!!!!!! Thank you for spotting that!!!!!!
|
I have two simple Excel Spreadsheets, which I will attach as v1.xlsx and v2.xlsx
I can NOT get Mapforce to consistently read the rows/dates/times in both of them, even though they look identical to me.
Changing all the column formats to "string" and using the xlsx-to-date and/or time works fine with v1.xlsx but v2.xlsx creates no output.
I've monkeyed with this for an hour and have no idea why only one or the other file will work.
|
We have a schema which has a great deal of annotation. While this is really helpful when one needs details, it really clutters up the view of the elements and associated variables in the component display in a map.
When choosing a root item, there is a toggle to hide annotation.
It would be great to have the ability to toggle annotation viewing on/off for the overall component too (i.e., have a toggle on the Component Settings or even selectively on elements within a component).
|
I am trying to build a relatively simple database select statement with 3 parms as follows:
SELECT o.vendor_order_id FROM Vendor_API_Log_QA.API_Order o JOIN Vendor_API_Log_QA.Redwood_Source s ON o.redwood_source_id = s.redwood_source_id WHERE s.redwood_source=:my_source and o.owner_vendor_id=:my_vendor and o.redwood_order_id = :my_order
MapForce populates the parms the way I want them, but then when I try to add the statement it says "Detected 3 parameter(s) instead of expected 0!"
What do I need to do differently here? The query works fine as-is in mySQL.
|
|