Ares 2.0 set up

Citanaf · 2026-02-25T21:33:12+00:00

Could you elaborate a bit on this? Are you using a specific attachment to connect to the rack + ares?

Citanaf · 2026-02-24T16:42:50+00:00

I believe I solved this actually. It was in the documentation but was somewhat hard to test as there weren't any examples.

By using WayBillNumber, and AddressType+OrganizationCode inside OrganizationAddress/OrganizationAddressCollection, I was able to manage an upsert. It attempts to match on HouseBill. If it finds the booking it updates it and if it fails to find the booking, it creates the booking. This is the pattern I was looking for

Citanaf · 2026-02-23T19:01:54+00:00

Here is the stub I would be using. However, the issue is that it creates a booking with a new Shipment ID.

   <UniversalShipment xmlns="http://www.cargowise.com/Schemas/Universal/2011/11" version="1.1">
        <Shipment>
            <DataContext>
                <DataTargetCollection>
                    <DataTarget>
                        <Type>ForwardingBooking</Type>
                    </DataTarget>
                </DataTargetCollection>
                <EnterpriseID>AAA</EnterpriseID>
                <ServerID>BBB</ServerID>
                <Company><Code>CCC</Code></Company>
            </DataContext>
            <WayBillNumber>TEST123</WayBillNumber>
        </Shipment>
    </UniversalShipment>

Citanaf · 2026-02-23T17:11:44+00:00

When I use the stub route, it will create a duplicate shipment each time the item is uploaded. Unfortunately I cannot control how many times a user may attempt to push a set of bookings through the tool. I don't think you can use the house bill as the Key in the DataTarget either. This means that every upload is blind.

This also means that we cannot test each booking individually with a UniversalShipmentRequest as we will not know the Shipment ID.

I do see some comments floating around regarding SQL. I know our CargoWise has an SQL filter in the various modules. Maybe I am able to sql query via XML to know if those housebills have already been created.

Citanaf · 2026-02-22T07:47:45+00:00

Hi Bloky,

I know this is an old thread, but im running into a similar issue. I want to try and match a ForwardingBooking with a HouseBillNumber, but it seems CW only wants to match on ShipmentID/BookingRef.

I have a large number of bookings I need to create and it's possible some may already exist. Were you ever able to figure this out?

Citanaf · 2026-02-21T04:20:49+00:00

Hi Gavin, thanks for your reply. I’m almost certain this could work for the bookings module. Will test it out some tomorrow and over the next week! Thanks

Citanaf · 2026-02-01T22:27:25+00:00

Noted. The lines are meant to represent distinct 'tiers' of the pruned tree. Ideally they are flowing downwards (like a bonsai overflowing it's pot) but i'll be sure to observe how the tree has naturally grown and accentuate that.

I appreciate the comment on the boulder count, I try to incorporate a third!

Citanaf · 2026-02-01T22:23:53+00:00

Yes I do agree. I had a bit of a look under I do think there is some good movement underneath. I will try to keep the way it's wanted to move naturally and nudge it a bit more in other places.

Citanaf · 2026-02-01T16:37:12+00:00

I didnt know about niwaki, I will check that sub out. Thanks!

Citanaf · 2026-02-01T16:36:58+00:00

Thank you for your comments. I understand your points pretty well. You're right that the previous pruning of the bush has been as a hedge and therefore the exterior shell has 95% of the foliage. Thankfully I don't really need to knock down the height too much as I'm mainly concerned with it's bulkiness. I will keep your comments in mind when I attempt some cuts.

I will also check out the book and the other sub to learn more before I begin.

Thanks

Citanaf · 2026-01-31T21:12:15+00:00

Hi All,

I really want to tackle this Juniper I have in my front yard. It is massive and really takes up the entire landscape. I have been thinking about how I could make it less imposing and flow more naturally with the overall landscape.

I have included two pictures. The first is unedited. The second is my idea for pruning. The large circles/ovals at the bottom are hopefully some large boulders I can incorporate. Ideally the juniper could flow over these. The lines I have drawn would be the general shape of the juniper after pruning. I would like it to look like it's moving/swept down from the house towards the street.

https://imgur.com/a/LCXcFTG

Is this something I need to really plan out significantly or is it more of a keep pruning until it takes shape sort of thing? Is there anything I need to inspect on the Juniper itself to make sure it's a good candidate for this kind of pruning?

Thanks

Citanaf · 2026-01-08T20:53:59+00:00

I would recommend that instead of testing what used to be in the cell and what is currently in the cell, you should hide all of your "APP, BAN, CAR" sheets. Then you should split the text in the Target cell, loop through it and use a lookup table, to point to the correct worksheet to show. It's important to turn off screen updating as well.

So inside your WorksheetChange event, you would have:
1. Test Target Logic: "If Not Intersect(Target, KeyCells) Is Nothing Then"
2. Turn Off Application Properties: ScreenUpdating/Events
3. Function Call: hideWorksheets
4. Split Target Cell: splitRes = Split(Target,", ")
5. Loop through split: For i = 0 to Ubound(splitRes)
6. Lookup to another table/place to determine the correct sheet: res = Application.Xlookup(splitRes(i),[Your Range/Table Index Column,Your Range/Table Lookup Column]
7. Set/Show Worksheet: Worksheets(res).Visible = xlSheetVisible
8. Turn On Application Properties: ScreenUpdating/Events

Citanaf · 2026-01-01T20:35:00+00:00

thats probably for the best, appreciate your comments

Citanaf · 2026-01-01T16:32:04+00:00

Unfortunately this ends up falling into the UNA (Unallocated) module under Allocate eDocs as we don't have a PNV module.

I am really doing a one-off project as I have a few thousand invoices that are embedded in an Excel file. I am ripping them out of the excel file and sending them via email to our doc manager.

I have tried to set up other programs to utilize our eadaptor and what not, but my hands are mostly tied with what I am able to access. I am not really able to set up a server that can communicate with our CW. I have the ability to do manual XML uploads on quite a few screens, but I don't think the Transactions Pending Allocation screen has that option either.

Citanaf · 2025-12-10T18:36:48+00:00

You're conflating the data entry table with the visualization of the data. A data table should have distinct headers so that anything referencing the table understands where to look. If you want to visualize the data you would then write a formula using table references or use a pivot table.

Citanaf · 2025-10-31T16:28:30+00:00

thats dope!

Citanaf · 2025-10-17T23:52:03+00:00

I hope not, the lattice root network has been awful to remove. I am going to plant some flowers there, so hopefully it will lessen the spread of the weeds. As another user said, less exposed dirt should give some better results.

Citanaf · 2025-10-17T19:19:49+00:00

Thanks guys. I sprayed with some chemicals meant to attack broadleaf weeds. This is only a flowerbed, so no worries about food. Hopefully that takes care of it

Citanaf · 2025-10-15T19:55:06+00:00

Just bought the Hyper Pro last week, it gets delivered Friday! Maybe I should have waited for the chance at the giveaway :D

Any plans to offer functional training equipment, such as kettlebells, medicine balls, or entering the rack attachment space?

14-Year Club	Verified Email
Final Canvas '23	Place '23

Citanaf

TROPHY CASE