Import CSV file into Quark

[mbozovic]

Hi there,
Is it possible to import CSV file into Quark(I use version 4)?

Thank you

 

[jimoblak]

Can you open it in a plain text editor and then copy/paste to Quark?

You can use find/replace to do some basic formatting.

- - picklefish - -

Why is everyone in this forum responding to me as picklefish?

 

[mbozovic]

This CSV file is huge. It is going to fit around 1500 pages.

 

[duncdude]

1,500 pages... that shouldn't cause Quark any problem

What are you trying to set in Quark - can you do any pre-formatting of the data using Perl before you import it into Quark?

Duncan

 

[mbozovic]

Here is the story.

My company is selling Business Directories. We save all listings as one CSV file and sand that to printing company.

Somehow they load that data into Quark (they charge $1 per page) and send back a PDF for proofing.

We would like to do that in house.

Regards,
Misko

 

[duncdude]

can you show an example of a few lines of the CSV

Duncan

 

[mbozovic]

Here is:


company,addr,city,st,zip,fullphone,sic,fax,tollfree,email,website,noe
J & J WATERPROOFING INC,12170 ROUNDSAVILLE RD,BATON ROUGE,LA,70818-3043,225-262-1855,16290203,,,,,10
TRAVIS BOATS MTRS BATON ROUGE,14369 FLORIDA BLVD,BATON ROUGE,LA,70819-3214,225-272-2628,55510100,,,,,15
CLAIRES BOUTIQUES INC,6401 BLUEBONNET BLVD,BATON ROUGE,LA,70836-6401,225-757-0559,56320000,,,,,10
GIBSLAND BANK & TRUST CO,1246 S 3RD ST,GIBSLAND,LA,71028-4301,318-843-6228,60220000,,,,,11
KRISTINE H COLE CPA,601 MAIN ST,MINDEN,LA,71055-3327,318-377-3171,87210101,,,,,12

 

[duncdude]

no problem - what does it need to look like in Quark?

can you e-mail me a PDF? scan@btinternet.com

it would be so easy to split the file up on the commas and add Quark tags around the separate 'columns' of data - this would take almost all of the work out of Quark

Duncan

 

[duncdude]

and do you use a Mac or PC?

Duncan

 

[mbozovic]

PC

Misko

 

[duncdude]

Sorry about mentioning Perl - I forgot I was in the Quark forum!!!

To explain - I do quite a bit of 'Power Publishing' using Perl/Quark

Duncan

 

[Foamcow]

I haven't tried this but...

can't you just draw a text box and then "Get Text" (command/ctrl + E).

Then use find/replace to format it.

 

[blueark]

http://www.iconlogic.com/pdf/XPressTagsList.pdf

That's a PDF document with a list of tags that QuarkXPress uses. I would suggest opening your CSV file in a spreadsheet (like Excel), inserting columns between each field and inserting an appropriate tag, such as the name of a style sheet, or a new line charactor. Resave it, create a new Quark document with an automatic text box, and Get Text. You can then do a simple Find & Replace to get rid of all the commas.