Quote from: Tracy on March 20, 2013, 06:20:42 PM:laugh:
I would totally data merge for you!

Im may need to take you up on that! :laugh:

Quote from: gnubler on March 20, 2013, 06:24:46 PMData Merge is okay to an extent. Can you predict how many pages this will end up being? Because that's how long your merged Indy file will be. I've had some end up several hundred pages and making a PDF from that takes 4-ever.

It is going to end up being about 20 pages @ 12.5" x 22.5".

Quote from: Tracy on March 20, 2013, 06:28:58 PMyou should check it out tho.

select your file save as .txt tab delimited
you have to name your columns so you have to insert 1 row above
and you prolly have to get rid of the headline cuz that won't work

format a line a text open the data merge, select your .txt
and you will see your column names
select the first column of the formatted text, then click on the column name in the date merge pallete
then select your 2nd column formatted text then click on column name in data merge, then do the 3rd
then you just go to create merged data and I think its content options.
and in there you will see multiple records.

sorry it's kinda basic, If it's not Hot :laugh: I can do screen shots tomorrow
gotta go now, my anniversary today

See previous error message when I try to select the .csv. I'm using Libre Office to convert the Excel file and my only option from there is .csv (comma delimited).

PS: HAPPY ANNIVERSARY!

I could try it out right now but I just opened Beer #1™ and...

see, as I was typing this my bf said "omg, what are you doing?" I'm not allowed to do prepress after hours.  :laugh:

I may d/l anyway because I'm defiant.

Well I would hate to get in the way of beer!

I just spent the past 10 minutes dropping f-bombs at your xls. It took down OO twice and nearly took down my Mac (I have a 7 yr old iMac here at home). I was trying to delete the blank columns and it just locked up. I think I'm giving up at this point. Enjoy! 

You need to clean up the xls a bit, delete all the info in the top rows, and make a header row with column names, then save as csv for Data Merge.

I'm busy watching videos of idiots eating Carolina Reaper peppers. I blame farabomb.

Quote from: gnubler on March 20, 2013, 07:13:10 PMI just spent the past 10 minutes dropping f-bombs at your xls. It took down OO twice and nearly took down my Mac (I have a 7 yr old iMac here at home). I was trying to delete the blank columns and it just locked up. I think I'm giving up at this point. Enjoy! 

You need to clean up the xls a bit, delete all the info in the top rows, and make a header row with column names, then save as csv for Data Merge.

Yeah, I was having the same issue. I had to delete one column. Save. Close OO. Open XLS. Delete one Column. Save. Close OO. Fun time but I think I've gotten rid of all the blank/unnecessary rows and columns. Data merging right now into Indy. Taking awhile but still moving it seems.

I guess I'm not understanding the problem. Are you trying to format the text into InDesign? Not too hard. Show me what you are doing. I might have a solution, or I may not be understanding what you are doing. I am doing it right now, and I am having to clean-up some areas, but it's not that bad.

Quote from: DigitalCrapShoveler on March 20, 2013, 08:28:38 PMI guess I'm not understanding the problem. Are you trying to format the text into InDesign? Not too hard. Show me what you are doing. I might have a solution, or I may not be understanding what you are doing. I am doing it right now, and I am having to clean-up some areas, but it's not that bad.

Just like I said earlier.

https://www.b4print.com/index.php?topic=7462.msg225147#msg225147

I've never used data merge and it seems to be choking on the excel file with about 20,000 records.

No matter what you do, you are going to put a hard return after the third column. I formatted the Excel file, imported into InDesign as a .csv file with comma sepped tabs, and did a find and replace on the text where the commas are. It's clean now, all I have to do is select the number after the total assessed numerical value and hit return. It all is flowing pretty easy. It would take a while to click through every line, but it's pretty simple.

That's a lot. Data Merge is only good for so much, that's why we bought FusionPro to handle the bigger data files. Good luck.

Quote from: DigitalCrapShoveler on March 20, 2013, 08:45:53 PMNo matter what you do, you are going to put a hard return after the third column. I formatted the Excel file, imported into InDesign as a .csv file with comma sepped tabs, and did a find and replace on the text where the commas are. It's clean now, all I have to do is select the number after the total assessed numerical value and hit return. It all is flowing pretty easy. It would take a while to click through every line, but it's pretty simple.

This is exactly what I am trying to avoid.

Do you have it formatted like I specified in that post? 4 Columns on a 12.5" x 22.5" page? 6 pt Times Regular?

Yes, exactly. If they put a unique character at the end of column 3, I could do this whole job in about 30 minutes.

Quote from: DigitalCrapShoveler on March 20, 2013, 09:04:01 PMYes, exactly. If they put a unique character at the end of column 3, I could do this whole job in about 30 minutes.

Are you using data merge or just straight importing the Excel file? When I try a straight import of the Excel file it comes in a table format which is not what I want really but hey if it works, tell me how you are doing it.