I've hacked a simple macro together.
Have a look if that does what you need. Works with CSV, JOB, JXL and so on as well.
As always, unzip into a subfolder in "C:\ProgramData\Trimble\MacroCommands" and restart TBC.
If you want the layer name to follow a different scheme (include a hyphen or the like) you need to edit line 247.
Original Message:
Sent: 03-14-2023 01:43
From: Matthew Pitt
Subject: Select Feature
My workflow for this would be:
Open Project Explorer
Expand Imported Files tab
Right Click on your Work Order Import YYMMDD and Click Select Members
Go to the Home Tab and Open Advanced Select
Click Current Selection and Multiple Data Types (Or if it's just one data type you're after select that)
Go to the drop down menu below and select your prefered attribute select equal to/contains and add your search criteria.
I use this to isolate superceded drainage data from residential housing projects when I get a newer CAD layout, but it should also function for your purposes.
Matt
------------------------------
Matthew Pitt
Original Message:
Sent: 02-16-2023 20:41
From: Julius Newman
Subject: Select Feature
When we have multiple work orders coming into a project. Is there an easy way to select all attributes with say code "XXX" within YYMMDD work order file - for the purpose of putting into a new layer?
i.e. the surveyors are constantly survey the topsoil strip level "TSS" and we import numerous work orders (containing multiple codes) into the one project. We prefix our work orders with a date (So I don't think process feature codes is the solution here) - although I haven't used it in sometime due to issues with our workflow and that function.
This comes back to an old post requesting prefix feature code options.
i.e. import a work order / prefix with a reference code e.g. SURV 230209 * and the mapping file / feature code library then outputs to the various layers. i.e.
Example
Import file SU 230209.spj
Layer outputs
SU 230209 TSS
SU 230209 CL
SU 230209 EOK
SU 230209 FEL
SU 230209 FSL,
etc,
Import file SU 230212.spj
Layer outputs
SU 230212 TSS
SU 230212 CL
SU 230212 EOK
SU 230212 FEL
SU 230212 FSL,
etc,
Regards,
Julius
------------------------------
Julius Newman
------------------------------