CorelDRAW Graphics Suite X6 :: Print Merge NOT Recognizing Numeric Field From Excel File
Jun 1, 2012
I am having an issue with X6's print merge not recognizing a properly formatted numeric filed from my Excel spreadsheet. My first issue was that Corel was adding a decimal point after my numbers. This was when they were still formatted as text fields. (which i still don't understand why, since they were just TEXT fileds)
I know that the fields need to be "numeric" fields.
FYI i have ALREADY COMPLETED MY TASK by using an "added" numeric filed that i added IN CorelDraw and then used the "Numeric Field Options" at the bottom of the page to get my number sequence.
However, that is not my question.... my question is: How do i get corel to RECOGNIZE a numeric field AS a numeric field in the first place.
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.
The problem is that I have not Excel on my PC. Only Open office. I create a csv file but Open Office asks me every time what the Field and Text delimiter have to be - for the Field "," ";" ":" "tab" or "space" and for the Text " or '. After that it asks me to check or not few check boxes. See the picture below.
I tryed few combinations but the same result - Failed to save print merge data!
I dont know what to chek but the biggest problem is that I tryed to save a txt tab delimited on other computer with excel and when I try to print merge after loading the txt file Corel says Failed to save print merge data.
I saw that we can Print merge directly from xls files but I cant find that option in ODCB Data Source. Weird! because I have to do 1100 badjes with different merge fields like country, name, code etc... and if I start to make them by hand it will be forever!
I created a list if voucher numbering from 1001 to 1200, but when I perform the Print Merge, the list shown are with one decimal point i.e. 1001.0, 1002.0, etc....
I have just ugraded 4 computers to X5 (one w7, 3 with XP) and are having a lot of problems with the application crashing or hanging. Applies to all computers. We do a lot of print merges, more than 100 a day. Happens randomly, but mainly after several jobs have been printed (jobs, 5-10, still open in X5 in case som modifications are needed).
since i upgraded to X6 i cannot do imposition anymore, using print merge.
Before i set a page with lets say A5 with the layout, and then in the print merge, i would put 4up (four A5), and it went well, using (collate and cut as well).
Now look at my attached file, the first page stays different size.
I need to prepare the artwork for 1000 member cards with the membership number present as a barcode. How can I generate the barcode for each individual card without doing it one by one?
While using print merge option Corel Draw X5 give me an error when I try to import an existing csv or txt file on the print merge dialog box. It says "Impossible to open the file or not correct file format". The files are made with open office or microsoft works, and in the past I've already used and worked good. Now I find this error...
I am using CorelDraw to create price labels for my store. When I merge in the price field for an item I want it to show on the label with the cents in superscript as opposed to using a decimal and full sized cents text. Is this possible in any version of CorelDraw using the print merge feature?
Keep in mind that I also have the price field in an envelope so that the price takes up the full size allotted on the label whether the price is $1.99 or $999.99.
I have a document, where I need to have 4 different print merge fields from 4 different data sources (.txt).I can only make it work with 1 print merge field.
Whenever I perform a PrintMerge the print dialog and its options are reset everytime I leave the print dialog.
Usually you hit print set parameters and hit apply, you now can cancel the dialog and hit print again, your previous settings should still be there. Same goes if you actually print and want to repeat the print process, as long as you dont close the document. This works for normal printing but fails with print merge.
Every time I close the dialog (not the document) all the settings are back to default. This did not happen in X5 and is very annoying since it resets to default even if you actually hit print, forcing you to set the parameters every time.
I´m trying to extract text from a Corel file to a TXT file in another editor and then merge it back in.Extracting the text seems to be working just fine but when I´m trying to merge it back in I get the error message "Wrong file format or could not open".
A1 field name is FIRST NAME B1 is LAST NAME C1 is ADDRESS D1 is CITY E1 is STATE
F1 is ZIP H1 is name1 I1 is name 2 Fields H1 & I1 could not be inserted.
I entered the above field labels and loaded them with the saved Excel file saved as a CSV (Comma Delimited)
When the First names and last names appear in a document there is too big of a space between the first and last names. The same problem happens when I put city, state, and zip on the same line
in the document.
I did a concatenate combining A1 &B1 to eliminate the space problem and a concatenate to combine D!, E1, and f1 Fields on one line. I put the results of the concatenates in seperate columns H1 & I1 but these 2 column fields could not be inserted for the print merge.
How i can solve the space problem between first and last names and the problem to put city, state and zip on the same line with proper space and punctuation.
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.
I am building a big catalog for hundreds of products, and it would be a life savior if i could connect dynamically the (customized) text (fields) in the .cdr file to an external excel file data. For example smth like the text field "Title" to be taking its values from the column "Description" of the excel file, incrementally as each line of the excel file could represent a record. This way also when the excel file changes, (because it will be probably like 10 more versions before it gets final), the content inside the corel draw file will change automatically as well.
Download sample corel file here :
[URL]....
and sample excel file here :
[URL]....
How to accomplish smth like that or even faster / simpler ......
Is it possible to do such a thing? Everyday I have to change the production number in the label artwork. Can I link this production number in the artwork to an external file such as an Excel datasheet?
We upgraded to x6.1 and are having some issues. I have X5 and X6 installed on my machine. When using X6 and you add a new page to the document, then publish a PDF. The PDF will show grid lines on the new pages. This happens with new docs and previously created docs when we add new pages. Also, on the new pages, you can't disable the printing in the object manager.
Second problem, when you have a bitmap in your document and click on it, Photo Paint is available. Only the trace option. Edit Bitmap is grayed out on the Property Bar and not available when you right click the image. I have to open Photo Paint and copy the image into it. There are three of us having the same problems.
CorelDraw X5 (German Version 15.0.2.0695):I've installed Corel X5 under Windows 7 Ultimate 64 Bit.
When I try to set up my ppd-file in the printer dialog window, I can chose the ppd-file but the OK-button (öffnen) doesn't work. Clicking by mouse or by Enter button at the keyboard: nothing happens, the ppd-file won't be accepted. It seams the OK-button is out of any function in this window.
I have a file set up that has a white box with a 65% transparency lens. When I go to print, the white box and what's under it disappear and do not print. If I close the document and reopen it, the transparent box and what under it are back.
I try to move a guideline with the field Y for example.1-) Put a guideline in the page2-) I need to put my guideline exactly to: Y: 5.181''.So, I put in the Y field 5.181''. The bug result is that the field makes an addition.If the position of the guideline is Y: 4.0'', and I want to move it to Y: 5.181'':the guideline go directly to Y: 9.181''.Another question:What is the use of the Object Origin button's options for the guidelines?
Whenever I try to enter a value into one of the CorelDRAW X6 toolbar edit fields, then moving the mouse pointer away from the toolbar in order to see what I'm about to enter, CorelDRAW X6 takes the focus away from that edit field.See her for an example to reproduce the problem:
var video_8143bd82692c4abebed036cbf4afd70b = new jeroenwijering.Player(document.getElementById('video_8143bd82-692c-4abe-bed0-36cbf4afd70b'), URL.....
so, for some reason when i choose the body of this cow i drew to fill, it fills its hind leg, and stubbornly refuses to fill the body at all. i have tried all the fill tools to get this too work. i figure if i flatten the image the fill tool will work a bit better.
there is no such thing as flattening the image or merging layers in the help section and the info online hasn't been so great. How do you merge layers?
Using x4. I am looking to merge a list of names into a matrix and maintain text constraints. I want all the names to fit into a certain space (ex. 1.5" long) and to maintain a certain character height (ex. .25" high). So my output should be no longer than 1.5" and all should have .25" high characters on a single line. I am able to setup the template and lock the fields, but during the merge everything gets messed up. All x, y positions, text length and text height have to be manually reentered for each name.
We are using Coral Draw 11 and have to get a lot of our data from Excel. Currently we are copying and pasting the information in, but this is very time consuming. Is there a faster and simplier method?
I need to make a bunch of barcode tags for a client. I know CorelDraw isn't the best tool for this, but it's what I have and this is a one-time job.
To partially automate the process, I'm trying to use print merge to make the parts of the tags that aren't barcode, but I include the text that belongs in the barcode on the page. The print merge works correctly, I get what I expect. The next step would be to cut the barcode text, choose Insert Barcode, and then paste the barcode text into the barcode dialog.
Except, when trying to paste the text intended for the barcode I discovered that I was actually copying the <var1> field--not the text. I verified this by copying the "text" from the print merge document and then pasting back into the same document--what I got from the paste was not the expected text, but <var1>.
Since the barcode type I was using does not support the "<" character, it gave me an "invalid character" error.
My attempted solution was to publish to a PDF file and then import into a new document. This worked except for some reason CorelDraw makes a new layer named, inexplicably, "Layer 1" (there's a "Layer 1" by default, why make a second layer with the same name?) BUT when the import is done the new layer is NOT chosen in Object Manager, the original "Layer 1" is. Which means, when I go to copy the text and insert the barcode it ends up UNDER the other parts of the barcode tag which are on the NEW "Layer 1".
