CorelDRAW Graphics Suite X5 :: Dynamically Connect Text To Excel File?
Jun 21, 2011
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 ......
For some time I was using CorelDraw 12 with Windows XP and Excel 2007.I normally make some tables in Excel which I copy and paste into Corel using "Paste special"/Picture/Enhanced Metafile. In Windows XP there was no problem. Since I switched to Windows 7, I have the following problems:
- The font Wingdings 3 comes out as Arial.
- The second problem is a very strange thing: Some characters, such as ,-"; , always at the END of the line, just dissapear. It happens sometimes, not always, and I can't see absolutely no logic in it: I copy the same thing, paste it several times, and sometimes the comma comes out, sometimes not. I remember that this happened to me ONCE, long time ago, when I was still using XP, but then I restarted Corel and it stopped making problems. But now, with Windows 7, it happens almost all the time. I tried it on a few different PCs and I even tried it with Corel X4. Always the same problem.
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?
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.
Corel Connect not showing thumbnails.I have the paid download version of CorelDraw GS X5 installed on a PC running Windows Vista Ultimate 32-bit. I found that the Corel Graphics - Windows Shell Extension only shows in the CorelDraw installer when "Custom" is selected versus "Typical," even though the shell extension shows in Control Panel. The latest twist is that Corel Connect will show photo thumbnails on the hard drive, but will not show thumbnails for photos on a CD or DVD. Other than a different file structure, a DVD or CD is read only. If I copy a photo from a DVD to the C: drive, Corel Connect will show the thumbnail on C:. Windows Explorer shows the thumbnails on the hard drive, CD, or DVD. Corel Connect will not show thumbnails of the Corel .CDR files on the hard drive, CD, or DVD in Vista but it will show them in Win XP.
Why doesn't Corel Connect display .jpg thumbnails on a DVD or CD? I think there is a bug in the Corel Graphics - Windows Shell Extension in Windows Vista.
Just installed X6 and tried CONNECT for the first time and it doesn't display the thumbnails of the vector images only bitmaps etc.. Any way to correct that?
When I want to search in connect, I select the folders I want to include in my search, that is fine.But when I close the progarm and restart it the selection is reset so nothing is selected except the X6 content on disc.
In X5, X6 it would keep the selected folders and they would remain selected and ready to go each time I started connect or CorelDraw.But in X6.1, it seems that each time I close the program it resets everything.
I select the folders I want to use in my search, favorites are locations I want to use in every search.But when I close down for the day and restart CorelDraw the next day and go to connect, this is what I get, all check boxes cleared.
is there a way to get it to keep my selections when I close the program?To me, at least, this is annoying to have to select the folders every time I start the program.
In Connect I see only blank thumbnails of my .cdr files. The nice thing of this program should be thati can scroll through my files and look at large thumbnail So I know what iám working on.
In new version of Corel draw x6, Urdu alphabet ی (Unicode Value: 06CC) not proper connect with other alphabets. In older version it is correct but in new version something wrong. On the other hand, when we copy Urdu text from any text editor e.g notepad and paste in Core draw x6, then it properly connect with others.
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".
I am having an issue with CD X6. I opened a file created in X5 using the new X6 and it worked just fine. The problem is when I send the file to my image setter to image a plate, part of the text in the heading of what is to be printed is getting lost somewhere in transmission. When I view the file in the print preview in CD all the content is there, however, when I view the raster image at the rip station before imaging the plate I notice parts of the text in the heading is missing. I have attached an image of the raster file .
Now when I send the same file using X5 the image goes thru without any issues and all the content is secure. I created a new page in X6 and copied over the text that I am having trouble with and the same thing happens. I am attaching the CDX6 file with all the fonts used.
So since we installed CorelDraw x6 the one file we have been working on is a long text file and it slowes every thing down drasticly.We did think updating would work so we did that and it still lags.
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 import an pdf file which contains text in black colour in corel draw X5. By default it import the file in RGB colour model but I want the same in cmyk colour model.
(CORELDRAW X6.3) Today I tried to export a .jpg file (text file) for a banner that was 6ft x 18ft. The export function wouldn't allow the 18ft, but changed it to like 9ft.
Tried in same in X3 and had the same result.
I could export the file as a .pdf and it worked just fine.
I've created a personalized invoice form in which I integrated a Microsoft Excel from to it. Ever since the version I integrated my Excel forms it has always been an issue.
When I integrate a Microsoft Excel form in CorelDRAW and apply changes to it, the form doesn't retain its size and emplacement. The change VERY slightly, but still ALWAYS change.
I'm having some trouble setting my workflow and I need linking data to corel draw from excel. Basically, what I want to do is to have excel data automatically copy from Excel to Draw and "Paste Special / Paste Link Objects/MS Excel Worksheet is almost what I need.
It would be perfect if only it would copy CONTENT of the Excel file or cells, not their formating (font, size, border etc.) which I want to do in Corel, since separation of the content (excel) and form (draw) would be just natural and functional - don't want my number crunchers to affect design of the Draw document, just as I don't want to have my designer to do the math
So - is there way to link objects (cells from Excel) but to transfer content (text) only or should I revert to VBA?
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.
For some reason I am having issues converting a CDR file to PDF which contains objects/text with fountain fills.
I have looked at some previous posts detailing the same problem, have followed their remedies, i.e. "render complex fills as bitmaps" in the advanced tab in the PDF conversion pane. Despite these best efforts I am still having the problem of my black background; fixed in the "page layout" tab being corrupted, resulting in the background being the fountain fill once converted.
I'm perfectly happy with the TrueType font (BankGothic Md BT), but all the style settings change to the T1 equivalent every time I close, and when I open the file again the T1 text does not show up. I can go through and reset all the styles, then re-apply them, but it wastes a lot of time.
I have X5 and would like to know if there is anyway I can insert an excel name list into a coreldraw file. The file is a layout of badges with a name on 1 line of text, I want to change each line by inserting or dropping the name in with the name list I have in excel. Then there's no worries with spelling corrections on my part.
I have an excel spreadsheet of boreholes. The spreadsheet has the format of ID, X, Y, Z
I have tried using the 'Connect to Data' feature in Map 3D 2012 64 bit.
The ODBC connection is created and tests correctly. After connecting to the ODBC DSN and loggin in, I am able to see the fields identified in the excel file. There is also the Class available from the named range in the excel spreadsheet.
I select my Identity Property, X, Y, and Z - but that's as far as I can go. I have no opportunity to set the coordinate system and the 'connect' button does not activate.
Using Win 7 64 bit - and I have the 64 bit ODBC driver's installed.
why (sometimes) when I export text or graphics as .eps files to my cutter it cuts the same outline up to four to five times and ends up cutting right through the backing paper. I have been using postcut with various corel editions since 1997 with no problems until recently. It also cuts random lines through lines of text which is such an expensive pain in the ass.
I started to use the production manager in flexi sign to cut my designs and same thing happens, except for the random lines but it will make up to five cuts on some objects. All text and graphics are exported the same. Has something in corel newer versions changed in relation to this?
Often whatever I'm working on in X4 disappears off the document page when I zoom in or out. It's still there (I can see it in the print preview)and I can print it, but I can't see it no matter what view (e.g., normal, draft, etc.) I select. If I select the entire page I can see the graphic and text handles, but nothing else. The only way I can see my work again is to save it, close the program, and then re-open the file. My computer is a Dell Precision Work Station T3400 running Vista Ultimate with an Intel Core2 Quad CPU, 4GB RAM, and my graphics card is an NVIDIA Quadro FX 570 256MB. All my software and drivers are up to date. The problem occurs no matter what screen resolution or refresh rate I'm using.
X5 Recently have begun missing parts of print out. Tried to duplicate but appears completely random.
Output to both Full colour laser and Wide Format printers will miss either text or part of objects. Today printed the text but not the text effects. Initially closed and reopened, rebooted, However this has become a now daily feature so regardless tried reprint from the same screen so next print has everything included.
Very costly and time consuming - print preview shows all correct but output is not the same.