Lightroom :: Creating Tables (or Other Persistent Data Structures)
Aug 19, 2013
I have a complex data structure I want to be able to add to a Lightroom plugin. I know Lightroom uses a SQLite database. Can I add tables to that database from either inside a Lightroom plugin or externally? I see no documentation of any API capabilities granting direct queries of the SQLite database and as of now it's looking like the only technique I have at my disposal is to create my own homebrewed database system using the file system. I would like that not to be the case.
View 1 Replies
ADVERTISEMENT
Sep 18, 2013
Here at the office we use a template I created using Data Extraction. After creating the table and inserting it, it works just fine. Then, if you make changes to the door or window you can click the "Download Changes From Source File" and it will update the table ... However, after saving it and trying to work on it the next day, it somehow unlinks the table I have in my drawing and I cannot "Download Changes From Source File" to update the table ... I checked under XREF and it shows it is loaded and I have it reading from the same path I saved it. I would like to know if there is a way to re-link the table to the .dxe file or how to prevent from it un-linking new tables?
View 0 Replies
View Related
Aug 13, 2013
I have Acad 2011 and Excel 2010 on my computer. What I would like to do is to create a list of materials in my autocad that will update from an excel table. The only problem is my Acad Table needs only some materials from that large spread sheet. For example when I write in my Acad table a piece number(col A) I would like to have a description coming automatic from excel (in col.b).
There will be hundreds of drawings with tables taking data from the same excel table.
View 8 Replies
View Related
Jul 31, 2012
is there a quick way to create & export points from a pipe network? i've probably got 100 or so structures that need points with the correct structure name in the point description.
Dell Studio XPS 9100
Intel Core i7 CPU 930 @ 2.8GHz
12GB Ram
64 bit
C3D 2012 SP3.0
View 2 Replies
View Related
Jun 12, 2013
A large combined file in our GIS format corrupted. I dug out all the old files that were originally used to create it but they are too old and will not combine in the GIS.
I exported each one to SHP, and then imported all of them into civil 3d as shp files, creating object data. This meant that I could correct the corrupted sections, which I have done, but now I need to get it back into the GIS program with the object data intact.
The problem is that the object data, coming from several combined files, is in several tables. Each table contains the same identical fields. (eg every table has a field called drawing)
I need to combine those tables so that I can re-export the shape files. I need one table with all of the object data in it.
View 9 Replies
View Related
Oct 17, 2011
I have an Excel spreadsheet I am testing to see how to edit table data in Map 3D and see the changes back in Excel. I have created the .udl file from my Excel file, which AutoCAD stores way down in the Data Links folder. I attach the .udl file as a Data Source. It shows the named range and I can view the table but it is always Read Only. I checked the Access permissions under Properties and none of the boxes were checked. So I checked ReadWrite but I still can't edit the table.
Then I tried just attaching it as an FDO provider. It links and displays the table just fine, but when I perform an edit (which it allows), the whole program crashes out without a single warning. Like I never had Map open.
This may be a Windows 7 permissions thing but since Map won't let me change the folder location where I save the .udl file, I can't test this out by putting it in a folder I know I have full access to.
View 3 Replies
View Related
Jun 10, 2011
I have created a data extraction table based on attributes placed on blocks. The data table is in my layout and it includes part number, dimensions, and cost. What I need to do is total the cost of all the items at the bottom of my table. I added in a row for the total cost which is not linked to the table but when I try to add a field in that cell to sum the cells above it (the costs), I get ###. I already tried unlocking the cells, but that didn't do anything.
How can I add a field summing these costs?
View 1 Replies
View Related
Sep 25, 2012
I have set up some autocad tables that are linked to excel data( using relative path) in an Autocad Architecture project template. In the xref dialog box, the data links are show as relative path e.g. ..Standards excel file
After creating a new project from this template and right-clicking in one of the cells which have linked data and selecting "data links" and "open data links file" it opens the template excel file, not the excel file within the project folder.
If I use the xref command, select and right click one of the excel data links and select "open" it does open the correct excel file located in the current project folder.
The xref dialog box does show all the data links as relative path e.g. ..Standardsexcel file.
View 1 Replies
View Related
Apr 19, 2012
I have a new issue that I am unsure what to do about.
This has never occurred with previous version of ACAD and this is the first time I created data links with Autocad 2012, and I am using the same procedure that I have successfully used in the past.
I have data tables linked to excel spreadsheets. I used the "TABLE" button on the ANNOTATE ribbon to place the table, and the layout of the cells assumes the layout of the excel spreadsheet, which is what I want.
As long as I don't Scale the table, I can Update the data table links just fine.
However when I scale the table and then update table links, the table layout changes drastically, and is undesirable.
I have tried locking the cells' but that will not fix the problem.
I want to keep the layout of the table that is assumed when I place the table originally. Is there any way to lock it as such?
View 0 Replies
View Related
May 17, 2011
Table styles / Data linked tables. In particular when re-syncing the table from excel, cells that should be merged become unmerged.
i have unchecked excel formatting, as i am using table styles used in autocad, i did try getting it to work starting with excel formatting, but couldn't get styles consistent, and text was much fainter.
As it is now the tables are working well except for the merged cells!
View 1 Replies
View Related
Jul 21, 2013
Not sure if it's a setting I'm missing, a workflow gaffe, or a feature that is simply absent. I would like new/multiple versions of a file to be persistent across multiple collections. It is not inconceivable to have an image in more than one collection; something could be in a Landscape collection, Portfolio collection, Blog Postings, and so forth. Unfortunately, it seems that if I export a file to edit in Photoshop (or any external application) it will only stack with the image in the collection from which it was sent. It will not show in any other collections so they would not include the current version of a file unless manually added.
View 4 Replies
View Related
Mar 19, 2013
I want to export data from AC3D to Excel; I've tried to do it with copying directly the tables I made, but it isn't text or number format.For example, I want to get the data from this table:
I know that with previous versions of autocad it could be done.In addition, I also want to get value table of the calculated cant of the "Cant Tabular Editor":How can I get a table of this data? I need it because I have a lot of curves and I want to do some verifications of the standars of my country.
View 4 Replies
View Related
May 23, 2013
Would you have a solution to accessing ODTables for a dwg object only loaded into memory? I have 1000+ dwgs that I want to return a string with the names of the various ODTable names for auding purposes that I would prefer to just side load rather than full load for performance reasons.
I'm attempting to use something like this (which works fine on an open drawing):
Public Function ReturnOBJData(acObjIDIn As ObjectId, intOffset As Integer) As String
'Don't forget that table is 0 based offset so....plan accordingly Dim strRet As String = ""
Dim acDoc As Document = Application.DocumentManager.MdiActiveDocument
Dim acDb As Database = acDoc.Database Dim acEd As Editor = acDoc.Editor
[Code] .......
In a fashion along the lines of
Public Function GetTables(strFileIn As String) As List(Of String)
Dim lstReturn As New List(Of String)
Dim acMapApp As MapApplication = HostMapApplicationServices.Application
Dim acActiveProject As Project.ProjectModel = acMapApp.ActiveProject
Dim acTableList As Tables = acActiveProject.ODTables Dim acTable As ObjectData.Table
[Code] ....
The problem is that I can't seem to link the ODTables object off of the memory database object. In this sample, the msgbox always returns a count of 0 where I would expect it to be in the range of 1-4.
View 6 Replies
View Related
Jul 19, 2013
I am trying to delete a few rows in both my pipe table and my structure table but the 'remove items' button doesn't work.
View 2 Replies
View Related
Oct 2, 2012
I wonder if you can make a table of families picking "elements of details." Why? I mean, when I do a detail included screws, foams, sealants, etc ... all these elements I have done as families of "elements of detail."Now I want to collect these items on tables and include calculated values to determine the amounts thereof.
View 2 Replies
View Related
Feb 6, 2009
Whenever I open a drawing in a certain project this error message always pops up.Some of the message details are:
-Parameter ERRCODE; Value 786433
-Error 786433 - Conflict between data tables in open drawings (57 consecutive occurrences)
-Parameter: APPLNAME Value: ad
-Parameter: CLASSNAME Value: airfield
this message box stops popping up when I open the drawings?
View 4 Replies
View Related
Mar 7, 2014
I've been using v3.6 with Win Vista for a long time and also use Geosetter to Geotag my RAW images with location data. Geosetter creates an XMP file which includes the location data. I then update the metadata of the image in LR. In the process LR has always created keywords using the location fields e.g Country, State/Province etc.
I've now moved over to Win 8.1 and re-installed LR 3.6 but still use the same catalog. Now when I go throught the same process as above the keywords are not created. Geosetter is the same version although the Exiftool version has been updated.
View 2 Replies
View Related
Dec 12, 2012
I am using x6 to create datasheets & need to insert tables to hold the data.Most of the time when doing anything to a table ...combining cells, splitting cells or almost anything, nothing actually works & x6 ends up crashing.
When starting a table, i click on the table icon, go up to the columns & rows box & type the numbers that i want ...but whatever i type, a 3 x 3 table appears.
View 4 Replies
View Related
Apr 27, 2012
I decided to use Data Link Tables for my Excel sheet instead of OLELinks. The appearance is far sharper, and I am also pleased there is no background color transfered. What IS the problem is when I update the table, its goes from 12" Wide by 12" Tall table @ 7/16" Text W/O borders back to 3" Wide by 10" Tall with varying text size to fit and gains back all borders except diagonals (of which none are present on the Excel file).
So, any way to default the format when I refresh so that it holds each cell at the 6"X1" dimensions with no border.
With that, If there is a way to have a stencil for making the range links with Excel, that would be useful. I use the exact same 4 or 6 ranges (2 formats) in every dwg.
View 7 Replies
View Related
Jan 6, 2014
When I try to create a table from a view, I get the following error. I have never had this error before?
View 1 Replies
View Related
Mar 5, 2013
I am producing a drawing which contains a sample hydraulic layout which depicts all of the various hydraulic components we use.
I would like to add a table next to each part that lists the size variation agains our Part no's.
View 2 Replies
View Related
Jul 9, 2012
I've previously used Autocad 2008 Electrical. I've just started a new job and I have been asked to update some electrical drawings from a recent project. My current employer use Autocad 2010 as opposed to Autocad Electrical which I have previously used.
The problem I have is that I have a drawing with a table linked to an Excel spreadsheet that displays an I/O table.
Since the drawings have changed the amount I/O has increased.
I have a new excel sheet with the new I/O list which is larger than the old I/O list.
When I "point" the Table to look at the new spreadsheet in the "Modify Excel Link" Dialogue and alter the "Link to Range" Tab to my new desired excel sheet and apply the changes the table. The new excel sheet populates the table correctly until the end of the old table used to stop then the format goes all to hell and the new part of the table is way out of scale and at 90 degrees out to the original table.
I think I am possibly missing a step somehwere when updating the Data Table Links!?!?....Do I need to alter the table properties somewhere too?.
View 2 Replies
View Related
Dec 20, 2013
My old folder structure built up over years before I started using Lightroom has hundreds of subfolders and is entirely logical. I can import all the photos into lightroom, but not the folder structure.
View 3 Replies
View Related
Aug 4, 2009
I recently purchased a new tower and happily installed my CS3 upon it. Thus far I have been delighted with the smooth experience of the program. I was previously running it upon a laptop and it was always a bit slow to keep up. Unfortunately I have discovered that no matter what file I am in or what type of light I use, my lighting effects filter contains an artifact. I have thus far tried what fixes I could find listed here on the site/in the forums but nothing has worked.Upon the third re-instal attempt I now have two line artifacts appearing in my Filter>Render>Lighting Effects...
I can note that this problem did NOT occur previously on the lap top which was running the same operating system. here is my technical breakdown; Photoshop Version 10 (CS3)Windows Vista Home Premium (64 Bit Operating System) Service Pack 2AMD processor 2.80 GHzRAM 4.0 GB437 GB free disk spaceVideo Card : RADEON HD 4870 X2 If this was a filter that I didn't use very often I probably wouldn't care but Lighting Effects is a staple of mine and I miss it terribly!
View 10 Replies
View Related
Nov 29, 2013
I have an application that saves the handle of some geometry on a DB.
The geometry is limked with database information, and each time the drawing is open the data is loaded to application via a Handle.
I used the Handle, because the is persistent, but one time when I open the drawing, the applications says the data doesn't match the drawing, I check it and it was the same drawing, when defining again the geometry I realize the handle had change.
I don't know why this happens, I only save and close the drawing. Is there some point the handles need to be recycled on the application?
Or what could happen that changed the handlers of the drawing.
It only happen one time, in one drawing, but I don't know if it can happen again.
View 9 Replies
View Related
Dec 3, 2012
I am on Win 7, 64-bit, 20 gb RAM. Using CS 6 (Cloud).
I have this strange shadow that looks like a pop-out menu once occupied that space, on my interface background.
It will not go away permanently. Everyday when I first start Illustrator, I have to go to Preferences==>User Interface and change the background color.
That makes it go away temporarily. But when I restart, it comes right back.
View 3 Replies
View Related
Nov 18, 2012
The gps data from my D-SLR camera does not appear in Lightroom 4 after importing the pictures
View 1 Replies
View Related
Feb 14, 2012
Bog-standard install of CS 5.5 Design Standard suite on a Mac, OS 10.7.3, everything is up to date.
No networking, all apps insatlled locally, Swatches reside in /Applications/Adobe Illustrator CS5.1/Presets/en_US/Swatches/Color Books.
I'm logged in to an admin account.
I've tried saving workspaces with the Pantone Solid Coated swatch open and marked "persistent" and nothing seems to work.
View 6 Replies
View Related
Feb 3, 2014
Today I am working on a book that has been laidout in InDesign. I am trying to convert it to a digital publication format, and as such, I am trying to strip running heads since they insert willy-nilly in text because the digital text doesn't follow the same page flows as the print version.
In this case, I have a master page A that is a left and right page, both of which have a running header, the left with the book name and the right with the chapter title. When I go to the master page and delete the header text boxes for BOTH pages, this removes the LEFT page's running heads throughout the whole book. However, for some reason the RIGHT page's running head stays where it is. This is a book that is about 600 pages in length. I really don't want to scroll through 300 pages to manually delete these headers. Oh, I should note that the pages in question do say "A", so the A master page would appear to be applying to them. That goes for both the left and right pages, but only the left ones are responding to an edit of the master page.
Here is a picture of the before and after situation. In "before", I'm showing you the file as it came to me. The verso and recto A masters both have text boxes with running head info, and the body of the text is in accordance. However, when I edit the A-Master pages to remove these text boxes, only the verso page responds in the body. I note that the text content of the recto boxes is different (each chapter has its own chapter title). However, the format follows the A page as you can note from the Pages panel on the right of each screenshot. So why is it that the recto is hanging around? I've had this problem in a couple of shorter texts where it was quicker just to manually nuke the boxes, but I feel carpal tunnel setting in just thinking about doing this for multi-volume sets and the like.
View 2 Replies
View Related
Apr 29, 2013
I'm trying to create a topographic map using 200+ (x,y,z) data points that I already loaded into an excel file, but I can't figure out how to apply them to my AutoCAD.
I've already looked around at a few lisp programs, and I've downloaded them, loaded them, but when I try to activate them in the command box I type them in and nothing happens.
I'm running on 2013 AutoCAD Mac edition.
View 3 Replies
View Related
Mar 11, 2013
Can't seem to be able to Export to ACAD 2007 without the following appearing
Recover has found no errors, all XREFS have been bound and I've even exploded AEC objects
IDSP Premium 2014 (mainly Civil 3D 2014 UKIE SP1 & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 256Gb SSD, 300Gb 15,000 rpm HDD
16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
View 9 Replies
View Related
