![](/uploads/1/2/6/2/126224937/507411138.jpg)
Dec 01, 2016 CS6 has the function to save as CS5.5 file. This file you can open in CS5.5 and save in there as CS5. Then your friend can open that cs5 project. You can use the free trial of cs5.5 to simplyresave your project as cs5. Also, there is a script called ptopensesame.
![Windows Windows](/uploads/1/2/6/2/126224937/443511420.jpg)
Brief overview and best practices on how to take an Excel (.xlsx) file and convert it into a comma delimited values (CSV or.csv) file. This is useful if you're trying to upload files to a database or other systems that do not support.xlsx or other files. You can simply convert them to.csv so the system can ingest them in a compatible format.This tutorial will cover how-to execute this and some basic best practices.Though this is pretty basic IT knowledge, it can be used as a useful How-To for beginners and/or used as a living document you can refer people to.
Lastly, even though it's basic file conversion, there's some tips on what to watch out for when converting from Excel to CSV. In the form of a 'File Format' option the menu will ask you what type of file you want to save your current.xlsx into. The full list of conversion options will vary by the type of operating system you have, but there's a few common types that are pretty consistent across the board.The highlighted option in the attached image is the most general of.csv file options. MS-DOS) are more specific in their use-case. Unless you have a known reason for picking another variety, it is advised to pick the.csv option that has no explicit verbiage in the naming convention as shown in the image.Author's Note:You'll notice that the photo shows me saving this to my applications file. This is not an advisable location for storing files of this type.
I am only doing this so that I'm not showing you other files. Choose the file location that makes the most sense for your use-case. Once you've selected your file type and location you are technically done because your file has been converted, but there's a few 'gotchas' to consider when making conversions.1).csv does not support multiple tabs like.xslx does (basic conversion consideration)If you have an Excel file with multiple tabs, you'll need to convert each tab to it's own.xlsx file and convert each to a.csv separately. Typically, you'll get a warning of potential data loss if you're using the 'Save As' wizard, but the error message is not always explicit as to what you're going to lose.2) The default file opener for.csv files in most systems is Excel (slightly more advanced consideration)This is because Excel is smart enough to break files into rows and columns better than most (if not all user-friendly) programs. However, it is not the only way these types of files can be opened.
In fact, if you're having trouble importing a.csv into a database, I would advise that you open it up in your favorite text editor instead. That way, you can see what the root cause of a potential error is because Excel will often mask these errors making it look like nothing is wrong because it is smart enough to correct these errors behind the covers.The image attached to this step shows the example file in.csv format. Wherever you put the file you converted in previous steps, right click it, go to 'Open With', and you'll see your default program as well as a list of other options. If you open the file with a text editor (e.g. Notepad, Notepad, TextEdit, Sublime, Atom, etc.), you'll be able to view the file as the 'computer sees it'. This will help you navigate upload errors in a database.3) File header best practice (advanced consideration)In the file in step one, you'll notice that the second column, column B, has spaces in its header.
This is not advised if you want to upload a.csv file into another system and carry the headers over. This is because it can cause two potential problems in a database:a) If it uploads with a header, you will have to wrap what is now your column name in double quotes every time you call it in a query. It's not an impediment to uploading all the time, but it can be really annoying if you have to write it that way over and over again. Also, it will prevent auto-complete if your database program supports it.b) It could cause an upload error in some systems because they're trying to prevent the troubles in 'a' above, and it could prevent you from uploading the file entirely if you do not remove or fix the header.To prevent this, simply snakecase or CamelCase the header so there are no spaces in its name.
One note I would like to add, if you're building an application that uploads a.csv, and a.csv only, this conversion won't matter on a Windows machine because of how that OS handles file conversions. In short, Windows handles MIME types in ways that make uploading.csv files difficult because you cannot truly convert them out of.xlsx.Explanation of the problem in a GitHub project:The tools are starting to get better and handling file types more expertlyExample application with filetype selection for better handling of variance:. Furicle:There no official CSV standard, but there are common ways that CSV handle escaped fields.
It's generally accepted that if you have a field with commas in it, the field can be enclosed by double quotes. That's how excel handles it, and that's how most databases handle it (sometimes it has to be enabled. For example, doing a MySQL import infile command, you can specify a clauseOPTIONALLY ENCLOSED BY '(that's a single quote, a double quote, and a single quote, meaning you can enclose fields in double quotes. And there are further ways to escape double quotes that are generally considered as best practices, if not an outright standard. It's only.not. a standard because it basically pre-dates everyone trying to patent their garbage formats and seek licensing fees.
I once (back in the 90's) had to manipulate a 'database' file containing every model of car in existence, at least every one that the company, an insurance broker, would cover. I think it was 35-50k lines of data.
The original file came from a mainframe and was in a kind of loosely organised csv-style format and they needed it in Excel since that's what the office was using. Every time I changed something and did a sort on the table, I'd start it running and then go to lunch, getting back about 1 hour later to find it had either just completed or was near to finishing. I'm glad we have better tools and processors these days. Thanks for the tips, I have had to teach this on many occasions, but still learned a little about importing csvs into other applications.
.On your Mac, then choose File Get Info.If the information in Sharing & Permissions isn’t visible, click the disclosure triangle.Click the lock icon to unlock it.Enter an name and password.Click a user or group in the Name column, then choose a privilege setting from the pop-up menu.Read & Write: Allows a user to open the item and change it.Read Only: Allows a user to open the item, but not change its contents.Write Only: Makes a folder into a drop box. Users can copy items to the drop box, but can’t open it. Only the owner of the drop box can open it.No Access: Blocks all access to the item.You can undo any changes to privilege settings for a user or group in the Sharing & Permissions section since opening the Info window. Before closing the Info window, click the Action pop-up menu, then choose “Revert changes.”.On your Mac, then choose File Get Info.Click the lock icon to unlock it.Enter an name and password.If the new owner’s name isn’t listed in the Name column in the Sharing & Permissions section, click the Add button to add the new owner.Select the new owner in the Name column, click the Action pop-up menu, then choose “Make the owner.”You can undo any changes to an item’s owner in the Sharing & Permissions section since opening the Info window. Before closing the Info window, click the Action pop-up menu, then choose “Revert changes.”.On your Mac, then choose File Get Info.Click the lock icon to unlock it.Enter an name and password.In the Sharing & Permissions section, do any of the following:.Add a user or group: Click the Add button below the list, select a user or group, then click Select.Remove a user or group: Select the user or group, then click the Remove button below the list.You can undo adding or removing a user or group in the Sharing & Permissions section since opening the Info window. Before closing the Info window, click the Action pop-up menu, then choose “Revert changes.”.
![](/uploads/1/2/6/2/126224937/507411138.jpg)