David Ashton: Created page with "If you're using Excel to edit the files, we'll have to take some extra steps to make sure none of the UPCs get converted to scientific notation. If you try to open the csv files directly, Excel will automatically format the UPCs into scientific notation and there will be no way to get the original UPC text back. You start by opening a new blank worksheet. Then click the Data tab, and on that ribbon click the From Text button to import the csv into excel File:Exce..."

2022-08-02T23:31:32Z

Created page with "If you're using Excel to edit the files, we'll have to take some extra steps to make sure none of the UPCs get converted to scientific notation. If you try to open the csv files directly, Excel will automatically format the UPCs into scientific notation and there will be no way to get the original UPC text back. You start by opening a new blank worksheet. Then click the Data tab, and on that ribbon click the From Text button to import the csv into excel File:Exce..."

New page

If you're using Excel to edit the files, we'll have to take some extra steps to make sure none of the UPCs get converted to scientific notation. If you try to open the csv files directly, Excel will automatically format the UPCs into scientific notation and there will be no way to get the original UPC text back.

You start by opening a new blank worksheet. Then click the Data tab, and on that ribbon click the From Text button to import the csv into excel
[[File:Excel data from text.png|none|thumb|Excel data from text]]

This should start the Text Import Wizard. For step 1, select Delimited and Start Import at row 1. Click next to move to step 2
[[File:Excel deliminited.png|none|thumb|Excel delimited]]

For step 2, make sure only the Comma delimiter is checked, and the Text Qualifier is "
[[File:Excel comma delimiter.png|none|thumb|Excel comma delimiter]]

For Step 3, you'll have to select each column in the bottom, and select the Text format so that all of the columns are imported exactly as the text appears in the csv file. Make sure to do this for ALL columns
[[File:Excel text format for all columns.png|none|thumb|Excel text format for all columns]]

When you have all of the columns set to Text, click Finish to import the file to excel, and for the last window you can leave the defaults and click OK.
[[File:Excel existing worksheet.png|none|thumb|Excel existing worksheet]]

This method should preserve the UPCs. You can save the excel file in regular excel format for now so you will be able to close excel and reopen it without doing the import procedure, but you will need to do this excel import every time you get a new exported file from the website.

When you finish editing the menu, you can click File, Save As

and select CSV (MS-DOS)
[[File:Menu save as.png|none|thumb|Menu save as]]

The warning that it gives about losing data is just letting you know that the column sizes and Text format will be gone if you try to open the csv file in Excel (which is why we had to do the import at the start). The warning is nothing to worry about.

With the new csv file you just made, you can open the website and go to the Menu page, click the Import/Export tab, and then choose your updated menu file and click Import
[[File:Import Menu.png|none|thumb|Import Menu from the LinkPOS web portal]]

Import Menu from an Excel file - Revision history