hello all, I am trying to export the customer data using MS management studio. I have a litl experience with SQL query this is the culomn data [{“Name”:“PostCode”,“Value”:“BS3 1JQ”},{“Name”:“House Number”,“Value”:“169”},{“Name”:“Street”,“Value”:“North Street”},{“Name”:“Town”,“Value”:“Bristol”},{…

It’s not that confusing, third result for search of ‘export entity data’ [image] Export custom data into csv or txt V5 Question Youll need to add a constraint expression to entity type etc to set to only be one type of entity. As for output how do you mean fkd? are you s…

SambaClub Forum

Help export customer data

V5 Question

QMcKay May 23, 2017, 11:21pm 10

SambaPOS 5 Bulk Product and Inventory Importer V5 Tutorial

##Synopsis This Tool is primarily used as a Bulk Product, Inventory, and Recipe importer based on data read from a CSV file. This is especially useful in Retail applications where there is a direct 1:1 relationship between Items you buy from a supplier and Products you sell. As of this release, this Tool is compatible with the following SambaPOS versions: 5.1.58 - 5.1.60 (DB version 124) ::: dbops124c.zip (24.6 KB) Originally developed by @JohnS for SambaPOS 3, updates to the Tool were dev…

Excel file to sambapos V5 Question

Search the 'net to find tools to convert CSV to YAML. Or use Excel to read the CSV data and use this formula in a Cell: =CONCATENATE("- Name: ", A2, CHAR(10), " GroupCode: ", "Imported", CHAR(10), " Barcode: ", C2, CHAR(10), " Portions: ", CHAR(10), " - Name: Normal", CHAR(10), " Price: ", G2) That produces YAML formatted data from your CSV file. Copy the formula to every row. You will probably want to clean up your CSV data file. There are duplicate Products, and some wi…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled