The Data connection wizard

LabeljoyNew version

The Data connection wizard connects a label set to your data, a few steps at a time: what kind of data it is, where it is, which part of it you want, and a look at the records before you confirm. It opens with Connect data source in the Data source panel, when you right-click a label with no data, from the Fields menu of the text editor, and from the Create from data source card of the home screen. Help Help, at its top right, opens this page.

Or just drag a data file from a folder and drop it on a label: the wizard opens with the kind of data and the file already filled in.

The Data connection wizard at step 1 of 4,
Connection type: tiles for Excel, Access, Text file, SQLite, FoxPro dBase Clipper, XML, JSON, Clipboard, MySQL,
SQL Server, Oracle, Firebird, PostgreSQL, MongoDB and Custom connection, with Text file selected.

The steps
Connection typeClick the kind of data you have - or double-click it to go straight on.
Connection parametersWhere the data is: a file, a server, a connection string.
Data sourceWhich part of it: a worksheet, a table, a query. Skipped when there's only one, as for a text file.
OptionsHow many labels each row makes, and a couple of choices about empty rows.
Data reviewThe records, as the labels will get them.

The bottom of the wizard says which step you're at, as in Step 2 of 5. Back goes back a step, Next checks what you've entered and goes on, OK on the last step connects the data. Cancel, the X or the Esc key close the wizard and change nothing. When something's wrong - a file that can't be read, a server that doesn't answer - the reason shows in red at the bottom.

Connection type - which page tells you more
ExcelSpreadsheets
Text fileText and CSV files
Access, SQLite, FoxPro, dBase, ClipperDatabase files
XML, JSONXML and JSON files
ClipboardThe clipboard
MySQL, SQL Server, Oracle, Firebird, PostgreSQL, MongoDBProfessional database
Custom connectionCustom connection
Data source
SourceThe worksheets, tables or other parts of your data, in groups such as Tables and Views. Where it can be used, the last one is SQL query: pick it, and type what to read in the SQL query box. Each kind of data's page says what goes in it.
Show system objectsLists the parts a database keeps for itself, too, in italics. Off, you only see your own.

The Options step: Quantity field on (One label
per row), and the switches Skip empty rows and Count rows before loading data.

Options
Quantity field(One label per row), or a field that says how many labels each row makes. A row whose value isn't a whole number above 0 makes one label, and no row makes more than 1000 - a bigger number counts as 1000. Only text and number fields are offered.
Skip empty rowsLeaves out the rows with nothing in them.
Count rows before loading dataCounts the rows first, so the progress bar knows how far it has to go. Loading a big file or a slow server? Switch it off. Labeljoy remembers your choice.

The Data review step: a table with a # column and
the fields Code, Description, Price and Quantity, the first records of a product list, the line Records 1 to 10 of
12, and the page buttons.

Data review
The tableThe records, a page at a time. # is the record's place; hover a column's name to see what kind of values it holds.
The pagesFirst, Back, Next and Last, the page numbers, or pick one under Page.
The gearAdapt cells to content widens the columns to fit instead of wrapping, and Records per page shows 10, 25, 50 or 100 at a time.

Loading more than 10,000 rows? Labeljoy warns you, because it takes longer and makes the document bigger: the records are saved inside it. If you don't need them all, filter them, or connect a smaller part of your data.

Connecting a label set that already has data replaces it. The filter and sort are removed, and so is any field the new data doesn't have, from every label. You can undo it.