Data & developer tools
Structured data, encoding and interoperable file conversions.
39 troubleshooting guides · Page 1 / 2
Why is my JSON rejected even though it looks like JavaScript?
JSON is a data format with stricter syntax than a JavaScript object literal. Formatting cannot repair an unknown intended value automatically.
Why does a comma inside a product description create an extra CSV column?
The description must be one quoted field when it contains the delimiter.
My supplier uses semicolons. How do I make a comma-separated product file safely?
Use https://kitforma.com/en/csv-delimiter-converter/ with the actual input delimiter and comma as the output delimiter.
Can duplicate-SKU removal accidentally discard a valid product variant?
Yes, if your chosen key is not unique at variant level.
How do I send a supplier only the catalog columns they need?
Make a copy and select explicit columns in https://kitforma.com/en/csv-column-picker/, such as SKU, product name and quantity.
Can I combine two supplier CSV files whose columns are in a different order?
Normalize the header names and order before merging.
Why does sorting product codes alphabetically put 100 before 20?
Text order compares characters, while numeric order compares quantities.
Why should I review product cells that begin with an equals sign?
Spreadsheet software may treat formula-like cells as executable formulas rather than plain catalog text.
How do I keep a long numeric identifier unchanged when working with JSON?
If the value is an identifier rather than a quantity, represent it as a quoted string in the upstream data contract.
Can repeated JSON keys hide a value during a later conversion?
A document such as {"status":"draft","status":"live"} is ambiguous for interoperability: downstream parsers may keep only one value.
Will JSON minification remove meaningful spaces inside a product description?
A JSON-aware minifier removes insignificant formatting between tokens, not the spaces inside a quoted string.
How do I address a JSON key containing a slash or tilde?
How do I address a JSON key containing a slash or tilde.
Why does flattening JSON produce slash-prefixed property names?
https://kitforma.com/en/json-flattener/ identifies leaves with JSON Pointer paths so nested locations remain distinguishable.
Why does filtering JSON for 12 not match the string "12"?
Number 12 and string "12" are different JSON values.
Can a schema inferred from one JSON example validate my whole API?
https://kitforma.com/en/json-schema-inference/ describes the sample it sees; it cannot discover missing optional fields, real numeric ranges or every future variant.
Why can reordering a JSON array appear as several changed values?
https://kitforma.com/en/json-structure-diff/ compares array elements by their positions.
Can I make NDJSON by putting each line of pretty-printed JSON on a new line?
Each nonempty NDJSON line must contain one complete JSON value.
Does generating a TypeScript type from JSON add runtime validation?
Does generating a TypeScript type from JSON add runtime validation.
Why does null delete a property in JSON Merge Patch?
In an object merge patch, null means remove that member.
Can I execute generated JSON-to-SQL output directly on a live database?
Can I execute generated JSON-to-SQL output directly on a live database.
Why should CSV headers be checked before converting rows into JSON objects?
Headers become property names, so an empty or repeated header can make the intended mapping unclear.
How should I prepare nested JSON before exporting it as a table?
Decide what one output row represents before opening https://kitforma.com/en/json-to-csv/.
Does transposing a CSV preserve the meaning of its headers?
Does transposing a CSV preserve the meaning of its headers.
Does a blank numeric CSV cell count as zero in column statistics?
https://kitforma.com/en/csv-column-statistics/ reports blank cells as missing and computes numeric statistics from nonblank values.
Ask your own question · Sign in to post questions and answers.