Transferring data from idealpos to Phototicket

Prepare The Map File

Phototicket uses a map file to map fields from an idealpos export.

A map file is a comma seperated values file consisting of two columns.

The first column contains a field name exported by idealpos and the second column contains the matching field name imported by Phototicket.

The first row specifies the fields that will be used as the unique identifier for each product.

The field names that Phototicket can import are:

• name
• caption
• department
• subdepartment
• brand
• supplier
• plu_sku
• barcode
• barcode_128
• qr_code
• article_number
• product_code
• kj
• kj_per_serve
• kj_per_100g
• extra_text
• size
• normal_price
• normal_unit_price
• hide_normal_unit_price
• special_price
• special_unit_price
• hide_special_unit_price
• special_start_date
• special_end_date
• savings_amount
• multibuy_quantity
• multibuy_price
• multibuy_unit_price
• hide_multibuy_unit_price
• was_price
• show_australia_logo
• australia_percent

The field names closely match the names in the Phototicket Product form:

Note that the Phototicket Display Name is set to the same value as Name when a product is first imported. On subsequent imports, the Display Name is only updated if the Update Display Name flag is set. This allows store staff to improve the product name for display on tickets, changing pkt to packet, for example, and not having those improvements overwritten on subsequent imports.

An example map file might look like this:

SCAN,barcode
CODE,plu_sku
DESC,name
DESC2,extra_text
PRICE1,normal_price

Automatic exporting

• In idealpos, from the main menu,
• select Utilities > Export Data > Stock items.

• In the export stock items form,
• set Export to Automatic Export Format,
• select the required Export Specific Fields by Range values,
• ensure Include Headers is checked,
• click the Save Format button.

• In idealpos, from the main menu,
• select Setup > POS Terminals.

• In the pos terminals form,
• select a POS terminal,
• click the Modify button.

• In the pos terminals form,
• select the Import / Export tab.
• In the Automatic Export Settings section,
• set Export Folder to C:\Users\Public\Documents\DPI,
• set Export Stock Items to All Items,
• set Or every x minutes to 1,
• set Filename to Export.csv,
• ensure Use Saved Automatic Export Format is checked,
• close the form.

Automatic importing

• In Phototicket, from the main menu,
• select File > Preferences....

• In the Preferences form,
• select the Application tab.
• In the Startup section,
• set Refresh Data to mapped-csv-file/Group Name/C:\Uses\Public\Documents\DPI\Export.csv/C:\Uses\Public\Documents\DPI\Map.csv/dmy/true (where Group Name is the case sensitive name of an existing group, dmy is the date format, which could also be ymd and true instructs Phototicket to update the product Display Name when the product Name is updated),
• click the OK button.