Jeg vil meget gerne vide, hvordan dælen, jeg laver en excel fil om til en brugbar csv fil.
Systemet som skal importere filen vil meget gerne "se" den således:
"Queston 1","This is the answer to question 1","meta keywords, install","meta description", 0, 1, 0
"Queston 2","This is the answer to question 2","meta keywords, sales","meta description", 0, 1, 0
"Queston 3","This is the answer to question 3","meta keywords, processing","meta description", 0, 1, 1
Hvis man bruger headers så skal det se således ud:
- title (required) - The title of the question, with a maximum length of 255 letters.
- answer (required) - The answer to the question. This can be as long as you like and can also contain HTML formatting.
- metakeywords - Keywords for the question. These get checked for searches and are placed inside the headers of the question page as the meta keyword tag for search engines. Keywords are separated by a comma.
- metadescription - Description to put in the description meta tag of the page, used by search engines.
- sortorder - The higher the number, the higher the result will appear when viewing the list of questions in a category. This can be any positive number. The default is 0.
- visible - Is this question visible or not? If the value is 1 then it will be visible, otherwise it will be hidden. This can be either 0 or 1. The default is 1.
- detectrelated - When viewing the question, do you want ActiveKB to try and find related questions automatically or do you want to manually specify related questions. This can be either 0 or 1. The default is 0 (Don't automatically detect related questions).
Og jeg vil meget gerne arbejde med det i excel for overskuelighedens skyld.
Jeg kan også bruge notes til første løsning, men det er lidt omstændigt.
Bliv gratis medlem
Opret bruger