Can someone that is more versed in *.lst file editing (it can be either V8i or Connect edition at this point whatever works) take a look and maybe give some resolution to this ? Some stuff like in what paper number is located the part/group/asembly etc.. probably isn't possible i dont know please help.
Explanation of variables:
these are definition for drawing names
Explanation are in the picture above
The first 9 symbols are specified by XXXX firm and are the same for the entire project. (red and blue frame)
The next 3 digits are also specified by XXXX firm. However, these digits differ depending on the construction part.
For example, in the case of the example project, there is a number for the filter support, a number for the platform on the device, a number for the roof railing and another number for the pipe support.
The letter after the digits describes the type of part.
With this number, their ERP system can distinguish between the different types of parts and process them correctly.
A= assembly parts with profiles and/or plates
R= assembly parts for railings
G= gratings
E= profile single parts (cuttings) for assembly parts with „A“
F= plate single parts (cuttings) for assembly parts with „A“
M= profile single parts (cuttings) for assembly parts with „R“
N= plate single parts (cuttings) for assembly parts with „R“
J= purchased parts with blanks, like insulation plates
X= drawings without parts, like assembly drawings, multidrawings for gratings, sketches and so on.
The last 4 digits can be chosen by the program itself. These are a sequential number to distinguish the different parts. (i've found that i've only managed to do this with this variable while printing to *.PDF file System.Path.GetFileNameWithoutExtension (PrintDefinition.SourceFile) & System.String.Format ("{0:D3}", PrintDefinition.Sequence) )
Now the problematic part :
For them
There are 2 ways to send the parts list:
As an .xsr file or the "XXXfirm-Interface-Sample.xltm" file must already be filled in correctly. // file is uploaded at the end of the post
The ".xsr" example file can also be opened with the Windows Notepad.
The “.xsr” file can also be sent as .csv or .txt. =>> THESE I CAN EXPORT //file example is uploaded at the end of the post
These are data records of the respective parts which are differentiated with a ";" as a separator. => THIS ONE I KNOW HOW TO DEFINE
Each component is one line. The separators must be strictly adhered to.
example:
explanation of the terms
snapshot od CSV file snapshot
Example of CSV - export file
SC-229137_400_Stückliste_Vault_export.csv
file into which this needs to be imported (had to zip it since *.xltm arent allowed here)
Scheuch-Schnittstelle-Muster.7z
Can Prosteel do something like this, I am already contemplating that i'll need to physically input most of these . Am not a begineer user so i have some expirience (5yrs) but once in a while something comes along that challenges your knowledge.
Kind regards
This should be doable. You need the field width for each variable/column needed, set up an *.lst file with the correct sequence of columns and use the LL CSV export.
But please
Bentley Structural YouTube Channel
Bentley Technical Support
Johannes Michalowsky
User Success Support - Bentley Systems
ServiceRequest Manager