InDesign :: How To Import Data From Excel File
Feb 6, 2014
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?
View 2 Replies
ADVERTISEMENT
Mar 12, 2014
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.
View 3 Replies
View Related
Apr 7, 2014
I'm trying to import a table from Excel into Indesign but can't manage it. The internet is full of the tip to use File-->Place and then choose import options, sheet, cell range, formatted table. This does work, sort of, except the Excel table has no numbers and is formatted all whacky and doesn't have the right color.
View 11 Replies
View Related
Mar 1, 2014
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 Replies
View Related
May 29, 2007
I have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).
I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.
View 9 Replies
View Related
Sep 14, 2012
How to import data from excel (from particular cell) to AutoCAD Drawing. I have already Created a template for both Excel and AutoCAD. I want to do Whenever i am changing the datas in excel sheet corresponding changes to be done in AutoCAd drawing.
I am using AutoCAD 2010 and Microsoft excel 2007.
View 7 Replies
View Related
May 20, 2013
How can I import excel data for a hydrograph into SSA for a sub basin? I have 10 subbasins each with their own hydrograph.
View 1 Replies
View Related
Nov 19, 2013
I am creating a template for my company with associated description keysets. The codes and attributes have already been created in an excel spreadsheet. Currently I am typing these all individually by hand but would like to import the excel data if possible.
View 2 Replies
View Related
Apr 26, 2011
we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies
View Related
May 18, 2013
this dwg file data reading with c#?
View 9 Replies
View Related
Oct 13, 2011
Can I export the text from autocad 2012 LT to excel file.
View 1 Replies
View Related
Jul 5, 2013
example
[CommandMethod("Test")]public static void TestMethod(){ Document doc = Application.DocumentManager.MdiActiveDocument; Editor ed = doc.Editor; Database db = doc.Database; using (Transaction Tx = db.TransactionManager.StartTransaction()) {
[Code]...
1-autocad program will be closed
2-be selected within the file path c sharp example: csharp.jpg
3-I want to read data from a DWG excel file using C#. examples: dwgfile.jpg and drawing1.dwg
4-I want to list here DataGridView data
5-c sharp winform .net 4.0
View 1 Replies
View Related
Apr 26, 2013
I would like an VB application that from within autocad can open an excel file,from there select 2 columns containing x,y co-ordinates. Which when selected will draw a polyline in the acad drawing.
I usually do this the long way, but it seems I'm doing it more and more so would like to have it fairly automated.New to VBA and stuck at even opening the excel file....nevermind the actual selecting columns and drawing of the polyline!!!
View 4 Replies
View Related
Aug 29, 2011
I have an autocad drawing with so many light fixtures with all different names.Now we have to change all those names, i already have an excel sheet containing two columns with first one containing "name in drawing" and second one containing respective "new name".
Is there any way to replace the names in cad file using that excel sheet.i just dont want to do all those thousand rename manually ...
View 6 Replies
View Related
Oct 12, 2012
I'm currently working on building up a library of 3D models of crane rigging for a new job. Specifically, I'm creating wire rope slings (like this 3/8" wire rope sling) but with less of an emphasis on visual detail and more on precise measurements.
In order to simplify the process a bit, I created an excel file to enter the basic four measurements of a sling (length, rope thickness, eye width, and eye length) which then calculates and displays for me the coordinates and measurements of all the objects needed to make the sling (arcs, lines, circles to sweep along those lines, etc.)
I realize now that I'm really just creating a task of endless copy/paste, and I'm looking for a better way to get through the process. How to make this work as efficiently as possible.
Is there some way that I could point AutoCAD to the Excel file and have it read all the coordinates and measurements to draw everything automatically? I also considered creating a line in Excel that would give output that I could copy and paste into a .scr, but I have never used any scripting in CAD before, so it would be new territory for me.
View 5 Replies
View Related
Jun 12, 2013
We have a custom LISP program (Written, upadated in 2003) that takes a keyed in item number, opens and searches a .txt file with four coulmns, for the keyed in item number (column 1) and returns a part number (column 2), description (column 3) and any information in column 4.
Here is the Part of the cod in question:
(setq recx (open "H:/ACAD2012/alcocustm/LISP/hardware.txt" "r"))
(setq d "?")
(setq rec (read-line recx))
[Code]....
A quetsion was asked if the data in the .txt file could be put in an Excel file. I tried looking at other post, but I can't seem to find a clear cut way to open and extract the data. Or this old dog overlooked a boand. Is there a easy way to do this, similar to the above?
View 8 Replies
View Related
Apr 4, 2014
I am having troubles finding an actual answer for this online
I understand that the import file is a CSV versus XML, but since both can come out of Excel why would you choose one over the other.
View 1 Replies
View Related
Oct 7, 2011
I would like to be able to retreive data from a sepcified cell, in a specified worksheet, from an excel file.
I don't have any clue how to connect to an excel file and read the data. Most seems to think you already had an understanding but I'm starting from the beginning.
View 5 Replies
View Related
Jan 15, 2013
Is there a possibility to furnish a hyperlink linking on a defined Excel-data sheet within an Excel file? Are there other possibilities to tie together to a drawing object external additional information, e.g., a product name, product data or product pictures?
View 1 Replies
View Related
Jun 9, 2010
I am using Civil3D 2010. I am trying to export the offset/elevation data from my cross sections to a text file or excel file so i can paste the info into another program. so far i've been labeling the offset/elevation info on the section and typing it into excel by hand.
View 9 Replies
View Related
Dec 22, 2011
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies
View Related
Feb 9, 2012
I am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies
View Related
Nov 10, 2012
I have a batch of 5000 pictures (jpg). I need to add the information that I have in an .xls file (Excel), from a column with the description of each picture. Each description is different from the others, so I would have to assign the code number of the file jpg (first colum of the excel) to the correspondance info that exists in the column of the description/caption into the IPTC field.
I have tried several ways, applications that I have found through Google, but I have no way to do it. It seems that the origin of the problem is the xls file or the txt file that I have had to created to try to do the importation. In any case messages of errors like "the file does not exists", etc etc. I don`t know what to do it. It's very important and urgent for my job.
* I work with MAC OX S 10.7.5, Adobe Photoshop CS5.1
* I have tried applications like: DIY Metadata, VRA Export-Import Metadata and another ones... which names I don't remember now.
View 7 Replies
View Related
Feb 8, 2013
I know that if I use IMPORTOBJ I can import an excel file....but the file is multiple pages (within the same workbook page). Is there a way to bring that in withought breaking up the Excel file into mulitple files?
View 1 Replies
View Related
Dec 14, 2011
i have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
View 7 Replies
View Related
Feb 1, 2013
I'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".
View 9 Replies
View Related
Feb 9, 2014
The PS file InDesign CS6 generated to use to import into Acrobat for printer spreads has pixelated halftones. Is this a problem with InDesign CS6? Does it contain a post script driver?
View 1 Replies
View Related
Jul 5, 2010
I have collected point data for the positions of trees using PocketGIS software. The software produces a csv. file with the Northings and eastings of each point surveyed to which are attached a number of other attributes (e.g. tree tag number, height, species etc.).
Is it possible to import and plot these points directly into AutoCAD?
Can some or all of the attributes be included (i.e. it would be very useful if the positions could be plotted together with the tag number)?
View 9 Replies
View Related
Nov 24, 2012
I'm using Map 3D 2012 with Oracle 11g. I created an enterprise project with an industry model with water and wastewater modules. After this i created my feature classes and defined the utility model linking the geometry feature class to the attribute ones (ex: WA_POINT to WA_ARMATURE, WA_VALVE, WA_HYDRANT etc.).
At this moment i have to import a large amount of data from *.shp or *.sdf files, but theese files contain geometric and attribute data together.
How can i import the geometry from the shp or sdf file to the geometry feature class (ex: WA_POINT) and the attributes to the attribute feature class (ex: WA_VALVE), while creating the reference between the geometry and attribute feature classes?
I tried bulk-copying the geometry, but it doesn't create the coresponding attribute feature.
View 2 Replies
View Related
Aug 20, 2012
I am importing survey data using a .txt file. In that file there are a few lines that I don't want C3D to read. Is there some character I can put at the beginning of the line so that it won't read or give me an error? In some other programs I have seen # or : used to do this.
C3D 2012 sp1
W7Pro 64bit
HP Z400 Workstation
16 GB RAM
Intel Xeon CPU W3565@3.20GHz
NVIDIA Quadro 4000
View 4 Replies
View Related
Jul 3, 2012
I have centerline data from SHP file that I can either import or attach to. Has a few lines of object data with it including a centerline of road name. Each one unique. When I attach to the data, I can then "join" with it additional data from a database. When I select a line and look at the properties, it contains both the original object data AND the additional data from the database. SO far So good.
When I edit the style and try to add feature labels only part of the labels come in. I end up with a lot of them with only the letters "text" or just not there. If I right-click on the line and select "Show Data Table" I can confirm that there is data for that label. I find nothing in common with the map features that have labels, or don't have labels. Kind of random.
Question: If I import the SHP file and create object data I need to know if there is a way to "ADD" the rest of my data that is in the database to this object data. If so then I think I could define a Template and label each piece with the block with attributes. Is this possible? OR
Is it possible for me to export to a new SHP file after I have connected to the data (both shp file and database).
View 2 Replies
View Related
