topic Help on File (SQLite DWG) based Industry Models : Copy the FID Field ? in AutoCAD Map 3D Forum

Help on File (SQLite DWG) based Industry Models : Copy the FID Field ?

braudpat — Thu, 14 Nov 2024 17:39:49 GMT

Hello

Please help me ...

I would like to copy the famous Integer Field FID which is created / generated on all SQLite Tables by the Industry Models

So I need an Utility (DLL, ARX, Script, etc) which run on File (SQLite DWG) based Industry Models

It will create a NEW Integer Field named FID_COPY and copy the original FID into it ...

It must run on ALL SQLite Tables of the Project (which are inside the DWG) ...

Thanks in advance, Bye, Pat (The Old French EE Froggy)

Re: Help on File (SQLite DWG) based Industry Models : Copy the FID Field ?

O_Eckmann — Fri, 15 Nov 2024 14:06:33 GMT

Hi @braudpat ,

With IM Editor, you can open your DWG, add a field to your base, edit form to add this new field, and then Export Excel Direct, update new column by copy/paste into excel, and then Import Excel direct.

The workflow should work, even if it doesn't on my Map 2024 😓

Re: Help on File (SQLite DWG) based Industry Models : Copy the FID Field ?

braudpat — Sat, 16 Nov 2024 07:35:10 GMT

Hello @O_Eckmann

YES but I have many tables (20-60) per SQLite DWG and many DWGs ...

So a Tool would be Nice to run inside a SQLite DWG

Bye, Pat