Import ASCII file: user prompt

[Former Member]

Hi,

is it possible to create an additional prompt when using the data manager to import an ASCII file? We have a file that contains all necessary information bar the period. Would it therefore be possible to ask the user at runtime which period the data should be imported to?

Thanks,

Arnold

[Former Member · Accepted solution]

Hi Arnold,

While running the import DM, you can definitely change the advanced logic and create a prompt statement to prompt the user for the time member. However, not sure whether it will be taken care of while importing the data from the flat file or not. Usually, all the records from the flat file are loaded into the fac2 table of the application (provided the members are base level).

I believe, it will be easier to have the appropriate periods in your flat file.

Hope this helps.

[Former Member · Accepted solution]

Hi,

the file as we have it at the moment is generated automatically by the source system, any change means manual interference which I was hoping to avoid. But if it is not possible to have a prompt, we'll have to see how we can get the time into the file.

[Former Member · Accepted solution]

You can create a prompt for the period in the SSIS package using a prompt command. I would use the text box input instead of the dimension input as the output is easier to handle. Then in the import pacakge use SSIS data transform task to take the source file to a new file adding period as a column using the user input as the value for all records. Now use this new file as the source for your conversion task.

[Former Member · Accepted solution]

Thanks for that, will have to investigate how to get that to work.