Inventory & Equipment List / Cables

[nakedeye]

Hi everyone, I'm making some new worksheets up and running into an odd thing with the inventory and equipment list tool. If I filter out and just do a cable report I get some cables on a second (and third etc) column. The cable report shows the correct count but for some reason 2 out of the 3 10m socks are on another column.

 

Any thoughts?

 

mx

 

 

 

[nakedeye]

From what I can see I have the usedcable , 1, 1 and the second column is 2, 1 so is there a syntax to combine the two?

 

[Pat Stanford]

I haven't used it, but it looks like the 1,1 means the first part and then the first parameter of that part.

 

ObjectData(criteria, 'inventory part param', part_univ_name, part_index, param_index)
Get inventory part parameter value from inventory supported object.

 

Since you are using it in a Database, the Criteria part is automatically supplied by the database.

[nakedeye]

Thanks Pat, I'll take a look. All I actually want is a cable report that I can recalculate rather than having to run the command again which loses any formatting. I'm trying to do a multiple of 1 so 1 and 2 which should solve it.

[Scott C. Parker]

The various parts of cables are baked into each cable and pulling the info about each cable and each part is trapped within the cable. The Equipment and Inventory dialog has code that extracts the info in two ways. One, the way Pat describes and uses the 1, 2, 3 for each part to pull the info out and put into the worksheet. The second report pulls out the info in a way users need to build shop orders, aka, list form with quantities.

Unfortunatly, this makes it hard to build custom worksheets to repeat counting. 

We're open to receiving examples of formatted reports that 'might' be used as templates for the reports we make via the Equipment and Inventory dialog. I don't know if it's possible to have this happen.

Thanks, Scott

[nakedeye]

Thanks Scott, is there any way I can make a cable report such as the one generated under cable planning that gives the total amounts of cables that will allow me to recalculate it as that one won't and the cable report generated by the inventory and equipment list command breaks them down into separate columns if they are part of the same cable run?

[Scott C. Parker]

1 hour ago, nakedeye said:

cable report such as the one generated under cable planning that gives the total amounts of cables that will allow me to recalculate it

Sorry, no, not at this time. As the info is trapped inside each cable run, making actual database worksheets is not possible. Hence the two versions of plain reports supplied. We're doing some magic in the background to parse the info for plain counting. Each cable inside a cable run is a "sub part" and worksheets don't like listing the parts vertically. This is why the parts can be shown across using the .1, .2, indicators for each column.

[Stefan B.]

On 7/30/2024 at 7:59 PM, Scott C. Parker said:

some magic in the background

This magic that you speak of, care to elaborate? I would really like to fetch this data.