Hi
I've been working on a hierarchical import file creator using macros in a spreadsheet to transpose values from a flat file - and I'm nearly there (I hope).
My current problem is that the .csv I am generating has trailing commas on each line, and at the moment I can't see how to get rid of them. I had hoped Actinic might ignore them, but I think they are causing the following error on import:
Apart from these trailing commas, my import-ready file looks similar to my exported reference file, with one further exception:
I have yet to hard code in the fixed values for the bulk of the section, product and custom property lines (those values which are constant and don't appear in the flat file).
Does anybody know which if either of these issues might be causing the error?
Thanks, Dan
I've been working on a hierarchical import file creator using macros in a spreadsheet to transpose values from a flat file - and I'm nearly there (I hope).
My current problem is that the .csv I am generating has trailing commas on each line, and at the moment I can't see how to get rid of them. I had hoped Actinic might ignore them, but I think they are causing the following error on import:
no fields found in first line of file
I have yet to hard code in the fixed values for the bulk of the section, product and custom property lines (those values which are constant and don't appear in the flat file).
Does anybody know which if either of these issues might be causing the error?
Thanks, Dan
Comment