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 ......
View 2 Replies
ADVERTISEMENT
Nov 28, 2011
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.
View 2 Replies
View Related
Nov 16, 2012
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?
View 3 Replies
View Related
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.
View 2 Replies
View Related
May 22, 2013
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.
View 10 Replies
View Related
Apr 11, 2012
How can I add shutterstock to correl connect like the Flickt, fotolia, iStockphoto?
View 2 Replies
View Related
Mar 7, 2013
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?
View 7 Replies
View Related
Oct 2, 2012
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.
Software used: Wilcom ES3 Level 3 [V3.0H], CorelDrawGS X6 (64-bit) [16.4.0.1280]Computer: OS: Win7 Pro x64 SP1 | CPU: Intel i5-2500K 3.30Ghz | RAM: 8GB 1600mhz | Graphics: ASUS EAH6850 1GB | Monitor: 24" BenQ E2420HD | Tablet: Wacom Intuos4 Medium
View 3 Replies
View Related
Jun 8, 2011
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.
View 12 Replies
View Related
Mar 26, 2012
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.
View 6 Replies
View Related
Dec 7, 2012
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".
View 2 Replies
View Related
Jul 16, 2012
FFC IMAGE.JPG
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.
View 16 Replies
View Related
Jul 5, 2013
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.
View 4 Replies
View Related
Jun 1, 2011
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?
View 4 Replies
View Related
Nov 18, 2013
I need to locate or create a Macro that would read a text file that contains
x postion, y position, and diameter.
Each of the 4000 circles in this file are a different diameter. There is no linear progression.
View 1 Replies
View Related
Mar 5, 2012
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.
View 2 Replies
View Related
Apr 18, 2013
(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.
The question is, is there a maximum export size?
View 9 Replies
View Related
Apr 26, 2011
I have done it in a lot of steps. There must be a simple way to do it.
View 3 Replies
View Related
Sep 5, 2013
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.
View 1 Replies
View Related
Nov 26, 2011
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?
View 1 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
Jul 30, 2012
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.
View 2 Replies
View Related
Apr 27, 2011
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.
View 1 Replies
View Related
Jul 1, 2011
I use Coreldraw 11. and how to make one Line connect to another Line?
I know there is a way you select both Lines and have Coreldraw auto connect them?
View 1 Replies
View Related
Jan 16, 2012
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.
View 5 Replies
View Related
Apr 20, 2012
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.
View 9 Replies
View Related
Mar 18, 2012
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?
View 7 Replies
View Related
Dec 1, 2010
We are having a big problem with dropping lines of text or parts of graphics. It is happening on 3 different laser systems and 2 different printers.
View 14 Replies
View Related
Sep 5, 2009
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.
View 6 Replies
View Related
May 9, 2011
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.
Running Win 7 64bit 8GB Ram
View 14 Replies
View Related
Jan 2, 2013
02012013010.jpg
Blank Blocks behind text and graphics
View 4 Replies
View Related
