InDesign - Datamerge skips and re-orders data

-

hi everyone. i'm having bit of trouble feature of indesign have lot of experience with, , i'd appreciate second pair of eyes possibly spot ridiculously simple i'm missing.

 

i have lot of experience datamerge, , particular template has been used several dozen times in past 6 months has been acting wonky. seems skip first 11 rows or of .csv file, repeat next line 10 times, continue next few rows, repeat same line before 40 or times.

 

there no hidden columns/rows in csv file. , make sure, i've re-created file 3 different times, copy/pasting data fresh workbook. no dice. , can confirm i'm using correct csv file every time.

 

under datamerge options, set "all records", , "remove blank lines empty fields" left unchecked. weirdly enough, the preview multiple record layout lays out correctly. single record preview. merge, trips on itself.

 

in interests of being thorough possible, below screenshots of step step along way:

 

1. csv file. in alphabetical order, starting "alamos". 5 "liberty creek" entries:

http://ethanguillemette.com/work/datamerge9.jpg

2. correct csv file selected, , data holders filled.

http://ethanguillemette.com/work/datamerge1.jpg

3. preview shows first tag being "alamos malbec".

http://ethanguillemette.com/work/datamerge2.jpg

4. "all records" selected.

http://ethanguillemette.com/work/datamerge3.jpg

5. multiple record layout options (not sure if here relevant)

http://ethanguillemette.com/work/datamerge4.jpg

6. "remove blank lines empty fields" unchecked.

http://ethanguillemette.com/work/datamerge5.jpg

7. "preview multiple record layout shows correct data.

http://ethanguillemette.com/work/datamerge6.jpg

8. once datamerged, first tag "liberty creek merlot" (should "alamos malbec"). continues "liberty creek merlot" 11 entries.

http://ethanguillemette.com/work/datamerge7.jpg

9. after 7 correct entries, repeats "liberty creek merlot" several pages until end of document.

http://ethanguillemette.com/work/datamerge8.jpg

 

i've tried same template other csv files, , skips rows, not same one. additionally, same thing on 2 different computers.

 

am missed obvious here? or broken? it's barebones template recreate in sleep, i'm worried there's don't know i'm doing messing things up.

 

message edited by: ethan guillemette (added bit not working other csv files , other computers)

for several versions now, there has been data merge bug in indesign has potential trash template if use preview on multiple records layout. far know, has not yet been fixed.

try rebuilding template, , outputting without previewing.



More discussions in InDesign


adobe

Comments

Post a Comment

Popular posts from this blog

Illustrator CS6 Ocurrío un error E/S en el archivo.

-
este error me me sale cada ves que guardo un archivo que ya estado trabajando varias veces, sale cuando ya esta finalizando el proceso de guardar, ya probe cambiar nombre del archivo, ubicación de guardado, convertí curvas las fuentes y sigue saliendo el mismo error, no se que mas hacer, si alguien le ha sucedido y sabe como solucionarlo por favor ayuda. versión exacta (acerca de illustrator) de illustrator? versión sistema operativo?   guardas en el disco duro principal del ordenador o en otro disco, memoria pendrive,...? ese disco que clase de disco, modelo, antiguedad, espacio libre,...? More discussions in Foro en español adobe
Read more

Why is os_ViewContainer running?

-
when open illustrator (cc) opens window os_viewcontainer cannot view or close. shows in taskbar second window illustrator when mousing on ai icon. have tried select no luck. have tried clear using red x, no luck. close when close illustrator. wondering why there , if should concerned. oh, running windows 10. hi ccsachs,   as per query when launch illustrator opens " os_viewcontainer "   i request please share screenshots along below-mentioned details:   exact version of illustrator  graphic card using , when updated last time how performs in safe mode? ( https://support.microsoft.com/en-in/help/12376/windows-10-start-your-pc-in-safe-mode ) if works fine in safe mode please share antivirus using?   regards srishti More discussions in Illustrator adobe
Read more

Animate - problem with duplicating scripts after loop

-
hi all,   i have problem simple button script @ first frame. fine when timeline playing first time. after when timeline loops , stop again @ 0 frame button script fireing 2 times, when loops third time fireing 3 times etc...   here script:   this.stop(); exportroot.mc_cta.cursor = "pointer";   this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() {     console.log("clicked");     eb.useractioncounter("clicked");     exportroot.gotoandplay(1); }   anybody ideas? wrong?   thanks! kris use:   this.stop(); exportroot.mc_cta.cursor = "pointer";   if(!this.alreadyexecuted){ this.alreadyexecuted=true; this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() { console.log("clicked"); eb.useractioncounter("clicked"); exportroot.gotoandplay(1); } } More discussions in Adobe Animate CC - General adobe
Read more