LDT xls not reloaded

LDT xls not reloaded

Hector_Rocha
Participant Participant
1,798 Views
10 Replies
Message 1 of 11

LDT xls not reloaded

Hector_Rocha
Participant
Participant

I had placed all attributes from the excel file for first time, and runs OK, but when I make a change on the excel file, same file is not loading, I tried making a copy of the file with a "rev" mark and load it again, but doesn't work.

AutoCAD is reading the file because the worksheet name is recognized, but not the rows and columns. 

Do anyone had same problem? How should I solve it?

Hector_Rocha_0-1683737465350.png

 

0 Likes
Accepted solutions (1)
1,799 Views
10 Replies
Replies (10)
Message 2 of 11

Michiel.Valcke
Advisor
Advisor

Is the excel file saved in the project folder or is it somewhere else? Do you still have the problem if you load the excel from a non- OneDrive location?

0 Likes
Message 3 of 11

Hector_Rocha
Participant
Participant

Hi. Mike. Yes, the file is in the project folder, but AutoCAD can't read it, I try with other excel files and works perfect but not with the project one. I save the file in our network drive, but same results.

I have created a copy of the "Final_ANSI-B" just to prevent to damage on configuration if I made some changes, works ok, till I tried to insert LDT attributes.

Hector_Rocha_0-1684152394828.png

 

0 Likes
Message 4 of 11

Michiel_Valcke_GeoIT
Contributor
Contributor

Can you test it when you put the LDT file in the Isometric directory or the related files directory and not in the style directory? Does the error persist when you do?

0 Likes
Message 5 of 11

Michiel.Valcke
Advisor
Advisor
Accepted solution

@Michiel_Valcke_GeoIT wrote:

Can you test it when you put the LDT file in the Isometric directory or the related files directory and not in the style directory? Does the error persist when you do?


oops, different account 😛 but what I said above.

0 Likes
Message 6 of 11

jw7018
Collaborator
Collaborator

try setting  your "look up" in the header row and column per your mapped attributes.

 

 

jw7018_0-1684365041799.png

jw7018_1-1684365059764.png

 

 

jw7018_2-1684365123436.png

 

 

0 Likes
Message 7 of 11

falk_holland
Contributor
Contributor

One tip regarding the excel file - please make sure the file extensions stays the same. It can happen, that modifying for example the LDT.xls file in excel that it gets saved as LDT.xlsx (especially when working on different workstations).

Message 8 of 11

falk_holland
Contributor
Contributor

Try using ATTSYNC on your title block.

That command helped me to discover missing and misplaced attributes.

Message 9 of 11

yogesh_sankpal_pune
Advocate
Advocate

@Michiel.Valcke 

i have same issue with using LDT file 

we are using p3d version 2022 & 23 

my Project is on sql server 

multiple users working in LDT at same time so we are used option For that LDT file share workbook (legacy) 

(if any better option for use of LDT multiple users please suggest)  

excel 

yogesh_sankpal_pune_4-1737711010198.png

 

my LDT file location on below path  

yogesh_sankpal_pune_2-1737710298870.png

when i added ldt in project it will works fine after sometime having issue like missing attributes don't know reason?? 

so i will use command ATTSYNC >name >title block> then get message on command bar attsync complete. but not resolved.

Request you! if anything wrongly done please check & confirm.    

 

 

 

 

 

0 Likes
Message 10 of 11

Michiel.Valcke
Advisor
Advisor

First move the LDT to the Isometric folder, secondly make sure that none of the users renamed the columns/sheets/...

Message 11 of 11

Tomislav.Golubovic
Advisor
Advisor

Also I've found if you have the file open, the LDT doesn't populate. You have to edit it, then close the file then it should run. Try that.

0 Likes