Import Configuration File 2

[nLeo]

Howdie Folks!
Exported the Configuration as csv...
opened in excel, made changes to hunt groups...
resaved as csv.. thenm imported... merged..
no changes???
Any ideas please?

Thank you
Leo

 

[IPGuru]

This is not a supported process

also I don't think the CSV export exports every parameter for a group so it could cause you problems

That said I know other posters here have don it from time to time to spare ware & tear on their mouse finger.

Did you check the changes in the CFG after the import before saving back to the IPO



Do things on the cheap & it will cost you dear

 

[nLeo]

the Ip office did not show any changes...
all the Hunts were still the same.

 

[AACon]

DO NOT DO THIS.

However, if you MUST do this (DO NOT), excel is a terrible way to do it, because it will automatically add a "," for every single column.
IP Office does not export in a typical CSV fashion, nor will it properly import one with all the "," at the end. You have to open it up in something like notepad++ and delete all the extra commas.

In the past, when changing a TON of ports that couldn't be done with the extension renumber, I'd make two copies. Open on in excel, make the changes there, and then paste that into the original csv file opened in notepad++ and save. It would not add those extra commas for the missing columns. That typically works.



-Austin
I used to be an ACE. Now I'm just an Arse.

 

[TouchToneTommy]

Trim down the spreadsheet to just HuntGroup_Info_Start through HuntGroup_Info_End. Make your changes, and resave as Configuration.csv. Open in Notepad, delete the comma's after HuntGroup_Info_Start and the comma's after HuntGroup_Info_End. Save again and import into the IPO.

 

[nLeo]

Oh Dear,
got it opened in notepad.. I see commas, but not sure which ones to remove..
When I checked on Manager, couldn't see any commas.
When I re exported the Configuration, the changes were not there.
Any help please?

Thank you

 

[nLeo]

Hold on..
I have the configuration opened in notepad++ but I cannot see any ","
I see commas everywhere
but not between quotes " "
does it means I'm good to go?

 

[janni78]

I hope you're not doing this with a live system since if something is wrong in the file you might end up with a corrupt config.

Look at the file before you change anything and compare it with the edited version.
There should be no " between the commas and no commas after [HuntGroup_Info_Start] and [HuntGroup_Info_End].

"Trying is the first step to failure..." - Homer

 

[nLeo]

mistake yesterday:
Exported Configuration file
Opened in Excel As csv, made changes to hunts
Saved
Imported. No changes seen .
Did not reboot though
Now I'm working OFF line
I have deleted all apart the hunt start to hunt end..
I see lots of commas .. deleted them all..

Should I look for the same in all the config file?

 

[nLeo]

are we talking about the ,,,,,,,,,,,,,, after lines?
not commas in between right?

 

[janni78]

Not all the lines, just the line with [HuntGroup_Info_Start] and [HuntGroup_Info_End].

"Trying is the first step to failure..." - Homer

 

[nLeo]

Thank you Janni..
am I right to think then... the commas are added only to what you modify?
and are added after infor start... and info end?

 

[janni78]

If you do it correctly the commas are only added to those 2 lines, leave the commas on the other lines.

"Trying is the first step to failure..." - Homer

 

[TouchToneTommy]

delete the comma's after HuntGroup_Info_Start and the comma's after HuntGroup_Info_End.

Means just what it says.

HuntGroup_Info_Start,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
becomes
HuntGroup_Info_Start

and

HuntGroup_Info_End,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
becomes
HuntGroup_Info_End

 

[nLeo]

Worked!
Thank you!
Done it for hunt groups..

All good

 

[nLeo]

Hope you both got the Star you deserve!

 

[intrigrant]

It is plain stupid to adjust configurations like that. One day you make a little mistake which may have impact to the whole programming.

 

[joe2938]

Personally the time it took to get all of this feed back he could have programmed it from scratch

 

[mojoputter]

IP500 your playing with fire and got very lucky!!

 

[nLeo]

I appreciate your comments
I understand your points.
There were 1630 Hunts groups to change... (I know too many) and this was the only way.
Would you have known a better way? Please tell me

Anyway,
thank you and have a great day

Leo