HomeMicrosoft


Persuading AutoRoute to Put Data Where I Want It
werdnanostaw
For the last few weeks we have been reading web sites and paper books from the library (how quaint) to generate lists of beautiful places to visit in France, Germany, Czech Republic, Slovakia, Hungary and Poland.

All suggestions gratefully received.

We have generated spreadsheets with 4 columns:

Latitude, Longitude, Name, Name2 where Name is Place Name and Name2 is Description.

These were saved as CSV files.

When they are imported into Autoroute 2013 the Name and Name2 fields are concatenated and displayed on the top line of the Information text balloon.

Is there any way to get the contents of the Name2 field to be imported into the third line of the text balloon?

I could manually cut and paste the data from the first to the third line if that's the only way but I would prefer to have it done automatically if possible.
werdnanostaw
Address1

The third line is blank.

The fourth line displays F2: Description.

Problem solved but which field name goes to line three?
werdnanostaw
If anyone's interested here's the data for Czech Republic:

"Cesky Krumlov","Astonishingly beautiful, well preserved small medieval town",48.81091,14.31521
"Karlovy Vary","Spa town. Has imposing colonnades and stunning churches like the late 19th century Byzantine-style Orthodox Church of St. Peter and Paul",50.23271,12.87117
"Kutná Hora","Beautiful structures. World Heritage Site. Baroque St. Barbara's Cathedral, built in 1338 and notable for its beautifully decorated interior and frescoes",49.94839,15.26816
"Sedlec","Home to the famous ""Bone Church,"" the Gothic All Saints Chapel. Just outside Kutna Hora",49.96182,15.28821
"Turnov","Beautiful, spectacular Bohemian Paradise (Český ráj). Area of outstanding natural beauty. Notable for its many massive rock formations. 5km south of Turnov.",50.58356,15.15186
"Karlova Studanka","18th-century spa town in the Jeseniky Mountains. Beautifully laid out with wide streets, parks, and gardens, this picturesque town is famous for its wooden architecture, its mountain peak, and its numerous waterfalls and rivers.",50.0731,17.30685
"Brno","Second largest city after Prague. Splendid historical sites and attractions: Spilberk Castle, Dietrichstein Palace, Cathedral of St. Peter and Paul.",49.19522,16.60796
"Ostrava","Third largest city in Czech Republic. Old mining town historically interesting. Its industrial heritage presents the city with outstanding architectural jewels.",49.83465,18.28204
"Karlštejn","Karlštejn Castle. Large Gothic castle founded 1348 CE by Charles IV, Holy Roman Emperor-elect and King of Bohemia.",49.71698,16.05662
"Třebíč","Basilica of St Procopius and the Jewish quarter of Zámostí.UNESCO Heritage Site",49.21492,15.88166
"Telč","UNESCO Heritage Site",49.18418,15.45275
"Litomyšl","UNESCO Heritage Site",49.86809,16.31298
"Žďár nad Sázavou","Pilgrimage church of St John Nepomuk.UNESCO Heritage Site",49.56263,15.93924
"Holašovice","Baroque village.UNESCO Heritage Site",49.99843,17.80847
"Kroměříž","Lednice-Valtice area.UNESCO Heritage Site",49.29785,17.39312
"Benešov","One of the Czech Republic's loveliest palaces, Konopiště Chateau - just 50 kilometers southeast of Prague",49.78162,14.68697
"České Budějovice","Just north of town is most beautiful of the Czech Republic's many fine castles - Hluboká Castle.",48.97447,14.47434
"Hruboskalsko","The Hruboskalsko is one of the best-known rock formations. It is characterised by impressive towers reaching up to 55 m and also by steep canyons.,50.56078,15.19881
"Břeclav","Lednice–Valtice Cultural Landscape spread over the site of a mighty 12th century border castle. Today it is the home of a romantic château & a picturesque village. UNESCO Site.",48.75897,16.88203
"Holašovice","Traditional Central European village. Village buildings from 18/19th centuries-South Bohemian Folk Baroque style have been preserved on a ground plan that dates from the middle ages.",49.99843,17.80847
"Olomouc","Holy Trinity Column erected in the early 18th century.",49.59552,17.25175
"Znojmo","Town centre-numerous churches surrounded by mediaeval city walls. Renaissance look, full of crooked lanes, romantic views,picturesque nooks & crannies. Znojmo Castle.",48.8555,16.0488
"České Budějovice","Short drive north of the city of České Budějovice, the huge white Neo-Gothic Hluboká Castle (Hluboká nad Vltavou) is often said to be the most beautiful of the Czech Republic's many fine castles.",48.97447,14.47434

Yes, I know there are a couple of duplicate entries. That's what happens when you merge data sets prepared by two people and you're too lazy to sort by name. I certainly will for the other countries and if I have time I'll do it for CR as well.
© laptopgpsworld.com About