Without using scripts, is there any way to have rectangles or textboxes act on values coming from a data file? For examplle if the value in a textbox was greater than 10 coming from a data record, could the textbox change color, or any other attribute to make it change from record to recortd as it is being viewed or printed?
View 9 RepliesI'm creating a catalog, using data merge in InDesign CS5.5 for the first time. I'm using dummy data to start, naming the products with a naming convention Product 1, Product 2, etc.
Everything seemed to be working, but then I noticed that the merge is all jumbled, such as:
Page 1 has Product 15 repeated, with the product description, price and other information from product 6. This repeats five times down the first page.Page 2 starts with Product name, price and number for Product 7, but the description for product 6. Continuing on page 2, everything seems one off. Product names mixed with data from the next product. Page 3-15 are the same as page 1, all Product 15 with the description for Product 6.
In short, this is very weird. I am saving the data in a CSV comma deliminated (also tried text with tab delineations.) I don't think there are any text breaks in the data, nor blanks. The odd thing is also that the preview looks perfect before I merge the document.
Here's Page 1:
Here's page 2:
By the way, all numbers (except pupil price) relay the product number. For example, Product 1 has a price of $1.00, an item number of H1, and the description "This is product 1".
I have an addin with a palette that include some datagridviews.
I show in these datagrid, properties and information about all alignments in drawing.
With event commandEndend I can update all information if I use "grip-strectch" for some PI alignment.
However, we can modify alignment data from Panorama palette (geometry editor) and I would like to know if there are any event to catch it after modify data.
I have the same trouble that this post:
[URL]
Autocad Civil 3D 2014 +SP1
Quad Core Intel i7 3770-cpu 3.40Ghz.
ssd samsung 840 pro 512gb+ssd samsung 840 pro 256 gb+1tb hdd
32gb RAM 1600 Mhz.
nVidia Quadro 2000.
Win 7 Pro 64bit
I have a very large excel file with a list of companies in this format:
company_category company_name company_description telephone email
In InDesign I have paragraph style for each one but I need a solution to import all this data and apply the styles automatically.
Few things:
- I don't want to import all these into a table. I want all the info in a 3 text columns format that will run accros 150 pages (more or less)
- I'm using InDesign CS6
Is there any way to automate this?
First i got a big Adobe InDesign File where I already have designed a catalog. It's made through tables.
It looks like this:
So here's my problem. The article numbers are already filled in. And I have a .csv file with 3 different colums. Art.Number, StandardPrice, DaliPrice It looks like this:
So now i want to import only the prices from this file, because the article numbers are already filled in. If i try to import the .csv file through data merge --> create merged document i am not able to choose this field which i marked blue (dataset). I don't know why... maybe i have to format my csv file different?
And also if i try to show the preview it only takes the data from the first line in my csv file. So somehow i have to merge the fields from the csv file with the article number which is already in my indesign file.
All those fields who look like this------>
are from an plugin which is calls easy catalog... but i think i won't need this plugin... i am sure it's also possible with data merge.
how you put the rule in but is there a way to remove the rule. I put one in and I don't like how its acting and would like to remove the rule from the list but I see no way do do so...
View 6 Replies View RelatedI have a master shape file that contains parcel ID, owner, tax info., etc. I have another file ( access 2003 -open to better file format suggestions-) which contains parcel ID and a "yes" or " no" entry for whether or not the parcel needs a new water meter. All I want to do is add the water meter information into the other shape file. This would create one shape file with one table with all the information that I need.
Ultimately I will use the information to do a map query and find out spatially where i need new water meters.
Right now i have the master shape file connected though the “Connect to Data” feature. I also have the new data added to the drawing though the Data sources------>attach under the “Map Explorer” Task pane. I attached access file (ver. 2003 .mdb) which has two columns “Parcel ID” and “Meter”.
I right click on the shape file under the display manager and select”Create a Join;” however my water meter table is not listed as an option. Will this not work?
Plan B - I tried to Create and connect to the access file as an ODBC connection. Followed this guy’s directions to a T [URL]. But when i populate my table under the fdo connection the column headings exist ( “parcel ID” and “Meter”) but the actual data is missing. Am I missing something important?
Note: I am running c3d 2012 on a Win 7 64 Bit machine. I also removed office 32 bit apps and installed 64 bit apps to see if that would solve the problem. No go.
I am using AutoCAD Map 3D 2009. I am not getting the object data values seen in the properties window in one of my machine. The other machine I am able to get the object data in the properties window.
I have attached screen shot of the machine where the object data can be seen in the properties window.
I have some soil boring data captured, in the field, to an Excel spreadsheet; basically, a bore site ID and coordinates.
I'd like to be able to have the coordinate attributes of blocks inserted into my bore site plans populate automatically, perhaps based off of the value of a bore site ID attribute which is manually entered for each bore site.
Alternatively, if there were a way to insert the bore site blocks based off the actual Excel records, populating all attributes and locating the block by the actual X,Y,Z coordinate, that might be even better.
InDesign and a multiple language data source.
I am not sure if this is possible with CSV, XML, MySQL, or if there is a third-party plugin available for this...but here it goes:
I have some data:
SOURCEDE_LABELES_LABELNL_LABELAppleApfelManzanaAppelBananaBananePlátanoBanaanCherryKirscheCerezaKersPearBirnePeraPeerGrapeTraubeUvaDruif
What I need to be able to do is insert the SOURCE fieldnames/placeholders throughout a document and then depending on what language I select (either through a text variable, or manual selection), the translated terms are automatically inserted in place.
I would like to know if it is somehow possible to search for empty entries after Data Merge is completed?
The 'Entries' are shown with Hidden Characters visible as you can see in attached screenshot:
I can copy those and insert into the Find/Change window but nothing can be found. I think these are not real hidden characters.
remove blank lines for empty fields before data merging
I am placing addresses on a mailer. I need to remove lines where there is a blank field (ex. apartment numbers are on some but not others). I have checked the remove blank lines option in the data merge drop down menu but it doesn't seem to work. I also did the find/change option once the file was created and it also didn't work. I am not sure what possibly could be going on. I am using INdesign CS6 on a mac. Here is a screen shot of the file before the merge, the setting menu, the file after merge and the csv file.
View 7 Replies View RelatedI am using Data Merge in InDesign CS6 (Middle Eastern version) with Arabic language content. The resulting text is all gibberish (mostly rectangles).
View 3 Replies View RelatedCan you extract the data from tracking/story editor outside of InDesign? I do a large catalogue and want a way to identify which product sets had changes made to them or not, but not just within story editor, but download the data to say a txt file or excel, etc.
View 4 Replies View RelatedI want to make a price list, using attributes in block and then extracting them to cell matching some cells with excel
While in data extr wizard for some reason I cant get the size column to set in ascending order.. Why does size 10 brake the logic?
Can I edit the extracted data without launching data extr wizard?
Data extr wizard brings a data in one table what if I want the table to display other types of attribute ( example see pic for instance instead of EL i have SS no problem until now, but my matched data link in excel is for EL and not for SS)
Its hard to explain Basicly i selected the column in excel for one type of attribute "EL" and I want fo a different name of same attribute different cell matching.
See pic: text.data.dwgsQ1.jpg
I've got a block with multiple attributes. This is not a problem to redefine the blocks attributes.
Some of the attributes contains dynamic fields (blockplace holder x y z parameters) When i insert a block with such atributes that includes the blockplaceholder dynamic fields i get
X: InsertionPoint => It is recognized as an Dynamic field but displays InsertionPoint. and does not update the value.
How can i update the fielddata from vb.net?
Part of the code I use (where i think the problem is)
For Each attid As ObjectId In refbtr attent = tr.GetObject(attid, OpenMode.ForRead) If TypeOf attent Is AttributeDefinition Then Dim attdef As AttributeDefinition = attent Dim attref As New AttributeReference() attref.SetAttributeFromBlock(attdef, myBlockRef.BlockTransform) Dim attrefid As ObjectId = myBlockRef.AttributeCollection.AppendAttribute(attref) tr.AddNewlyCreatedDBObject(attref, True) End IfNext
When I do a data merge and select multi records it shift them way off the page. The only time it does the multi page correctly is when I use the default page size (8.5x11). This happens whether I preview it or export it with out the preview. Is there a patch coming out for this or asome setting I am missing? My CS5 did not have this issue.
View 1 Replies View RelatedI have a drawing template (block) where the drawing number is displayed in two locations (attributes). The same value has to be entered in both attributes.
Is there any way of "echoing" the data from one attribute to other attributes (or text objects)?
I have two questions about data merging....
1) I am going to consistently need to merge into a document that I will also set up with mulitple records with the same margins, spacing, etc. Is there a way to 'save' templates so I don't have to start over each time I create a multiple record layout??
2) If I want to merge in a single document, but have the same column 'name' laid out various time, do I keep inserting 'name' from the data source? How will it know to proceed to the next one on the list and not repeat the same one over and over?
Running a Query that inserts a block with attributes filled with text derived from a file that has a large set of polylines with object data (text)? Is it easier just to insert this object data as text with a query. Or can I place this object data (text) into a block that inserts?
Example:
- You have land locations defined within the object data assigned to a set of closed polylines. (Large subdivision)
- Field name for object data on each closed polyline is "LAND_LOC"
- Now, I'd like to label these locations with a block that inserts to a central point within the closed polyline.
- Block Attributes with "get" the information from the polyline / object data and place this value in the block attribute.
- I have 1 drawing file that has closed polylines with object data assigned to them.
- What is the best method for this? I'd like a block with attributes to insert and pull the object data / field and place it into the block with a defined attribute, that is central to each of the closed polylines. (LAND_LOC)
I am working on parsing the psd file and saving the data as per doc of photoshop 6. I need to make an image from the layer data alone with different combinations of layers selected, visible etc... and not using the merged data section in the file.
View 1 Replies View Relatedsay you make some parcels in your project with custom data fields like: id_no, permit_no, acres_served etc. you attach an agency provided shape file via an fdo connection that has many fields of information like above.
when you right click on your parcel and do parcel properties you get a tab that lets you input the custom parcel data.
lets say you print an fdo map label showing, say, the id_no, provided in the shape file. Then in your custom parcel properties for id_no you type that in.
is there a way to make an expression to put in the other custom parcel properties that will read, say, the permit_no(id_no) from the fdo like and put that information in the custom parcel property field?
I'm having problems getting super elevation data to transfer to different drawings by means of an alignment data shortcut. I know alignments hold the super elevation data so I've gone into my alignments data shortcut, input my super elevation data, saved and closed. Now when I open my finished grade drawing, reference in my alignment and profiles, then create a corridor from that information, my super elevation didn't transfer with the reference.
I pulled cross sections and it appears is has no clue there is any super elevation data. Also, I tried bringing it directly into the drawing I'm doing my corridors in and it erred saying I must be in the parent alignment drawing. Data shortcuts are pretty much useless to me if super elevation data doesn't transfer.
64 bit Windows 7
Intel Xeon (R) @2.8GHz
6.00GB Ram
Civil 3D 2012
Civil 3D 2012
Intel(R) Xeon W3530 @ 2.80GHz
6.00GB Ram
Windows 7 Professional
I am trying to link my extracted data from blocks with attributes to an extenal source so that the table I create and place into the drawing already has the formulas I need to due the required calculations. But every time I create and place the table the formulas are not in the table. I include the columes that contain the data but it doesn't seem to be working.
View 2 Replies View Relatedi have created a data band in profile view that should show a created profiles elevation, but some of the the data fields are missing irregulary. Also in the data band that shoud show the diferenece betven the tow profiles - EG and the new profile the data is missing. The EG profiles data and the surface are ok all is shown.
View 4 Replies View RelatedI've just installed Civil3D, 64-bit on windows 7(running on bootcamp) and am trying to insert a georeferenced raster image but have encountered some issues.
1. "Home tab>>Data panel>>>insert An Image" - The data panel is missing and it's also not found in "customize palettes"
2. Trying the data connect route does not work either: Display manager>>>Data>>>Connect To Data - There is no 'Data' option and I cannot connect to Data.
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
I know that the xmls are very important in the design data folder and we shouldn't mess with them.What about the rest of the folders. I have around 11 folders. GOST, AEC Exchange, AIT, Cable & Harness, Bend Tables, DWG-DXF etc...
I need to know if any of these folders can be deleted? We don't use AEC Exchange, Cable Harness, BIm Exchange, Design Accelerator, Tube & Pipe.
What about the Optimisation, DXF-DWG. I am not sure if I am using them unknowingly.Does this could be deleted? Is there a procedure to get rid of them.
I have a long document with text variable running headers along page edges. Behind each running header on the Master Pages, there is a black band. I want the color black to change to several different fill colors, when the running header changes, to define different "sections."
It's one document, no separate chapters or sections, at this point. See attached image.
Is there a way to tie the fill color of these colored bands to the running header so that it changes when the running header does? I think what I'm looking for is a way to make a variable object style (fill) to be triggered by the running header change. I have no experience writing scripts, but am willing to try. Plan B will be to unlink the master items and manually recolor on each page.
how to import point data that has Map Object Data also attached to it? "import it by attaching to a data source".
Example: I have a bunch of manholes. Each MH has X,Y,Z, but also Type, Invert Elevs., Pipe Sizes, Pipe Materials, Pipe Directions, Structure Type/Material, etc. etc. etc. I may have point data representing MH's, airport runway ends, trees, anything you can imagine, with all kinds of data imaginable.
I want to import this data directly into Autocad/Civil 3D as either Autocad points, lines, or closed polylines (I also have utility lines, parking lots, etc.- all with data associated with it), all with the data attached as object data. I know that anything more complex than points might be hard to explain here, so I am hoping at least for a solution on how to import points - I have 99,999 MH's and obviously I don't want to have to type all that data in one by one.
I basically suck at using sql server. I can get around using the Map workspace and the different tabs. I have never used FDO, and I am not even sure what it is.
I fooled it today by creating 99,999 Autocad points at the correct XYZ, attaching the correct object data to them, then exporting as a shp file. I went into the shp_name.dbf file and edited it to add the data I wanted by cutting & pasting from Excel. then I re-imported the shp file. but, this is a workaround at best.
Surely Map can import objects and their associated data fields, all populated with valid data! all I need is to know how to do it. I mean, if this is not something I can do directly using Map commands should I take the money I earned by surveying 99,999 MH's with my GIS data collector that allows me to assign 101data fields to each object I survey, and buy something better?
C3D 2012 on 64bit Win 7 all up to date
Dell Precision 7core 8GB RAM
NVIDIA Quadro FX 1800M
LDT/C3D user since release 12
Is it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
View 2 Replies View Related