[HS] Re: Version question
"holsteinfrisiane" <e-post2011-S0/[email protected]> Sun, 26 Aug 2012 10:34:56 -0000
| Newsgroups | gmane.comp.handhelds.palm.handyshopper |
|---|---|
| Message-ID | <[email protected]> |
Okay, I figured out part of the problem. OpenOfficeCalc changes the notation of the CSV when saving, surrounding every value with quotes (the CSV file out of HS3convert does not have quotes). This makes HS3convert choke on the file on re-import. I haven't been able to "repair" the problem by simply finding and deleting the quotes. Additionally, due to the missing quotes commas in values (e.g. "T-Shirt, blue") are interpreted as value separators when importing the CSV to OpenOffice, and I get additional columns/fields per entry, breaking the data set. To get this working, a lot of manual correction would be necessary (correcting the columns, then replacing text commas in values with something else, then editing and saving, then removing quotes before re-converting to PDB). From next week on I'll have access to a PC with Word/Excel, so I'll see how it goes there. --- In [email protected], "holsteinfrisiane": > I tried to convert the *.csv back to *.pdb with hs3convert, but got the following error message: > "Header line is incorrect. > Error reading input file 'hs2einkauf.csv'." > > I assume the header line is something internal, not the csv column headers. > Is my use of OpenOfficeCalc the problem? Is it possible at all to use hs3convert to convert HS2 databases (both ways) and have them working? > And if not, is there a way to obtain the hs2convert application somewhere? I only have the *.cab for v2. A web search did not bring up something, except Chris Antos' website, where only the current version seems to be available.