excel data mapper : import cell in Costs Property
Discussion Open
Hello, I try to import Excel file into a map and I have one column representing a cost.
I can map a column with a new property for a topic, but is there a way to map my prices into the "costs" property of my topic ?
That allow me to roll up costs on the top topic and consolidate my quotes.
The workaround solution can be to use a macro in order to move the content of the property created during import into the topic's costs attribute.
But I don't know if it's possible and I'm not a real pro on macros....
Many thanks for the feedback and my apologies fir my English.
Matthieu
I can't find a simple alternative without using macros - and I'm also not very good at writing them - but a macro is likely to be the best option.
However, if for any reason this isn’t possible to do with a macro I have figured out how to convert a column directly into General Costs when importing simple tables from Word, though a bit of a workaround is required.
If nobody comes up with a macro or another alternative I'll post the instructions if you're interested.
I can't find a simple alternative without using macros - and I'm also not very good at writing them - but a macro is likely to be the best option.
However, if for any reason this isn’t possible to do with a macro I have figured out how to convert a column directly into General Costs when importing simple tables from Word, though a bit of a workaround is required.
If nobody comes up with a macro or another alternative I'll post the instructions if you're interested.
I would be happy draft a macro to copy the contents of a numerical property called "General Cost" to the General Cost field of all topics. This would need to be run after each import from Excel. Is this what is needed?
I would be happy draft a macro to copy the contents of a numerical property called "General Cost" to the General Cost field of all topics. This would need to be run after each import from Excel. Is this what is needed?
---