Happy new year I hope everyone had a good one. I im doing a big update of products from filemaker pro into actinic. I'll be doing this using a standard tab file.
Problems I've had previous that I know will happen but im hoping that someone might know a way I can get around.
1. importing data I cant import using CSV as in our long description we have used commas. (this is why I am exporting to a tab seperated file.)
2. Prices all our prices are in a caclulated field which for example will export as £99.999999 for £99 but actinic requires this to be 9999?? I had issues on previous imports with 0s being cut off the end of the price. Not really too bad when having to check aprox 200 products. I will be importing over 1000 products & need an easy way verify the data.
3. Import of carriage returns. Importing as squares. If I export then import directly into actinic I think this doesnt happen its only If I open with a text editor or excel. Again anyone have an easy way to avoid this. As I will need to verify the data....????
I think thats it. Any help would be great.
Thanks
David Shorthouse
Problems I've had previous that I know will happen but im hoping that someone might know a way I can get around.
1. importing data I cant import using CSV as in our long description we have used commas. (this is why I am exporting to a tab seperated file.)
2. Prices all our prices are in a caclulated field which for example will export as £99.999999 for £99 but actinic requires this to be 9999?? I had issues on previous imports with 0s being cut off the end of the price. Not really too bad when having to check aprox 200 products. I will be importing over 1000 products & need an easy way verify the data.
3. Import of carriage returns. Importing as squares. If I export then import directly into actinic I think this doesnt happen its only If I open with a text editor or excel. Again anyone have an easy way to avoid this. As I will need to verify the data....????
I think thats it. Any help would be great.
Thanks
David Shorthouse
Comment