AI Assistant
Notifications
Clear all

Field to Finish - How to create the FLD in Carlson

2 Posts
2 Users
0 Reactions
1,983 Views
spledeus
(@spledeus)
Posts: 2757
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

It has been a few years since I created my FLD file but I learned the secret and I am sharing it here.?ÿ I saw the other thread on F2F and thought of this.

The FLD File is a CSV with | as a separator.

Create a FLD file with a few varying codes, 2d, 3d, linework, block insert, layer, etc.?ÿ Import the FLD into Excel using | as a delimiter.?ÿ Now create all your codes in a spreadsheet.?ÿ There are two options for saving.
Save as CSV and replace all , with |.
Or change the universal setting from , to | in windows and save as CSV.?ÿ Be sure to change it back.
Rename your file to FLD and run it.


 
Posted : February 11, 2021 8:45 am
ladd-nelson
(@ladd-nelson)
Posts: 738
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I've followed this approach (I tend to use Microsoft Access so I can query and update various codes as needed) but the process is generally the same.

Some "gotcha's" that Excel might throw at the unsuspecting user are the injection of "" string separators so the sage advice is not to use fancy characters in Excel (e.g. commas in descriptions and " symbols in descriptions, etc) as you might wind up making more work for yourself.

Also note that if you categorize your codes, the categories are prefixed in a certain way (I won't delve into that here) so the best advice is to do your best to keep it simple in the spreadsheet and let the Carlson interface handle the rest.


 
Posted : February 14, 2021 12:22 pm