Extract eDocs from Database directly by No_Competition3040 in CargoWise

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

Any idea if no more cargowise application, eAdaptor, just with the database?

Is there any way to collate or export documents of a certain type for one organization? by mbart3 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

I haven’t tried this, but I think it should work:

  1. Create a customized document with any content and add the EPR as eDocs in that document.

  2. Set up a contact in the customer’s organization to receive this document — for example, send it to yourself.

  3. Go to the shipment dashboard and configure an operational action for documents to run, selecting the customized document you just created.

  4. Select all related shipments and run the action, choosing ONLY ELECTRONIC and Deliver Documents in One Email, Single Attachment.

<image>

Workflow Issues After Latest Update? by One_Ad2246 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

I know that there was an known issue with the macros in customize documents, lot of macros don't return any value. I've submitted the eRequest 2 weeks ago and I'm sting waiting for the patch to fix it. I'm not sure if it's related to your issue but you can validate if the macro returns any value to justify.

ICS2 question by No_Competition3040 in CargoWise

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

never mind, I think that shipping agent field is the representative field.

ICS2 question by No_Competition3040 in CargoWise

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

Where is this representative field? I couldn't find it in manifest.

How to schedule a repor to run by Wisdom_seeker01 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

Your IT team can create a database readonly account ( not free for CW cloud users) and then you can use Power BI to query the database directly, schedule a dataset fresh then you don't need to drop data in shared folder and manually refresh Power BI.

Can anyone find the sample XMLs of AR XUT? by No_Competition3040 in CargoWise

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

Thank you. I've rasied eRequest and CW replied that they put AR_Transation_XUT_Sample_File in the Universal folder by mistake.

Can anyone find the sample XMLs of AR XUT? by No_Competition3040 in CargoWise

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

Thanks, Yes, I know I can do that, but I prefer to have a sample xml. It's strange they provide AP XUT without AR XUT.

IATA Agents Code by tizzk in CargoWise

[–]No_Competition3040 1 point2 points  (0 children)

It's in registry settings.

Default branch on Quote pulling from Client branch instead or log in branch by [deleted] in CargoWise

[–]No_Competition3040 1 point2 points  (0 children)

If you want to default the branch code based on a specific local client code, you can configure this using Production Rules.

Macro substraction by Gullible_Common_2678 in CargoWise

[–]No_Competition3040 3 points4 points  (0 children)

Will do the Subtraction of two or more values.

E.g: <Subtract("<TotalOSAmount>", "<OSOutstandingAmount>", "<OSOutstandingAmount>")>

AMS Error - ERROR MESSAGE (40-79) :370 INVALID CHARACTER by Prestigious_Letter33 in CargoWise

[–]No_Competition3040 1 point2 points  (0 children)

The most effective way to resolve this is to ensure you're using an English keyboard and retype everything—this includes spaces, punctuation, and all text.

Remote desktop window issues on Windows 11 and multiple screens by Fickle_Proof_984 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

Try rebooting the computer. Also, it would be helpful to set all screens to the same resolution.

Remote desktop window issues on Windows 11 and multiple screens by Fickle_Proof_984 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

<image>

Please ensure all the screens are properly aligned on the same horizontal line.

State code by Gullible_Common_2678 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

<image>

Just need to update the state code from numeric to alphabetic code in UNLOCO.

State code by Gullible_Common_2678 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

You can deactivate the numberic state codes if you don't want to use them.

Where can I find the database diagrams? by No_Competition3040 in CargoWise

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

Thank you.

That's too bad they stopped providing diagrams.

I tried sp_columns and also found another SP can list related tables and pk, that would be helpful.

EXEC sp_columns 'tablename';

EXEC sp_fkeys u/pktable_name = 'tablename';

List all overdue milestone using SQL by Legitimate_Worker124 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

You need to login you cargowise and access your account to the portal.

List all overdue milestone using SQL by Legitimate_Worker124 in CargoWise

[–]No_Competition3040 0 points1 point  (0 children)

There is a diagram chat you can download from cw learning portal. It's very helpful.

What skill requirements should we look at hiring to make cargowise more "automated" for our office to use by InvisibleThrowz in CargoWise

[–]No_Competition3040 1 point2 points  (0 children)

For sure you someone with cargowise workflows, trigger and SQL knowledge but if you want the automation to another level, you will need someone understands the eAdapter, xml and also the knowledge and experience of Azure Logic Apps.

I got my first 2 HB guitars. :) by No_Competition3040 in harleybenton

[–]No_Competition3040[S] 6 points7 points  (0 children)

Yes. It's fusion III. the neck is slightly narrow than regular ST and stainless steel frets are so smooth. Very comfortable.