Export Map Question

[JJ]

I've been able to create an export map to pull Task data from Project
and put it into a CSV file. The CSV file has a specific order for each
column and no columns can be added or deleted. This is because the CSV
file is used for importing into another system.

Now, for the purposes of this post. Let's say that the export map has
10 columns of data, and like I said each column is reserved for a
specific kind of data. However, for MY purposes I do not need or want
the data in say column 8 to be part of the export map.

My question is... Is there a way of removing column 8 out of the map
and making it a blank column in the map? I do not want to replace it
with another Project field because I can't be sure (without
programmatically checking) that the selected field is indeed empty.
All I want to try to do is have the map skip column 8. Is that
possible?

Thanks in advance!
JJ

 

[John]

I've been able to create an export map to pull Task data from Project
and put it into a CSV file. The CSV file has a specific order for each
column and no columns can be added or deleted. This is because the CSV
file is used for importing into another system.

Now, for the purposes of this post. Let's say that the export map has
10 columns of data, and like I said each column is reserved for a
specific kind of data. However, for MY purposes I do not need or want
the data in say column 8 to be part of the export map.

My question is... Is there a way of removing column 8 out of the map
and making it a blank column in the map? I do not want to replace it
with another Project field because I can't be sure (without
programmatically checking) that the selected field is indeed empty.
All I want to try to do is have the map skip column 8. Is that
possible?

Thanks in advance!
JJ

JJ,
I sounds like you may need more than just a simple export map. A "map"
is exactly that, it maps a Project field to some other format (e.g. csv,
Excel spreadsheet, etc.). There are no null fields in Project, every
field potentially has data.

I see a couple of choices. First, you can set up ground rules for using
Project at your company and one of those ground rules is to never use
spare field "xyz" for data. Then you simply map that blank field for
your column 8. Second, use a VBA macro to create the csv file. Then you
can easily create whatever csv format you need. I personally would go
for the latter.

John
Project MVP

 

[JJ]

Thanks John! I was afraid that would be the answer. Do you have some
basic code to build a comma-delimited file? I have never created one
before.