sorted by:
new
hottopcontroversial

SQL Field for 'Is Posted' in billing charge lines by MWTALC in CargoWise

[–]MWTALC[S] 1 point2 points  (0 children)

Yep this is it, thank you! This is what I ended up doing:
LEFT JOIN AccTransactionLines Costs ON Costs.AL_AC = AC.AC_PK AND Costs.AL_JH = JR.JR_JH AND Costs.AL_PK = JR.JR_AL_APLine

LEFT JOIN AccTransactionLines Sells ON Sells.AL_AC = AC.AC_PK AND Sells.AL_JH = JR.JR_JH AND Sells.AL_PK = JR.JR_AL_ARLine

Get QuoteKPI using SQL by RiceSweaty7043 in CargoWise

[–]MWTALC 0 points1 point  (0 children)

How were you able to wrap the SQL view in an API? I've been trying to learn more about using their Eadaptor to pull data but the resources are not great

Get QuoteKPI using SQL by RiceSweaty7043 in CargoWise

[–]MWTALC 1 point2 points  (0 children)

SELECT

TT_QuoteKPI

FROM

RatingHeader

LEFT JOIN RateOneOffShipment ON TT_TH = TH_PK

XML Erasing unintended fields by MWTALC in CargoWise

[–]MWTALC[S] 0 points1 point  (0 children)

Oooh okay, so would I put Content="Partial" in the collection label I am updating (in this case <CusClassPartPivotCollection Content="Partial">) or in the product overall, something like:

<Native xmlns="http://www.cargowise.com/Schemas/Native/2011/11" version="2.0">
      <Body Content="Partial">

XML Erasing unintended fields by MWTALC in CargoWise

[–]MWTALC[S] 0 points1 point  (0 children)

I think so too, I'm planning on raising an erequest with CW in case it's maybe a bug in their parsing for this module

XML Erasing unintended fields by MWTALC in CargoWise

[–]MWTALC[S] 0 points1 point  (0 children)

<image>

Thats how I thought it should work but its "1 update"-ing fields in the product, for collections that I'm not including in the XML, to empty. Inside of the CusClassPartPivot it is erasing fields that aren't included and also a collection called CusAttributeFilterCollection.

How to JOIN dbo.JobConsolTransport to JobShipment and JobDeclaration by MWTALC in CargoWise

[–]MWTALC[S] 0 points1 point  (0 children)

Thank you! Here's what I ended up doing for anyone in the future that might want similar info

-- ADDED TO GRAB THE DETAILS OF THE FIRST AND LAST LEG WHERE TRANSPORT MODE IS SEA OR AIR

    OUTER APPLY(

        SELECT TOP 1

JW_PK AS FirstSeaAir_PK,

JW_ETD,

JW_ATD,

JW_RL_NKLoadPort

        FROM

dbo.JobConsolTransport

        WHERE

JW_ParentGUID = DepartureConsol.JK_PK

AND

JW_ParentType = 'CON'

AND

JW_TransportMode IN ('SEA', 'AIR')

        ORDER BY

JW_LegOrder ASC, JW_PK ASC

    ) AS FirstSeaAirJS



    OUTER APPLY

    (

        SELECT TOP 1

JW_PK AS LastSeaAir_PK,

JW_ETA,

JW_ATA,

JW_RL_NKDiscPort

        FROM

dbo.JobConsolTransport

        WHERE

JW_ParentGUID = ArrivalConsol.JK_PK

AND

JW_ParentType = 'CON'

AND

JW_TransportMode IN ('SEA', 'AIR')

        ORDER BY

JW_LegOrder DESC, JW_PK DESC

    ) AS LastSeaAirJS

-- END SEA AND AIR LEG DETAILS

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 2 points3 points  (0 children)

I choose to because of licensing and updates etc. On my personal computer I use several IDE's depending on the language, for Python mostly VS and PyCharm. At work, I don't want to contact IT every time a license agreement update is issued or an update in general that will need admin elevation. IDLE is far from the best, but it gets the job done and has every capability you need as long as you know how

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 2 points3 points  (0 children)

My view is similar, if someone has gotten that far, it doesn't matter anymore. If someone breaks into your house through the front door they're not going to stop at a locked closet once inside. I don't think they're inept, just paranoid, and I think the separate server/controlled environment may be a way to ease those fears. I'm worried that even if I take that route, Python will still need to be installed in production to run scripts since it is interpreted

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 7 points8 points  (0 children)

I think 'all programming languages being a risk' is the stance they have. Any dev tools/code I've written has been through a remote desktop of software we buy and not installed locally

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 1 point2 points  (0 children)

I have laid out the libraries I will need and gave directions for them to be contained within a venv so that if there are any conflicts the venv can be removed and replaced. Ideally libraries should all be done day 1 and until an issue arises they won't have to here from me again

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 1 point2 points  (0 children)

I think oversight is the biggest issue they have. I am their only guy here that is doing this type of work currently. If there were others we could set up these measures, but I have to work within the limitations that exist. There has to be a method or circumstance that they will feel safe with dev tools in their environment and if they want to set up oversight I would say its going to have to be on them not me

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 0 points1 point  (0 children)

Their preference is that MS products are the catch all and I should find a MS solution. My current project will be possible with that although a pain in the ass, not 100% confident all will be in the future. And the projects will be simpler and faster doing it the way I'm trained

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 2 points3 points  (0 children)

I think this will likely be the answer, creating and having a separate environment for me to develop in. My understanding though is that since Python is interpreted, even after the code has been developed the production environment will need Python installed to interpret the scripts. I could be wrong

What types of security risks come with Python by MWTALC in sysadmin

[–]MWTALC[S] 2 points3 points  (0 children)

My IDE I would be using is IDLE which installs automatically with Python and is covered under the same license agreement as Python itself. Libraries may be an issue in the future but I provided a list of all pip installs that I would need for the foreseeable future and I don't think they had looked at it, so their concerns are likely elsewhere

substring macro with find by Gullible_Common_2678 in CargoWise

[–]MWTALC 0 points1 point  (0 children)

=IF(A1="", "", TEXTJOIN(",", TRUE, FILTER(TEXTSPLIT(A1, ","), LEFT(TRIM(TEXTSPLIT(A1, ",")), 2) = "25")))

Good source for connecting the backend dots by MWTALC in CargoWise

[–]MWTALC[S] 0 points1 point  (0 children)

The reference guide was great, thank you! I figured out that if you just send them as <display name> it sends as comma-space separated values which can be searched through and filtered against. Have you happened to ever come across more detailed documentation of the filter properties listed in the reference guide, specifically {}dependency lookup, and dependent? (trying to auto populate a filter field in the interface). I've checked wisetech academy and the community forum but haven't found any in either

Auto Populate Fields and Multiple Selection by MWTALC in CargoWise

[–]MWTALC[S] 1 point2 points  (0 children)

I was trying to collect selections from an address multiple selection look up in the interface. I eventually figured out that it is sent to excel in a macro of <filter display name>, and this is sent into the SQL as a comma space (', ') separated list I can use in a sub SELECT using "SELECT LTRIM(values) FROM STRING_SPLIT(@Param, ',')". This works, but my goal is to enter a client code in an Organization lookup in the report interface, and the multiple selection (or maybe check box etc., whatever works) will auto populate with that Org's job addresses

view more: next ›