InDesign :: Data Merge / Import Through CSV File
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
ADVERTISEMENT
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
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
Mar 25, 2014
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
View 8 Replies
View Related
Mar 7, 2014
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 Related
Mar 4, 2014
I 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 Related
Feb 25, 2014
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 Related
Feb 7, 2014
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?
View 16 Replies
View Related
Feb 26, 2013
Why cant I save a cdr job with all the merge fields setup so that next time I open the file I can go straight to 'merge to new document'.
So Ive set up a 10 to view raffle tickets job. Inserted 20 numerical merge fields, positioned, resized, applied font size color alignment etc etc etc.. Takes ages..... So then merge to a new document, works nice and I can save it fine.
There are a hundred reasons why i may have to close the 'master' merge file before the job has been successfully printed. It may be a repeat print job.
Any which way I really dont get why the live merge data fields are lost on closing the file.
View 3 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
Feb 18, 2014
Is it possible to do a multiple-records data merge that doesn't generate multiple text boxes? And if so, how?
For publications such as a directory with contact information, it would be easier to manage the layout by merging multiple records into one text box. However, it seems like the only option in InDesign is to merge the records into each of their own text boxes.
View 3 Replies
View Related
Sep 7, 2012
I am attempting to create a tag system that will have a 5 digit number but must be printed as shown below
1
2
3
4
5
We have to create a file to be engraved that has 2000 consecutive numbers and we cannot figure out how to make them appear stacked using the merge feature.
View 4 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
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
Apr 5, 2012
Can you export data merge files to a PDF from Photoshop? If so, how? All I can find is information on InDesign.
View 2 Replies
View Related
Jan 20, 2011
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
View 9 Replies
View Related
Feb 20, 2014
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.
View 4 Replies
View Related
Mar 3, 2013
when I import PNEZD format .csv using import wizard the coordinates get transformed. all points are shifted about 20' in northing and 5 feet in easting. I have to use the import wizard w/ survey database in order to process linework codes.
View 5 Replies
View Related
Aug 2, 2011
When I create my merge document, regardless of how many pages, I will need to make edits to some of the text. Corel will randomly crash when I try to edit the text. Every time. I have lots of work to do and have not the time to deal with this.
Using Corel Draw X4 v14.0.0.701
View 4 Replies
View Related
Feb 20, 2014
Can 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 Related
May 25, 2011
I opened a new 3dsMax file and Import/Merge an object in it. When I opened the "Material Editor" Window of the new file, it is empty.
How can I get the material of the merged object? Is there a way to import/merge an object and their materials as well?
View 2 Replies
View Related
Nov 27, 2011
I have a bunch of images that I would like to merge for HDR.These are RAW files. Should I open them in Photoshop and merge them/edit them before I import them into LR 3 or should I import first, do my keywords, etc. then export into PS. I am using CS4. I assume I shouldn't develop in LR3 until after the images are merged.
View 2 Replies
View Related
Jun 7, 2011
When I merge geometry into a scene that is already using the same materials, it prompts me what I want to do. I always select "Use scene materials"...however, whenever I look at the slate, it shows duplicates all over the place. To keep mat library optimized becomes a task when you are dealing with a lot of materials.
Why does MAX not listen to me when I tell it to use the scene materials that have matching names?
Max 2014 (SP2)
Win 7 64-bit; Dual Xeon E5-2687W @ 3.10 GHz; 64 GB Ram
NVIDIA GeForce GTX 570; Quadro 4000
View 8 Replies
View Related
Apr 24, 2012
I 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.
View 3 Replies
View Related
Feb 28, 2005
how to import layers? I need to merge two images together, but they are on seperate files and so on seperate layers, how can i put these two images onto one file?
View 1 Replies
View Related
Feb 5, 2014
I have a logo that seems to import at half opacity when placed. I thought maybe it was the way it was being viewed, but it prints that way too. Something obvious I am missing?
View 15 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
